public static CitiesList GetCitiesListByCountry(int CountryID)
{
CitiesList cl = new CitiesList();
Config cfg = new Config();
OdbcConnection cn = new OdbcConnection();
cn.ConnectionString = cfg.ConnectionString;
OdbcCommand cm = cn.CreateCommand();
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "{ CALL RefSelectCitiesListByID (?)}";
cm.Parameters.Add(new OdbcParameter("CountryID", CountryID));
try
{
cn.Open();
OdbcDataReader dr = cm.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
City qq = new City();
qq.CityID = (int)dr["city_id"];
qq.CityName = dr["city_name"].ToString();
cl.Add(qq);
}
}
catch (OdbcException ex)
{
throw ex;
}
return(cl);
}
public static CitiesList GetDefaultCitiesList()
{
CitiesList cList = new CitiesList();
Config config = new Config();
OdbcConnection cn = new OdbcConnection();
cn.ConnectionString = config.ConnectionString;
cn.Open();
OdbcCommand cm = cn.CreateCommand();
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "SelectCitiesList";
OdbcDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
City info = new City();
info.CityID = Convert.ToInt32(dr["city_id"]);
info.CountryID = (int)dr["city_cntr_id_FK"];
info.CityName = dr["city_name"].ToString();
info.CitySignGMT = dr["city_signGMT"].ToString();
info.CityGMT = Convert.ToDateTime(dr["city_GMT"]);
cList.Add(info);
}
cn.Close();
cn.Dispose();
return(cList);
}
