CupLedger

CupLedger — cafe operations and staff management for admin and floor staff.

Overview

CupLedger is a desktop management suite for coffee shops and small cafes. Built with .NET WinForms, C#, Guna UI, and SQL Server (ADO.NET), it gives managers and staff a single place to run the floor: menus, tables, orders, invoices, shifts, and daily reporting.

Features

Admin

• Secure login with role-based access (admin vs staff).
• Dashboard — revenue today, staff count, menu items, invoices; monthly revenue chart; top-selling items.
• Menu management — add, edit, remove items; categories; pricing and stock.
• Staff management — staff records and accounts.
• Work shift & schedule — shifts and work-day planning.
• Daily reports — sales and operational summaries.
• Invoice management — billing history and payment tracking.

Staff

• Table management — live table grid (available / occupied), order details, merge tables, close table.
• Order creation — build orders with quantities and line totals.
• Billing — cash and card; discounts where configured.

Technologies

• Language: C#
• UI: .NET WinForms, Guna UI 2, Guna Charts, LiveCharts
• Data: ADO.NET
• Database: Microsoft SQL Server
• IDE: Visual Studio 2022

Getting started

Prerequisites

• Visual Studio 2022
• .NET Framework 4.6+
• Microsoft SQL Server

Setup

1. Clone this repository.
2. Open CoffeeShopManagement.sln in Visual Studio.
3. Attach the database from the database folder:
   • Copy the .mdf and .ldf files to your SQL Server data directory, for example:

     C:\Program Files\Microsoft SQL Server\<version>\MSSQL\DATA\
     

   • Attach the database in SQL Server Management Studio.
4. Copy CafeApp/Global.cs.example to CafeApp/Global.cs and set your connection string.
5. Restore NuGet packages, build, and run.

Contributing

Pull requests are welcome. For larger changes, open an issue first to discuss the approach.

License

MIT