/GameHub

Game Distribution management System build with CRUD operations and a strong backend 🐣 a C# .net winform application project.

Primary LanguageC#MIT LicenseMIT

MIT License GitHub code size in bytes made-with-dotnet

Table of Contents

Project Overview

The GameHub Management System is a C# Windows Forms application, a comprehensive digital distribution platform and game server management software. It provides administrators with an interface to add, edit and delete games from the system and offers users a platform to download and view game details. The system is built to be a centralized hub where multiple games can be managed, with features for categorization, user management and detailed tracking of download history.

This a university-level project and a practical exercise in database management, form-based user interfaces. It is built with user-friendly controls and provides a smooth UI experience for both users and administrators.

Features

Admin Panel

  • Add, Update and Delete Games: Administrators can manage games in the system database by CRUD operations.
  • Add and Delete Admin: Administrator can add new admin to the system to operate and can remove the ex-admins.
  • User Database: Admins can see the provided user informations from the database.
  • View Download History: Admins can track user downloads, including timestamps and game details. [under development]
  • Game Categories: Games are sorted into categories for easier management and user browsing. And if necessary admins can add new category, update category and even delete the irrelevent one.

User Panel

  • Game List & Details: Users can browse through the list of games and view detailed descriptions, including the game genre, release date and pricing.
  • Dynamic Loading: The interface dynamically loads content from the database, enhancing scalability and performance.

Data Handling

  • Database Connectivity: SQL server management system is used to ensure data persistence for game details, users and admin actions.
  • CRUD Operations: Built-in functionality for Create, Read, Update, Delete operations on the database tables.

User Account Management

  • Sign Up & Login: Users can create accounts and log in to manage their downloads and access exclusive games.
  • Admin Login: A separate log in form is added for the admins to manage the system database.

Project Demo

Loading Form


User Login


Sign Up


Admin Login


Home Screen


Add New Admin


User Profile


Game Click


Game Database


Adding New Game


Game Category Database


User Database


Technologies Used
  • Programming Language: C# (.NET Framework v4.7.2)
  • Database: SQL Server management system
  • UI Components: Krypton.Toolkit, Bunifu.UI, CuoreUI for custom controls and enhanced UI experience
  • IDE: Visual Studio
  • Version Control: GitHub

Setup and Installation

Prerequisites

  • .NET Framework 4.7.2
  • Microsoft SQL Server: Make sure SQL local server is connected and all the queries from the Query directory was executed properly.
  • Visual Studio IDE

Steps to Setup

  1. Clone the repository: 
    git clone https://github.com/navinxqz/GameHub.git
  2. Open the solution file in Visual Studio.
  3. Open SSMS and import the database logs from bin\Debug\GameServerDB.mdf along with the log file GameServerDB_log.ldf
  4. Configure the SQL database connection in the DBconnect.cs project file: 
    public static readonly string cs = @"Data Source=your_server_name;Initial Catalog=GameServerDB;Integrated Security=True";
  5. Build the solution and run the project.

Contributing

Bug Reports and Feature Requests

If you encounter any bugs or have feature requests, feel free to create an issue in the GitHub repository. Contributions are welcome!

Contributors

Navin, Md Nawshin Sadman Shabab Durjoy Podder Sifti Al Mahmud