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