Time Sheet Management System .Net Project

The main aim of developing this Time Sheet management System .Net Project is to provide automated work Time sheet for allocated projects all employees in the organisation.

The main Users are Employee, Manager and Admin.

Employee functionalities:

where employees can login with their credentials and view their details, modify existing details, enter new time sheets, view time sheet, update time sheet, delete sheets

Manager functionalities:

Where manager has actions like release, update, view, change & allocation time sheet functions.

Admin functionalities:

Where admin can add employees, approve time sheets, create projects, view projects, create employee id’s, project billing actions, etc.

Database Tables below:

Project Table:

 

Column Name	Data Type
UniqId	int
ProjectId	Varchar(50)
Project Name	Varchar(50)
Started Date	Varchar(50)
Estimated Date	Varchar(50)
Client Name	Varchar(50)
Client Location	Varchar(50)
Address	Varchar(50)
Poc	Varchar(50)
PO	Varchar(50)
Scope Document	Varchar(50)
Estimated Cost	Varchar(50)
Types	Varchar(50)
Pay For Manager	Varchar(50)
Pay For Employee	Varchar(50)
Technology Required	Varchar(50)
Data Bases	Varchar(50)
AssgineTo	Varchar(50)

Employee table:

Column Naame	Data Type
UniqId	int
EmpId	Varchar(50)
First Name	Varchar(50)
Last name	Varchar(50)
Password	Varchar(50)
Gender	Varchar(50)
Phone Number	Varchar(50)
Email	Varchar(50)
AltEmail	Varchar(50)
Experience	Varchar(50)
Date Of Join	Varchar(50)
Address	Varchar(50)
City	Varchar(50)
State	Varchar(50)
Country	Varchar(50)
Pincode	Varchar(50)
Position	Varchar(50)
Status	Varchar(50)

Timesheet Table:

Column Name	Data Type
TimeSheet Id	int
EmpId	Varchar(50)
Date	Varcar(50)
Analasys Requirement	Varcar(50)
Preparing Functional Design Document	Varcar(50)
Preparing High Level Design	Varcar(50)
Preparing  Loe Level Design	Varcar(50)
Writing Code	Varcar(50)
Preparing Tcehnical Design Document	Varcar(50)
Analasys & Fixing Bug	Varcar(50)
Unit Testing	Varcar(50)
System Testing	Varcar(50)
Integrity Testing	Varcar(50)
Preparing Test cases	Varcar(50)
Totaltime	Varcar(50)
Status	Varcar(50)

 

Column Name	Data Type
Allocated Id	int
Allocated By	Varcar(50)
Project Id	Varcar(50)
Project Name	Varcar(50)
Allocated To	Varcar(50)
Status	Varcar(50)

 

Column Name	Data Type
Uniq Id	int
Project Id	Varcar(50)
Emp Id	Varcar(50)
Total Work Hrs	Varcar(50)
Payment	Varcar(50)

Download the Time Sheet Management System .Net Project Source code