MyRegPlanner - University Course Registration Planner

📋 Overview

MyRegPlanner is a desktop application built with C# and .NET 8.0 Windows Forms, designed to help university students plan their course registrations efficiently. The application allows students to add courses, set section priorities, and generate optimal class routines based on their preferences and constraints. I made it as a fun project to practice as well as to help me during my University course registrations.

✨ Features

• Course Management: Add and manage courses with multiple sections
• Section Priority: Set priorities for different course sections based on preferences
• Routine Generation: Automatically generate class schedules avoiding time conflicts
• Dashboard: Overview of added courses and generated routines
• Excel Export: Export generated routines to Excel format using ClosedXML
• Visual Interface: Modern UI with custom panels and intuitive navigation
• Input Validation: Ensures data integrity with built-in validation utilities

🎯 Purpose

This practice project was developed to:

• Solve a real-world problem of course registration planning
• Demonstrate proficiency in Windows Forms development
• Practice working with third-party libraries (ClosedXML, Krypton Toolkit)
• Apply software architecture principles (BLL pattern, separation of concerns)

🏗️ System Architecture

MyRegPlanner follows a layered architecture:

Presentation Layer (Forms + UserControls) → Business Logic Layer (BLL) → Data Access Layer (Data)

Components

Presentation Layer

• Forms: Main application windows (MainForm, SplashScreen, SectionPriority)
• UserControls: Reusable UI components (Dashboard, AddCourses, Routines)

Business Logic Layer

• Course and Section management
• Priority algorithms
• Routine generation logic
• Query management for data operations

Data Access Layer

• Database connection management

Utilities

• Form design helpers
• Input validation functions

📁 Project Structure

MyRegPlanner/
├── MyRegPlanner.sln          # Solution file
│
└── MyRegPlanner/
    ├── Assets/               # Images and icons
    │   ├── general/          # UI icons
    │   └── [UI assets]
    ├── BLL/                  # Business Logic Layer
    │   ├── Course.cs
    │   ├── Section.cs
    │   ├── AddCoursesManager.cs
    │   ├── AddCoursesQueries.cs
    │   ├── RoutinesManager.cs
    │   ├── RoutinesQueries.cs
    │   └── SectionPriorityManager.cs
    ├── Data/                 # Data Access Layer
    │   └── DatabaseConnection.cs
    ├── Forms/                # Application Forms
    │   ├── MainForm.cs
    │   ├── SplashScreen.cs
    │   └── SectionPriority.cs
    ├── UserControls/         # Reusable UI Components
    │   ├── Dashboard.cs
    │   ├── AddCourses.cs
    │   └── Routines.cs
    ├── Utilities/            # Helper Classes
    │   ├── FormDesign.cs
    │   └── InputValidator.cs
    ├── Properties/           # Project properties
    ├── bin/                  # Build output (ignored)
    ├── obj/                  # Build intermediates (ignored)
    ├── MyRegPlanner.csproj   # Project file
    └── Program.cs            # Entry point

✨ Demo & Screenshots

Dashboard	Add courses

Generate Courses	Section Priority

🚀 Setup Instructions

Prerequisites

• Visual Studio 2022 or later
• .NET 8.0 SDK
• SQL Server 2019 or later
• Windows 10/11

Installation

1. Clone the repository

   git clone https://github.com/LT-Ripjaws/MyRegPlanner-csharp-project.git
   cd MyRegPlanner-csharp-project

2. Open the solution

   • Open MyRegPlanner.sln in Visual Studio

3. Restore NuGet Packages

   • Packages should restore automatically
   • If not: Right-click Solution → Restore NuGet Packages

4. Database Configuration

   • Update connection string in Data/DatabaseConnection.cs Set the location of the provided .mdf:

   private string connectionString = "Server=YOUR_SERVER;Database=MyRegPlannerDB;Integrated Security=true;TrustServerCertificate=true;";

5. Build and Run

• Build → Build Solution (Ctrl+Shift+B)
• Press F5 to run

💡 Usage

Adding Courses

1. Navigate to the Add Courses tab
2. Enter course details
3. Add sections

Setting Section Priorities

1. Go to Section Priority window
2. View all available sections
3. Assign priority
4. Higher priority sections are preferred during routine generation

Generating Routines

1. Navigate to the Routines tab
2. Click Generate Routine
3. The algorithm will:
   • Select sections based on priority
   • Avoid time conflicts
4. View generated routine in the grid
5. Export to Excel if needed

Dashboard

• View summary of added courses
• Check total credits
• See routine statistics

🎓 Key Features Explained

Conflict Detection

The routine generator automatically detects and prevents:

• Overlapping time slots
• Same-day conflicts

Priority Algorithm

• Sections are ranked by user-assigned priority
• Higher priority sections are selected first
• Falls back to lower priority if conflicts exist

Excel Export

• Generates formatted Excel files
• Includes course details

🐛 Known Issues

• Routine generation may not find optimal solution
• Limited to single-semester planning
• Requires manual section data entry

📝 Notes

• Practice Project: This was developed as a practice project to solve a personal need during university course registration.
• Data Privacy: No personal student information is stored beyond course selections.

📄 License

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

📊 Project Status

🚧 Completed development – Version 1.0.0

👤 Author

Chinmoy Guha

• GitHub: @LT-Ripjaws
• Email: chinmoyguha676z@gmail.com