public static ObservableCollection <Vol> SelectVols() { ObservableCollection <Vol> Vols = new ObservableCollection <Vol>(); bdd.OpenConnection(); string query = "SELECT * FROM vol;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Vol Vol = new Vol(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3), reader.GetDateTime(4)); Vols.Add(Vol); } reader.Close(); bdd.CloseConnection(); return(Vols); }
public static ObservableCollection <Ville> SelectVilles() { ObservableCollection <Ville> villes = new ObservableCollection <Ville>(); bdd.OpenConnection(); string query = "SELECT * FROM ville;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Ville ville = new Ville(reader.GetInt32(0), reader.GetString(1), reader.GetString(2)); villes.Add(ville); } reader.Close(); bdd.CloseConnection(); return(villes); }
public static ObservableCollection <Classe> SelectClasses() { ObservableCollection <Classe> Classes = new ObservableCollection <Classe>(); bdd.OpenConnection(); string query = "SELECT * FROM classe;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Classe Classe = new Classe(reader.GetInt32(0), reader.GetString(1)); Classes.Add(Classe); } reader.Close(); bdd.CloseConnection(); return(Classes); }
public static ObservableCollection <Aeroport> SelectAeroports() { ObservableCollection <Aeroport> aeroports = new ObservableCollection <Aeroport>(); bdd.OpenConnection(); string query = "SELECT * FROM aeroport;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Aeroport aeroport = new Aeroport(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3)); aeroports.Add(aeroport); } reader.Close(); bdd.CloseConnection(); return(aeroports); }
public static ObservableCollection <Avion> SelectAvions() { ObservableCollection <Avion> avions = new ObservableCollection <Avion>(); bdd.OpenConnection(); string query = "SELECT * FROM avion;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Avion avion = new Avion(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetFloat(3), reader.GetString(4), reader.GetString(5), reader.GetInt32(6)); avions.Add(avion); } reader.Close(); bdd.CloseConnection(); return(avions); }
public static Employe GetEmploye(string mail, string mdp) { bdd.OpenConnection(); string query = "SELECT * FROM employe WHERE mail = @mail;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.Parameters.AddWithValue("@mail", mail); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); Employe employe = null; if (reader.HasRows) { if (BCrypt.Net.BCrypt.Verify(mdp, reader.GetString(4))) { employe = new Employe(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetBoolean(5), reader.GetString(6)); } } reader.Close(); bdd.CloseConnection(); return(employe); }
public static ObservableCollection <Maintenance> SelectMaintenances() { ObservableCollection <Maintenance> Maintenances = new ObservableCollection <Maintenance>(); bdd.OpenConnection(); string query = "SELECT * FROM maintenance;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Maintenance Maintenance = new Maintenance(reader.GetInt32(0), reader.GetInt32(1), reader.GetDateTime(2), reader.GetInt32(3), reader.GetString(4), reader.GetInt32(5)); Maintenances.Add(Maintenance); } reader.Close(); bdd.CloseConnection(); return(Maintenances); }
public static ObservableCollection <Tarif> SelectTarifs() { ObservableCollection <Tarif> Tarifs = new ObservableCollection <Tarif>(); bdd.OpenConnection(); string query = "SELECT * FROM tarif;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Tarif Tarif = new Tarif(reader.GetInt32(0), reader.GetInt32(1), reader.GetString(2)); Tarifs.Add(Tarif); } reader.Close(); bdd.CloseConnection(); return(Tarifs); }
public static ObservableCollection <Client> SelectClients() { ObservableCollection <Client> clients = new ObservableCollection <Client>(); bdd.OpenConnection(); string query = "SELECT * FROM client;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Client client = new Client(reader.GetInt32(0), reader.GetString(1), reader.GetBoolean(2), reader.GetInt32(3), reader.GetString(4), reader.GetString(5), reader.GetString(6)); clients.Add(client); } reader.Close(); bdd.CloseConnection(); return(clients); }
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); }
public static ObservableCollection <Billet> SelectBillets() { ObservableCollection <Billet> Billets = new ObservableCollection <Billet>(); bdd.OpenConnection(); string query = "SELECT * FROM billet;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Billet Billet = new Billet(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3)); Billets.Add(Billet); } reader.Close(); bdd.CloseConnection(); return(Billets); }
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); }