private EntityDataServiceResponse <CityInfo> GetCities(GetCitiesDataRequest request)
{
ThrowIf.Null(request.CountryRegionCode, "countryRegionCode");
ThrowIf.Null(request.StateId, "stateId");
ThrowIf.Null(request.CountyId, "countyId");
ParameterSet filters = new ParameterSet();
filters[AddressServiceConstants.CountryRegionId] = request.CountryRegionCode;
filters[AddressServiceConstants.StateProvinceId] = request.StateId;
filters[AddressServiceConstants.CountyId] = request.CountyId;
PagedResult <CityInfo> cities;
using (SqlServerDatabaseContext sqlServerDatabaseContext = new SqlServerDatabaseContext(request))
{
cities = sqlServerDatabaseContext.ExecuteStoredProcedure <CityInfo>(GetCitiesInfoSprocName, filters);
}
return(new EntityDataServiceResponse <CityInfo>(cities));
}
/// <summary>
/// Gets the cities.
/// </summary>
/// <param name="request">The request.</param>
/// <returns>The response.</returns>
private static GetCitiesServiceResponse GetCities(GetCitiesServiceRequest request)
{
ValidateGetAddressInfoRequests(request);
string countryRegionId = request.Filters[AddressServiceConstants.CountryRegionId].ToString();
string stateId = string.Empty;
string countyId = string.Empty;
if (request.Filters[AddressServiceConstants.StateProvinceId] != null)
{
stateId = request.Filters[AddressServiceConstants.StateProvinceId].ToString();
}
if (request.Filters[AddressServiceConstants.CountyId] != null)
{
countyId = request.Filters[AddressServiceConstants.CountyId].ToString();
}
var getCityDataRequest = new GetCitiesDataRequest(countryRegionId, stateId, countyId, request.QueryResultSettings);
var cityDataSet = request.RequestContext.Runtime.Execute <EntityDataServiceResponse <CityInfo> >(getCityDataRequest, request.RequestContext);
return(new GetCitiesServiceResponse(cityDataSet.PagedEntityCollection));
}
