Employee-Management-System

GUI-Based Employee Management System using SQLite 3 and Pyqt5

In this project, I have designed an application using Pyqt5 and SQLite to manage all employees of a hypothetical company. Each employee has an Employee Id (which acts as Primary Key for our table), Name, Lastname, Age, Position, and Email address. This Company will hire people who are older than 18 and younger than 70 years old. I have defined a function to generate 40 employees with fake information.

How to run :

python mainGUI.py

Note:

+ User and password is admin

Requirements:

• SQLite
• Plotly
• Pyqt5
• Mailjet_rest

check the requirments.txt

Features:

• Login page
• Display table
• Search function 
• Update data (double click or right click on each cell )
• Delete data
• different themes and fonts
• Interesting data (such as number of employees, salary per position, average salary per position)
• Interactive  plots
• sending email to specific employee ( update use_jet_mail.py file with your jetmail api and email )

for more information and video check the link below:

https://ht21992.pythonanywhere.com/en/my_projects/25/