public IQueryable <KhachHang> Filtering(IQueryable <KhachHang> kh, KhachHangQuery query)
{
if (query.TenKh != null)
{
kh = from x in kh
where x.Ten.Contains(query.TenKh)
select x;
}
if (query.SDT != null)
{
kh = from x in kh
where x.SDT.Contains(query.SDT)
select x;
}
if (query.Mail != null)
{
kh = from x in kh
where x.Mail.Contains(query.Mail)
select x;
}
if (query.FromDiem != null)
{
kh = kh.Where(x => x.Diem >= query.FromDiem);
}
if (query.ToDiem != null)
{
kh = kh.Where(x => x.Diem <= query.ToDiem);
}
return(kh);
}
public async Task <object> Get(KhachHangQuery query)
{
var kh = Sorting <KhachHang> .Get(Filtering(db.KhachHang, query), query);
return(new
{
Total = kh.Count(),
Content = await Paging <KhachHang> .Get(kh, query).Include(x => x.DiaChi).ToListAsync()
});
}
public async Task <IActionResult> Get([FromQuery] KhachHangQuery query)
{
return(Ok(await khachHangService.Get(query)));
}
