public IActionResult Get(CatCommodityGroupCriteria criteria, int page, int size)
{
var data = catComonityGroupService.Paging(criteria, page, size, out int rowCount);
var result = new { data, totalItems = rowCount, page, size };
return(Ok(result));
}
public async Task <IActionResult> ExportCommodityGroup(CatCommodityGroupCriteria catCommodityGroupCriteria)
{
Helper helper = new Helper();
var responseFromApi = await HttpServiceExtension.GetDataFromApi(catCommodityGroupCriteria, aPis.CatalogueAPI + Urls.Catelogue.CatCommodityGroupUrl);
var dataObjects = responseFromApi.Content.ReadAsAsync <List <CatCommodityGroup> >();
var stream = helper.CreateCommoditygroupExcelFile(dataObjects.Result);
return(new FileHelper().ExportExcel(stream, FilesNames.CommodityGroupList));
}
public IQueryable <CatCommodityGroupModel> Paging(CatCommodityGroupCriteria criteria, int page, int size, out int rowsCount)
{
Expression <Func <CatCommodityGroupModel, bool> > query = null;
if (criteria.All == null)
{
query = x => (x.GroupNameEn ?? "").IndexOf(criteria.GroupNameEn ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.GroupNameVn ?? "").IndexOf(criteria.GroupNameVn ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.Active == criteria.Active || criteria.Active == null);
}
else
{
query = x => ((x.GroupNameEn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
(x.GroupNameVn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1) &&
(x.Active == criteria.Active || criteria.Active == null);
}
var data = Paging(query, page, size, x => x.DatetimeModified, false, out rowsCount);
return(data);
}
public IQueryable <CatCommodityGroupModel> Query(CatCommodityGroupCriteria criteria)
{
Expression <Func <CatCommodityGroupModel, bool> > query = null;
if (criteria.All == null)
{
query = x => (x.GroupNameEn ?? "").IndexOf(criteria.GroupNameEn ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.GroupNameVn ?? "").IndexOf(criteria.GroupNameVn ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.Active == criteria.Active || criteria.Active == null);
}
else
{
query = x => ((x.GroupNameEn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
(x.GroupNameVn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1) &&
(x.Active == criteria.Active || criteria.Active == null);
}
var results = Get(query);
return(results);
}
public IActionResult Get(CatCommodityGroupCriteria criteria)
{
var results = catComonityGroupService.Query(criteria);
return(Ok(results));
}
