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