public List <Order> GetAllOrders() { using (var db = new OrderDB()) { return(db.Order.Include("Details").ToList <Order>()); } }
public List <Order> QueryByCustormer(String custormer) { using (var db = new OrderDB()) { return(db.Order.Include("Details") .Where(o => o.Customer.Equals(custormer)).ToList <Order>()); } }
public Order GetOrder(String Id) { using (var db = new OrderDB()) { return(db.Order.Include("Details"). SingleOrDefault(o => o.Id == Id)); } }
public List <Order> QueryByGoods(String goods) { using (var db = new OrderDB()) { var query = db.Order.Include("Details") .Where(o => o.Details.Where( detail => detail.Goods.Equals(goods)).Count() > 0); return(query.ToList <Order>()); } }
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 Add(Order order) { using (var db = new OrderDB()) { db.Order.Add(order); //db.Order.Attach(order); //db.Entry(order).State = EntityState.Added; 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(); } }