// GET: Order/Details/5 public ActionResult Details(int id) { IEnumerable <P1B.Customer> customers = CustomerRepo.GetAllCustomers(); IEnumerable <P1B.Location> locations = LocRepo.GetAllLocations(); List <Project1.BLL.Cupcake> cupcakes = CupcakeRepo.GetAllCupcakes().OrderBy(c => c.Id).ToList(); List <Project1.BLL.OrderItem> orderItems = OrderItemRepo.GetOrderItems(id).ToList(); Project1.BLL.Order order = OrderRepo.GetOrder(id); var viewModel = new OrderViewModel { OrderId = id, LocationId = order.OrderLocation, LocationName = locations.Single(l => l.Id == order.OrderLocation).Name, CustomerId = order.OrderCustomer, CustomerName = customers.Single(c => c.Id == order.OrderCustomer).ReturnFullName(), OrderTime = order.OrderTime, Locations = LocRepo.GetAllLocations().ToList(), Customers = CustomerRepo.GetAllCustomers().ToList(), Cupcakes = cupcakes, OrderItems = orderItems, OrderTotal = OrderRepo.GetOrder(order.Id).GetTotalCost(OrderItemRepo.GetOrderItems(order.Id).ToList(), cupcakes.ToList()) }; // give the Create view values for its dropdown return(View(viewModel)); }
// GET: Order/Details/5 public ActionResult Orders(int id, string sortOrder) { ViewData["TimeSortParm"] = String.IsNullOrEmpty(sortOrder) ? "time_desc" : ""; ViewData["OrderTotalSortParm"] = sortOrder == "OrderTotal" ? "order_total_desc" : "OrderTotal"; IEnumerable <P1B.Customer> customers = CustomerRepo.GetAllCustomers(); IEnumerable <P1B.Location> locations = LocRepo.GetAllLocations(); List <Project1.BLL.Cupcake> cupcakes = CupcakeRepo.GetAllCupcakes().OrderBy(c => c.Id).ToList(); IEnumerable <P1B.Order> orders = LocRepo.GetLocationOrderHistory(id).ToList(); List <OrderViewModel> viewModels = new List <OrderViewModel>(); ViewData["LocationName"] = locations.Single(l => l.Id == id).Name; ViewData["LocationId"] = id; switch (sortOrder) { case "time_desc": orders = orders.OrderByDescending(o => o.OrderTime); break; case "OrderTotal": orders = orders.OrderBy(o => o.GetTotalCost(OrderItemRepo.GetOrderItems(o.Id).ToList(), cupcakes.ToList())); break; case "order_total_desc": orders = orders.OrderByDescending(o => o.GetTotalCost(OrderItemRepo.GetOrderItems(o.Id).ToList(), cupcakes.ToList())); break; default: orders = orders.OrderBy(o => o.OrderTime); break; } foreach (var order in orders) { viewModels.Add(new OrderViewModel { OrderId = order.Id, LocationId = order.OrderLocation, LocationName = locations.Single(l => l.Id == order.OrderLocation).Name, CustomerId = order.OrderCustomer, CustomerName = customers.Single(c => c.Id == order.OrderCustomer).ReturnFullName(), OrderTime = order.OrderTime, Locations = locations.ToList(), Customers = customers.ToList(), Cupcakes = cupcakes, OrderItems = OrderItemRepo.GetOrderItems(order.Id).ToList(), OrderTotal = OrderRepo.GetOrder(order.Id).GetTotalCost(OrderItemRepo.GetOrderItems(order.Id).ToList(), cupcakes.ToList()) }); } return(View(viewModels)); }
public IEnumerable <OrderItemViewDto> GetAllByOrderId(int orderId) { if (orderId <= 0) { return(null); } using (var cxt = DbContext(DbOperation.Read)) { var repo = new OrderItemRepo(cxt); return(repo.GetAllByOrderId(orderId)); } }
public ActionResult Index(string sortOrder) { ViewData["TimeSortParm"] = String.IsNullOrEmpty(sortOrder) ? "time_desc" : ""; ViewData["OrderTotalSortParm"] = sortOrder == "OrderTotal" ? "order_total_desc" : "OrderTotal"; IEnumerable <P1B.Order> orders = OrderRepo.GetAllOrders(); IEnumerable <P1B.Customer> customers = CustomerRepo.GetAllCustomers(); IEnumerable <P1B.Location> locations = LocRepo.GetAllLocations(); IEnumerable <P1B.Cupcake> cupcakes = CupcakeRepo.GetAllCupcakes().OrderBy(c => c.Id); switch (sortOrder) { case "time_desc": orders = orders.OrderByDescending(o => o.OrderTime); break; case "OrderTotal": orders = orders.OrderBy(o => o.GetTotalCost(OrderItemRepo.GetOrderItems(o.Id).ToList(), cupcakes.ToList())); break; case "order_total_desc": orders = orders.OrderByDescending(o => o.GetTotalCost(OrderItemRepo.GetOrderItems(o.Id).ToList(), cupcakes.ToList())); break; default: orders = orders.OrderBy(o => o.OrderTime); break; } var viewModels = orders.Select(o => new OrderViewModel { OrderId = o.Id, LocationId = o.OrderLocation, LocationName = locations.Single(l => l.Id == o.OrderLocation).Name, CustomerId = o.OrderCustomer, CustomerName = customers.Single(c => c.Id == o.OrderCustomer).ReturnFullName(), OrderTime = o.OrderTime, Locations = locations.ToList(), Customers = customers.ToList(), Cupcakes = cupcakes.ToList(), OrderItems = OrderItemRepo.GetOrderItems(o.Id).ToList(), OrderTotal = OrderRepo.GetOrder(o.Id).GetTotalCost(OrderItemRepo.GetOrderItems(o.Id).ToList(), cupcakes.ToList()) }).ToList(); return(View(viewModels)); }
public IActionResult Index() { Project1.ViewModels.HomeViewModel viewModel = new ViewModels.HomeViewModel { Locations = LocRepo.GetAllLocations().ToList(), Customers = CustomerRepo.GetAllCustomers().ToList(), Cupcakes = CupcakeRepo.GetAllCupcakes().ToList(), Orders = OrderRepo.GetAllOrders().ToList(), OrderItems = OrderItemRepo.GetAllOrderItems().ToList() }; decimal sum = 0; decimal incrementer = 0; foreach (var order in viewModel.Orders) { sum += order.GetTotalCost(OrderItemRepo.GetOrderItems(order.Id).ToList(), viewModel.Cupcakes); incrementer++; } if (incrementer > 0) { viewModel.OrderTotalAverage = sum / incrementer; } if (viewModel.Locations.Count > 0) { viewModel.LocationMostOrders = viewModel.Locations.MaxBy(sL => LocRepo.GetLocationOrderHistory(sL.Id).Count()).OrderBy(sL => sL.Id).First().Name; if (viewModel.Orders.Count > 0) { viewModel.LocationWithLatestOrder = viewModel.Locations.Single(l => l.Id == viewModel.Orders.MaxBy(o => o.OrderTime).First().OrderLocation).Name; } } return(View(viewModel)); }
public ActionResult Create(Project1.ViewModels.OrderViewModel viewModel) { try { for (int i = 0; i < viewModel.OrderItems.Count; i++) { viewModel.OrderItems[i].CupcakeId = i + 1; } List <Project1.BLL.OrderItem> newOrderItems = viewModel.OrderItems .Where(oi => oi.Quantity != null).ToList(); if (newOrderItems.Count == 0) { string message = "The order must have at least one cupcake."; TempData["ErrorMessage"] = message; _logger.LogWarning(message); return(RedirectToAction("Error", "Home")); } viewModel.Locations = LocRepo.GetAllLocations().ToList(); viewModel.Customers = CustomerRepo.GetAllCustomers().ToList(); viewModel.Cupcakes = CupcakeRepo.GetAllCupcakes().ToList(); viewModel.CustomerName = viewModel.Customers.Single(c => c.Id == viewModel.CustomerId).ReturnFullName(); viewModel.LocationName = viewModel.Locations.Single(l => l.Id == viewModel.LocationId).Name; if (!CustomerRepo.CheckCustomerExists(viewModel.CustomerId)) { string message = $"Customer {viewModel.CustomerName} is not in the database."; TempData["ErrorMessage"] = message; _logger.LogWarning(message); return(RedirectToAction("Error", "Home")); } if (!LocRepo.CheckLocationExists(viewModel.LocationId)) { string message = $"Location {viewModel.LocationName} is not in the list of stores."; TempData["ErrorMessage"] = message; _logger.LogWarning(message); return(RedirectToAction("Error", "Home")); } // The following checks to see if the customer can order from this store location // If the customer has ordered at this store within the past 2 hours, than they shouldn't be // able to order again. var orders = OrderRepo.GetAllOrders().ToList(); if (!Project1.BLL.Customer.CheckCustomerCanOrder(viewModel.CustomerId, viewModel.LocationId, orders)) { string message = "Customer can't place an order at this store because it hasn't been 2 hours \n" + "since there last order yet."; TempData["ErrorMessage"] = message; _logger.LogWarning(message); return(RedirectToAction("Error", "Home")); } foreach (var cupcake in newOrderItems) { if (!CupcakeRepo.CheckCupcakeExists(cupcake.CupcakeId)) { string message = $"Cupcake {viewModel.Cupcakes.Single(c => c.Id == cupcake.CupcakeId).Type} " + $"is not in the database"; TempData["ErrorMessage"] = message; _logger.LogWarning(message); return(RedirectToAction("Error", "Home")); } int qnty = cupcake.Quantity ?? 0; if (!Project1.BLL.Order.CheckCupcakeQuantity(qnty)) { string message = $"Quantity for cupcake " + $"{viewModel.Cupcakes.Single(c => c.Id == cupcake.CupcakeId).Type} " + $"is out of range"; TempData["ErrorMessage"] = message; _logger.LogWarning(message); return(RedirectToAction("Error", "Home")); } } // The following gets all orders and their associated order items in order // to validate that the store location's supply of the cupcakes in the customer's // requested order have not been exhausted. // Cupcake exhaustion happens when a store location has had more than 1000 cupcakes of one // type sold within 24 hours, at that point they cannot sell anymore. // This is arbitrary business logic that I added in order to satisfy the Project0 // requirements. var orderItems = OrderItemRepo.GetAllOrderItems().ToList(); if (!Project1.BLL.Location.CheckCanOrderCupcake(viewModel.LocationId, orders, orderItems, newOrderItems)) { string message = $"This store has exhausted supply of one of those cupcakes. " + $"Try back in 24 hours."; TempData["ErrorMessage"] = message; _logger.LogWarning(message); return(RedirectToAction("Error", "Home")); } // The following gets the recipes for the cupcakes in the customer's requested order // and checks to make sure that the store location's inventory can support the order. var recipes = RecipeItemRepo.GetRecipes(newOrderItems); var locationInv = LocationInventoryRepo.GetLocationInventoryByLocationId(viewModel.LocationId).ToList(); if (!Project1.BLL.Location.CheckOrderFeasible(recipes, locationInv, newOrderItems)) { string message = $"This store does not have enough ingredients to place " + $"the requested order."; TempData["ErrorMessage"] = message; _logger.LogWarning(message); return(RedirectToAction("Error", "Home")); } var newOrder = new P1B.Order { OrderLocation = viewModel.LocationId, OrderCustomer = viewModel.CustomerId, OrderTime = DateTime.Now }; OrderRepo.AddCupcakeOrder(newOrder); int newOrderId = OrderRepo.GetLastCupcakeOrderAdded(); for (int i = 0; i < newOrderItems.Count; i++) { newOrderItems[i].OrderId = newOrderId; } OrderItemRepo.AddCupcakeOrderItems(newOrderItems); LocationInventoryRepo.UpdateLocationInv(viewModel.LocationId, recipes, newOrderItems); return(RedirectToAction(nameof(Index))); } catch (Exception ex) { _logger.LogError(ex.ToString()); return(RedirectToAction("Error", "Home")); } }
static void Main(string[] args) { //var getCustomerRepo = new CustomerRepo(); while (true) { Console.WriteLine("Welcome to Downtown Deli!"); Console.WriteLine(""); Console.WriteLine("For customer access: a to add a new customer, press d to display customer, press s to search for a Customer"); Console.WriteLine("For store location info: Press l for store locations, press sl to search for orders at a given location"); Console.WriteLine("For orders: press c to create order, press do to display a customers order history"); Console.WriteLine("To exit press q"); Console.WriteLine(""); var userInput = Console.ReadLine(); if (userInput == "a") { CustomerRepo.addCustomer(); } else if (userInput == "d") { CustomerRepo.displayCustomer(); } else if (userInput == "q") { break; } else if (userInput == "r") { CustomerRepo.deleteCustomer(); } else if (userInput == "l") { storeRepo.getStores(); } else if (userInput == "o") { OrderItemRepo.getOrderItems(); } else if (userInput == "s") { CustomerRepo.findCustomerbyName(); } else if (userInput == "c") { OrderRepo.createOrder(); } else if (userInput == "do") { OrderRepo.displayOrderHistory(); } else if (userInput == "sl") { OrderRepo.findOrdersAtLocation(); } else { Console.WriteLine("Please enter a valid option"); } } }