Project Management System

A comprehensive ASP.NET Core MVC application for managing enterprise projects, teams, employees, tasks, and financial operations with a robust database-driven architecture.

📋 Table of Contents

• Features
• Tech Stack
• Prerequisites
• Installation
• Database Setup
• Configuration
• Project Structure
• Usage
• Screenshots
• License
• Author
• Support

✨ Features

Core Modules

• 📊 Dashboard: Real-time overview of projects, employees, teams, tasks, and financial metrics
• 👥 Employee Management: Complete CRUD operations for employee records with role assignments
• 📁 Project Management: Track projects with budgets, deadlines, status, and descriptions
• 👨‍👩‍👧‍👦 Team Management: Create and manage teams with member assignments
• ✅ Task Assignment: Assign tasks to teams and track completion status
• 💬 Comments: Add comments and notes to projects for collaboration
• 🏖️ Leave Management: Employee leave request tracking and approval system
• 💰 Invoice Management: Create and track project invoices with automatic calculations
• 📈 Profit Tracking: Monitor project profitability and financial performance

Technical Features

• Repository Pattern: Clean architecture with separation of concerns
• Dependency Injection: Scoped services for repositories
• ADO.NET: Direct database access using Microsoft.Data.SqlClient
• Turkish Localization: Currency formatting in Turkish Lira (₺)
• Responsive Design: Bootstrap 5 with modern UI components
• Data Validation: Model validation with DataAnnotations
• Error Handling: Comprehensive error management and logging

🛠️ Tech Stack

Backend

• .NET 10 - Latest .NET framework
• ASP.NET Core MVC - Web framework
• ADO.NET - Data access with Microsoft.Data.SqlClient 5.2.2
• C# 13 - Programming language

Frontend

• Bootstrap 5 - UI framework
• Bootstrap Icons - Icon library
• Razor Views - Server-side rendering
• HTML5/CSS3 - Markup and styling

Database

• Microsoft SQL Server - Primary database
• Integrated Security - Windows Authentication

📦 Prerequisites

Before running this project, ensure you have the following installed:

• .NET 10 SDK or later
• Microsoft SQL Server (2019 or later recommended)
• Visual Studio 2026 or Visual Studio Code
• Git (for cloning the repository)

🚀 Installation

1. Clone the repository

   git clone https://github.com/Nuraddin0/Project-Management-System.git
   cd Project-Management-System

2. Restore NuGet packages

   cd DatabaseProject
   dotnet restore

3. Build the project

   dotnet build

🗄️ Database Setup

The project includes comprehensive SQL scripts located in the Database folder to set up the complete database schema.

Quick Setup

1. Create the database

   • Open SQL Server Management Studio (SSMS)
   • Connect to your SQL Server instance
   • Create a new database named ProjectDB

   CREATE DATABASE ProjectDB;
   GO
   USE ProjectDB;
   GO

2. Execute the SQL scripts in order

   Navigate to the Database folder and execute the following scripts:

   a) Tables.sql - Creates all database tables

   • Employee - Employee master table with unique username and email
   • FullTimeEmployee - Full-time employees with monthly salary
   • HourlyEmployee - Hourly employees with hourly rate
   • Project - Project information with budget and deadlines
   • Team - Team structure and details
   • TeamMember - Team member assignments
   • TaskAssignment - Task assignments to teams and projects
   • Comment - Comments on tasks/projects
   • Leave - Employee leave requests
   • Invoice - Project invoices and billing
   • Profit - Project profitability tracking
   • DailyPerformance - Employee daily work hours tracking

   b) StoredProcedures.sql - Creates stored procedures for business logic

   • sp_Hiring_AddFullTime - Add full-time employee with transaction safety
   • sp_Hiring_AddHourly - Add hourly employee with transaction safety
   • sp_Accounting_GenerateInvoice - Generate invoice for hourly employees
   • And more...

   c) Triggers.sql - Creates database triggers for automation

   • trg_Employee_AutoUpdateDate - Auto-update employee modification timestamp
   • trg_Comment_AutoUpdateDate - Auto-update comment modification timestamp
   • trg_CheckBudgetOverflow - Prevent project expenses from exceeding budget
   • trg_AssignmentID_Constraint - Validate assignment constraints

Database Features

• Employee Hierarchy: Supports both full-time and hourly employees with specialized tables
• Transaction Safety: All insert/update operations wrapped in transactions
• Data Integrity: Foreign key constraints and unique constraints on critical fields
• Automatic Timestamps: Triggers automatically update modification dates
• Budget Control: Triggers prevent cost overruns on projects
• Business Logic: Stored procedures encapsulate complex operations

