public CountryRegionCollection GetCountryRegions(string CountryCode) { var result = new CountryRegionCollection(); var data = GetContext().GetSet(@" SELECT CountryCode, CountryDescription FROM Countries SELECT RegionCode, RegionDescription FROM CountryRegions WHERE CountryCode = {0} ", CountryCode); if (data == null) { return(null); } // Assemble the countries var countriesData = data.Tables[0]; foreach (DataRow row in countriesData.Rows) { result.Countries.Add(new Country() { CountryCode = row["CountryCode"].ToString(), CountryName = row["CountryDescription"].ToString() }); } // Assemble the regions var regionsData = data.Tables[1]; foreach (DataRow row in regionsData.Rows) { result.Regions.Add(new Region() { RegionCode = row["RegionCode"].ToString(), RegionName = row["RegionDescription"].ToString() }); } return(result); }
public CountryRegionCollection GetCountryRegions(string CountryCode) { var result = new CountryRegionCollection(); var response = GetContext().GetCountryRegions(new GetCountryRegionsRequest() { CountryCode = CountryCode }); if(response == null) return null; result.Countries = response.Countries.ToList() .Select(c => new Country() { CountryCode = c.CountryCode, CountryName = c.CountryName }).ToList(); result.Regions = response.Regions.ToList() .Select(c => new Region() { RegionCode = c.RegionCode, RegionName = c.RegionName }).ToList(); return result; }
public CountryRegionCollection GetCountryRegions(string CountryCode) { var result = new CountryRegionCollection(); var data = GetContext().GetSet(@" SELECT CountryCode, CountryDescription FROM Countries SELECT RegionCode, RegionDescription FROM CountryRegions WHERE CountryCode = {0} ", CountryCode); if(data == null) return null; // Assemble the countries var countriesData = data.Tables[0]; foreach (DataRow row in countriesData.Rows) { result.Countries.Add(new Country() { CountryCode = row["CountryCode"].ToString(), CountryName = row["CountryDescription"].ToString() }); } // Assemble the regions var regionsData = data.Tables[1]; foreach (DataRow row in regionsData.Rows) { result.Regions.Add(new Region() { RegionCode = row["RegionCode"].ToString(), RegionName = row["RegionDescription"].ToString() }); } return result; }