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