コード例 #1
0
        public Models.Order AddOrder(Models.Order order, Models.AppUser user, Models.Location location)
        {
            _context.Orders.Add(
                new Entities.Order {
                Total      = order.Total,
                LocationId = GetLocationID(location),
                UserId     = GetUserID(user),
            }
                );
            _context.SaveChanges();
            //get the order that was just created
            List <Entities.Order> orders = new List <Entities.Order>();

            foreach (Entities.Order o in _context.Orders)
            {
                orders.Add(o);
            }
            IEnumerable <Entities.Order> SortedOrders = from o in orders
                                                        group o by o.Id into sorto
                                                        select sorto.OrderByDescending(os => os.Id).First();

            int recentOrderId = SortedOrders.Max(x => x.Id);

            Entities.Order recentOrder = GetOrderById(recentOrderId);

            foreach (Models.Products prod in order.ProductList)
            {
                int prodId = GetProductID(prod);
                AddLineItem(prod, recentOrderId);
            }
            _context.SaveChanges();
            return(order);
        }
コード例 #2
0
        public Entities.Order GetOrderById(int order)
        {
            List <Entities.Order> orders = new List <Entities.Order>();

            foreach (Entities.Order r in _context.Orders)
            {
                orders.Add(r);
            }
            Entities.Order record = (from rec in orders
                                     where rec.Id == order
                                     select rec).FirstOrDefault();
            return(record);
        }