public void UpdateAvion(ViewModel.AvionBinder a) { ConnectionBdd bdd = new ConnectionBdd(); MySqlConnection connection = bdd.getConnection(); MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "UPDATE avion SET `matricule`=@matricule,`motorisation`=@motorisation,`maintenance`=@maintenance,`disponible`=@disponible,`type`=@type,`capacite`=@capacite,`premiere`=@premiere,`business`=@business,`premium`=@premium,`economique`=@economique WHERE id=@id"; cmd.Parameters.AddWithValue("@matricule", a.MatriculeProperty); cmd.Parameters.AddWithValue("@motorisation", a.MotorisationProperty); cmd.Parameters.AddWithValue("@maintenance", a.MaintenanceProperty); cmd.Parameters.AddWithValue("@disponible", a.DisponibleProperty); cmd.Parameters.AddWithValue("@type", a.TypeProperty); cmd.Parameters.AddWithValue("@capacite", a.CapaciteProperty); cmd.Parameters.AddWithValue("@premiere", a.PremiereProperty); cmd.Parameters.AddWithValue("@business", a.BusinessProperty); cmd.Parameters.AddWithValue("@premium", a.PremiumProperty); cmd.Parameters.AddWithValue("@economique", a.EconomiqueProperty); cmd.Parameters.AddWithValue("@id", a.IdProperty); //cmd.Parameters.AddWithValue("@id", a.IdProperty); // MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); }
public VolBinder(int id, string dateHeureA, string dateHeureD, int annule, string lieuA, string lieuD, int nbPassager, ViewModel.AvionBinder avion) { this.IdProperty = id; this.DateHeureAProperty = dateHeureA; this.DateHeureDProperty = dateHeureD; this.AnnuleProperty = annule; this.LieuAProperty = lieuA; this.LieuDProperty = lieuD; this.NbPassagerProperty = nbPassager; this.AvionProperty = avion; }
public static ViewModel.AvionBinder SelectAvion(int idavion) { ViewModel.AvionBinder unavion = null; try { ConnectionBdd bdd = new ConnectionBdd(); MySqlConnection connection = bdd.getConnection(); // Requête SQL string query = "SELECT * from avion where id=" + idavion + ""; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int Id = reader.GetInt32(0); string MatriculeProprty = reader.GetString(1); string MotorisationProperty = reader.GetString(2); int MaintenanceProperty = reader.GetInt32(3); int DisponibleProperty = reader.GetInt32(4); string TypeProperty = reader.GetString(5); int CapaciteProperty = reader.GetInt32(6); int PremiereProperty = reader.GetInt32(7); int BusinessProperty = reader.GetInt32(8); int PremiumProperty = reader.GetInt32(9); int EconomiqueProperty = reader.GetInt32(10); unavion = new ViewModel.AvionBinder(Id, MatriculeProprty, MotorisationProperty, MaintenanceProperty, DisponibleProperty, TypeProperty, CapaciteProperty, PremiereProperty, BusinessProperty, PremiumProperty, EconomiqueProperty); } //Fermeture de la connexion reader.Close(); connection.Close(); return(unavion); } catch { // Gestion des erreurs : // Possibilité de créer un Logger pour les exceptions SQL reçus // Possibilité de créer une méthode avec un booléan en retour pour savoir si le contact à été ajouté correctement. } return(unavion); }
private void Button_Click_Insert_Vol(object sender, RoutedEventArgs e) { Model.DAL.DALVol bdd = new Model.DAL.DALVol(); ViewModel.AvionBinder matricule = avion.SelectedItem as ViewModel.AvionBinder; //Convertir la date DD/MM/YYYY en YYYY-MM-DD string sdateD = dateD.Text; string[] depart = sdateD.Split('/'); string dayD = depart[0]; string monthD = depart[1]; string yearD = depart[2]; string dateDepart = yearD + "-" + monthD + "-" + dayD; string sdateA = dateA.Text; string[] arrivee = sdateA.Split('/'); string dayA = arrivee[0]; string monthA = arrivee[1]; string yearA = arrivee[2]; string dateArrivee = yearA + "-" + monthA + "-" + dayA; DigitalTime a = heureA.Time; int ha = a.Hour; int ma = a.Minute; string dateHeureA = dateArrivee + " " + ha + ":" + ma; DigitalTime d = heureD.Time; int hd = d.Hour; int md = d.Minute; string dateHeureD = dateDepart + " " + hd + ":" + md; bdd.AddVol(dateHeureA, dateHeureD, lieuA.Text, lieuD.Text, Convert.ToInt32(nbPassager.Text), matricule.IdProperty); lieuA.Clear(); lieuD.Clear(); nbPassager.Clear(); }