Green Gym
Desktop Gym Management System
Comprehensive desktop gym management system with member registration, class scheduling, payment tracking, and role-based access control. Enhanced security and optimised SQL performance.
Overview
About the Project
Green Gym is a full-featured desktop management system built for a gym business, covering every operational aspect from member onboarding to daily class management and financial tracking. The application features a clean Windows Forms UI with an underlying SQL Server database optimised for high-frequency read/write operations inherent to fitness facility management.
Capabilities
Key Features
Member Registration & Profiles
Comprehensive member management with registration, profile editing, membership plan assignment, and medical notes. Includes photo storage and membership status tracking.
Class Scheduling
Visual class timetable with trainer assignment, capacity limits, and member booking. Conflict detection prevents double-booking of trainers and rooms.
Payment & Billing
Monthly billing cycle management with payment recording, receipt generation, overdue alerts, and financial reporting for the gym owner.
Role-based Security
Multi-level access: Receptionist (member check-in, basic operations), Manager (full access), Super Admin (system configuration). Password hashing and session management.
Reporting & Analytics
Built-in reports for monthly revenue, member retention, class attendance, and trainer performance. Exportable to PDF.
Optimised SQL Queries
Carefully crafted stored procedures and strategic index placement to ensure sub-100ms response times even with large member datasets.
Gallery
Screenshots
Engineering
Challenges & Solutions
Results
Project Outcomes
Fully functional gym management desktop application
Significant query performance improvements through stored procedure optimisation
Secure multi-role access system protecting sensitive member data
Automated billing cycle reducing manual administrative workload
Clean N-tier architecture enabling future feature additions without major refactors