public void BatchUpdateItem(IEnumerable<Item> items) { using (var context = new GiaikhatNgocMaiEntities()) { items.Select(i => context.Entry(i).State = System.Data.Entity.EntityState.Modified); context.Items.AddRange(items); context.SaveChanges(); } }
public void BatchUpdateShipmentFee(IEnumerable<ShipmentFee> fee) { using (var context = new GiaikhatNgocMaiEntities()) { var newFeeList = fee.OrderBy(i => i.Id).ToList(); var dbFeeList = context.ShipmentFees.OrderBy(i => i.Id); foreach (var item in dbFeeList) { var existedFee = newFeeList.SingleOrDefault(i => i.Id == item.Id); if (existedFee == null) { context.Entry(item).State = System.Data.Entity.EntityState.Deleted; continue; } context.Entry(item).State = System.Data.Entity.EntityState.Modified; newFeeList.Remove(existedFee); } newFeeList.Select(i => context.Entry(i).State = System.Data.Entity.EntityState.Added); context.SaveChanges(); } }
public void BatchUpdateUnit(IEnumerable<Unit> units) { using (var context = new GiaikhatNgocMaiEntities()) { var newUnits = units.OrderBy(i => i.Id).ToList(); var dbUnits = context.Units.OrderBy(i => i.Id); foreach (var u in dbUnits) { var existedUnit = newUnits.SingleOrDefault(i => i.Id == u.Id); if (existedUnit == null) { context.Entry(u).State = System.Data.Entity.EntityState.Deleted; continue; } context.Entry(u).State = System.Data.Entity.EntityState.Modified; newUnits.Remove(existedUnit); } newUnits.Select(i => context.Entry(i).State = System.Data.Entity.EntityState.Added); context.SaveChanges(); } }
public void UpdateUser(User user) { using (var context = new GiaikhatNgocMaiEntities()) { var dbUser = context.Users.SingleOrDefault(u => u.Id == user.Id); if (dbUser == null) throw new NullReferenceException("Can not found user " + user.UserName); context.Entry(user).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void UpdatePolicyNews(SiteNew news) { using (var context = new GiaikhatNgocMaiEntities()) { news.DateUpdated = DateTime.Now; context.Entry(news).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void UpdateOrder(Order order) { using (var context = new GiaikhatNgocMaiEntities()) { var dbItemList = context.OrderDetails.Where(i => i.OrderId == order.Id).OrderBy(i => i.Id); var newItemList = order.OrderDetails.OrderBy(i => i.Id).ToList(); foreach (var dt in dbItemList) { var existedItem = newItemList.SingleOrDefault(i => i.Id == dt.Id); if (existedItem == null) { context.Entry(dt).State = System.Data.Entity.EntityState.Deleted; continue; } context.Entry(dt).State = System.Data.Entity.EntityState.Modified; newItemList.Remove(existedItem); } newItemList.Select(i => context.Entry(i).State = System.Data.Entity.EntityState.Added); context.Entry(order).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void UpdateNews(News news) { using (var context = new GiaikhatNgocMaiEntities()) { context.Entry(news).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void UpdateItem(Item item) { using (var context = new GiaikhatNgocMaiEntities()) { context.Entry(item).State = System.Data.Entity.EntityState.Modified; context.Items.Add(item); context.SaveChanges(); } }
public void UpdateCustomer(Customer customer) { using (var context = new GiaikhatNgocMaiEntities()) { var dbcustomer = context.Customers.SingleOrDefault(i => i.Id == customer.Id); if (dbcustomer == null) throw new NullReferenceException(); dbcustomer.RecieveInfo = customer.RecieveInfo; dbcustomer.CustomerName = customer.CustomerName; dbcustomer.CustomerPassword = customer.CustomerPassword; dbcustomer.CustomerPoint = customer.CustomerPoint; dbcustomer.CustomerPhone = customer.CustomerPhone; dbcustomer.ShipAddress = customer.ShipAddress; dbcustomer.ShipDistrict = customer.ShipDistrict; context.Entry(dbcustomer).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void UpdateCategory(Category category) { using (var context = new GiaikhatNgocMaiEntities()) { context.Categories.Add(category); context.Entry(category).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public string CreateOrder(Order order) { using (var context = new GiaikhatNgocMaiEntities()) { if (order.OrderDetails.Count <= 0) throw new Exception(); context.Orders.Add(order); context.SaveChanges(); context.Entry(order).Reload(); return order.OrderNumber; } }