A simple ADO.NET console-based Employee Management System that allows users to manage employees and departments using a Microsoft SQL Server database.

✅ Add New Employees & Departments
✅ Display Employees & Departments
✅ Sort Employees
✅ Search Employees
✅ Delete Employees & Departments
✅ Exit the System

Employee_System/
├── ClassLibraryEmployee/
│   └── Employee.cs
├── Employee_System/
│   ├── AppSettings.json
│   ├── DataBaseHelper.cs
│   ├── DepartmentDataAccess.cs
│   ├── EmployeeDataAccess.cs
│   └── Program.cs

The system consists of two tables:

git clone https://github.com/GziXnine/Employee_System.git
cd Employee_System

• Open SQL Server Management Studio (SSMS) or any SQL client.
• Execute the NewCompanyDB_ADO.sql to create the database and insert sample data.

• Open AppSettings.json
• Modify the connection string to match your database settings:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=.; Database=NewCompanyDB_ADO; Trusted_Connection=True; MultipleActiveResultSets=True; Integrated Security=SSPI; TrustServerCertificate=True;"
  }
}

dotnet run

This project was developed by:

• Abdelrahman Emad
• Ahmed Allam

We collaborated to build this system using ADO.NET, C#, and MS SQL to ensure efficiency and scalability. 🚀

💡 Contributions are welcome! Feel free to submit a pull request.

📄 This project is licensed under the BSD-3-Clause License. See the LICENSE file for more details.