// 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());
        }
Beispiel #2
0
 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());
            }
        }