public void deleteAllProductCategory(Models.QLShopOnlineEntities data)
{
deleteAllProduct(data);
data.LoaiSanPhams.RemoveRange(data.LoaiSanPhams);
data.SaveChanges();
}
public void deleteAllOrders(Models.QLShopOnlineEntities data)
{
deleteAllChiTietDonDatHangs(data);
data.DonDatHangs.RemoveRange(data.DonDatHangs);
data.SaveChanges();
}
public void deleteAllProduct(Models.QLShopOnlineEntities data)
{
//ShoppingCardHelper.getInstance().deleteAllChiTietDonDatHangs(data);
data.SanPhams.RemoveRange(data.SanPhams);
data.SaveChanges();
}
public bool checkThisAdminAccountExist(Models.QLShopOnlineEntities data, string username, string password)
{
var result = data.ThanhViens.Where(a => a.TaiKhoan.Equals(username) && a.MatKhau == password);
if (result.Count() > 0)
{
return(true);
}
return(false);
}
public int getPaidOrderAmount(Models.QLShopOnlineEntities data)
{
List <Models.DonDatHang> listOrder = data.DonDatHangs.ToList();
int amount = 0;
foreach (Models.DonDatHang order in listOrder)
{
if (order.DaThanhToan.HasValue && order.DaThanhToan.Value && order.DaHuy.HasValue && order.DaHuy.Value && order.TinhTrangGiaoHang.HasValue && order.TinhTrangGiaoHang.Value)
{
amount++;
}
}
return(amount);
}
public void deleteAllAdmins(Models.QLShopOnlineEntities data)
{
data.ThanhViens.RemoveRange(data.ThanhViens);
data.SaveChanges();
}
public Models.TinTuc getNewsById(Models.QLShopOnlineEntities data, int id)
{
Models.TinTuc result = data.TinTucs.Where(n => n.IdTinTuc == id).Single();
return(result);
}
public int getNewsAmount(Models.QLShopOnlineEntities data)
{
return(data.TinTucs.Count());
}
public void deleteAllNews(Models.QLShopOnlineEntities data)
{
data.TinTucs.RemoveRange(data.TinTucs);
data.SaveChanges();
}
public List <ShoppingCardItemModel> getListShoppingCardItemModelFromListOrderDetails(Models.QLShopOnlineEntities data, List <Models.ChiTietDonDatHang> listChiTietDonDatHangs)
{
List <ShoppingCardItemModel> result = new List <ShoppingCardItemModel>();
foreach (var ChiTietDonDatHang in listChiTietDonDatHangs)
{
Models.SanPham item = ProductHelper.getInstance().getProductById(data, ChiTietDonDatHang.IdSanPham.Value);
ShoppingCardItemModel model = new ShoppingCardItemModel();
model.id = ChiTietDonDatHang.IdSanPham.Value;
model.name = item.TenSanPham;
model.image = item.HinhAnh;
model.quantity = ChiTietDonDatHang.SoLuong.Value;
model.price = item.DonGia.Value;
model.total = model.price * model.quantity;
model.orderid = ChiTietDonDatHang.IdDDH.HasValue ? ChiTietDonDatHang.IdDDH.Value : 0;
model.modelid = ChiTietDonDatHang.IdCTDDH;
result.Add(model);
}
return(result);
}
public int getOrderAmount(Models.QLShopOnlineEntities data)
{
return(data.DonDatHangs.Count());
}
public Models.LoaiSanPham getProductCategoryById(Models.QLShopOnlineEntities data, int id)
{
Models.LoaiSanPham result = data.LoaiSanPhams.Where(n => n.IdLoaiSanPham == id).Single();
return(result);
}
public void deleteAllKhachHangs(Models.QLShopOnlineEntities data)
{
data.KhachHangs.RemoveRange(data.KhachHangs);
data.SaveChanges();
}
public int getMemberAccountAmount(Models.QLShopOnlineEntities data)
{
return(data.KhachHangs.Count());
}
public bool loginAdmin(Models.QLShopOnlineEntities data, string username, string password)
{
return(checkThisAdminAccountExist(data, username, password));
}
public Models.KhachHang getMemberAccountByEmail(Models.QLShopOnlineEntities data, string email)
{
Models.KhachHang result = data.KhachHangs.Where(n => n.Email.Equals(email)).Single();
return(result);
}
public List <Models.SanPham> getListOtherProductsByCategory(Models.QLShopOnlineEntities data, int id, int idProductType)
{
return(data.SanPhams.OrderByDescending(a => a.NgayCapNhat).Where(n => n.IdLoaiSanPham == idProductType && n.IdSanPham != id).ToList());
}
public List <Models.SanPham> getListAllProducts(Models.QLShopOnlineEntities data)
{
return(data.SanPhams.OrderByDescending(a => a.NgayCapNhat).ToList());
}
public int getProductsAmount(Models.QLShopOnlineEntities data)
{
return(data.SanPhams.Count());
}
public int getProductCategoryAmount(Models.QLShopOnlineEntities data)
{
return(data.LoaiSanPhams.Count());
}
