P1 Requirements

Store App 2.0 (Due 10/13)

Into the Web

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:

• Add a new customer
• Search customers
• Display details of an order
• Place orders to store locations for customers
• View order history of customer
• View order history of location
• View location inventory
• The customer should be able to purchase multiple products
• 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 (useful ones)
• At least 20 unit tests:
• Use Moq and Sqlite for testing
• DB methods should be tested
• Data should be persisted, (no data should be hard coded)
• You should use PostgreSQL DB
• Use code first approach to establish a connection to your DB
• WebApp should be deployed using Azure App Services
• A CI/CD pipeline should be established use Github Actions
• Use ASP.NET Core MVC for the UI
• DB structure should be 3NF
• Should have an ER Diagram
• Code should have xml documentation

Tech Stack:

• C#
• PostgreSQL DB
• EF Core
• Xunit
• Serilog or Nlog
• Azure
• Github Actions
• ASP.NET Core MVC