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