public void SelectAeroports(ObservableCollection <Aeroport> l)
{
connection.Close();
connection.Open();
string query = "SELECT * FROM aeroport";
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Aeroport a = new Aeroport(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3));
l.Add(a);
}
reader.Close();
connection.Close();
}
public Aeroport ChooseAeroport(int id)
{
connection.Close();
connection.Open();
string query = "SELECT * FROM aeroport where idAeroport = @id";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.Parameters.AddWithValue("@id", id);
MySqlDataReader reader = cmd.ExecuteReader();
Aeroport b = new Aeroport();
if (reader.Read())
{
b = new Aeroport(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3));
}
reader.Close();
return(b);
}