🏢 Hostel Management System

A comprehensive desktop application built with C# WPF and Material Design for managing all aspects of hostel operations. This system provides an intuitive, modern interface for managing students, rooms, staff, fees, visitors, complaints, and attendance records.

📋 Table of Contents

• Features
• Screenshots
• Technology Stack
• Prerequisites
• Installation
• Database Setup
• Configuration
• Usage
• Project Structure
• Key Modules
• Database Schema
• Development
• Contributing
• Future Enhancements
• License
• Contact

✨ Features

🎨 Modern User Interface

• Material Design principles with clean, professional aesthetics
• Responsive layouts that adapt to different screen sizes
• Card-based design with shadows and rounded corners
• Intuitive navigation with top navigation bar similar to modern web applications
• Smooth animations and hover effects for enhanced user experience
• Consistent typography and color scheme throughout the application

🔐 Authentication & Security

• Role-based access control (Admin, Warden, Staff)
• Secure login system with credential validation
• "Remember Me" functionality for convenience
• Password recovery option
• Session management

📊 Dashboard & Analytics

• Real-time statistics and metrics
• Quick access buttons to all modules
• Visual summary cards showing:
  • Total students count
  • Available/occupied rooms
  • Staff members count
  • Pending complaints
  • Fee collection status
  • Recent visitor logs

👨‍🎓 Student Management

• Complete CRUD operations (Create, Read, Update, Delete)
• Student profile management with:
  • Personal information (Name, DOB, Gender)
  • Contact details
  • Address information
  • Admission date tracking
  • Room assignment
• Advanced search and filter capabilities
• Bulk operations support
• Export student data functionality

🏠 Room Management

• Room allocation and deallocation
• Capacity tracking and management
• Room status management:
  • Available
  • Occupied
  • Under Maintenance
• Room type categorization (Single, Double, Triple, Quad)
• Visual occupancy indicators
• Room assignment workflow

🏢 Hostel Management

• Multiple hostel support
• Hostel information management:
  • Name and location
  • Capacity tracking
  • Warden assignment
  • Contact information
• Hostel-wise reports and analytics
• Occupancy statistics per hostel

👥 Staff Management

• Employee records management
• Role-based categorization:
  • Warden
  • Security Guard
  • Cleaner
  • Maintenance
  • Cook
  • Admin Staff
• Contact information tracking
• Staff directory with search
• Employment history

💰 Fee Management

• Comprehensive fee tracking system
• Payment status monitoring:
  • Paid
  • Pending
  • Overdue
• Fee collection recording
• Due date management
• Automated payment reminders
• Fee history per student
• Monthly/semester fee reports
• Payment receipt generation

👨‍👩‍👧‍👦 Visitor Management

• Visitor registration and logging
• Student visit tracking
• Relationship tracking (Parent, Friend, Relative, Guardian)
• Visit date and time recording
• Purpose of visit documentation
• Visitor history reports
• Security logs

📝 Complaints Management

• Complaint submission system
• Status tracking:
  • Pending
  • In Progress
  • Resolved
• Priority levels (Low, Medium, High, Critical)
• Category-based organization:
  • Maintenance
  • Food
  • Room Issues
  • Security
  • Other
• Resolution tracking and notes
• Complaint history
• Response time analytics

📅 Attendance Management

• Daily attendance marking system
• Individual student attendance recording
• Bulk attendance marking for efficiency
• Attendance reports:
  • Daily attendance sheets
  • Monthly attendance summaries
  • Student-wise attendance history
• Attendance percentage calculation
• Defaulter identification
• Export attendance data

📸 Screenshots

Login Window

Professional login interface with gradient background and role selection.

Dashboard

Modern dashboard with statistics cards and quick action buttons.

Student Management

Clean interface for managing student records with advanced search capabilities.

Room Management

Visual room management with status indicators and allocation tools.

🛠 Technology Stack

Frontend

• Framework: .NET 8.0 (Windows Desktop)
• UI Framework: Windows Presentation Foundation (WPF)
• Language: C# 12.0
• UI Library: MaterialDesignThemes (v4.9.0)
• Design: MaterialDesignColors (v2.1.4)

Backend & Database

• Database: Microsoft SQL Server 2019+
• Data Access: ADO.NET with System.Data.SqlClient (v4.8.6)
• Configuration: System.Configuration.ConfigurationManager (v8.0.0)

Architecture & Patterns

• MVVM-ready structure for future enhancements
• Repository pattern compatible design
• Stored procedures for database operations
• Modular page-based architecture

