I created a desktop application designed to streamline human resources management by handling employee records, department assignments, and authentication. Built with C# WinForms and SQL Server.
- Full CRUD Operations: Add, update, delete, and view employee records.
- Database Integration: Persistent storage using SQL relational database.
- Authentication Module: Secure login system for authorized access.
- Department Management: Organized view of employees across different organizational units.
- Dynamic Search: Real-time filtering of employee data.
- Frontend: C# Windows Forms (WinForms)
- Backend: .NET Framework
- Database: Microsoft SQL Server
- Data Access: ADO.NET / SQL Client
This project demonstrates proficiency in relational database management (RDBMS). Key SQL concepts implemented:
- Schema Design: Structured tables for Employees, Departments, and Admin Users.
- Data Integrity: Primary keys and data type constraints.
- Querying: Optimized T-SQL queries for data retrieval and manipulation.
/Authentication- Logic for user login and security./MainMenu- Core UI and dashboard management./Sql- Database connection strings and SQL query implementations./Data- Data models and object structures.
- Min Requirements: * Visual Studio 2022+
- SQL Server (LocalDB)
- Setup:
- Clone the repo:
git clone https://github.com/MichalPytlarz/Employee_Management_Project.git - Run the provided SQL scripts (found in
/Sqlor documentation) to set up your local database. - Update the connection string in
App.config.
- Clone the repo:
- Launch: Open the
.csprojfile in Visual Studio and pressF5.
Building this project allowed me to bridge the gap between application logic and data persistence. I gained hands-on experience in:
- Managing state between a UI and a relational database.
- Handling SQL exceptions and ensuring safe data transactions.
- Designing user-friendly interfaces for data-heavy applications.