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