public void BatchCreateItems(IEnumerable<Item> items)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Items.AddRange(items);
context.SaveChanges();
}
}
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 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 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 UpdateNews(News news)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Entry(news).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 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 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;
}
}
public int CreateItem(Item item)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Items.Add(item);
context.SaveChanges();
return item.Id;
}
}
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 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 DeleteItem(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Items.Remove(context.Items.SingleOrDefault(i => i.Id == id));
context.ItemPhotoes.RemoveRange(context.ItemPhotoes.Where(i => i.ItemId == id));
context.SaveChanges();
}
}
public void DeleteNews(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var news = context.News.SingleOrDefault(i => i.Id == id);
context.News.Remove(news);
context.SaveChanges();
}
}
public void DeleteCustomer(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Customers.Remove(context.Customers.SingleOrDefault(c => c.Id == id));
context.SaveChanges();
}
}
public void DeleteBanner(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var banner = context.Banners.SingleOrDefault(i => i.Id == id);
if (banner != null)
{
context.Banners.Remove(banner);
context.SaveChanges();
}
}
}
public int CreateUser(User user)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Users.Add(user);
context.SaveChanges();
return user.Id;
}
}
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 int CreateCustomer(Customer customer)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Customers.Add(customer);
context.SaveChanges();
return customer.Id;
}
}
public void DeleteOrder(int orderId)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var order = context.Orders.SingleOrDefault(i => i.Id == orderId);
context.Orders.Remove(order);
context.SaveChanges();
}
}
public int CreateNews(News news)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.News.Add(news);
context.SaveChanges();
return news.Id;
}
}
public void UploadPhotoes(IEnumerable<ItemPhoto> photoes)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.ItemPhotoes.AddRange(photoes);
context.SaveChanges();
}
}
public void DeleteUser(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var dbUser = context.Users.SingleOrDefault(u => u.Id == id);
context.Users.Remove(dbUser);
context.SaveChanges();
}
}
public int CreateBanner(Banner banner)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Banners.Add(banner);
context.SaveChanges();
return banner.Id;
}
}
public int CreateCategory(Category category)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Categories.Add(category);
context.SaveChanges();
return category.Id;
}
}
