Exemple #1
0
        public static Trajet GetTrajet(int id)
        {
            bdd.OpenConnection();
            string       query = "SELECT * FROM trajet WHERE id = @id;";
            MySqlCommand cmd   = new MySqlCommand(query, bdd.GetConnection());

            cmd.Parameters.AddWithValue("@id", id);
            cmd.ExecuteNonQuery();
            MySqlDataReader reader = cmd.ExecuteReader();

            reader.Read();
            Trajet trajet = new Trajet(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3), reader.GetFloat(4), reader.GetString(5));

            reader.Close();
            bdd.CloseConnection();
            return(trajet);
        }
Exemple #2
0
        public static List <string> SelectStrTrajets()
        {
            List <string> trajets = new List <string>();

            bdd.OpenConnection();
            string       query = "SELECT * FROM trajet;";
            MySqlCommand cmd   = new MySqlCommand(query, bdd.GetConnection());

            cmd.ExecuteNonQuery();
            MySqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                Trajet trajet = new Trajet(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3), reader.GetFloat(4), reader.GetString(5));
                trajets.Add(trajet.Depart + " - " + trajet.Arrivee);
            }
            reader.Close();
            bdd.CloseConnection();
            return(trajets);
        }
Exemple #3
0
        public static ObservableCollection <Trajet> SelectTrajets()
        {
            ObservableCollection <Trajet> trajets = new ObservableCollection <Trajet>();

            bdd.OpenConnection();
            string       query = "SELECT * FROM trajet;";
            MySqlCommand cmd   = new MySqlCommand(query, bdd.GetConnection());

            cmd.ExecuteNonQuery();
            MySqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                Trajet trajet = new Trajet(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3), reader.GetFloat(4), reader.GetString(5));
                trajets.Add(trajet);
            }
            reader.Close();
            bdd.CloseConnection();
            return(trajets);
        }
        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;
                    Trajet   trajet     = DAL_Trajet.GetTrajet(IdTrajet);

                    switch (column_nom)
                    {
                    case "Durée":
                        trajet.Duree = el.Text;
                        break;

                    case "Référence":
                        trajet.Reference = el.Text;
                        break;

                    case "Distance":
                        trajet.Distance = float.Parse(el.Text);
                        break;

                    case "Départ":
                        trajet.Depart = (string)co.SelectionBoxItem;
                        break;

                    case "Arrivée":
                        trajet.Arrivee = (string)co.SelectionBoxItem;
                        break;

                    default:
                        break;
                    }
                    DAL_Trajet.ModifierTrajet(trajet.Id, trajet.Duree, trajet.Reference, trajet.Distance, DAL_Aeroport.FindByName(trajet.Depart).Id, DAL_Aeroport.FindByName(trajet.Arrivee).Id);
                }
            }
        }