public static TarifVol GetTarifVol(int id) { bdd.OpenConnection(); string query = "SELECT * FROM tarif_vol WHERE id = @id;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); TarifVol TarifVol = new TarifVol(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetFloat(3)); reader.Close(); bdd.CloseConnection(); return(TarifVol); }
private void Edit(object sender, DataGridCellEditEndingEventArgs e) { if (e.EditAction == DataGridEditAction.Commit) { DataGridColumn column = e.Column; if (column != null) { string column_nom = (string)column.Header; TextBox el = e.EditingElement as TextBox; TarifVol TarifVol = DAL_TarifVol.GetTarifVol(IdTarifVol); int value; switch (column_nom) { case "Tarif": if (!int.TryParse(el.Text, out value)) { value = TarifVol.Tarif; } TarifVol.Tarif = value; break; case "Vol": if (!int.TryParse(el.Text, out value)) { value = TarifVol.Vol; } TarifVol.Vol = value; break; case "Prix": float prix; if (!float.TryParse(el.Text, out prix)) { prix = TarifVol.Prix; } TarifVol.Prix = prix; break; default: break; } DAL_TarifVol.ModifierTarifVol(TarifVol.Id, TarifVol.Tarif, TarifVol.Vol, TarifVol.Prix); } } }
public static ObservableCollection <TarifVol> SelectTarifVols() { ObservableCollection <TarifVol> TarifVols = new ObservableCollection <TarifVol>(); bdd.OpenConnection(); string query = "SELECT * FROM tarif_vol;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { TarifVol TarifVol = new TarifVol(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetFloat(3)); TarifVols.Add(TarifVol); } reader.Close(); bdd.CloseConnection(); return(TarifVols); }