Skip to content

Latest commit

 

History

History
307 lines (245 loc) · 10.6 KB

README.md

File metadata and controls

307 lines (245 loc) · 10.6 KB

🎓 Course Management System (Console App)

A clean, interactive C#/.NET console application for managing Students, Instructors, Courses, Categories, and Enrollments with Entity Framework Core (SQL Server LocalDB). It demonstrates real-world CRUD, 1-N and N-N relationships (via a join entity), and LINQ-based reports — all through a structured, friendly terminal UI.

📝 Description

This project is a modular console app that simulates a mini learning platform back office. It covers the full flow:

  • Create Categories ➜ add Instructors ➜ add Courses ➜ manage Students ➜ Enroll students ➜ generate Reports — with consistent menus, validation helpers, and a reusable reporting printer.

✨ Features

  • ➕ CRUD for Students, Instructors, Categories, and Courses
  • 🧾 Enroll students into courses (prevents duplicate enrollments)
  • 📊 Reports:
    • Courses with their instructors
    • Enrollment count per course
    • Students with their courses
    • Course (by ID) with enrolled students
    • Top 3 courses by enrollments
  • 🔎 Query helper: Get courses under a specific price (service-level)
  • 🧱 Separation of concerns: Models, Services, Screens, Helpers, Data
  • 🧰 Generic base service for common CRUD with EF Core
  • 🧯 Graceful console messages + minimal error handling on SaveChanges()

🗂️ Project Structure

CourseManagementSystem/
├── Data/
│   └── AppDbContext.cs              # EF Core DbContext + relationships
├── Helpers/
│   ├── ConsoleUIHelper.cs           # Boxed menus, prompts
│   └── InputHelper.cs               # Input validation (int/decimal/string)
├── Migrations/                      # EF Core migrations + snapshot
├── Models/
│   ├── CategoryModel.cs
│   ├── CourseModel.cs
│   ├── EnrollmentModel.cs
│   ├── InstructorModel.cs
│   └── StudentModel.cs
├── Screens/
│   ├── Category/
│   │   ├── AddCategoryScreen.cs
│   │   ├── CategoryMenuScreen.cs
│   │   └── ViewCategoriesScreen.cs
│   ├── Course/
│   │   ├── AddCourseScreen.cs
│   │   ├── CourseMenuScreen.cs
│   │   ├── UpdateCourseScreen.cs
│   │   └── ViewCourseScreen.cs
│   ├── Instructor/
│   │   ├── AddInstructorScreen.cs
│   │   ├── InstructorMenuScreen.cs
│   │   └── ViewInstructorsScreen.cs
│   ├── Reports/
│   │   ├── ReportPrinter.cs
│   │   ├── ReportsMenuScreen.cs
│   │   └── ReportsRenderingMethodsScreen.cs
│   └── Student/
│       ├── AddStudentScreen.cs
│       ├── DeleteStudentScreen.cs
│       ├── EnrollStudentScreen.cs
│       ├── StudentMenuScreen.cs
│       ├── UpdateStudentScreen.cs
│       └── ViewStudentsScreen.cs
├── Services/
│   ├── BaseService.cs
│   ├── CategoryService.cs
│   ├── CourseService.cs
│   ├── EnrollmentService.cs
│   ├── InstructorService.cs
│   ├── ReportService.cs
│   └── StudentService.cs
└── Program.cs

🧩 Models & Relationships

Category (1) ─── (∞) Course (∞) ───  (∞) Student    via Enrollment 
                    │
                    └── (1) Instructor
  • Many-to-Many between Student and Course inplemented via Enrollment join table
  • One-to-Many: Instructor -> Courses, Category -> Courses
  • Relationships configured in AppDbContext.OnModelCreating(…).

🧾 Properties of Models

  • StudentModel
    • int Id, string FullName, string Email
    • ICollection<EnrollmentModel> Enrollments
  • InstructorModel
    • int Id, string FullName, string Email
    • ICollection<CourseModel> Courses
  • CategoryModel
    • int Id, string Name
    • ICollection<CourseModel> Courses
  • CourseModel
    • int Id, string Title, string Description, decimal Price
    • int InstructorId, InstructorModel Instructor
    • int CategoryId, CategoryModel Category
    • ICollection<EnrollmentModel> Enrollments
  • EnrollmentModel
    • int Id
    • int StudentId, StudentModel Student
    • int CourseId, CourseModel Course

🧠 Services Overview

  • BaseService
    • Add(T entity), Update(T entity), T? GetById(int id), List<T> GetAll()
  • StudentService : BaseService
    • Delete(int id) ➜ removes student + their enrollments
    • GetStudentsWithoutCourses()
  • InstructorService : BaseService
  • CategoryService : BaseService
  • CourseService : BaseService
    • GetCoursesUnderPrice(decimal maxPrice) ➜ { Title, Price }
  • EnrollmentService : BaseService
  • ReportService
    • GetCoursesWithInstructors() ➜ { Title, InstructorName }
    • GetEnrollmentsCount() ➜ { Title, StudentCount }
    • GetStudentsWithCourses() ➜ StudentModel + Enrollments.Course
    • GetCourseWithStudents(int id) ➜ CourseModel + Enrollments.Student
    • GetTop3CoursesByEnrollments() ➜ { Title, Count }

