P0 Requirements

Store App

Overview

The store app is a software that helps customers purchase products from your business. Designed with functionality that would make virtual shopping much simpler!

Functionality

• The customer should be able to place orders
• The customer should be able to view their order history
• The customer should be able to view location inventory
• The customer should know how much of a product is remaining
• The customer should be able to purchase multiple products
• Locations should have records of order history
• Order histories should have the option to be sorted by date (latest to oldest and vice versa) or cost (least expensive to most expensive)
• The manager should be able to replenish inventory

Models

• Customer
• Location
• Orders
• Product

Note

Add as much models as you would need for your design

Additional requirements

• Exception Handling
• Input validation
• Logging (to a file, no logging to the console)
• At least 10 unit tests
• Data should be persisted, (no data should be hard coded)
• You should use a DB to store data
• DB structure should be 3NF
• Should have an ER Diagram
• Code should have xml documentation

Tech Stack

• C#
• Xunit
• PostgreSQL DB (or some other DB dialect)
• EF Core
• Serilog or Nlog (or any other logging frameworks)