AIUB•Academic Capstone•enterprise
Enterprise University Management System – C# .NET Desktop ERP
Enterprise 3-tier desktop ERP application engineered in C# and .NET Framework 4.5 with Windows Forms and Microsoft SQL Server to automate campus academic administration, course enrollment, and student records.
Executive Overview & Key Engineering Deliverables
- 3-Tier Role Governance: Dedicated desktop environments for Administrators (system controls), Faculty (grading and attendance), and Students (course enrollment and transcripts).
- Prerequisite Validation Engine: Automated prerequisite logic enforcing passing mark thresholds (mid_mark >= 50) and administrative pre-registration control toggles (sprereg / fprereg) to manage enrollment windows.
- Atomic Data Persistence: Hybrid data access layer coupling strongly-typed LINQ to SQL entities with ADO.NET DataSets and SqlCommandBuilder for single-transaction batch grid persistence.
- Interactive Academic Matrix: Feature-rich WinForms DataGridView components with column freezing, 5-day lecture attendance logging, and midterm/final grade tracking.
C#.NET Framework 4.5Windows Forms (WinForms)Microsoft SQL ServerADO.NETLINQ to SQLLocalDB / MDFT-SQL
Role Portals
3 RBAC Portals
Departments
CSE, EEE, BBA
Data Architecture
LINQ + ADO.NET
Database Engine
MS SQL Server
LIVE SYSTEM SIMULATION & INTERACTIVE PREVIEW
STATUS: ACTIVE WEBGL/SIMENTERPRISE UNIVERSITY MANAGEMENT // C# .NET DESKTOP ERP
STUDENT COURSE PORTAL • WINFORMS/WPF • SQL SERVER ACIDAIUB UNIVERSITY ERP // C# .NET COURSE MANAGEMENTDESKTOP ERP
STUDENT: Farhad Zaman (17-34821-2) • AIUB CSE • SQL Server 2022
Farhad-DevStation (Windows 11 / .NET 8 SDK)
Active: CSC 4102 (Section B)
#
AIUB University ERP v4.2 - [Student Course Management - Farhad Zaman (17-34821-2)]|Logged in: Farhad Zaman (17-34821-2)
CGPA: 3.82Completed: 139 / 148 Cr
AIUB Portal ERP
CSC 4102
Section B • Spring Semester 2026Advanced Database Systems & Architecture
Credits:3.0 Cr (Lecture: 3h, Lab: 1h)
Faculty Instructor:Dr. K. Rahman
Faculty Office:Faculty Bldg CS-402, Ext: 284
Lecture Schedule:Sun & Tue 10:00 AM – 11:30 AM
Lecture Room:AB4-302
Lab Session:Wed 02:00 PM – 04:00 PM
Lab Room:Database Lab 3 (CS-108)
Enrollment Status:ENROLLED
Roster Capacity:38 / 40 Students (95% Filled)
PREREQUISITE ACADEMIC AUDIT:✓ ELIGIBLE FOR ENROLLMENT
CSC 3102: Database Management Systems IGrade: A (Req: C) ✓
CSC 2201: Data Structures & AlgorithmsGrade: A+ (Req: C) ✓
Midterm: 30%Final: 40%Lab Project: 20%Quizzes: 10%
OFFERED COURSES // System.Windows.Forms.DataGridViewClick a row to inspect course
| Code | Course Title | Cr. | Sec | Schedule | Room | Status |
|---|---|---|---|---|---|---|
| CSC 4102 | Advanced Database Systems & Architecture | 3.0 | B | Sun & Tue 10:00 AM – 11:30 AM | AB4-302 | ENROLLED |
| CSC 3201 | C# .NET Enterprise Systems Development | 3.0 | A | Mon & Wed 08:30 AM – 10:00 AM | CS-204 | ENROLLED |
| CSC 4211 | Computer Vision & Stereo Depth Tracking | 3.0 | C | Mon & Wed 12:00 PM – 01:30 PM | CS-301 | ENROLLED |
| MAT 2101 | Complex Variable, Fourier & Statistics | 3.0 | D | Sun & Tue 02:00 PM – 03:30 PM | MATH-102 | ENROLLED |
| ENG 1202 | Technical Communication & Research Writing | 3.0 | A | Thursday 10:00 AM – 01:00 PM | CS-105 | COMPLETED |
Ready|Connected: MS SQL Server 2022 (aiub_erp_prod)|Protocol: TCP/IP (Port 1433)
Stored Proc: dbo.usp_GetStudentCourseDetails|Isolation: SERIALIZABLE|3.4ms
FULL-STACK SYSTEM ARCHITECTURE SPECIFICATION
CLIENT & UI TIER
- C# .NET Windows Forms (WinForms) multi-window desktop interface with MDI-style container panels and tooltips.
- Role-segregated operational dashboards (Administrator, Faculty, Student) with pattern-based ID validation (XX-XXXXX-X for students, XXX-XXX-XX for faculty, X-XXXX-XXX for admins).
- Interactive DataGridView components with in-place cell editing, column freezing (student ID/name), and read-only protections.
- Dynamic ComboBox cascaded data bindings querying real-time database records for departments, terms, and course rosters.
- Visual status indicators (System.Drawing.Color) for real-time pre-registration lock/unlock switches and blank-field validation alerts.
API & REAL-TIME ENGINE
- .NET Framework 4.5 business logic engine coordinating academic enrollment policies and course scheduling rules.
- Prerequisite validation solver checking course requirements and minimum mark thresholds (mid_mark >= 50) prior to course addition.
- Administrative pre-registration control mechanism (sprereg / fprereg) dynamically opening and closing self-service student and faculty enrollment windows.
- Multi-department curriculum orchestrator automatically synchronizing course listings across CSE, EEE, and BBA departments.
- Atomic dataset synchronization engine utilizing SqlCommandBuilder and SqlDataAdapter to persist bulk grid mutations in a single transaction.
DATA & INFRASTRUCTURE
- Microsoft SQL Server relational database (LocalDB / Express db.mdf) with primary key constraints and foreign key relationships (dept, faculty, student).
- Normalized relational schema spanning taken_course, student, faculty, admin, fprereg, sprereg, and departmental curriculum catalogs (CSE, EEE, BBA).
- Hybrid data access layer (DataAccess.cs) coupling LINQ to SQL ORM (dbDataContext) with ADO.NET (SqlConnection, SqlCommand, DataSet).
- Course-to-faculty assignment junction tables (CSE_faculty_course, eee_faculty_course, bba_faculty_course) managing instructor teaching loads.
- 5-day lecture attendance matrix (day1 to day5) and midterm/final grade tracking columns directly integrated into course records.
- Local database file attachment (|DataDirectory|\db.mdf) and SQL Server Compact (db.sdf) multi-provider connection string failover.
ROLE-BASED WORKFLOW SPECIFICATION (RBAC)
AdministratorCAMPUS REGISTRATION GOVERNANCE
- ▸Student Lifecycle: Register new students with academic metadata, search/remove records, and modify bio/contact info via interactive DataGridView
- ▸Faculty Governance: Onboard professors and lecturers across departments (CSE, EEE, BBA), manage departmental assignments, and search/remove faculty accounts
- ▸Curriculum & Course Catalog: Add new courses (Course ID, Title, Credit Hours, Prerequisites) dynamically syncing departmental course lists and faculty teaching pools
- ▸Pre-Registration Controls: Global master toggles (sprereg for students, fprereg for faculty) opening or locking enrollment windows with active semester terms
- ▸Multi-Admin Delegation: Provision secondary administrative accounts with strict ID format validation (X-XXXX-XXX)
FacultyFACULTY & ACADEMIC INSTRUCTOR
- ▸Teaching Schedule: View assigned courses, enrolled credits, and student rosters filtered by academic semester
- ▸Course Claiming: Select and claim offered departmental curriculum courses during active faculty pre-registration windows
- ▸5-Day Attendance Tracking: Log and audit student attendance across instructional days (day1 through day5) using DataGridView batch updates
- ▸Grading & Evaluation: Submit midterm and final term marks and letter grades with locked/read-only student ID columns and atomic dataset submission
- ▸Self-Service Credentials: Secure credential management and password update workflows
StudentUNDERGRADUATE STUDENT
- ▸Academic Semester Records: Review enrolled course history, assigned instructors, midterm grades, and final term letter grades by semester
- ▸Self-Service Pre-Registration: Register for offered courses during open pre-registration windows (sprereg status=1), validating course prerequisite passing thresholds (mid_mark >= 50)
- ▸Course Drop & Adjustment: Add or drop courses dynamically from taken_course before semester lock
- ▸Detailed Grade Breakdown: View itemized midterm and final term marks, grades, and credit hours per subject
- ▸Class Attendance Auditing: Track individual attendance percentages across day1–day5 per enrolled lecture
- ▸Student Self-Service: Password updates and contact record verification
Key Technical Achievements
- 013-Tier Role Governance: Engineered segregated desktop environments for Administrator (system governance), Faculty (grading & attendance), and Student (registration & grades) with pattern-based login credentials.
- 02Prerequisite & Pre-Registration Engine: Built automated prerequisite verification checking student course completion (mid_mark >= 50) coupled with admin master toggles (sprereg / fprereg) controlling enrollment windows.
- 03Multi-Department Curriculum Orchestrator: Dynamic course management supporting Computer Science (CSE), Electrical Engineering (EEE), and Business Administration (BBA) with synchronized faculty assignment pools.
- 045-Day Attendance & Grading Grid: Interactive DataGridView grade book allowing faculty to record daily lecture attendance (day1–day5) and enter midterm/final term numerical scores and letter grades.
- 05Hybrid ADO.NET & LINQ to SQL Architecture: High-performance data layer coupling strongly-typed LINQ to SQL entities (db.dbml) for identity queries with ADO.NET DataSets for disconnected batch persistence.
- 06Student Academic Transcripts: Self-service student portal displaying semester course histories, instructor names, midterm/final grades, and course drop capabilities before semester lock.
Measurable Impact & Production Verification
Eliminated paper-based course registration, automated prerequisite enforcement across multi-department curricula (CSE, EEE, BBA), and enabled real-time attendance and grade synchronization between faculty and students.
Key Production Deliverables & Verification
3-Tier Desktop ERP Architecture
Dedicated WinForms environments for Administrator, Faculty, and Students with pattern-based ID validation.
Prerequisite & Pre-Registration Engine
Automated prerequisite verification (mid_mark >= 50) and master admin enrollment window switches.
Atomic ADO.NET Persistence
Single-transaction batch grid persistence using SqlCommandBuilder and SqlDataAdapter for attendance and grades.
5-Day Attendance & Grading Matrix
Interactive DataGridView grade book with column freezing, locked student IDs, and real-time GPA tracking.