private IQueryable <Seller> Filtering(IQueryable <Seller> sellers, SellerQuery query)
{
if (query.TenSeller != null)
{
sellers = from x in sellers
where x.Ten.Contains(query.TenSeller)
select x;
}
if (query.CMND != null)
{
sellers = from x in sellers
where x.CMND.Contains(query.CMND)
select x;
}
if (query.Mail != null)
{
sellers = from x in sellers
where x.Mail.Contains(query.Mail)
select x;
}
if (query.CheckMail != null)
{
sellers = sellers.Where(x => x.CheckMail == query.CheckMail);
}
if (query.CheckCMND != null)
{
sellers = sellers.Where(x => x.CheckCMND == query.CheckCMND);
}
return(sellers);
}
public async Task <object> Get(SellerQuery query)
{
var sellers = Sorting <Seller> .Get(Filtering(db.Seller, query), query);
return(new
{
Total = sellers.Count(),
Content = await Paging <Seller> .Get(sellers, query).Include(x => x.DiaChi).ToListAsync()
});
}
public PageModel <ShopInfo> GetSellers(SellerQuery sellerQueryModel)
{
IQueryable <ShopInfo> shopInfo = context.ShopInfo;
if (!string.IsNullOrEmpty(sellerQueryModel.ShopName))
{
shopInfo =
from item in shopInfo
where item.ShopName.Contains(sellerQueryModel.ShopName)
select item;
}
if (sellerQueryModel.RegionId.HasValue)
{
shopInfo =
from item in shopInfo
where item.CompanyRegionId >= sellerQueryModel.RegionId.Value
select item;
}
if (sellerQueryModel.NextRegionId.HasValue)
{
shopInfo =
from item in shopInfo
where item.CompanyRegionId < sellerQueryModel.NextRegionId.Value
select item;
}
if (sellerQueryModel.Ids != null && sellerQueryModel.Ids.Count() > 0)
{
shopInfo =
from item in shopInfo
where sellerQueryModel.Ids.Contains(item.Id)
select item;
}
if (sellerQueryModel.ShopId.HasValue)
{
shopInfo =
from item in shopInfo
where item.Id != sellerQueryModel.ShopId.Value
select item;
}
int num = 0;
num = shopInfo.Count();
shopInfo = shopInfo.FindBy <ShopInfo, long>((ShopInfo item) => (int)item.ShopStatus == 7 && (int?)item.Stage == (int?)ShopInfo.ShopStage.Finish, sellerQueryModel.PageNo, sellerQueryModel.PageSize, out num, (ShopInfo item) => item.Id, false);
return(new PageModel <ShopInfo>()
{
Models = shopInfo,
Total = num
});
}
public async Task <IActionResult> Get([FromQuery] SellerQuery query)
{
return(Ok(await sellerService.Get(query)));
}
