public IActionResult Get(CatUnitCriteria criteria, int page, int size)
{
var data = catUnitService.Paging(criteria, page, size, out int rowCount);
var result = new { data, totalItems = rowCount, page, size };
return(Ok(result));
}
public async Task <IActionResult> ExportUnit(CatUnitCriteria catUnitCriteria)
{
Helper helper = new Helper();
var responseFromApi = await HttpServiceExtension.GetDataFromApi(catUnitCriteria, aPis.CatalogueAPI + Urls.Catelogue.CatUnitUrl);
var dataObjects = responseFromApi.Content.ReadAsAsync <List <CatUnit> >();
var stream = helper.CreateCatUnitExcelFile(dataObjects.Result);
return(new FileHelper().ExportExcel(stream, FilesNames.UnitList));
}
public IQueryable <CatUnitModel> Paging(CatUnitCriteria criteria, int pageNumber, int pageSize, out int rowsCount)
{
IQueryable <CatUnitModel> returnList = null;
var data = GetBy(criteria);
if (data == null)
{
rowsCount = 0;
return(data);
}
rowsCount = data.Count();
data = data.OrderByDescending(x => x.DatetimeModified);
if (pageSize > 1)
{
if (pageNumber < 1)
{
pageNumber = 1;
}
returnList = data.Skip((pageNumber - 1) * pageSize).Take(pageSize);
}
return(returnList);
}
private IQueryable <CatUnitModel> GetBy(CatUnitCriteria criteria)
{
Expression <Func <CatUnitModel, bool> > query = null;
if (criteria.All == null)
{
query = x => (x.Code ?? "").IndexOf(criteria.Code ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.UnitNameVn ?? "").IndexOf(criteria.UnitNameVn ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.UnitNameEn ?? "").IndexOf(criteria.UnitNameEn ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.UnitType ?? "").IndexOf(criteria.UnitType ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.Active == criteria.Active || criteria.Active == null);
}
else
{
query = x => ((x.Code ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
(x.UnitNameVn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
(x.UnitNameEn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
(x.UnitType ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1) &&
(x.Active == criteria.Active || criteria.Active == null);
}
var data = Get().Where(query);
return(data);
}
public IQueryable <CatUnitModel> Query(CatUnitCriteria criteria)
{
var data = GetBy(criteria);
return(data);
}
public IActionResult Get(CatUnitCriteria criteria)
{
var result = catUnitService.Query(criteria);
return(Ok(result));
}
