Esempio n. 1
0
 static public void ModifyOrder(Order newOrder)
 {
     using (var context = new OrderServiceContext())
     {
         var order = context.Orders.FirstOrDefault(o => o.Order_ID == newOrder.ID);
         if (order != null)
         {
             order.Name      = newOrder.Name;
             order.Address   = newOrder.Address;
             order.OrderTime = newOrder.OrderTime;
             var query = context.Items
                         .Where(i => i.OrderID == newOrder.ID);
             List <DB_OrderItem> items = query.ToList();
             foreach (OrderItem item in newOrder.orderItems)
             {
                 var db_item = new DB_OrderItem()
                 {
                     Name     = item.Name,
                     Price    = item.Price,
                     Quantity = item.Quantity,
                     OrderID  = newOrder.ID
                 };
                 if (items.Contains(db_item))
                 {
                     continue;
                 }
                 AddItem(item, newOrder.ID);
             }
         }
     }
 }
Esempio n. 2
0
        static void AddItem(OrderItem item, int orderID)
        {
            var db_item = new DB_OrderItem()
            {
                Name     = item.Name,
                Price    = item.Price,
                Quantity = item.Quantity,
                OrderID  = orderID
            };

            using (var context = new OrderServiceContext())
            {
                context.Entry(db_item).State = EntityState.Added;
                context.SaveChanges();
                newItemID = db_item.ItemID;
            }
        }