public static COMN_City GetCOMN_CountryByCountryID(int CountryID)
{
COMN_City cOMN_City = new COMN_City();
SqlCOMN_CityProvider sqlCOMN_CityProvider = new SqlCOMN_CityProvider();
cOMN_City = sqlCOMN_CityProvider.GetCOMN_CityByCountryID(CountryID);
return cOMN_City;
}