Payroll Management System Project in Asp.Net - Dotnet Programmer


This Payroll Management System (PMS) project is a web based application was developed by using c# coding in asp.net. This project is very usefull for .Net Begineers to understand the requirements and functionalities. This can be used as a Mini Project for MCA, B.E/B.Tech and Diploma students.
The Front End of this project is Asp.net, c# coding and Back End is SQL Server.

Project Description

In PMS project there are two kinds of users are their i.e Administrator or Manager and Employees.
Employee : can only have permission to view his information and his transaction details per month wise and also he can send message's to administration by using message services in this application.
Administrator or Manager : have more permission than Employees. He can have CRUD Permission i.e nothing but a {Create | Read | Update | Delete}. Admin can perform CRUD permission on employee information and employee salary information.

Project Modules :

Before continue with this project first we create database.

Payroll Management System Project Database

In PMS Database i'm using 4 tables they are Employees | Levels | Message | Payslip Table's.

Employee Table

This table is used to store employee information by administrator at the time of creating employee account.

CREATE TABLE [dbo].[employees](
 [employeeid] [int] IDENTITY(100000,1) NOT NULL,
 [name] [varchar](50) NULL,
 [phone] [varchar](50) NULL,
 [email] [varchar](50) NULL,
 [designation] [varchar](50) NULL,
 [levelID] [int] NULL,
 [username] [varchar](50) NULL,
 [password] [varchar](50) NULL,
 CONSTRAINT [PK_employees] PRIMARY KEY CLUSTERED 
(
 [employeeid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

Levels Table

This table have predefined information about employee job level i.e nothing but a job status (for eg :- Entry | Junior | Senior Level)

CREATE TABLE [dbo].[levels](
 [levelid] [int] IDENTITY(1,1) NOT NULL,
 [levelname] [varchar](50) NULL,
 [basicsalary] [varchar](50) NULL,
 CONSTRAINT [PK_levels] PRIMARY KEY CLUSTERED 
(
 [levelid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

Message Table

This table is used by both Employ and Admin.

CREATE TABLE [dbo].[messages](
 [messageID] [int] IDENTITY(1,1) NOT NULL,
 [Date] [datetime] NULL,
 [MessageFrom] [varchar](50) NULL,
 [MessageTo] [varchar](50) NULL,
 [Message] [varchar](max) NULL,
 [EmployeeID] [int] NULL,
 [active] [int] NULL,
 CONSTRAINT [PK_messages] PRIMARY KEY CLUSTERED 
(
 [messageID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

Pay Slip Table

CREATE TABLE [dbo].[payslips](
 [payslipid] [int] IDENTITY(1,1) NOT NULL,
 [employeeid] [varchar](50) NULL,
 [date] [varchar](50) NULL,
 [month] [varchar](50) NULL,
 [year] [varchar](50) NULL,
 [generatedon] [varchar](50) NULL,
 [basicsalary] [varchar](50) NULL,
 [noofleaves] [varchar](50) NULL,
 [salaryperday] [varchar](50) NULL,
 [deductionforleaves] [varchar](50) NULL,
 [netsalary] [varchar](50) NULL,
 CONSTRAINT [PK_payslips] PRIMARY KEY CLUSTERED 
(
 [payslipid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

Download Project Source Code

To Download Source Code of this Project, Please goto NEXT Page.


1 2 3 4 5
0 Komentar untuk "Payroll Management System Project in Asp.Net - Dotnet Programmer"

Back To Top