sugaarxd / supermarket

An Application for Advanced Programming Methods Course with C# and WPF (.NET Framework)

Supermarket

Overview

This is a C# project utilizing WPF (.NET Framework) and MVVM (Model-View-ViewModel) design pattern to create a application for managing a supermarket. The application consists of two main modules: administration and cashier.

Technologies Used

• C#
• WPF (Windows Presentation Foundation)
• SQL Server
• MVVM (Model-View-ViewModel)
• ADO.NET

Main Features

• Manage products, producers, categories, stocks and users
• Handle user authentication with different roles (administrator and cashier)
• Generate and view sales receipts

1. Administration Module

• CRUD operations on all tables
• Specific reports like :
  • List all products from a selected manufacturer by categories.
  • Display the total value of each product category in the supermarket.
  • View daily earnings for a selected user and month.
  • Display data from the largest receipt of the day.

2. Cashier Module

• Product search:

  • Search products by name, barcode, expiration date, manufacturer, or category.

• Receipt management:

  • Add products to receipts, displaying their correct prices.
  • Remove products from receipts.

Security Considerations

• The database is structured in the third normal form.
• The application avoids SQL injection by using stored procedures.