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