public static OrderHistoryViewModel GetOrderHistory(string userId) { List <GetOrderHistory_Result> result = new List <GetOrderHistory_Result>(); if (!string.IsNullOrEmpty(userId)) { using (FreeMarketEntities db = new FreeMarketEntities()) { result = db.GetOrderHistory(userId) .ToList(); } } OrderHistoryViewModel model = new OrderHistoryViewModel { Items = result }; return(model); }
public AdminOrderHistoryViewModel(string customerNumber) { OrderHistory = OrderHistoryViewModel.GetOrderHistory(customerNumber); ApplicationUser user = System.Web.HttpContext.Current .GetOwinContext() .GetUserManager <ApplicationUserManager>() .FindById(customerNumber); CustomerName = user.Name; CustomerNumber = customerNumber; using (FreeMarketEntities db = new FreeMarketEntities()) { TotalOrders = db.OrderHeaders .Count(c => c.CustomerNumber == customerNumber && (c.OrderStatus == "Confirmed" || c.OrderStatus == "Completed")); Quantities = db.GetItemHistory(customerNumber).ToList(); DeliveryTypes = db.GetDeliveryTypeHistory(customerNumber).ToList(); } }