Payroll Management System Project in Asp.Net - Dotnet Programmer

Exploring the Payroll Management System Project

Introduction

The Payroll Management System (PMS) is a web-based application developed using C# coding in ASP.NET, providing a valuable resource for .Net beginners and students pursuing MCA, B.E/B.Tech, and diploma courses. This project offers insights into essential requirements and functionalities.

Project Overview

The project utilizes Asp.net and C# for the front-end and SQL Server for the back-end. Designed with simplicity, PMS caters to two main user categories: Administrators/Managers and Employees, each with specific permissions and functionalities.

User Roles and Permissions:

• Employee:

  • View personal information and transaction details monthly.
  • Send messages to the administration using the application's messaging services.

• Administrator/Manager:

  • Enjoy CRUD (Create, Read, Update, Delete) permissions.
  • Admins can perform CRUD operations on employee information and salary details.

Project Modules:

•   Login Module  - Click Here go Login Module Page
•  Administrator Module
  • Add Employee  - Click Here go Administrator Module Page
  • View Employee Record  - Click Here go Administrator Module Page
  • Delete Employee Record  - Click Here go Administrator Module Page
•  Manager Module
  • View Employee Details  - Click Here go Manager Module Page
  • Compose | Inbox Message  - Click Here go Manager Module Page
  • Generate Pay Slip  - Click Here go Manager Module Page
•  Employee Module
  • View Employee Profile  - Click Here go Employee Module Page
  • Compose Message  - Click Here go Employee Module Page
  • Employee Pay Slip  - Click Here go Employee Module Page

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

The source code of this Payroll Management System project you can download from here

D o w n l o a d

Conclusion:

The Payroll Management System project serves as an excellent learning tool for beginners, offering practical insights into web-based application development using C# and ASP.NET. With its user-friendly modules and well-organized database structure, it provides a valuable resource for educational purposes.

1 2 3 4 5