Employee Leave Management System ASP.NET Project

0
5856

Employee Leave Management System is an Intranet-based application titled “Easy Leave”, developed using ASP.NET with AJAX, C#.NET, and MS SQL Server database. This project is aimed at developing a web-based leave management tool that can used in either an organization or a college and can be accessed throughout the organization and its departments.

The complete source code, database, project documentation, report, and sample ppt of ELMS can be downloaded from the link below. The project report is complete with class diagrams, UML diagrams, activity diagrams, collaboration diagrams, DFDs, ER diagrams, tables, SQL restore data, screenshots, and work flow.

Download Employee Leave Management System ASP.NET Project with Source Code, Database, Project Report, Documentation, and Sample PPT

About Employee Leave Management System:

Easy Leave is an online employee leave management system that can be used to automate the entire workflow of leave applications and their approvals. This system automates periodic crediting of leave as well, and includes features such as automatic approval, report generation, notifications, cancellation of leave, and much more.

Existing System:

The existing leave management procedure is manual and traditional as it is pen-and-paper based. Here, employees cannot upload and download the latest updates; there’s no use of web services; risk of data mismanagement is high; less security; no proper co-ordination between different applications and users; and it is not that user friendly.

Proposed System:

The entire system has been developed keeping in mind the distributed client server computing technology. The specification has been normalized up to 3NF to eliminate all the anomalies that may arise due to the database transaction that are executed by the general users and the organizational administration.

The user interfaces are browser specific to give distributed accessibility for the overall system. The internal database has been selected as MS-SQL server 2000.The basic constructs of table spaces, clusters and indexes have been exploited to provide higher consistency and reliability for the data storage.

Functional Components:

The users of the system includes registered people and approvers or requestors. The hierarchy of work flow in an organization is:Engineers/Managers/Business Managers/Managing Director, and so on. Whereas, that in a college is: Lecturer/Professor/Head of the Department/Dean/Principal, and so on.

With the proposed system, a person can log in to the system through the first page of the application. They can see their eligibility with respect to how many days of leave that can apply for. They can query the leave balance and see their leave history since joining the organization or college.

While applying for leave, the employee should specify the form and to dates, reason for taking leave, address for communication during the leave, and their superior’s email id. They can view current leave applications, and the respective department can either approve or reject applications.

Employees can even withdraw the leave application that has not been approved or cancel the applications that had already been approved. As soon as a leave application is approved, withdrawn, rejected, or cancelled, an automatic email is sent to the person applying and the superior to whom the application was sent.

Keywords:

  • Generic Technology Keywords: Databases, User Interface, Programming
  • Specific Technology Keywords: ASP.Net, C#.Net, MS SQL Server
  • Project Type Keywords: Presentation, Business, Data Access Layers
  • SDLC Keywords: Analysis, Design, Implementation, Testing

Modules Involved:

  • Administration
  • Employee
  • Search
  • Report
  • Authentication

Detailed description of these modules can be found in the project report.

Screenshots:

Employee Leave Management System in ASP.NET - Home Page
Home Page
Employee Leave Management System -  Manage Department
Manage Department
Employee Leave Management System -  Employee Balance Leave Details
Employee Balance Leave Details
Employee Leave Management System - List of Employees Available Nextday
List of Employees Available Nextday

System Requirements:

Hardware Specification:

  • Processor: Intel Pentium or More
  • Ram: 512 MB Ram
  • Hard Disk: PC with 20GB

Software Specification:

  • Operating System Server: Windows XP or later
  • Database Server: Microsoft SQL Server-2005
  • Client: Microsoft Internet Explorer
  • Tools: Microsoft Visual Studio .Net-2008
  • User Interface: Asp.Net with Ajax
  • Code Behind: C#.Net

Also see,
Online Collaboration System
Payroll Management System
More ASP.NET Projects

Conclusion:

Employee Leave Management System, being web-based, needs to be throughly tested before implementation to find any security gaps. A console for the data centre may be made available to allow the personnel to monitor on the sites which were cleared for hosting during a particular period.

This application is just a beginning and is very flexible. The system can be easily utilized as per user requirement in various other types of auditing operations viz. Networking auditing or other similar process/workflow based applications.

LEAVE A REPLY

Please enter your comment!
Please enter your name here