public static void insertEtudeHasPlage(EtudeHasPlageDAO e) { string query = "INSERT INTO etude_has_Plage VALUES (\"" + e.Etude_idEtudeDAO + "\",\"" + e.Plage_idPlageDAO + "\",\"" + e.Zone_idZoneDAO + "\",\"" + e.name_concatenationDAO + "\");"; MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2); cmd2.ExecuteNonQuery(); }
public static void updateEtudeHasPlage(EtudeHasPlageDAO e) { string query = "UPDATE etude_has_Plage SET name_concatenation =" + e.name_concatenationDAO + " WHERE Etude_idEtude =" + e.Etude_idEtudeDAO + " AND Plage_idPlage =" + e.Plage_idPlageDAO + " AND zoneprelevement_idZonePrelevement =" + e.Zone_idZoneDAO + ";"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); }
public static EtudeHasPlageViewModel getEtudeHasPlage(int idEtude, int idPlage, int idZone) { EtudeHasPlageDAO eDAO = EtudeHasPlageDAO.getEtudeHasPlage(idEtude, idPlage, idZone); int Etude_idEtude = eDAO.Etude_idEtudeDAO; EtudeViewModel et = EtudeORM.getEtude(Etude_idEtude); int Plage_idPlage = eDAO.Plage_idPlageDAO; PlageViewModel p = PlageORM.getPlage(Plage_idPlage); int Zone_idZone = eDAO.Zone_idZoneDAO; ZoneViewModel z = ZoneORM.getZone(Zone_idZone); EtudeHasPlageViewModel ep = new EtudeHasPlageViewModel(et, p, z, eDAO.name_concatenationDAO); return(ep); }
public static ObservableCollection <EtudeHasPlageDAO> selectEtudeHasPlages() { ObservableCollection <EtudeHasPlageDAO> l = new ObservableCollection <EtudeHasPlageDAO>(); string query = "SELECT * FROM etude_has_Plage;"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { EtudeHasPlageDAO u = new EtudeHasPlageDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3)); l.Add(u); } reader.Close(); return(l); }
public static ObservableCollection <EtudeHasPlageViewModel> listeEtudeHasPlages() { ObservableCollection <EtudeHasPlageDAO> lDAO = EtudeHasPlageDAO.listeEtudeHasPlages(); ObservableCollection <EtudeHasPlageViewModel> l = new ObservableCollection <EtudeHasPlageViewModel>(); foreach (EtudeHasPlageDAO element in lDAO) { int Etude_idEtude = element.Etude_idEtudeDAO; EtudeViewModel et = EtudeORM.getEtude(Etude_idEtude); int Plage_idPlage = element.Plage_idPlageDAO; PlageViewModel p = PlageORM.getPlage(Plage_idPlage); int Zone_idZone = element.Zone_idZoneDAO; ZoneViewModel z = ZoneORM.getZone(Zone_idZone); EtudeHasPlageViewModel ep = new EtudeHasPlageViewModel(et, p, z, element.name_concatenationDAO); l.Add(ep); } return(l); }
public static EtudeHasPlageDAO getEtudeHasPlage(int idEtude, int idPlage, int idZone) { string query = "SELECT * FROM etude_has_Plage WHERE Etude_idEtude=" + idEtude + " and plage_idPlage=" + idPlage + " and zoneprelevement_idZonePrelevement=" + idZone + ";"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); EtudeHasPlageDAO etude; if (reader.HasRows) { etude = new EtudeHasPlageDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3)); } else { etude = new EtudeHasPlageDAO(1, 1, 1, "Pas de nom"); } reader.Close(); return(etude); }
public static void insertEtudeHasPlage(EtudeHasPlageViewModel ep) { EtudeHasPlageDAO.insertEtudeHasPlage(new EtudeHasPlageDAO(ep.Etude_EtudeHasPlageProperty.idEtudeProperty, ep.Plage_EtudeHasPlageProperty.idPlageProperty, ep.Zone_EtudeHasPlageProperty.idZonePrelevementProperty, ep.name_concatenationProperty)); }
public static void supprimerEtudeHasPlage(int idEtude, int idPlage, int idZone) { EtudeHasPlageDAO.supprimerEtudeHasPlage(idEtude, idPlage, idZone); }