// 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");
}
}
}