⚙️ Configuration

1. Update the connection string

   Open appsettings.json and update the connection string to match your SQL Server instance:

   {
     "ConnectionStrings": {
       "DefaultConnection": "Data Source=YOUR_SERVER_NAME;Initial Catalog=ProjectDB;Integrated Security=True;Connect Timeout=30;Encrypt=True;Trust Server Certificate=True;Application Intent=ReadWrite;Multi Subnet Failover=False;Command Timeout=30"
     }
   }

   Replace YOUR_SERVER_NAME with your SQL Server instance name (e.g., localhost, (localdb)\\MSSQLLocalDB, or your server name).

2. Run the application

   dotnet run

3. Access the application

   Open your browser and navigate to:

   • https://localhost:5001 (HTTPS)
   • http://localhost:5000 (HTTP)

📂 Project Structure

DatabaseProject/
├── Controllers/           # MVC Controllers
│   ├── HomeController.cs
│   ├── EmployeesController.cs
│   ├── ProjectsController.cs
│   ├── TeamsController.cs
│   ├── TasksController.cs
│   ├── CommentsController.cs
│   ├── LeavesController.cs
│   ├── InvoicesController.cs
│   └── ProfitsController.cs
├── Models/               # Data models
│   ├── Employee.cs
│   ├── Project.cs
│   ├── Team.cs
│   ├── TaskAssignment.cs
│   ├── Comment.cs
│   ├── Leave.cs
│   ├── Invoice.cs
│   └── Profit.cs
├── Repositories/         # Repository pattern implementation
│   ├── Interfaces/
│   │   ├── IEmployeeRepository.cs
│   │   ├── IProjectRepository.cs
│   │   ├── ITeamRepository.cs
│   │   ├── ITeamMemberRepository.cs
│   │   ├── ITaskAssignmentRepository.cs
│   │   ├── ICommentRepository.cs
│   │   ├── ILeaveRepository.cs
│   │   ├── IInvoiceRepository.cs
│   │   └── IProfitRepository.cs
│   └── Implementations/
│       ├── EmployeeRepository.cs
│       ├── ProjectRepository.cs
│       ├── TeamRepository.cs
│       ├── TeamMemberRepository.cs
│       ├── TaskAssignmentRepository.cs
│       ├── CommentRepository.cs
│       ├── LeaveRepository.cs
│       ├── InvoiceRepository.cs
│       └── ProfitRepository.cs
├── Data/                 # Database connection
│   └── DatabaseHelper.cs
├── Views/               # Razor views
│   ├── Home/
│   ├── Employees/
│   ├── Projects/
│   ├── Teams/
│   ├── Tasks/
│   ├── Comments/
│   ├── Leaves/
│   ├── Invoices/
│   ├── Profits/
│   └── Shared/
├── wwwroot/             # Static files (CSS, JS, images)
├── appsettings.json     # Configuration
└── Program.cs           # Application entry point

💡 Usage

• Dashboard

  • View real-time statistics for all modules
  • Quick access to all management sections
  • Visual cards with counts and metrics

• Employee Management

  1. Navigate to Employees section
  2. Click Create New to add employees
  3. View, edit, or delete employee records
  4. Track employee details, positions, and salaries

• Project Management

  1. Go to Projects section
  2. Create new projects with:
     • Project name and description
     • Budget and deadline
     • Status tracking
  3. Monitor project progress and completion

• Team Management

  1. Access Teams section
  2. Create teams and assign members
  3. Manage team composition
  4. Track team assignments

• Task Assignment

  1. Navigate to Tasks section
  2. Assign tasks to specific teams
  3. Link tasks to projects
  4. Track task completion status

• Leave Management

  1. Go to Leaves section
  2. Create leave requests with:
     • Employee selection
     • Leave type and dates
     • Approval status
  3. Monitor leave balances

• Invoice & Profit Tracking

  1. Access Invoices section to create project invoices
  2. View Profits to monitor financial performance
  3. Track project budgets vs actual costs

🖼️ Screenshots

• Dashboard

Main dashboard with real-time statistics and overview of all modules

• Projects Management

Project listing and management interface

• Team Management

Team creation and member assignment

• Task Assignments

Task assignment and tracking system

• Invoice Management

Invoice creation and management

• Financial Details

Profit tracking and financial performance metrics

📝 License

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

👤 Author

This repository is created by Nuraddin0

📧 Support

For issues, questions, or suggestions, please open an issue on the GitHub repository.

---