📦 Prerequisites

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

• Operating System: Windows 10 (1809+) or Windows 11
• .NET SDK: .NET 8.0 SDK or later
• Database: SQL Server 2019 or later
  • SQL Server Express (free) is sufficient
  • SQL Server Management Studio (SSMS) recommended
• IDE (Optional but recommended):
  • Visual Studio 2022 (Community/Professional/Enterprise)
  • Or VS Code with C# extension
• Git: For cloning the repository

🚀 Installation

Step 1: Clone the Repository

git clone https://github.com/1hadii/HostelManagementSystem.git
cd HostelManagementSystem

Step 2: Restore NuGet Packages

dotnet restore

Step 3: Database Setup

See the Database Setup section below for detailed instructions.

Step 4: Configure Connection String

1. Open App.config in the root directory
2. Update the connection string with your SQL Server details:

<add name="HostelManagementDB" 
     connectionString="Server=localhost\SQLEXPRESS;Database=HostelManagementSystemDB;Trusted_Connection=True;TrustServerCertificate=True;Encrypt=False;" 
     providerName="System.Data.SqlClient" />

Replace YOUR_SERVER_NAME with your SQL Server instance name.

Step 5: Build the Application

dotnet build

Step 6: Run the Application

dotnet run

Or open the solution in Visual Studio and press F5 to run.

💾 Database Setup

Method 1: Using SQL Script (Recommended)

1. Open SQL Server Management Studio (SSMS)

2. Connect to your SQL Server instance

3. Execute the main SQL script:

   • Open HostelManagementQuery.sql
   • Execute the entire script (F5)
   • This will:
     • Create the database HostelManagementSystemDB
     • Create all required tables
     • Insert sample data
     • Create stored procedures

4. Execute the triggers script:

   • Open TriggersSetup.sql
   • Execute the script to set up database triggers

5. Verify the setup:

   • Check that all tables are created
   • Verify sample data is inserted
   • Test stored procedures

Method 2: Manual Setup

Detailed step-by-step instructions are available in DATABASE_SETUP.md.

Sample Data

The database comes with pre-loaded sample data including:

• 28 Students across different rooms
• 16 Rooms (14 occupied, 2 available)
• 5 Hostels with assigned wardens
• 11 Staff members across different roles
• Fee records for all students
• Visitor logs with various relationships
• Complaint records with different statuses
• 3 days of attendance records

⚙ Configuration

Connection String Configuration

The application uses App.config for database connection settings. Three configuration options are provided:

1. Windows Authentication (Recommended):

Server=localhost\SQLEXPRESS;Database=HostelManagementSystemDB;Trusted_Connection=True;TrustServerCertificate=True;Encrypt=False;

2. SQL Server Authentication:

Server=YOUR_SERVER;Database=HostelManagementSystemDB;User Id=YOUR_USERNAME;Password=YOUR_PASSWORD;TrustServerCertificate=True;Encrypt=False;

3. Default Instance:

Server=localhost;Database=HostelManagementSystemDB;Trusted_Connection=True;TrustServerCertificate=True;Encrypt=False;

Finding Your SQL Server Instance Name

Run this command in Command Prompt or PowerShell:

sqlcmd -L

Or check SQL Server Configuration Manager.

📖 Usage

Login

1. Launch the application
2. Enter your credentials (see sample users in database)
3. Select your role (Admin/Warden/Staff)
4. Click "Login"

Default Test Credentials:

• Use any username and password (demo mode available)
• Or use credentials from LoginUsers table in the database

Navigation

• Top Navigation Bar: Click on any menu item to navigate between modules
• Dashboard: Central hub with quick access to all features
• Search: Use search boxes to quickly find records
• Actions: Use action buttons for Create, Edit, Delete operations

Common Operations

Adding a New Student

1. Navigate to Student Management
2. Click "Add Student" button
3. Fill in the required information
4. Select an available room
5. Click "Save"

Room Allocation

1. Go to Room Management
2. Find an available room
3. Click "Assign" button
4. Select a student from the list
5. Confirm allocation

Recording Attendance

1. Navigate to Attendance Management
2. Select date
3. Mark attendance for students (Present/Absent)
4. Use bulk marking for efficiency
5. Save attendance records

Managing Complaints

1. Go to Complaints Management
2. View pending complaints
3. Update status as you work on them
4. Add resolution notes
5. Mark as resolved when complete

📁 Project Structure

