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 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 Item GetItem(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var item = context.Items.Include("Category").Include("ItemPhotoes").SingleOrDefault(i => i.Id == id);
return item;
}
}
public User GetUser(string email, string password)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Configuration.AutoDetectChangesEnabled = false;
var user = context.Users.Include("Orders").SingleOrDefault(u => u.Email == email && u.Password == password);
return user;
}
}
public Banner GetBanner(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var banner = context.Banners.SingleOrDefault(i => i.Id == id);
return banner;
}
}
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 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 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 UpdateNews(News news)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Entry(news).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public IEnumerable<Customer> GetCustomers(Func<Customer,bool> predicate)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var dbcus = context.Customers.Where(predicate).ToArray();
return dbcus;
}
}
public IEnumerable<User> GetUsers(Func<User, bool> predicate)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var users = context.Users.Where(predicate).ToArray();
return users;
}
}
public IEnumerable<Category> GetCategories(Func<Category, bool> predicate, bool passbyItem = true)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var dbcate = passbyItem ? context.Categories.Include("Category1").Where(predicate).ToArray() :
context.Categories.Include("Category1").Include("Items").Where(predicate).ToArray();
return dbcate;
}
}
public Customer GetCustomer(Func<Customer, bool> predicate)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var dbcus = context.Customers.Include("Orders").Where(predicate).FirstOrDefault();
return dbcus;
}
}
public Customer GetCustomer(string email, string password)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var dbcus = context.Customers.SingleOrDefault(i => i.CustomerEmail == email && i.CustomerPassword == password);
return dbcus;
}
}
public IEnumerable<News> GetConditionalNews(Func<News, bool> predicate)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var newsList = context.News.Where(predicate).ToArray();
return newsList;
}
}
public Category GetCategory(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var dbcate = context.Categories.Include("Category1").Include("Items").SingleOrDefault(i => i.Id == id);
return dbcate;
}
}
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 IEnumerable<Item> GetItems(Func<Item, bool> predicate)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var items = context.Items.Include("Category").Where(predicate).ToArray();
return items;
}
}
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 News GetNews(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var news = context.News.Include("User").SingleOrDefault(i => i.Id == id);
return news;
}
}
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 Order GetOrder(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var order = context.Orders.Include("OrderDetails").Include("User").Include("Customer").SingleOrDefault(i => i.Id == id);
return order;
}
}
public SiteNew GetPolicyNews(int id)
{
using (var context = new GiaikhatNgocMaiEntities())
{
var policy = context.SiteNews.SingleOrDefault(i => i.Id == id);
return policy;
}
}
public IEnumerable<ShipmentFee> GetShipmentFees()
{
using (var context = new GiaikhatNgocMaiEntities())
{
var feeList = context.ShipmentFees.ToArray();
return feeList;
}
}
public void UploadPhotoes(IEnumerable<ItemPhoto> photoes)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.ItemPhotoes.AddRange(photoes);
context.SaveChanges();
}
}
public IEnumerable<Unit> GetUnits()
{
using (var context = new GiaikhatNgocMaiEntities())
{
var units = context.Units.ToArray();
return units;
}
}
public int CreateBanner(Banner banner)
{
using (var context = new GiaikhatNgocMaiEntities())
{
context.Banners.Add(banner);
context.SaveChanges();
return banner.Id;
}
}
public IEnumerable<SiteNew> GetAllPolicyNews()
{
using (var context = new GiaikhatNgocMaiEntities())
{
var policies = context.SiteNews.ToArray();
return policies;
}
}