🏋️ Gym Management System

A Windows GUI desktop application built using C++/CLI with Windows Forms and SQL Server for managing gym members, memberships, fees, and member details.

---

📋 Table of Contents

• About the Project
• Features
• Tech Stack
• Project Structure
• Database Setup
• Getting Started
• Screenshots
• Future Improvements

---

📌 About the Project

The Gym Management System is a desktop application designed for gym owners/admins to efficiently manage their gym operations. It provides a secure login system, the ability to add and view member details, and track memberships — all through a user-friendly Windows Forms interface.

---

✅ Features

• 🔐 Owner Login — Secure authentication via SQL Server database
• ➕ Add Member — Register new members with personal and membership details
• 👁️ View Member Details — Search and display member information by ID
• ✏️ Edit Member Details — Update existing member records
• 🗑️ Delete Members — Remove member records from the database
• 📅 Membership Tracking — Track member type, start date, and fee amount
• 🖼️ Welcome Dashboard — Clean main screen with gym image display

---

🛠️ Tech Stack

Technology	Description
C++/CLI	Core programming language
Windows Forms (.NET)	GUI Framework
Visual Studio 2022	IDE
SQL Server (SQLExpress)	Database
ADO.NET (SqlClient)	Database connectivity

---

📁 Project Structure

GymManagementSystem/
│
├── GymManagementSystem.sln          # Visual Studio Solution file
│
└── GymManagementSystem/             # Main project folder
    ├── Source.cpp                   # Entry point — launches LoginForm
    ├── User.h                       # User model (id, Name, Email, Password)
    │
    ├── LoginForm.h / .cpp           # Owner login screen with SQL auth
    ├── Welcome.h / .cpp             # Main dashboard after login
    ├── AddMember.h / .cpp           # Form to add new gym members
    ├── Details.h / .cpp             # Form to search, view, edit members
    ├── ShowCustomer.h / .cpp        # Show customer data form
    ├── Member.h / .cpp              # Member form (base)
    │
    ├── *.resx                       # Windows Forms resource files
    ├── *.vcxproj                    # Visual Studio project configuration
    │
    ├── assets/
    │   └── Gym.png                  # Gym image used in Welcome screen
    │
    └── database/
        └── GYMdb_setup.sql          # SQL script to set up the database

---

🗄️ Database Setup

This project uses SQL Server Express (localhost\SQLExpress) with a database named GYMdb.

Step 1 — Create the database

Open SQL Server Management Studio (SSMS) or run via command line:

CREATE DATABASE GYMdb;

Step 2 — Create the Login table

USE GYMdb;

CREATE TABLE Login (
    Id       INT PRIMARY KEY IDENTITY(1,1),
    Name     NVARCHAR(100)  NOT NULL,
    Email    NVARCHAR(100)  NOT NULL UNIQUE,
    Password NVARCHAR(100)  NOT NULL
);

-- Insert a default admin user
INSERT INTO Login (Name, Email, Password)
VALUES ('Admin', 'admin@gym.com', 'admin123');

Step 3 — Create the Members table

USE GYMdb;

CREATE TABLE Members (
    Id           INT PRIMARY KEY IDENTITY(1,1),
    FirstName    NVARCHAR(100),
    LastName     NVARCHAR(100),
    Email        NVARCHAR(100),
    Phone        NVARCHAR(20),
    Address      NVARCHAR(200),
    DOB          DATE,
    MemberType   NVARCHAR(50),
    StartDate    DATE,
    AmountPaid   DECIMAL(10, 2),
    FeeDetails   NVARCHAR(200)
);

⚠️ The full SQL setup script is also available at GymManagementSystem/database/GYMdb_setup.sql

---

🚀 Getting Started

Prerequisites

• Windows OS
• Visual Studio 2022 with Desktop development with C++ workload
• SQL Server Express
• .NET Framework (included with Visual Studio)

Steps to Run

1. Clone the repository

   git clone https://github.com/Gupta-ng/Gym-Management-System.git
   cd Gym-Management-System

2. Set up the database using the SQL scripts in database/ folder (see Database Setup)

3. Open the solution — double-click GymManagementSystem.sln in Visual Studio

4. Build the project — Press Ctrl + Shift + B

5. Run the application — Press F5 or click the ▶️ button

6. Login with default credentials:

   • Email: admin@gym.com
   • Password: admin123

---

🖼️ Screenshots

(Add screenshots of your application here)

Login Screen	Dashboard	Add Member
screenshot	screenshot	screenshot

---

🔮 Future Improvements

• Password hashing for secure storage
• Member fee due date alerts
• Membership expiry notifications
• Print/export member reports to PDF
• Attendance tracking system
• Trainer management module
• Dark mode UI

---

👨‍💻 Author

Gupta-ng
GitHub: @Gupta-ng

---

📄 License

This project is open source and available under the MIT License.