HostelManagementSystem/
│
├── 📄 App.xaml                          # Application-level resources and startup
├── 📄 App.xaml.cs                       # Application startup logic
├── 📄 App.config                        # Configuration (connection strings)
│
├── 🪟 Windows/
│   ├── LoginWindow.xaml                 # Login interface
│   ├── LoginWindow.xaml.cs              # Login logic
│   ├── DashboardWindow.xaml             # Main application window
│   └── DashboardWindow.xaml.cs          # Dashboard logic and navigation
│
├── 📄 Pages/
│   ├── HomePage.xaml                    # Dashboard with statistics
│   ├── HomePage.xaml.cs
│   ├── StudentManagementPage.xaml       # Student CRUD operations
│   ├── StudentManagementPage.xaml.cs
│   ├── RoomManagementPage.xaml          # Room management
│   ├── RoomManagementPage.xaml.cs
│   ├── HostelManagementPage.xaml        # Hostel management
│   ├── HostelManagementPage.xaml.cs
│   ├── StaffManagementPage.xaml         # Staff management
│   ├── StaffManagementPage.xaml.cs
│   ├── FeeManagementPage.xaml           # Fee tracking
│   ├── FeeManagementPage.xaml.cs
│   ├── VisitorLogPage.xaml              # Visitor registration
│   ├── VisitorLogPage.xaml.cs
│   ├── ComplaintsPage.xaml              # Complaints management
│   ├── ComplaintsPage.xaml.cs
│   ├── AttendancePage.xaml              # Attendance marking
│   └── AttendancePage.xaml.cs
│
├── 📦 Models/
│   └── Models.cs                        # Data models for all entities
│
├── 🔧 Services/
│   └── DatabaseConnection.cs            # Database connection management
│
├── 🖼️ Images/
│   ├── hostel.png                       # Application icons
│   └── hotel.png
│
├── 💾 Database/
│   ├── HostelManagementQuery.sql        # Main database script
│   ├── TriggersSetup.sql                # Database triggers
│   ├── Database_README.md               # Database documentation
│   └── HostelManagementQuery_StoredProcedures_Explanation.md
│
├── 📄 HostelManagementSystem.csproj     # Project file
├── 📄 HostelManagementSystem.sln        # Solution file
├── 📄 README.md                         # This file
└── 📄 .gitignore                        # Git ignore rules

🔑 Key Modules

1. Authentication Module

• Location: LoginWindow.xaml/.cs
• Features: User validation, role selection, remember me
• Database: Uses sp_ValidateLogin stored procedure

2. Student Management Module

• Location: Pages/StudentManagementPage.xaml/.cs
• Features: CRUD operations, search, room assignment
• Database:
  • sp_GetAllStudents
  • sp_AddStudent
  • sp_UpdateStudent
  • sp_DeleteStudent

3. Room Management Module

• Location: Pages/RoomManagementPage.xaml/.cs
• Features: Room allocation, status tracking, capacity management
• Database:
  • sp_GetAllRooms
  • sp_AddRoom
  • sp_UpdateRoom
  • sp_DeleteRoom

4. Fee Management Module

• Location: Pages/FeeManagementPage.xaml/.cs
• Features: Payment tracking, due date management, receipts
• Database:
  • sp_GetAllFees
  • sp_AddFee
  • sp_UpdateFee
  • sp_DeleteFee

5. Attendance Module

• Location: Pages/AttendancePage.xaml/.cs
• Features: Daily marking, bulk operations, reports
• Database:
  • sp_GetAllAttendance
  • sp_AddAttendance
  • sp_UpdateAttendance
  • sp_DeleteAttendance

🗄 Database Schema

Core Tables

Students

• Id (PK), Name, DateOfBirth, Gender, Contact, Address, AdmissionDate, AssignedRoom (FK)

Rooms

• Id (PK), RoomNumber, Capacity, HostelId (FK), Status

Hostels

• Id (PK), Name, Location, WardenId (FK), Contact

Staff

• Id (PK), Name, Role, Contact, Email, JoinDate

Fees

• Id (PK), StudentId (FK), Amount, DueDate, PaidDate, Status

Visitors

• Id (PK), StudentId (FK), VisitorName, Relationship, VisitDate, Purpose

Complaints

• Id (PK), StudentId (FK), ComplaintText, Status, SubmittedDate, ResolvedDate

Attendance

• Id (PK), StudentId (FK), Date, Status (Present/Absent)

LoginUsers

• Id (PK), Username, Password, Role

