public static void updateAvion(Avion a)
{
connection.Open();
string query = "UPDATE avions SET modele=\"" + a.ModelAvionProperty + "\",motorisation=\"" + a.MotorisationProperty + "\",capacite=\"" + a.CapaciteProperty + "\",nb_place_premium=\"" + a.NbrPremiumProperty + "\",nb_place_business=\"" + a.NbrBusinessProperty + "\",nb_place_eco=\"" + a.NbrEcoProperty + "\",etat=\"" + a.EtatAvionProperty + "\",type=\"" + a.TypeProperty + "\" WHERE idAvion=" + a.idProperty + "";
MySqlCommand cmd = new MySqlCommand(query, connection);
//MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
connection.Close();
}
public void SelectAvion(ObservableCollection <Avion> l)
{
connection.Close();
connection.Open();
string query = "SELECT * FROM avions";
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Avion a = new Avion(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetInt32(8));
l.Add(a);
}
reader.Close();
connection.Close();
}
