public static void updatePlageEtude(LienPlageEtudeDAO p)
{
string query = "UPDATE personne set Plage_idPlage=\"" + p.idplage + "\", Etude_idEtude=\"" + p.idetude + "\";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertPlageEtudeDAO(LienPlageEtudeDAO p)
{
int id = getMaxIdLienPlageEtude() + 1;
string query = "INSERT INTO personne VALUES (\"" + id + "\",\"" + p.idplage + "\"" + p.idetude + "\";";
MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static LienPlageEtudeDAO getLienPlageEtude(int idLienPlageEtude)
{
string query = "SELECT * FROM personne WHERE id=" + idLienPlageEtude + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
LienPlageEtudeDAO pers = new LienPlageEtudeDAO(reader.GetInt32(0), reader.GetInt32(1));
reader.Close();
return(pers);
}
public static ObservableCollection <LienPlageEtudeDAO> selectPlageEtude()
{
ObservableCollection <LienPlageEtudeDAO> l = new ObservableCollection <LienPlageEtudeDAO>();
string query = "SELECT * FROM LienPlageEtude;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
LienPlageEtudeDAO p = new LienPlageEtudeDAO(reader.GetInt32(0), reader.GetInt32(1));
l.Add(p);
}
reader.Close();
return(l);
}