Stored Procedures

The application uses 32+ stored procedures for all database operations:

• Student Operations: 4 procedures (CRUD)
• Room Operations: 4 procedures
• Hostel Operations: 4 procedures
• Staff Operations: 4 procedures
• Fee Operations: 4 procedures
• Visitor Operations: 4 procedures
• Complaint Operations: 4 procedures
• Attendance Operations: 4 procedures
• Authentication: 1 procedure

See HostelManagementQuery_StoredProcedures_Explanation.md for detailed documentation.

👨‍💻 Development

Building from Source

# Clone the repository
git clone https://github.com/1hadii/HostelManagementSystem.git

# Navigate to project directory
cd HostelManagementSystem

# Restore dependencies
dotnet restore

# Build the project
dotnet build --configuration Release

# Run the application
dotnet run

Debugging in Visual Studio

1. Open HostelManagementSystem.sln in Visual Studio 2022
2. Set HostelManagementSystem as the startup project
3. Press F5 or click "Start Debugging"

Code Style

• Follow C# naming conventions
• Use meaningful variable and method names
• Add XML documentation comments for public methods
• Keep methods focused and concise
• Use async/await for database operations

Testing

Currently, the application includes:

• Sample data for testing all features
• Manual testing procedures
• Database validation scripts

Future: Unit tests and integration tests planned.

🤝 Contributing

Contributions are welcome! Here's how you can help:

Reporting Bugs

1. Check if the bug has already been reported
2. Create a new issue with detailed description
3. Include steps to reproduce
4. Add screenshots if applicable

Suggesting Features

1. Open an issue describing the feature
2. Explain the use case and benefits
3. Provide mockups or examples if possible

Pull Requests

1. Fork the repository
2. Create a feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

Development Guidelines

• Follow the existing code style
• Write clear commit messages
• Update documentation as needed
• Test your changes thoroughly
• Ensure all builds pass

🚀 Future Enhancements

Planned Features

• Advanced Reporting

  • PDF report generation
  • Excel export functionality
  • Custom report builder
  • Scheduled report emails

• Enhanced Security

  • Password hashing (BCrypt/SHA256)
  • Multi-factor authentication
  • Session timeout management
  • Activity logging

• File Management

  • Student photo upload
  • Document management
  • ID card generation
  • Document scanner integration

• Notifications

  • Email notifications for fee due dates
  • SMS alerts for important events
  • In-app notification center
  • Push notifications

• Analytics Dashboard

  • Interactive charts (using LiveCharts/OxyPlot)
  • Trend analysis
  • Occupancy forecasting
  • Financial analytics

• Mobile App

  • Cross-platform mobile app (Xamarin/MAUI)
  • Student portal
  • Parent access
  • QR code scanning

• Integration

  • Biometric attendance system integration
  • Payment gateway integration
  • Email/SMS gateway integration
  • Cloud backup integration

• Advanced Features

  • Multi-language support
  • Dark mode theme
  • Customizable dashboards
  • Role-based permissions
  • Audit trail
  • Data export/import (CSV, JSON)
  • Backup and restore utilities
  • Advanced search with filters
  • Bulk operations

📄 License

This project is available under the MIT License. See LICENSE file for details.

MIT License

Copyright (c) 2026 [Abdul Hadi Sohail]

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.

📧 Contact

Project Maintainer: Abdul Hadi Sohail

