Leave Management System Using C# and MySQL Database with Source Code

This Leave Management System is an automated system that is made up of C# and MySQL Database. The system aims to track the activity of every employee in a company most especially their leave of absence. With the use of this system, the admin has the ability to see how often an employee made a leave all throughout the month and that can be viewed in the Reports. To know more about the system you can check the following features shown below.

Features

Manage Employees

• List of Employees
• Add New Employee
• Edit Employee Information
• Print All Employee
• Print Remaining Leaves of Employee

Manage Leave of Absence

• Apply Leave of Absence
• History of Approved Leaves

Maintenance

• Manage Position of Employees
• Manage Departments

How to Run

Requirements: Download and Install the following

• XAMPP Latest Version
• MySQL Connector
• MySQL Odbc
• Microsoft Visual Studio 2015 (recently tested using Visual Studio 2019 community)
• SAP Crystal Reports

Installation

1. Download and Extract the provided source code zip file. (download button is located below)
2. Open your XAMPP's Control Panel and start the "MySQL" for the database and "Apache" to use PHPMyAdmin in managing the database.
3. Locate the provided SQL file known as "db_leave.sql" inside the extracted source code folder.
4. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
5. Create a new database naming "db_leave".
6. Import the SQL file into your newly created database.
7. Locate the Solution file known as "LeaveManagementSystem1.1.sln" inside the extracted source code folder.
8. Open the Solution File with your MS Visual Studio Software.
9. Press the "F5" key on your keyboard to Run the Leave Management System in C# and MySQL Database Project.

Credentials:

Username: admin
Password: admin

DEMO

That's it! You can now explore the features and functionalities of this Leave Management System Project using C# and MySQL Database. I hope this will you with what you are looking for and for your future C# Projects.

For more information about the system. You can contact me @
Email – [email protected]
Mobile No. – 09305235027 – TNT
FB Account – https://www.facebook.com/onnaj.soicalap
Or feel free to comment below.

Explore more on this website for Tutorials and Free Project Source Code.

Enjoy :)