C# Migrations Exercise

Pizza Shop Api

Pizza Shop needs a very simple ordering system with just just 3 tables, Customer, Pizza and Order.

Setup

• Create, then add your credentials to the appsettings.json file and connect to your neon database.

Core

• Write all endpoints in the PizzaShopApi.cs
• Use your initiative to create relevant endpoints such as GetOrders, GetOrdersByCustomerId, GetPizzas etc..
• Use Dependency Injection to instance the DbContext Repository
• Inject the IRepository into the EndPoints in the PizzaShopApi
• An order consists of 1 customer ordering 1 pizza.
• Seed some data for the orders. Dave likes a Cheese & Pineapple pizza and Nigel likes Vegan ones.
• Include yourself as a customer and your favourite Pizza.

Extension

• Assume that Pizzas take 3 minutes to prepare and 12 minutes to cook in the oven. Modify your code so your customers see at what stage their order is and add an endpoint so the delivery drivers app can set the order as Delivered

Super Extension (optional)

• The Pizza Shop can only cook 4 pizzas at a time and the delivery driver is allocated 10 minutes to deliver one pizza at a time. Add an estimated delivery time to the Order!

Comments by Agron

For the extensions I have made some assumptions

• We have infinite amount of delivery drivers (No waiting for pickup)
• The order for pizza cooking is FIFO. Therefore, when a pizza is announced to be done, we take the one at the end of the queue regardless.
• The 10 minutes allocated for the delivery is only for providing and estimated delivery to customer. In this app, the delivery will be manually reported.
• When there are n pizzas in front in queue, we assume calculate the estimated delivery time for a pizza to take Ceiling(n/4) minutes + 15 minutes cooking + 10 minutes delivery + remaining time for next pizza out of oven.
• Check the terminal when placing orders
• For testing purposes, preparing takes 1 minute and cooking takes 2 minutes. Change the input values in FromMinutes under PizzaOrder.cs to change this.
• Shutting down the website does not update orders to be done or deleted. Trash in, trash out.

Tips

• You can map the Pizza to the Customer with the Order model
• You'll need a composite key in the Order model

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 {
        modelBuilder.Entity<Order>().HasKey(o=> new {o.PizzaId, o.CustomerId});
 }