public List <City> GetCities()
{
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT cities.* FROM flights
JOIN cities_flights ON (flights.id = cities_flights.flight_id)
JOIN cities ON (cities_flights.city_id = cities.id)
WHERE flights.id = @FlightId;";
MySqlParameter flightIdParameter = new MySqlParameter();
flightIdParameter.ParameterName = "@FlightId";
flightIdParameter.Value = _id;
cmd.Parameters.Add(flightIdParameter);
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
List <City> cities = new List <City> {
};
while (rdr.Read())
{
int cityId = rdr.GetInt32(0);
string cityName = rdr.GetString(1);
City newCity = new City(cityName, cityId);
cities.Add(newCity);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(cities);
}
