← BACK TO PORTFOLIO

ALMOHAFED MANAGEMENT SYSTEM

Advanced management and recitation tracking system for Quran learning centers.

RoleDesktop Application Developer
Tech StackVB.NET, SQL Server, WinForms

OVERVIEW

AlMohafed is a comprehensive management and recitation tracking system specifically engineered for Quran learning centers. Developed using VB.NET WinForms and SQL Server, the application modernizes administrative operations and student progression tracking. The system utilizes a Repository-based software architecture to ensure robust data handling, maintainable code, and a seamless operational flow for administrators, educators (Sheikhs), and students.

AlMohafed System Screenshot 1
AlMohafed System Screenshot 2
AlMohafed System Screenshot 3
AlMohafed System Screenshot 4
AlMohafed System Screenshot 5

KEY FEATURES

  • ▸ Student & Staff Management: Efficiently manage student enrollment, demographics, and Sheikh assignments with full CRUD capabilities and role-based access control.
  • ▸ Quranic Database Engine: Features a fully structured Quran database integrating Suras and Ayat, supporting dynamic loading, Arabic RTL rendering, and traditional Mushaf-style typographic display via custom fonts like Amiri and Cairo Play.
  • ▸ Recitation (Tasmee) Tracking: Advanced session management allowing Sheikhs to select specific students, Suras, and Ayah ranges to log daily recitations and contextual notes.
  • ▸ Mistake Classification System: Highly granular error tracking system capable of categorizing recitation mistakes (e.g., Tajweed errors, forgotten words, incorrect pronunciation, or stopping) linked directly to the specific session and Ayah.
  • ▸ Role-Based Authentication: Multi-tiered user access distinguishing between Admin privileges (full system access), User access (data entry), and Sheikh profiles (student-specific access).

SYSTEM ARCHITECTURE & TECHNOLOGIES

Backend Infrastructure
Developed in VB.NET using ADO.NET for direct, optimized, and highly reliable database connectivity.
Software Architecture
Implements the Repository and Controller Patterns to strictly separate business logic, data access, and UI layers, ensuring a highly decoupled and maintainable codebase.
Database Management
Driven by SQL Server, heavily utilizing asynchronous data operations (Async/Await) to prevent UI blocking and ensure high-performance data fetching.
User Interface
Constructed using WinForms and DevExpress Components to deliver a responsive, professional, and data-dense desktop application interface.

DATABASE SCHEMA & STRUCTURE

The underlying SQL Server database is rigorously normalized to enforce data integrity across students, educational staff, and historical session logs.

Students Table
  • ID: INT PRIMARY KEY
  • StudentName: VARCHAR
  • StudentBirthDate: DATE
  • PhoneNumber / Address: VARCHAR
  • BelongShk: INT FOREIGN KEY
Shoyoukh Table
  • ID: INT PRIMARY KEY
  • SheikhName: VARCHAR
  • SheikhPassword: VARCHAR
  • IsUser / IsAdmin: BIT
  • Stores credentials and roles.
Suras Table
  • Id: INT PRIMARY KEY
  • SuraName: VARCHAR
  • SuraNumber: INT
  • Maintains index of all chapters.
Ayat Table
  • Id: INT PRIMARY KEY
  • sura: INT FOREIGN KEY
  • aya: INT
  • text: NVARCHAR
  • Stores raw text for dynamic rendering.
TasmeeSessions Table
  • Id: INT PRIMARY KEY
  • StudentId / SheikhId: INT
  • FromAyahId / ToAyahId: INT
  • SessionDate: DATE
TasmeeErrors Table
  • Id: INT PRIMARY KEY
  • SessionId / AyahId: INT
  • ErrorTypeId: INT FOREIGN KEY
  • ErrorCount: INT
  • Links exact mistakes to a specific Ayah.

INSTALLATION & SETUP

1. Clone the repository:

git clone https://github.com/AAFLY99/AlMohafed

2. Database Configuration:

Execute the provided database scripts inside SQL Server. Once generated, update the connection string located in your My.Settings file.

3. Run the Application:

Open the solution file using Visual Studio (with .NET Framework and DevExpress installed) and compile the project.

FUTURE ROADMAP

Digital Expansion
Transitioning the architecture to Web and Mobile platforms equipped with active cloud database synchronization.
Analytical Enhancements
Implementation of advanced student statistics, granular memorization trajectories, and comprehensive Tajweed analytical reports.
Multimedia Integration
Planned support for targeted audio recitation playback and a fully integrated, scalable Quranic search engine.

* This project is currently under active development.