public static void addPersonne(DAOPersonne personne)
{
string query = "INSERT INTO personne VALUES (\"" + personne.idPersonneDAO + "\",\"" + personne.NomDAO + "\",\"" + personne.PrénomDAO + "\",\"" + personne.AdminBénévoleDAO + "\");";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static void addPlage(DAOPlage plage)
{
string query = "INSERT INTO plage VALUES (\"" + plage.idPlageDAO + "\",\"" + plage.NomDAO + "\",\"" + plage.CommuneDAO + "\",\"" + plage.DépartementDAO + "\",\"" + plage.SuperficieDAO + "\");";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static void addZone(DAOZonePrelevement zone)
{
string query = "INSERT INTO zoneprélèvement VALUES (\"" + zone.idZoneDAO + "\",\"" + zone.idEtudeDAO + "\",\"" + zone.idPlageDAO + "\",\"" + zone.Angle1DAO + "\",\"" + zone.Angle2DAO + "\",\"" + zone.Angle3DAO + "\",\"" + zone.Angle3DAO + "\",\"" + zone.idPersonneDAO + "\");";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static void deletePersonne(int id)
{
string query = "DELETE FROM personne WHERE idPersonne = " + id + ";";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static void updatePersonne(DAOPersonne personne)
{
string query = "UPDATE personne SET Nom=" + personne.NomDAO + ", Prénom=" + personne.PrénomDAO + ", AdminBénévole=" + personne.AdminBénévoleDAO + ";";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static void addEtude(DAOEtude etude)
{
string query = "INSERT INTO etude VALUES (\"" + etude.idEtudeDAO + "\",\"" + etude.nomEtudeDAO + "\",\"" + etude.dateDAO + "\",\"" + etude.idPersonneDAO + "\");";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static void updatePlage(DAOPlage plage)
{
string query = "UPDATE personne SET Nom=" + plage.NomDAO + ", Commune=" + plage.CommuneDAO + ", Département=" + plage.DépartementDAO + ", Superficie=" + plage.SuperficieDAO + ";";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static void addEspèce(DAOEspèce espèce)
{
string query = "INSERT INTO espèce VALUES (" + espèce.NomDAO + ");";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static void addZone(DAOZoneEspece zone)
{
string query = "INSERT INTO zoneespèce VALUES (\"" + zone.idZoneEDAO + "\",\"" + zone.IdEspeceDAO + "\",\"" + zone.IdZoneDAO + "\",\"" + zone.IdEtudeDAO + "\",\"" + zone.IdPlageDAO + "\",\"" + zone.NombreDAO + "\");";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static DAOEtude getEtude(int id)
{
string query = "SELECT * FROM etude WHERE idEtude = " + id + ";";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
command.ExecuteNonQuery();
MySqlDataReader reader = command.ExecuteReader();
reader.Read();
DAOEtude etude = new DAOEtude(reader.GetInt32(0), reader.GetString(1), reader.GetDateTime(2), reader.GetInt32(3));
reader.Close();
return(etude);
}
public static int getMaxIdlage()
{
string query = "SELECT MAX(idPlage) FROM plage;";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
command.ExecuteNonQuery();
MySqlDataReader reader = command.ExecuteReader();
reader.Read();
int maxIdPlage = reader.GetInt32(0);
reader.Close();
return(maxIdPlage + 1);
}
public static DAOPlage getPlage(int id)
{
string query = "SELECT * FROM plage WHERE idPlage = " + id + ";";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
command.ExecuteNonQuery();
MySqlDataReader reader = command.ExecuteReader();
reader.Read();
DAOPlage plage = new DAOPlage(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt32(4));
reader.Close();
return(plage);
}
public static DAOZonePrelevement getZone(int id)
{
string query = "SELECT * FROM zoneprélèvement WHERE idZone = " + id + ";";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
command.ExecuteNonQuery();
MySqlDataReader reader = command.ExecuteReader();
reader.Read();
DAOZonePrelevement zone = new DAOZonePrelevement(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7));
reader.Close();
return(zone);
}
public static ObservableCollection <DAOPlage> selectPlages()
{
ObservableCollection <DAOPlage> ListesPlages = new ObservableCollection <DAOPlage>();
string query = "SELECT * FROM plage;";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
try
{
command.ExecuteNonQuery();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DAOPlage plage = new DAOPlage(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt32(4));
ListesPlages.Add(plage);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show("Une erreur est survenue impossible de continuer...");
}
return(ListesPlages);
}
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 <DAOZonePrelevement> selectZones()
{
ObservableCollection <DAOZonePrelevement> listeZones = new ObservableCollection <DAOZonePrelevement>();
string query = "SELECT * FROM zoneprélèvement;";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
try
{
command.ExecuteNonQuery();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DAOZonePrelevement zone = new DAOZonePrelevement(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7));
listeZones.Add(zone);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show("Une erreur est survenue impossible de continuer...");
}
return(listeZones);
}
public DALEspèce()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALEtude()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALPersonne()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALPlage()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALZonePrelevement()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
public DALZoneEspece()
{
DALConnection.Connection();
connection = DALConnection.connection;
}