🧭 Console Flow

[MAIN MENU]
  1) Student Menu
  2) Category & Instructor Management
  3) Course Menu
  4) Reports Menu
  5) Exit

Recommended workflow

  1. Add Category → 2. Add Instructor → 3. Add Course
  2. Add Student → 5. Enroll Student in Course → 6. Run Reports

🚀 Quick Start

# 1) Clone
git clone https
cd CourseManagementSystem

# 2) Ensure .NET SDK & EF Tools
dotnet --version
dotnet tool install --global dotnet-ef

# 3) Apply EF Core migrations (SQL Server LocalDB)
dotnet ef database update

# 4) Run
dotnet run

Connection string lives in AppDbContext.OnConfiguring (LocalDB):
Server=(localdb)\mssqllocaldb;Database=CourseManagementSystem;Trusted_Connection=True;
You can adapt it for a full SQL Server instance if needed.

🧰 Teck Stack

  • 🧱 C# .NET (Console App)
  • 🗄️ Entity Framework Core (with Migrations)
  • 🐘 SQL Server LocalDB
  • 🧮 LINQ queries + Include/ThenInclude
  • 🖥️ Console UI with boxed menus & validated input
  • 🧩 Clean separation across Data/Models/Services/Screens/Helpers

👀 Preview

╔══════════════════════════════════════════╗
║                MAIN MENU                 ║
╠══════════════════════════════════════════╣
║[1] Student Menu                          ║
║[2] Category & Instructor Management      ║
║[3] Course Menu                           ║
║[4] Reports Menu                          ║
║[5] Exit                                  ║
╚══════════════════════════════════════════╝
-> Select an option:

Sample “View Students” table

┌────┬────────────────────────────┬────────────────────────────────────┐
│ ID │        Full Name           │              Email                 │
├────┼────────────────────────────┼────────────────────────────────────┤
│  1 │ Mohamed Ahmed              │ mohamed@gmail.com                  │
│  2 │ Maria Amr                  │ maria@gmail.com                    │ 
└────┴────────────────────────────┴────────────────────────────────────┘

Report: Top 3 Courses by Enrollments

TOP 3 COURSES BY ENROLLMENTS
---------------------------------------------
Course Title                  |  Enrollments
---------------------------------------------
C# Fundamentals               |           12
SQL for Beginners             |            9
ASP.NET Core Essentials       |            7
---------------------------------------------

🧪 Example

# Add a Category
[Category Menu] -> Add Category
-> Enter Category Name: "Programming"

# Add an Instructor
[Instructor Menu] -> Add Instructor
-> Full Name: "Dr. Mostafa Saad"
-> Email: "mostafasaad@gamil.com"

# Add a Course
[Course Menu] -> Add Course
-> Title: "C++ Fundamentals"
-> Description: "Intro to C++"
-> Price: 1000.00
-> Instructor ID: 1
-> Category ID: 1

# Add Student
[Student Menu] -> Add Student
-> Full Name: "Mohamed Ahmed"
-> Email: "mohamed@gmail.com"

# Enroll Student
[Student Menu] -> Enroll Student in Course
-> Student ID: 1
-> Course ID: 1

# Reports
[Reports Menu] -> Enrollment count per course

🧠 What I Learned

  • Modeling 1–N and N–N relationships in EF Core with a join entity
  • writing espressive LINQ queries with Include/ThenInclude for eager loading
  • Building a generic service layer to reduce CRUD relationships
  • Designing console-first UX (clear menus, aligend tables, helpful prompts)
  • Organizing a solution for maintainability (Data/Models/Services/Screens/Helpers)
  • Using migrations and LocalDB connection for quick persistence

🔭 Future Enhancement

  • ✅ Use the “courses under price” query in the UI (currently implemented at service level)
  • 🔍 Search & filters (by name, price range, category) + pagination in listings
  • 🧹 Stronger input validation, domain rules, and centralized error handling
  • 🧱 Introduce DTOs/mappers to separate UI from EF entities
  • 🧪 Unit tests for services and helpers
  • 🧾 Seed data for quick demos
  • ⚙️ Move connection string to configuration (appsettings) and support multiple environments
  • 📤 Export reports to CSV/JSON
  • 🧑‍💻 Consider moving to a web UI (ASP.NET Core MVC/Minimal APIs) later

🤍 Task Outline in Breakin Point (Student Activity)

📎 Task Outline (Google Drive)

📸 Archived Copy at submission time (Google Drive)

Made with ❤️ by Kenzy Ragab

Feel free to fork, use, or contribute to this project!