/// <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(); } }
//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(); } }
public void Add(Order order) { using (var db = new OrderDB()) { db.Order.Add(order); 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(); } }//数据库删除订单
public void Delete(String orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("Details").SingleOrDefault(o => o.Id == orderId); db.OrderDetail.RemoveRange(order.Details); db.Order.Remove(order); db.SaveChanges(); } }
public void RemoveOrder(string orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("details").SingleOrDefault(o => o.Id == orderId); db.OrderItem.RemoveRange(order.details); db.Order.Remove(order); db.SaveChanges(); } }
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(); } }
public void Delete(int orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("Items").SingleOrDefault(o => o.Id == orderId); db.OrderItem.RemoveRange(order.Items); db.Order.Remove(order); db.SaveChanges(); } }
public void Delete(string orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("Details").Include("Customer").SingleOrDefault(o => o.Id == orderId); foreach (OrderDetail orderDetail in order.Details) { var ods = db.OrderDetail.Include("Goods").SingleOrDefault(d => d.Id == orderDetail.Id); db.Goods.Remove(ods.Goods); } db.OrderDetail.RemoveRange(order.Details); db.Customer.Remove(order.Customer); db.Order.Remove(order); SaveOrders.Remove(order); db.SaveChanges(); } }
/// <summary> /// add new order /// </summary> /// <param name="order">the order will be added</param> public void AddOrder(Order order) { //if (orderDict.ContainsKey(order.Id)) // throw new Exception($"order-{order.Id} is already existed!"); //orderDict[order.Id] = order; if (orderDict.ContainsKey(order.Id)) { throw new Exception($"order-{order.Id} is already existed!"); } else { using (var db = new OrderDB()) { db.Order.Add(order); db.SaveChanges(); } } }