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