public ActionResult DanhSachGiaoDichTable(int page) { int row = 5; int count = 0; int totalpages = 0; count = db.DON_HANG.Count(n => n.IsDeleted == false); if (count > 0) { totalpages = (int)Math.Ceiling((decimal)count / row); } else { totalpages = 0; } var start = row * (page - 1); var md = from a in db.DON_HANG join b in db.KHACH_HANG on a.MaKhachHang equals b.MaKhachHang select new DanhSachGiaoDichViewModel() { MaDonHang = a.MaDonHang, TenKhachHang = b.TenKhachHang, TongGiaTriDonHang = a.TongGiaTriDonHang, TrangThaiDonHang = a.TrangThaiDonHang, NgayTao = a.NgayTao, IsDeleted = a.IsDeleted }; var result = md.Where(n => n.IsDeleted == false).OrderBy(n => n.MaDonHang).Skip(start).Take(row).ToList(); PagingDanhSachGiaoDich model = new PagingDanhSachGiaoDich(); model.totalpage = totalpages; model.record = count; model.List = result; model.page = page; return(View(model)); }
public ActionResult Search(string codesearch, int page) { int row = 5; int count = 0; int totalpages = 0; if (codesearch == "") { var md = from a in db.DON_HANG join b in db.KHACH_HANG on a.MaKhachHang equals b.MaKhachHang select new DanhSachGiaoDichViewModel() { MaDonHang = a.MaDonHang, TenKhachHang = b.TenKhachHang, TongGiaTriDonHang = a.TongGiaTriDonHang, TrangThaiDonHang = a.TrangThaiDonHang, NgayTao = a.NgayTao, IsDeleted = a.IsDeleted }; count = md.Count(n => n.IsDeleted == false); if (count > 0) { totalpages = (int)Math.Ceiling((decimal)count / row); } else { totalpages = 0; } var start = row * (page - 1); var result = md.Where(n => n.IsDeleted == false).OrderBy(n => n.MaDonHang).Skip(start).Take(row).ToList(); PagingDanhSachGiaoDich model = new PagingDanhSachGiaoDich(); model.totalpage = totalpages; model.record = count; model.List = result; model.page = page; return(View("DanhSachGiaoDichTable", model)); } else { int start_gia = 0; int end_gia = 0; if (codesearch == "Dưới 5 triệu") { start_gia = 0; end_gia = 5000000; } if (codesearch == "Từ 5 - 10 triệu") { start_gia = 5000000; end_gia = 10000000; } if (codesearch == "Trên 10 triệu") { start_gia = 10000000; end_gia = 2000000000; } var md = from a in db.DON_HANG join b in db.KHACH_HANG on a.MaKhachHang equals b.MaKhachHang where a.TrangThaiDonHang == codesearch || (a.TongGiaTriDonHang >= start_gia && a.TongGiaTriDonHang <= end_gia) select new DanhSachGiaoDichViewModel() { MaDonHang = a.MaDonHang, TenKhachHang = b.TenKhachHang, TongGiaTriDonHang = a.TongGiaTriDonHang, TrangThaiDonHang = a.TrangThaiDonHang, NgayTao = a.NgayTao, IsDeleted = a.IsDeleted }; count = md.Count(n => n.IsDeleted == false); if (count > 0) { totalpages = (int)Math.Ceiling((decimal)count / row); } else { totalpages = 0; } var start = row * (page - 1); var result = md.Where(n => n.IsDeleted == false).OrderBy(n => n.MaDonHang).Skip(start).Take(row).ToList(); PagingDanhSachGiaoDich model = new PagingDanhSachGiaoDich(); model.totalpage = totalpages; model.record = count; model.List = result; model.page = page; return(View("DanhSachGiaoDichTable", model)); } }