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) |
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
hello sir,
i want to download this project, but its showing some error message. can you show me the way to download.