/// <summary>
/// Gets the counties.
/// </summary>
/// <param name="request">The request.</param>
/// <returns>The response.</returns>
private static GetCountiesServiceResponse GetCounties(GetCountiesServiceRequest request)
{
ValidateGetAddressInfoRequests(request);
string countryRegionId = request.Filters[AddressServiceConstants.CountryRegionId].ToString();
string stateId = string.Empty;
if (request.Filters[AddressServiceConstants.StateProvinceId] != null)
{
stateId = request.Filters[AddressServiceConstants.StateProvinceId].ToString();
}
var getCountiesDataRequest = new GetCountiesDataRequest(countryRegionId, stateId, request.QueryResultSettings);
var countyInfoDataSet = request.RequestContext.Runtime.Execute <EntityDataServiceResponse <CountyInfo> >(getCountiesDataRequest, request.RequestContext);
return(new GetCountiesServiceResponse(countyInfoDataSet.PagedEntityCollection));
}
private EntityDataServiceResponse <CountyInfo> GetCounties(GetCountiesDataRequest request)
{
ThrowIf.Null(request.CountryRegionCode, "countryRegionCode");
ThrowIf.Null(request.StateId, "stateId");
ParameterSet filters = new ParameterSet();
filters[AddressServiceConstants.CountryRegionId] = request.CountryRegionCode;
filters[AddressServiceConstants.StateProvinceId] = request.StateId;
PagedResult <CountyInfo> counties;
using (SqlServerDatabaseContext sqlServerDatabaseContext = new SqlServerDatabaseContext(request))
{
counties = sqlServerDatabaseContext.ExecuteStoredProcedure <CountyInfo>(GetCountiesInfoSprocName, filters);
}
return(new EntityDataServiceResponse <CountyInfo>(counties));
}
