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))); }