Skip to content

This repository hosts the source code for a Café Management System built with ADO.NET, a data access technology in the .NET framework. The system provides a comprehensive solution for managing various aspects of a cafe, including orders, inventory, and customer data.

Notifications You must be signed in to change notification settings

hoigreen/project-coffee-shop-management-ado-dotnet

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

94 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Project Coffee Shop Management Windows Form Application .NET

Coffee Shop Management - Website coffee managent for staff and admin users in shop.

Overview

The Coffee Shop Management project is a comprehensive software solution designed to streamline and enhance the management of a coffee shop. Built using .NET WinForms, C#, Guna Framework, and integrated with SQL Server, this application provides a user-friendly interface for managing various aspects of a coffee shop business.

Features

1. Admin Authentication and Authorization

  • Secure login functionality for admin members to manage database in system.
  • Role-based access control to ensure proper authorization levels.

2. Product Management

  • Add, edit, or remove coffee and non-coffee products from the menu.
  • Categorize products for easy navigation (e.g., coffee, tea, snacks).
  • Set prices, manage inventory, and track stock levels.

3. Order Processing in Staff Role

  • Create new orders and add items to them.
  • Customize orders based on customer preferences (e.g., size, sugar level, milk type).
  • Calculate and display the total amount for each order.

4. Sales and Reporting

  • Record daily sales and generate reports.
  • View sales analytics, including popular products and peak hours.
  • Monitor inventory levels and receive low stock alerts.

5. Billing and Payment

  • Generate and print bills for customers.
  • Accept various payment methods (cash, credit card) and record transactions.
  • Calculate and apply discounts or promotions.

Technologies 🔧

  • Programming Language: C#
  • User Interface Framework: .NET WinForms, Guna Framework, LiveCharts
  • Data Access Technology: ADO .NET.
  • Database: Mircosoft SQL Server
  • Version Control: Git, Github
  • Integrated Development Environment (IDE): Visual Studio 2022

Screenshots 📸

image image image image image image image image image

Installation ✔️

Before you get started, you need to install the following prerequisites:

Then, you can proceed with the project setup:

  1. Clone the repository from GitHub Repo.
# Clone on method HTTPS
git clone https://github.com/hoigreen/project-coffee-shop-management-ado-dotnet.git


# Clone on method SSH
git clone git@github.com:hoigreen/project-coffee-shop-management-ado-dotnet.git
  1. Open the project in Visual Studio.
  2. Attach database file from project to Mircosoft SQL Server
  • Go to folder /database in project.
  • Copy 2 file with extensions is ".mdf" and ".ldf" to \DATA in your device path at:
    "C:\Program Files\Microsoft SQL Server\<Version MSSQL>\MSSQL\DATA\"
  • Attach database into SQL Server.
  1. Copy file Global.cs.example with new name is "Global.cs".
  2. Configure the database connection settings in the application to file Global.cs.
  3. Build, run and debug the application.

Goodluck. 🍀🍀🍀

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

License

MIT

About our team 🤝:

1.Backend Developer:

2.Frontend Developer

About

This repository hosts the source code for a Café Management System built with ADO.NET, a data access technology in the .NET framework. The system provides a comprehensive solution for managing various aspects of a cafe, including orders, inventory, and customer data.

Topics

Resources

Stars

Watchers

Forks

Languages