public IActionResult Get(CatCountryCriteria criteria, int page, int size) { var data = catCountryService.GetCountries(criteria, page, size, out int rowCount); var result = new { data, totalItems = rowCount, page, size }; return(Ok(result)); }
public async Task <IActionResult> ExportCountry(CatCountryCriteria catCountryCriteria) { Helper helper = new Helper(); var responseFromApi = await HttpServiceExtension.GetDataFromApi(catCountryCriteria, aPis.CatalogueAPI + Urls.Catelogue.CountryUrl); var dataObjects = responseFromApi.Content.ReadAsAsync <List <CatCountry> >(); var stream = helper.CreateCountryExcelFile(dataObjects.Result); return(new FileHelper().ExportExcel(stream, FilesNames.CountryName)); }
public IQueryable <CatCountryModel> GetCountries(CatCountryCriteria criteria, int page, int size, out int rowsCount) { Expression <Func <CatCountryModel, bool> > query = null; if (criteria.All == null) { query = x => (x.Code ?? "").IndexOf(criteria.Code ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.NameEn ?? "").IndexOf(criteria.NameEn ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.NameVn ?? "").IndexOf(criteria.NameVn ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.Active == criteria.Active || criteria.Active == null); } else { query = x => ((x.Code ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 || (x.NameEn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 || (x.NameVn ?? "").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); }
private IQueryable <CatCountryModel> GetBy(CatCountryCriteria criteria) { Expression <Func <CatCountryModel, bool> > query = null; if (criteria.All == null) { query = x => (x.Code ?? "").IndexOf(criteria.Code ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.NameEn ?? "").IndexOf(criteria.NameEn ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.NameVn ?? "").IndexOf(criteria.NameVn ?? "", StringComparison.OrdinalIgnoreCase) > -1 && (x.Active == criteria.Active || criteria.Active == null); } else { query = x => ((x.Code ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 || (x.NameEn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 || (x.NameVn ?? "").IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1) && (x.Active == criteria.Active || criteria.Active == null); } var data = Get(query); return(data); }
public IActionResult Get(CatCountryCriteria criteria) { var data = catCountryService.Query(criteria); return(Ok(data)); }
public IQueryable <CatCountryModel> Query(CatCountryCriteria criteria) { IQueryable <CatCountryModel> data = GetBy(criteria); return(data); }