This is a conceptual project for a supermarket management system for Keels, developed using C# and MS SQL Server. The system includes a Point of Sale (POS) system, an Inventory Management system, and a Nexus Member Management system.
The system supports two types of accounts:
- Admins: Admins have access to a dashboard and can perform the following actions:
- Products: Add, update, and delete products.
- Product Category: Add, update, and delete product categories.
- Employee: Add, update, and delete employee details.
- Nexus Membership: Add, update, and delete Nexus memberships and calculate points.
- Cashiers: Cashiers have access to the POS with all capabilities including bill generation.
The Cashier POS has several features:
- Registering New Members: Cashiers can register new Nexus members at the checkout.
- Handling Transactions: The POS system can handle sales transactions, returns, and exchanges.
- Payment Processing: The system accepts multiple forms of payment and can handle split payments.
- Discounts and Promotions: The POS system automatically applies any active discounts or promotions.
- Receipt Generation: The system generates a receipt after every transaction.
- Nexus Points Calculation: The system automatically calculates the points earned on each purchase for Nexus members.
- Product Lookup: Cashiers can quickly look up products by their barcodes or search terms.
- End of Day Reporting: The system generates a report detailing the total sales, returns, and revenue for the day.
The POS system is capable of handling all standard POS operations. The inventory management system helps keep track of all products in the supermarket.
The Nexus Member Management system allows admins to manage Nexus memberships and calculate points based on purchases.
- C#: Used for backend logic.
- MS SQL Server: Used for database management.