public virtual PagedList <PhieuChuyenPhat> GetAllPhieuChuyenPhat(int NhaXeId = 0, int vanphongguid = 0, string _maphieu = "", string _tennguoigui = "",
ENTrangThaiChuyenPhat TrangThaiId = ENTrangThaiChuyenPhat.All, DateTime?NgayNhanHang = null,
int vanphongnhanid = 0,
int pageIndex = 0,
int pageSize = int.MaxValue)
{
var query = _phieuchuyenphatRepository.Table.Where(m => m.TrangThaiId != (int)ENTrangThaiChuyenPhat.Huy);
query = query.Where(m => m.NhaXeId == NhaXeId);
if (!String.IsNullOrWhiteSpace(_maphieu))
{
query = query.Where(m => m.MaPhieu.Contains(_maphieu));
}
if (!String.IsNullOrWhiteSpace(_tennguoigui))
{
query = query.Where(m => (m.NguoiGui.HoTen.Contains(_tennguoigui) || m.NguoiNhan.HoTen.Contains(_tennguoigui)));
}
if (TrangThaiId > 0)
{
query = query.Where(m => m.TrangThaiId == (int)TrangThaiId);
}
if (NgayNhanHang.HasValue)
{
var _ngaynhanhang = NgayNhanHang.Value.Date;
query = query.Where(c => c.NgayNhanHang == _ngaynhanhang);
}
if (vanphongnhanid > 0)
{
query = query.Where(m => m.VanPhongNhanId == vanphongnhanid);
}
if (vanphongguid > 0)
{
query = query.Where(m => m.VanPhongGuiId == vanphongguid);
}
query = query.OrderByDescending(m => m.Id);
return(new PagedList <PhieuChuyenPhat>(query, pageIndex, pageSize));
}
public virtual List <PhieuChuyenPhat> GetAllPhieuChuyenPhat(int NhaXeId, int vanphonggui_id, DateTime?NgayNhanHang = null, string _thongtin = "", ENTrangThaiChuyenPhat TrangThaiId = ENTrangThaiChuyenPhat.All, int PhieuVanChuyenId = 0, int VanPhongNhanId = 0, DateTime?TuNgay = null, DateTime?DenNgay = null)
{
var query = _phieuchuyenphatRepository.Table.Where(m => m.TrangThaiId != (int)ENTrangThaiChuyenPhat.Huy);
query = query.Where(m => m.NhaXeId == NhaXeId);
if (NgayNhanHang.HasValue)
{
var _ngaynhanhang = NgayNhanHang.Value.Date;
query = query.Where(c => c.NgayNhanHang == _ngaynhanhang);
}
if (TuNgay.HasValue)
{
var _tungay = TuNgay.Value.Date;
query = query.Where(c => c.NgayNhanHang > _tungay);
}
if (DenNgay.HasValue)
{
var _dengay = DenNgay.Value.Date.AddDays(1);
query = query.Where(c => c.NgayNhanHang < _dengay);
}
if (TrangThaiId != ENTrangThaiChuyenPhat.All)
{
query = query.Where(m => m.TrangThaiId == (int)TrangThaiId);
}
if (vanphonggui_id > 0)
{
query = query.Where(m => m.VanPhongGuiId == vanphonggui_id);
}
if (!String.IsNullOrWhiteSpace(_thongtin))
{
query = query.Where(m => (m.MaPhieu.Contains(_thongtin) || m.NguoiGui.HoTen.Contains(_thongtin) || m.NguoiNhan.HoTen.Contains(_thongtin) || m.TenHang.Contains(_thongtin)));
}
if (PhieuVanChuyenId > 0)
{
query = query.Where(m => m.PhieuVanChuyenId == PhieuVanChuyenId);
}
if (VanPhongNhanId > 0)
{
query = query.Where(m => m.phieuvanchuyen.nhatkyvanchuyens.Any(nk => nk.VanPhongNhanId == VanPhongNhanId) ||
(
m.VanPhongNhanId == VanPhongNhanId &&
m.phieuvanchuyen.LoaiPhieuVanChuyenId == (int)ENLoaiPhieuVanChuyen.TrongTuyen
)
);
}
query = query.OrderByDescending(m => m.Id);
return(query.ToList());
}
public virtual PagedList <PhieuChuyenPhat> GetAllPhieuChuyenPhatPageList(int NhaXeId, int vanphonggui_id, DateTime?NgayNhanHang = null, string _thongtin = "", ENTrangThaiChuyenPhat TrangThaiId = ENTrangThaiChuyenPhat.All, int PhieuVanChuyenId = 0, int VanPhongNhanId = 0, DateTime?TuNgay = null, DateTime?DenNgay = null, int pageIndex = 0, int pageSize = int.MaxValue)
{
var query = _phieuchuyenphatRepository.Table.Where(m => m.TrangThaiId != (int)ENTrangThaiChuyenPhat.Huy);
query = query.Where(m => m.NhaXeId == NhaXeId);
if (NgayNhanHang.HasValue)
{
var _ngaynhanhang = NgayNhanHang.Value.Date;
var lastday = DateTime.Now.AddDays(-1);
query = query.Where(c => c.NgayNhanHang == _ngaynhanhang ||
(c.NgayTao.Year == lastday.Year && c.NgayTao.Month == lastday.Month && c.NgayTao.Day == lastday.Day && c.NgayTao.Hour >= 17));
}
if (TuNgay.HasValue)
{
var _tungay = TuNgay.Value.Date;
query = query.Where(c => c.NgayNhanHang > _tungay);
}
if (DenNgay.HasValue)
{
var _dengay = DenNgay.Value.Date.AddDays(1);
query = query.Where(c => c.NgayNhanHang < _dengay);
}
if (TrangThaiId != ENTrangThaiChuyenPhat.All)
{
query = query.Where(m => m.TrangThaiId == (int)TrangThaiId);
}
if (vanphonggui_id > 0)
{
query = query.Where(m => m.VanPhongGuiId == vanphonggui_id);
}
if (!String.IsNullOrWhiteSpace(_thongtin))
{
query = query.Where(m => (m.MaPhieu.Contains(_thongtin) || m.NguoiGui.HoTen.Contains(_thongtin) || m.NguoiGui.SoDienThoai.Contains(_thongtin) || m.NguoiNhan.SoDienThoai.Contains(_thongtin) || m.NguoiNhan.HoTen.Contains(_thongtin) || m.TenHang.Contains(_thongtin)));
}
if (PhieuVanChuyenId > 0)
{
query = query.Where(m => m.PhieuVanChuyenId == PhieuVanChuyenId);
}
if (VanPhongNhanId > 0)
{
query = query.Where(m => m.phieuvanchuyen.nhatkyvanchuyens.Any(nk => nk.VanPhongNhanId == VanPhongNhanId) ||
(
m.VanPhongNhanId == VanPhongNhanId &&
m.phieuvanchuyen.LoaiPhieuVanChuyenId == (int)ENLoaiPhieuVanChuyen.TrongTuyen
)
);
}
query = query.OrderByDescending(m => m.Id);
//return query.ToList();
return(new PagedList <PhieuChuyenPhat>(query, pageIndex, pageSize));
}