Example #1
0
        /// <summary>
        /// update the order
        /// </summary>
        /// <param name="order">the order to be updated</param>

        /*public void Update(Order order) {
         * RemoveOrder(order.Id);
         * orderList.Add(order);
         * }
         */
        public void updata(Order order, List <OrderDetail> removed, List <OrderDetail> newDetails)
        {
            using (var db = new OrderDB())
            {
                order.Details.AddRange(newDetails);
                foreach (OrderDetail Detail in order.Details)
                {
                    if (removed.Contains(Detail))
                    {
                        db.Entry(Detail).State = EntityState.Deleted;
                    }
                    else if (newDetails.Contains(Detail))
                    {
                        db.Entry(Detail).State = EntityState.Added;
                    }
                    else
                    {
                        db.Entry(Detail).State = EntityState.Modified;
                    }
                }
                db.SaveChanges();
                db.Entry(order).State = EntityState.Modified;
                db.SaveChanges();
            }
        }
Example #2
0
 public void Update(Order order)
 {
     using (var db = new OrderDB())
     {
         db.Order.Attach(order);
         db.Entry(order).State = EntityState.Modified;
         order.Details.ForEach(detail => db.Entry(detail).State = EntityState.Modified);
         db.SaveChanges();
     }
 }
        //private List<Order> orderList;
        /// <summary>
        /// constructor
        /// </summary>

        /// <summary>
        /// add new order
        /// </summary>
        /// <param name="order">the order to be added</param>
        public void AddOrder(Order order)
        {
            using (var db = new OrderDB())
            {
                db.Entry(order).State = EntityState.Added;
                db.SaveChanges();
            }
        }
 /// <summary>
 /// update the order
 /// </summary>
 /// <param name="order">the order to be updated</param>
 public void Update(Order order)
 {
     RemoveOrder(order.Id);
     using (var db = new OrderDB())
     {
         db.Entry(order).State = EntityState.Added;
         db.SaveChanges();
     }
 }///更新订单
        /// <summary>
        /// remove order
        /// </summary>
        /// <param name="orderId">id of the order which will be removed</param>
        public void RemoveOrder(int orderId)
        {
            Order order = GetById(orderId);

            using (var db = new OrderDB())
            {
                db.Entry(order).State = EntityState.Deleted;
                db.SaveChanges();
            }
        }//数据库删除订单