public static void updatePlage(PlageDAO p) { string query = "UPDATE plage set nom=\"" + p.nomDAO + "\", Ville_idVille=\"" + p.Ville_idVilleDAO + "\", Departement_idDepartement=\"" + p.prelevement_idprelevementDAO + "\",prelevement_idprelevement=\"" + p.Departement_idDepartementDAO + "\" where idPlage=" + p.idPlageDAO + ";"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection()); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); }
public static void insertPlage(PlageDAO p) { int id = getMaxIdPlage() + 1; string query = "INSERT INTO plage VALUES (\"" + id + "\",\"" + p.nomDAO + "\", Ville_idVille=\"" + p.Ville_idVilleDAO + "\", Departement_idDepartement=\"" + p.prelevement_idprelevementDAO + "\",prelevement_idprelevement=\"" + p.Departement_idDepartementDAO + "\");"; MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.OpenConnection()); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2); cmd2.ExecuteNonQuery(); }
private void OnPropertyChanged(string info) { PropertyChangedEventHandler handler = PropertyChanged; if (handler != null) { handler(this, new PropertyChangedEventArgs(info)); PlageDAO.updatePlage(this); } }
public static PlageDAO getPlage(int idPlage) { string query = "SELECT * FROM plage WHERE id=" + idPlage + ";"; MySqlCommand cmd = new MySqlCommand(query, connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); PlageDAO pers = new PlageDAO(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetInt32(4)); reader.Close(); return(pers); }
public static ObservableCollection <PlageDAO> selectPlages() { ObservableCollection <PlageDAO> l = new ObservableCollection <PlageDAO>(); string query = "SELECT * FROM Plage;"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection()); try { cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { PlageDAO p = new PlageDAO(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetInt32(4)); l.Add(p); } reader.Close(); } catch (Exception e) { MessageBox.Show("La base de données n'est pas connectée"); } return(l); }
public static PlageDAO getPlage(int idPlage) { PlageDAO p = PlageDAL.getPlage(idPlage); return(p); }