public override void ApplyFilter(ref IQueryable <HDNHD.Models.DataContexts.Tuyenkhachhang> items)
{
HDNHDDataContext context = (HDNHDDataContext)GetDataContext(items);
if (NhanVienID != null) // nhan vien
{
items = from item in items
join ttnv in context.Tuyentheonhanviens on item.TuyenKHID equals ttnv.TuyenKHID
where ttnv.NhanVienID == NhanVienID
select item;
} // to
else if (ToID != null)
{
items = from item in items
join ttnv in context.Tuyentheonhanviens on item.TuyenKHID equals ttnv.TuyenKHID
join nv in context.Nhanviens on ttnv.NhanVienID equals nv.NhanvienID
where nv.ToQuanHuyenID == ToID
select item;
} // quan huyen
else if (QuanHuyenID != null)
{
items = from item in items
join ttnv in context.Tuyentheonhanviens on item.TuyenKHID equals ttnv.TuyenKHID
join nv in context.Nhanviens on ttnv.NhanVienID equals nv.NhanvienID
join to in context.ToQuanHuyens on nv.ToQuanHuyenID equals to.ToQuanHuyenID
where to.QuanHuyenID == QuanHuyenID
select item;
}
// select distinct result if duplicate on TuyenTheoNhanVien
items = items.Distinct();
}
public override void ApplyFilter(ref IQueryable <GiaoDichSumModel> items)
{
HDNHDDataContext context = (HDNHDDataContext)GetDataContext(items);
var query = from item in items
join stntt in context.SoTienNopTheoThangs on item.GiaoDich.TienNopTheoThangID equals stntt.ID
join hd in context.Hoadonnuocs on stntt.HoaDonNuocID equals hd.HoadonnuocID
join kh in context.Khachhangs on hd.KhachhangID equals kh.KhachhangID
select new
{
GiaoDich = item,
KhachHang = kh
};
if (TuyenKHID != null)
{
query = query.Where(m => m.KhachHang.TuyenKHID == TuyenKHID);
}
else if (NhanVienID != null) // nhan vien
{
query = from hdkh in query
join ttnv in context.Tuyentheonhanviens on hdkh.KhachHang.TuyenKHID equals ttnv.TuyenKHID
where ttnv.NhanVienID == NhanVienID
select hdkh;
} // to
else if (ToID != null)
{
query = from item in query
join to in context.ToQuanHuyens on item.KhachHang.QuanhuyenID equals to.QuanHuyenID
where to.ToQuanHuyenID == ToID
select item;
} // quan huyen
else if (QuanHuyenID != null)
{
query = query.Where(m => m.KhachHang.QuanhuyenID == QuanHuyenID);
}
// loai kh
if (LoaiKhachHang != null)
{
if (LoaiKhachHang == ELoaiKhachHang.CoQuanToChuc)
{
query = query.Where(m => m.KhachHang.LoaiKHID != (int)ELoaiKhachHang.HoGiaDinh);
}
else
{
query = query.Where(m => m.KhachHang.LoaiKHID == (int)LoaiKhachHang.Value);
}
}
if (HinhThucThanhToan != null)
{
query = query.Where(m => m.KhachHang.HinhthucttID == (int)HinhThucThanhToan.Value);
}
items = from item in query
select item.GiaoDich;
}
public override void ApplyFilter(ref IQueryable <DuCoModel> items)
{
HDNHDDataContext context = (HDNHDDataContext)GetDataContext(items);
if (TuyenKHID != null)
{
items = items.Where(m => m.KhachHang.TuyenKHID == TuyenKHID);
}
else if (NhanVienID != null) // nhan vien
{
items = from hdkh in items
join ttnv in context.Tuyentheonhanviens on hdkh.KhachHang.TuyenKHID equals ttnv.TuyenKHID
where ttnv.NhanVienID == NhanVienID
select hdkh;
} // to
else if (ToID != null)
{
items = from item in items
join to in context.ToQuanHuyens on item.KhachHang.QuanhuyenID equals to.QuanHuyenID
where to.ToQuanHuyenID == ToID
select item;
//items = from hdkh in items
// join ttnv in context.Tuyentheonhanviens on hdkh.KhachHang.TuyenKHID equals ttnv.TuyenKHID
// join nv in context.Nhanviens on ttnv.NhanVienID equals nv.NhanvienID
// where nv.ToQuanHuyenID == ToID
// group hdkh by hdkh.HoaDon.HoadonnuocID into g
// select g.First();
} // quan huyen
else if (QuanHuyenID != null)
{
items = items.Where(m => m.KhachHang.QuanhuyenID == QuanHuyenID);
}
// loai kh
if (LoaiKhachHang != null)
{
if (LoaiKhachHang == ELoaiKhachHang.CoQuanToChuc)
{
items = items.Where(m => m.KhachHang.LoaiKHID != (int)ELoaiKhachHang.HoGiaDinh);
}
else
{
items = items.Where(m => m.KhachHang.LoaiKHID == (int)LoaiKhachHang.Value);
}
}
if (HinhThucThanhToan != null)
{
items = items.Where(m => m.KhachHang.HinhthucttID == (int)HinhThucThanhToan.Value);
}
}
public SoTienNopTheoThangRepository(HDNHDDataContext context) : base(context)
{
dc = context;
}
public PhongBanRepository(HDNHDDataContext context) : base(context)
{
}
public GiaoDichRepository(HDNHDDataContext context) : base(context)
{
dc = context;
}
public DuCoRepository(DataContext context) : base(context)
{
dc = (HDNHDDataContext)context;
}
public KhachHangRepository(HDNHDDataContext context) : base(context)
{
}
public HoaDonRepository(HDNHDDataContext context)
: base(context)
{
dc = context;
}
public TuyenKHRepository(DataContext context) : base(context)
{
dc = (HDNHDDataContext)context;
}
public override void ApplyFilter(ref IQueryable <HoaDonModel> items)
{
if (Mode == null || Mode == FilterByManagementInfo)
{
HDNHDDataContext context = (HDNHDDataContext)GetDataContext(items);
if (TrangThaiThu == ETrangThaiThu.DaQuaHan)
{
items = items.Where(m => m.HoaDon.NamHoaDon < Year || (m.HoaDon.NamHoaDon == Year && m.HoaDon.ThangHoaDon < Month));
items = items.Where(m => m.HoaDon.Trangthaithu == false || m.HoaDon.Trangthaithu == null);
}
else
{
var month = Month;
var year = Year;
if (month != null)
{
month--;
if (month < 1)
{
month = 12;
year--;
}
items = items.Where(m => m.HoaDon.ThangHoaDon == month);
}
items = items.Where(m => m.HoaDon.NamHoaDon == year);
if (TrangThaiThu != null)
{
if (TrangThaiThu == ETrangThaiThu.DaNopTien)
{
items = items.Where(m => m.HoaDon.Trangthaithu == true);
}
if (TrangThaiThu == ETrangThaiThu.ChuaNopTien)
{
items = items.Where(m => m.HoaDon.Trangthaithu == false || m.HoaDon.Trangthaithu == null);
}
}
}
if (LoaiKhachHang != null)
{
if (LoaiKhachHang == ELoaiKhachHang.CoQuanToChuc)
{
items = items.Where(m => m.KhachHang.LoaiKHID != (int)ELoaiKhachHang.HoGiaDinh);
}
else
{
items = items.Where(m => m.KhachHang.LoaiKHID == (int)LoaiKhachHang.Value);
}
}
if (HinhThucThanhToan != null)
{
items = items.Where(m => m.KhachHang.HinhthucttID == (int)HinhThucThanhToan.Value);
}
//* filter by management info
if (TuyenKHID != null)
{
items = items.Where(m => m.KhachHang.TuyenKHID == TuyenKHID);
}
else if (NhanVienID != null)
{
items = from hdkh in items
join ttnv in context.Tuyentheonhanviens on hdkh.KhachHang.TuyenKHID equals ttnv.TuyenKHID
where ttnv.NhanVienID == NhanVienID
select hdkh;
}
else if (ToID != null)
{
items = from item in items
join to in context.ToQuanHuyens on item.KhachHang.QuanhuyenID equals to.QuanHuyenID
where to.ToQuanHuyenID == ToID
select item;
//items = from hdkh in items
// join ttnv in context.Tuyentheonhanviens on hdkh.KhachHang.TuyenKHID equals ttnv.TuyenKHID
// join nv in context.Nhanviens on ttnv.NhanVienID equals nv.NhanvienID
// where nv.ToQuanHuyenID == ToID
// group hdkh by hdkh.HoaDon.HoadonnuocID into g
// select g.First();
}
else if (QuanHuyenID != null)
{
items = items.Where(m => m.KhachHang.QuanhuyenID == QuanHuyenID);
}
}
if (Mode == FilterByUserInfo)
{
//* filter by customer info
if (MaKH != null)
{
items = items.Where(m => m.KhachHang.MaKhachHang == MaKH);
}
if (TenKH != null)
{
items = items.Where(m => m.KhachHang.Ten.Contains(TenKH));
}
if (DiaChiKH != null)
{
items = items.Where(m => m.KhachHang.Diachi.Contains(DiaChiKH));
}
items = from item in items
group item by item.KhachHang.KhachhangID into g
select g.First();
}
}
