private void Nouveau_vol_click(object sender, RoutedEventArgs e)
        {
            DateTime depart;
            DateTime arrivee;

            if ((DateTime.TryParse(Depart.Text, out depart)) && (DateTime.TryParse(Arrivee.Text, out arrivee)))
            {
                DAL_Vol.AjouterVol(DAL_Trajet.FindByStrTrajet(Trajet.Text).Id, DAL_Avion.FindByMatricule(Avion.Text).Id, depart, arrivee);
                AfficherVol();
            }
        }
 public void AfficherVol()
 {
     ListeVols                 = new ObservableCollection <Vol>();
     ListeVols                 = DAL_Vol.SelectVols();
     this.grid.ItemsSource     = ListeVols;
     this.trajet.ItemsSource   = DAL_Trajet.SelectStrTrajets();
     this.avion.ItemsSource    = DAL_Avion.SelectMatriculeAvions();
     this.Trajet.ItemsSource   = DAL_Trajet.SelectStrTrajets();
     this.Trajet.SelectedValue = DAL_Trajet.SelectStrTrajets().First();
     this.Avion.ItemsSource    = DAL_Avion.SelectMatriculeAvions();
     this.Avion.SelectedValue  = DAL_Avion.SelectMatriculeAvions().First();
 }
        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;
                    ComboBox co         = e.EditingElement as ComboBox;
                    Vol      Vol        = DAL_Vol.GetVol(IdVol);

                    switch (column_nom)
                    {
                    case "Trajet":
                        Vol.StrTrajet = co.Text;
                        Vol.Trajet    = DAL_Trajet.FindByStrTrajet(co.Text).Id;
                        break;

                    case "Avion":
                        Vol.Avion = co.Text;
                        break;

                    case "Départ":
                        DateTime depart;
                        if (!DateTime.TryParse(el.Text, out depart))
                        {
                            depart = Vol.Depart;
                        }
                        Vol.Depart = depart;
                        break;

                    case "Arrivée":
                        DateTime arrivee;
                        if (!DateTime.TryParse(el.Text, out arrivee))
                        {
                            arrivee = Vol.Arrivee;
                        }
                        Vol.Arrivee = arrivee;
                        break;

                    default:
                        break;
                    }
                    DAL_Vol.ModifierVol(Vol.Id, Vol.Trajet, DAL_Avion.FindByMatricule(Vol.Avion).Id, Vol.Depart, Vol.Arrivee);
                }
            }
        }
 private void Supp_vol_click(object sender, RoutedEventArgs e)
 {
     DAL_Vol.SupprimerVol(IdVol);
     AfficherVol();
 }