• GitHub: 1hadii
• Email: abdulhadisohail786@gmail.com
• LinkedIn: (https://www.linkedin.com/in/abdul-hadi-sohail-4b738a289/)

Project Link: (https://github.com/1hadii/HostelManagementSystem)

🙏 Acknowledgments

• Material Design In XAML Toolkit for the beautiful UI components
• .NET Foundation for the excellent framework
• All contributors who helped improve this project

---

⭐ Star this repository if you find it helpful!

Made with ❤️ using C# and WPF

Features

🏠 Modern Web-like UI Design

• Clean, responsive layout with Material Design principles
• Top navigation bar similar to web applications
• Card-based layouts with shadows and rounded corners
• Modern color scheme and typography
• Hero banner on the home page

🔐 Authentication System

• Professional login window with gradient background
• Role-based access (Admin, Warden, Staff)
• "Remember Me" functionality
• Forgot password option

📊 Dashboard Overview

• Real-time statistics cards
• Quick action buttons
• Visual summary of hostel metrics
• Easy navigation to all modules

👨‍🎓 Student Management

• Add, edit, delete student records
• Track admission dates and room assignments
• Search and filter functionality
• Export student data

🏠 Room Management

• Room allocation and capacity management
• Availability tracking
• Room status updates (Available/Occupied/Under Maintenance)
• Assignment functionality

🏢 Hostel Management

• Multiple hostel support
• Warden assignments
• Location tracking
• Comprehensive hostel information

👥 Staff Management

• Employee records management
• Role-based categorization
• Contact information tracking
• Staff directory

💰 Fee Management

• Fee collection tracking
• Payment status monitoring
• Due date management
• Automated reports

👨‍👩‍👧‍👦 Visitor Log

• Visitor registration
• Student visit history
• Relationship tracking
• Daily visitor reports

📝 Complaints Management

• Complaint submission system
• Status tracking (Pending/In Progress/Resolved)
• Priority management
• Resolution tracking

📅 Attendance Management

• Daily attendance marking
• Individual and bulk attendance
• Attendance reports and analytics
• Historical data tracking

Technology Stack

• Framework: .NET 8 with WPF
• Language: C#
• UI Library: Material Design In XAML Toolkit
• Architecture: MVVM-ready structure
• Database: Designed for easy database integration

Project Structure

HostelManagementSystem/
├── Models/
│   └── Models.cs                 # Data models for all entities
├── Pages/
│   ├── HomePage.xaml/cs          # Dashboard with statistics
│   ├── StudentManagementPage.xaml/cs
│   ├── RoomManagementPage.xaml/cs
│   ├── HostelManagementPage.xaml/cs
│   ├── StaffManagementPage.xaml/cs
│   ├── FeeManagementPage.xaml/cs
│   ├── VisitorLogPage.xaml/cs
│   ├── ComplaintsPage.xaml/cs
│   └── AttendancePage.xaml/cs
├── LoginWindow.xaml/cs           # Authentication interface
├── DashboardWindow.xaml/cs       # Main application window
├── App.xaml/cs                   # Application startup and styling
└── HostelManagementSystem.csproj # Project configuration

Key Features of the UI

🎨 Design Elements

• Modern Button Styles: Rounded corners, hover effects, shadows
• Professional Color Scheme: Material Design color palette
• Responsive Layout: Adapts to different screen sizes
• Card-based Design: Clean separation of content areas
• Consistent Typography: Professional font choices and sizing

🖥️ User Experience

• Intuitive Navigation: Top navigation bar with clear menu items
• Form Validation: Real-time input validation with user-friendly messages
• Data Grids: Sortable, searchable data tables with alternating row colors
• Modal Dialogs: Confirmation dialogs for critical actions
• Status Indicators: Visual feedback for operations and data states

Sample Data

The application comes pre-loaded with sample data for demonstration:

• 5+ students with complete profiles
• 8 rooms with different capacities and statuses
• 5 hostels with assigned wardens
• 11 staff members across different roles
• Fee records with payment tracking
• Visitor logs with relationship tracking
• Complaint records with status management
• Attendance records with analytics

Getting Started

1. Prerequisites:

   • .NET 8 SDK or later
   • Visual Studio 2022 or VS Code

2. Build and Run:

   cd HostelManagementSystem
   dotnet build
   dotnet run

3. Login Credentials:

   • Use any role (Admin/Warden/Staff)
   • Enter any username and password (demo mode)

Database Integration

The application is structured to easily integrate with databases:

• Entity Framework Core ready
• Repository pattern can be easily implemented
• Data models are already defined
• CRUD operations are abstracted and ready for backend integration

Future Enhancements

• Database Integration: SQL Server, PostgreSQL, or SQLite
• Reporting System: PDF/Excel report generation
• Email Notifications: Automated alerts and reminders
• File Upload: Student photos and document management
• Advanced Search: Global search across all modules
• Data Export: CSV/Excel export functionality
• Backup & Restore: Database backup and restore features
• Multi-language Support: Internationalization
• Audit Trail: Activity logging and history
• Advanced Analytics: Charts and graphs for insights

Screenshots

The application features:

• Login Window: Professional login interface with gradient background
• Dashboard: Modern dashboard with statistics cards and quick actions
• Management Pages: Clean, form-based interfaces for all modules
• Data Tables: Professional data grids with search and sort capabilities

Contributing

This is a complete, production-ready hostel management system that can be extended and customized for specific needs. The modular design makes it easy to add new features or modify existing functionality.

License

This project is created for educational and professional use. Feel free to modify and adapt it for your specific requirements.