// GET: Orders/Details/5 public ActionResult Details(int id) { IEnumerable <Lib.Customer> customers = CRepo.GetCustomers(); IEnumerable <Lib.Store> stores = SRepo.GetStores(); IEnumerable <Lib.Order> orders = ORepo.GetOrders(); List <Lib.OrderList> orderLists = ORepo.GetOrderLists(id).OrderBy(o => o.OrderId).ToList(); List <Lib.Products> products = PRepo.GetProducts().OrderBy(p => p.ItemId).ToList(); Lib.Order order = ORepo.GetOrderByOrderId(id); var viewModels = orders.Select(o => new Orders { OrderId = o.OrderId, StoreId = o.StoreId, CustomerId = o.CustomerId, DatePurchased = o.DatePurchased, Total = o.Total, //double total = db.tblCustomerOrders.Where(x => x.CustomerID == customer.CustomerID).Select(t => t.Amount ?? 0).Sum(); StoreName = stores.Single(s => s.Id == o.StoreId).Name, FirstName = customers.Single(c => c.Id == o.CustomerId).FirstName, LastName = customers.Single(c => c.Id == o.CustomerId).LastName, FullName = customers.Single(c => c.Id == o.CustomerId).FirstName + " " + customers.Single(c => c.Id == o.CustomerId).LastName }).ToList(); return(View()); }
public static StoreOrder Map(Lib.Order order) => new StoreOrder { OrderId = order.OrderId, StoreId = order.StoreId, CustomerId = order.CustomerId, Total = order.Total, DatePurchased = order.DatePurchased };
public ActionResult Create(Orders order) { try { // TODO: Add insert logic here var stores = SRepo.GetStores().ToList(); order.Stores = new List <Lib.Store>(); if (order.Stores == null) { foreach (var s in stores) { var tmpStore = new Lib.Store { Id = s.Id, Name = s.Name }; order.Stores.Add(tmpStore); } } var ord = new Lib.Order { StoreId = order.StoreId, DatePurchased = DateTime.Now, CustomerId = order.CustomerId, Total = 0 }; int orderCount = ORepo.GetOrders().Count() + 2; int oid = ORepo.GetOrders().Last().OrderId + 1; TempData["Order Id"] = oid; ORepo.InsertOrder(ord); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }