Skip to content

GziXnine/Employee_System

Repository files navigation

🏢 Employee Management System

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

📸 Preview

Completion Status    Visitors    Repository Size

📌 Features

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

Data Base Query

Data Base Employee

Data Base Department

📂 Project Structure

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

🗄 Database Structure

The system consists of two tables:

Data Base Tables

🔧 Setup Instructions

1️⃣ Clone the Repository

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

2️⃣ Configure the Database

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

Data Base Query

3️⃣ Update the Connection String

  • 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;"
  }
}

4️⃣ Run the Project 🚀

dotnet run

👥 Authors

This project was developed by:

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

🤝 Contributing

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

📜 License

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

About

Developed during ITI Winter Training | Web Development using .NET | Built with ADO.NET, C#, and MS SQL

Topics

Resources

License

Stars

Watchers

Forks

Contributors 2

  •  
  •