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;
}
}
