public static List <Avion> AllAvion()
{
MySqlConnection connection = new MySqlConnection(ConnectionString);
MySqlCommand command = new MySqlCommand();
command.Connection = connection;
connection.Open();
command.CommandText = @"SELECT Identifiant, Nom, IdentifiantModele
FROM Avion;";
MySqlDataReader reader = command.ExecuteReader();
List <Avion> avions = new List <Avion>();
Avion a = null;
while (reader.Read())
{
a = new Avion();
a.Identifiant = reader.GetInt32("Identifiant");
a.IdentifiantModele = reader.GetInt32("IdentifiantModele");
a.Nom = reader.GetString("Nom");
avions.Add(a);
}
connection.Close();
return(avions);
}
public static Avion GetAvion(int id)
{
MySqlConnection connection = new MySqlConnection(ConnectionString);
MySqlCommand command = new MySqlCommand();
command.Connection = connection;
connection.Open();
command.CommandText = @"SELECT Identifiant, Nom
FROM Avion
WHERE Identifiant =" + id + ";";
command.Parameters.AddWithValue("Identifiant", id);
MySqlDataReader reader = command.ExecuteReader();
Avion a = null;
if (reader.Read())
{
a = new Avion();
a.Identifiant = reader.GetInt32("Identifiant");
a.Nom = reader.GetString("Nom");
}
connection.Close();
return(a);
}