public static ObservableCollection <DAOPersonne> selectBenevoles()
{
ObservableCollection <DAOPersonne> ListeBene = new ObservableCollection <DAOPersonne>();
string query = "SELECT * FROM personne WHERE AdminBénévole = 1;";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
try
{
command.ExecuteNonQuery();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DAOPersonne bene = new DAOPersonne(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3));
ListeBene.Add(bene);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show("Une erreur est survenue impossible de continuer...");
}
return(ListeBene);
}
public static ObservableCollection <DAOEtude> selectEtudes()
{
ObservableCollection <DAOEtude> listeEtudes = new ObservableCollection <DAOEtude>();
string query = "SELECT * FROM etude;";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
try
{
command.ExecuteNonQuery();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DAOEtude etude = new DAOEtude(reader.GetInt32(0), reader.GetString(1), reader.GetDateTime(2), reader.GetInt32(3));
listeEtudes.Add(etude);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show("Une erreur est survenue impossible de continuer...");
}
return(listeEtudes);
}
public DALPlage()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALZonePrelevement()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALZoneEspece()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALPersonne()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALEtude()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALEspèce()
{
DALConnection.Connection();
connection = DALConnection.connection;
}