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);
}
