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