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