public async Task <IActionResult> Get([FromQuery] SanPhamQuery query)
{
GetResult rs = (ThuongMaiDienTuAPI.Helpers.GetResult) await sanPhamService.Get(query);
rs.Content = mapper.Map <List <SanPhamCommonViewDto> >((List <SanPham>)rs.Content);
return(Ok(rs.Get()));
}
public async Task <object> Get(int idSeller, SanPhamQuery query)
{
var sanpham = Sorting <SanPham> .Get(Filtering(db.SanPham.Where(x => x.IdSeller == idSeller), query), query);
return(new
{
Total = sanpham.Count(),
Content = await Paging <SanPham> .Get(sanpham, query).Include(x => x.CauHinh).Include(x => x.PhanLoaiSP).ToListAsync()
});
}
public async Task <object> Get(SanPhamQuery query)
{
var sanpham = Sorting <SanPham> .Get(Filtering(db.SanPham, query), query);
return(new GetResult(
sanpham.Count(),
await Paging <SanPham> .Get(sanpham, query)
.Include(x => x.CauHinh)
.Include(x => x.PhanLoaiSP)
.ToListAsync()));
}
public async Task <object> GetSanPhamKhuyeMai(int IdKhuyenMai, SanPhamQuery query)
{
var sanpham = Sorting <SanPham> .Get(Filtering(db.SanPham.Where(x => x.IDKhuyenMai == IdKhuyenMai), query), query);
return(new GetResult(sanpham.Count(), await Paging <SanPham> .Get(sanpham, query).Include(x => x.CauHinh).Include(x => x.PhanLoaiSP).ToListAsync()));
//return new
//{
// Total = sanpham.Count(),
// Content = await Paging<SanPham>.Get(sanpham, query).Include(x => x.CauHinh).Include(x => x.PhanLoaiSP).ToListAsync()
//};
}
public async Task <GetResult> Get(SanPhamQuery query)
{
var sanpham = Sorting <SanPham> .Get(Filtering(db.SanPham, query), query);
/*return new
* {
* Total = sanpham.Count(),
* Content = await Paging<SanPham>.Get(sanpham, query).Include(x=>x.CauHinh).Include(x=>x.PhanLoaiSP).ToListAsync()
* };*/
return(new GetResult(sanpham.Count(), await Paging <SanPham> .Get(sanpham, query).Include(x => x.CauHinh).Include(x => x.PhanLoaiSP).ToListAsync()));
}
private IQueryable <SanPham> Filtering(IQueryable <SanPham> sp, SanPhamQuery query)
{
if (query.IDPhanLoaiSP != null)
{
sp = sp.Where(x => db.PhanLoaiSP.Any(y => y.IDSanPham == x.ID && y.ID == query.IDPhanLoaiSP));
}
if (query.IDSeller != null)
{
sp = sp.Where(x => x.IDSeller == query.IDSeller);
}
if (query.Ten != null)
{
sp = from x in sp
where x.Ten.Contains(query.Ten)
select x;
}
if (query.TinhTrang != null)
{
sp = sp.Where(x => x.TinhTrang == query.TinhTrang);
}
if (query.IDDanhMuc != null)
{
sp = sp.Where(x => x.IDDanhMuc == query.IDDanhMuc);
}
if (query.FromGiaKM != null)
{
sp = sp.Where(x => x.PhanLoaiSP.Any(y => y.GiaKM >= query.FromGiaKM));
}
if (query.ToGiaKM != null)
{
sp = sp.Where(x => x.PhanLoaiSP.Any(y => y.GiaKM <= query.ToGiaKM));
}
if (query.FromSoLuong != null)
{
sp = sp.Where(x => x.PhanLoaiSP.Any(y => y.SoLuong >= query.FromSoLuong));
}
if (query.ToSoLuong != null)
{
sp = sp.Where(x => x.PhanLoaiSP.Any(y => y.SoLuong <= query.ToSoLuong));
}
if (query.Mau != null)
{
sp = sp.Where(x => x.PhanLoaiSP.Any(y => y.Mau == query.Mau));
}
return(sp);
}
private IQueryable <SanPham> Filtering(IQueryable <SanPham> sp, SanPhamQuery query)
{
if (query.IdSeller != null)
{
sp = sp.Where(x => x.IdSeller == query.IdSeller);
}
if (query.TenSP != null)
{
sp = from x in sp
where x.TenSP.Contains(query.TenSP)
select x;
}
if (query.TrangThai != null)
{
sp = sp.Where(x => x.TrangThai == query.TrangThai);
}
if (query.IdDanhMuc != null)
{
sp = sp.Where(x => x.IdDanhMuc == query.IdDanhMuc);
}
if (query.CoSPHot != null)
{
sp = sp.Where(x => x.CoSPHot == query.CoSPHot);
}
if (query.CoSPHome != null)
{
sp = sp.Where(x => x.CoSPHome == query.CoSPHome);
}
if (query.FromGiaKM != null)
{
sp = sp.Where(x => x.PhanLoaiSP.Any(y => y.GiaKM >= query.FromGiaKM));
}
if (query.ToGiaKM != null)
{
sp = sp.Where(x => x.PhanLoaiSP.Any(y => y.GiaKM <= query.ToGiaKM));
}
if (query.FromSoLuong != null)
{
sp = sp.Where(x => x.PhanLoaiSP.Any(y => y.SoLuong >= query.FromSoLuong));
}
if (query.ToSoLuong != null)
{
sp = sp.Where(x => x.PhanLoaiSP.Any(y => y.SoLuong <= query.ToSoLuong));
}
return(sp);
}
public async Task <IActionResult> GetBySeller([FromQuery] SanPhamQuery query)
{
int idSeller = User.GetIdSeller();
return(Ok(await sanPhamService.Get(idSeller, query)));
}
