public IHttpActionResult GetDonHangs(DonHangSearchList donHangSearchList)
{
return(Ok(new {
list = _donHangServices.GetAll(donHangSearchList),
page = donHangSearchList.page,
size = donHangSearchList.size,
total = _donHangServices.count_list
}));
}
public List <DonHangList> GetAll(DonHangSearchList donHangSearchList)
{
var query = from don_hang in _donhangRepository.GetAll()
select new
{
MaKhachHang = don_hang.MaKhachHang,
TenTaiKhoan = don_hang.TenTaiKhoan,
NguoiGui = don_hang.NguoiGui,
MaDonHang = don_hang.MaDonHang,
DiaChiGui = don_hang.DiaChiGui,
SoDienThoaiNguoiGui = don_hang.SoDienThoaiNguoiGui,
NguoiNhan = don_hang.NguoiNhan,
DiaChiNhan = don_hang.DiaChiNhan,
SoDienThoaiNguoiNhan = don_hang.SoDienThoaiNguoiNhan,
MaNhanVienGiao = don_hang.MaNhanVienGiao,
GhiChu = don_hang.GhiChu,
TinhTrang = don_hang.TinhTrang,
ThoiDiemDatDonHang = don_hang.ThoiDiemDatDonHang,
ThoiDiemTiepNhanDon = don_hang.ThoiDiemTiepNhanDon,
ThoiDiemHoanThanhDH = don_hang.ThoiDiemHoanThanhDH,
ThanhTien = don_hang.ThanhTien,
MaHanhTrinh = don_hang.MaHanhTrinh
};
if (!string.IsNullOrWhiteSpace(donHangSearchList.TenTaiKhoan))
{
query = query.Where(prop => prop.TenTaiKhoan.ToLower().Contains(donHangSearchList.TenTaiKhoan.ToLower()));
}
if (!string.IsNullOrWhiteSpace(donHangSearchList.MaKhachHang))
{
query = query.Where(prop => prop.MaKhachHang.ToString() == donHangSearchList.MaKhachHang);
}
if (donHangSearchList.MaNhanVien.HasValue)
{
query = query.Where(prop => prop.MaNhanVienGiao == donHangSearchList.MaNhanVien.Value);
}
if (!string.IsNullOrWhiteSpace(donHangSearchList.TinhTrang))
{
query = query.Where(prop => prop.TinhTrang.ToString() == donHangSearchList.TinhTrang);
}
this.count_list = query.Count();
query = query.Skip(donHangSearchList.page.Value * donHangSearchList.size.Value).Take(donHangSearchList.size.Value);
List <DonHangList> donHangLists = new List <DonHangList>();
DonHangList listdonhang;
foreach (var dh in query)
{
listdonhang = new DonHangList();
listdonhang.NguoiGui = dh.NguoiGui;
listdonhang.MaKhachHang = dh.MaKhachHang;
listdonhang.TenTaiKhoan = dh.TenTaiKhoan;
listdonhang.MaDonHang = dh.MaDonHang;
listdonhang.DiaChiGui = dh.DiaChiGui;
listdonhang.SoDienThoaiNguoiGui = dh.SoDienThoaiNguoiGui;
listdonhang.NguoiNhan = dh.NguoiNhan;
listdonhang.DiaChiNhan = dh.DiaChiNhan;
listdonhang.SoDienThoaiNguoiNhan = dh.SoDienThoaiNguoiNhan;
listdonhang.MaNhanVienGiao = dh.MaNhanVienGiao;
listdonhang.GhiChu = dh.GhiChu;
listdonhang.TinhTrang = dh.TinhTrang;
listdonhang.ThoiDiemDatDonHang = dh.ThoiDiemDatDonHang;
listdonhang.ThoiDiemTiepNhanDon = dh.ThoiDiemTiepNhanDon;
listdonhang.ThoiDiemHoanThanhDH = dh.ThoiDiemHoanThanhDH;
listdonhang.ThanhTien = dh.ThanhTien;
listdonhang.MaHanhTrinh = dh.MaHanhTrinh;
donHangLists.Add(listdonhang);
}
return(donHangLists);
}
