Esempio n. 1
0
            private EntityDataServiceResponse <ZipCodeInfo> GetZipCodes(GetZipPostalCodeDataRequest request)
            {
                ThrowIf.Null(request.CountryRegionCode, "countryRegionCode");
                ThrowIf.Null(request.StateId, "stateId");
                ThrowIf.Null(request.CountyId, "countyId");
                ThrowIf.Null(request.City, "city");
                ThrowIf.Null(request.District, "districtId");

                ParameterSet filters = new ParameterSet();

                filters[AddressServiceConstants.CountryRegionId]   = request.CountryRegionCode;
                filters[AddressServiceConstants.StateProvinceId]   = request.StateId;
                filters[AddressServiceConstants.CountyId]          = request.CountyId;
                filters[AddressServiceConstants.CityComponentName] = request.City;
                filters[AddressServiceConstants.DistrictId]        = request.District;

                PagedResult <ZipCodeInfo> zipCodes;

                using (SqlServerDatabaseContext sqlServerDatabaseContext = new SqlServerDatabaseContext(request))
                {
                    zipCodes = sqlServerDatabaseContext.ExecuteStoredProcedure <ZipCodeInfo>(GetZipCodesInfoSprocName, filters);
                }

                return(new EntityDataServiceResponse <ZipCodeInfo>(zipCodes));
            }
Esempio n. 2
0
            /// <summary>
            /// Gets the zip codes.
            /// </summary>
            /// <param name="request">The request.</param>
            /// <returns>The response.</returns>
            private static GetZipCodesServiceResponse GetZipCodes(GetZipCodesServiceRequest request)
            {
                ValidateGetAddressInfoRequests(request);

                string countryRegionId = request.Filters[AddressServiceConstants.CountryRegionId].ToString();

                string stateId  = string.Empty;
                string city     = string.Empty;
                string countyId = string.Empty;
                string district = 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();
                }

                if (request.Filters[AddressServiceConstants.CityComponentName] != null)
                {
                    city = request.Filters[AddressServiceConstants.CityComponentName].ToString();
                }

                if (request.Filters[AddressServiceConstants.DistrictId] != null)
                {
                    district = request.Filters[AddressServiceConstants.DistrictId].ToString();
                }

                var getZipcodeDataRequest = new GetZipPostalCodeDataRequest(countryRegionId, stateId, countyId, city, district);

                getZipcodeDataRequest.QueryResultSettings = request.QueryResultSettings;
                var zipcodeDataSet = request.RequestContext.Runtime.Execute <EntityDataServiceResponse <ZipCodeInfo> >(getZipcodeDataRequest, request.RequestContext);

                return(new GetZipCodesServiceResponse(zipcodeDataSet.PagedEntityCollection));
            }