Hello Sir,
I have good 10+ years of experience in asp.net and I have worked on many asp.net applications. Please review following plan about your requirement:
---------------------------------------------------------------------------------------------------------------------------------------
Steps I will follow are as below:
1) First I have will tables in database
> I will carete table Projects with following columns names and datatypes
Id (int, autoincrement)
ProjectName (nvarchar(200))
> Then I will create tabl Users with following column names and datatypes:
Id (int, autoincrement)
Username (nvarchar(20))
> Then I will create another table names document with following column names and datatypes:
Id (int, autoincreament)
DocName(nvarchar(200))
UserId (FK of Users table)
ProjectId (FK of Projects table)
DateTime (DateTime)
2> Create Stored Procedures
For Projects table:ProjectsInsert,ProjectsUpdate ,ProjectsDelete ,ProjectsGetAllRecords ,ProjectsGetRecordById
For Users table: UsersInsert,UsersUpdate, UsersDelete, UsersGetAllRecords, UsersGetRecordById
For Documents table: DocumentsInsert, DocumentsUpdate, DocumentsDelete, DocumentsGetAllRecords, DocumentsGetRecordById
3> Create architecture of the project
> Presentation layer where all .aspx page will come
> Business Layer where all business logic or server side validations will come
> Data Access layer where all database operations will happen.
---------------------------------------