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