/// <summary> /// Get Cities /// </summary> public Models.CitySearchRequestResponse Get([FromUri] CitySearchRequest request) { if (request == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } return(cityService.SearchCity(request).CreateFrom()); }
/// <summary> /// Search City /// </summary> public CitySearchRequestResponse SearchCity(CitySearchRequest request) { int rowCount; return(new CitySearchRequestResponse { Cities = cityRepository.SearchCity(request, out rowCount), TotalCount = rowCount }); }
public IList <Model.City> GetAll(CitySearchRequest request) { var query = _context.City.AsQueryable(); if (request?.CountryId.HasValue == true) { query = query.Where(x => x.CountryId == request.CountryId); } var list = query.ToList(); return(_mapper.Map <IList <Model.City> >(list)); }
public override List <City> Get(CitySearchRequest search) { var query = _context.Cities.AsQueryable(); if (!string.IsNullOrWhiteSpace(search.CityName)) { query = query.Where(w => w.Name.StartsWith(search.CityName)); } if (search.CityId != null) { query = query.Where(w => w.Id == search.CityId); } return(_mapper.Map <List <Model.City> >(query.ToList())); }
private async void btnSave_Click(object sender, EventArgs e) { if (txtSearch == null) { var result = await cityService.Get <List <MCity> >(null); dgvCity.DataSource = result; } else { var request = new CitySearchRequest() { CityName = txtSearch.Text }; var result = await cityService.Get <List <MCity> >(request); dgvCity.DataSource = result; } }
/// <summary> /// Search City /// </summary> public IEnumerable <City> SearchCity(CitySearchRequest request, out int rowCount) { int fromRow = (request.PageNo - 1) * request.PageSize; int toRow = request.PageSize; Expression <Func <City, bool> > query = city => (string.IsNullOrEmpty(request.CityFilterText) || (city.CityCode.Contains(request.CityFilterText)) || (city.CityName.Contains(request.CityFilterText))) && ( (!request.CountryId.HasValue || request.CountryId == city.CountryId)); rowCount = DbSet.Count(query); return(request.IsAsc ? DbSet.Where(query) .OrderBy(cityOrderByClause[request.CityOrderBy]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet.Where(query) .OrderByDescending(cityOrderByClause[request.CityOrderBy]) .Skip(fromRow) .Take(toRow) .ToList()); }
public IList <Model.City> GetAll([FromQuery] CitySearchRequest request) { return(_service.GetAll(request)); }