Employee Management System

This is an Employee Management System built using Python's Tkinter for the GUI and SQLite for the database. It allows users to add, update, delete, and view employee details.

Features

• Add new employee details (Name, Age, Date of Joining, Email, Gender, Contact Number, Address).
• Update employee details.
• Delete employee records.
• View all employee records in a table format.

Prerequisites

Make sure you have the following installed on your system:

• Python 3.x
• Tkinter (comes pre-installed with Python)
• SQLite3 (comes pre-installed with Python)

Project Structure

The project consists of two main files:

1. main.py: Contains the main GUI code and functionality.
2. db.py: Contains the database class to interact with the SQLite database.

Setup

1. Clone the repository or download the files.

2. Make sure both main.py and db.py are in the same directory.

3. Open a terminal or command prompt and navigate to the directory where the files are located.

4. Run the following command to start the application:

   python main.py

   This will launch the Employee Management System in a Tkinter window.

Usage

Add Employee

1. Fill in the details for the employee in the input fields.
2. Click the Add Details button to insert the employee record into the database.
3. The system will display a success message, and the employee details will be visible in the table.

Edit Employee

1. Click on a row in the table to select the employee record you want to edit.
2. Modify the details in the input fields.
3. Click the Update Details button to save the changes.
4. The system will display a success message, and the updated details will be reflected in the table.

Delete Employee

1. Select the employee record from the table that you want to delete.
2. Click the Delete Details button.
3. The system will ask for confirmation before deleting the record.

Clear Fields

1. Click the Clear Details button to clear all the input fields.

Viewing Employee Records

• All employee records are displayed in a table format below the input fields.
• The table will update automatically when records are added, edited, or deleted.

Database

The system uses an SQLite database (Employees.db) to store the employee records. The db.py file contains the Database class, which handles all interactions with the database, including inserting, updating, deleting, and fetching employee records.

Screenshots

Here is an example of the system in action:

License

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgements

• Tkinter for the GUI
• SQLite3 for the database
• Python 3.x