// ajoute une collection d'atelier a un participant pour la table participer : plusieurs nouvelles occurences possible public void dbAjoutAtelier(Benevoles unBenevole, List <Atelier> lesAteliers) { // ne va servir que lors de la creation d'un nouveau benevoles dans la bdd // va update l'id pour qu'il colle a celui en bdd puis va unBenevole.updateID(); DAOFactory db = new DAOFactory(); db.connecter(); String req; int i = 0; while (lesAteliers.Count > i) { Atelier unA = lesAteliers[i]; req = "insert into participer values ( '" + unBenevole.Id + "' , '" + unA.Id + "' ); " + " insert into intervention values ( " + " ' " + unBenevole.Email + " ' , " + unA.Id + " ) ; " ; db.execSQLWrite(req); i++; } req = " insert into intervenir values ( " + " '" + unBenevole.Email + " ' , " + unBenevole.Id + " ) ; "; db.execSQLWrite(req); }
// recree les occurences de la table participer en bdd pour correspondre au derniere modification. public void executeParticipe(Benevoles unB, String exMail = null) { Atelier unA; DAOFactory db = new DAOFactory(); db.connecter(); // on detruire les occurences String req = "Delete From participer where id = " + unB.Id + " ;" + " delete From intervenir " + " where email ='" + exMail + "' ;" + " delete From intervention " + "where email ='" + exMail + "' ;" ; db.execSQLWrite(req); int i = 0; // on les recrees grace a une boucle while (i < unB.LesAtelier.Count) { unA = unB.LesAtelier.ElementAt(i); req = "insert into participer values (" + unB.Id + ", " + unA.Id + ") ;" + " insert into intervention values ( " + " '" + unB.Email + " ' , " + unA.Id + " ) ; " ; i++; db.execSQLWrite(req); } req = " insert into intervenir values ( " + " '" + unB.Email + " ' , " + unB.Id + " ) ; "; db.execSQLWrite(req); }
public void executeSQLmodifAtelier(Atelier unAtelier) { String req = "update atelier set " + " nom = '" + unAtelier.Nom + "' , " + "capacite = " + unAtelier.Capacite + " where id = " + unAtelier.Id + " ;"; DAOFactory db = new DAOFactory(); db.connecter(); db.execSQLWrite(req); }
// recree les occurences de la table participer en bdd pour correspondre au derniere modification. public void executeParticipe(Participant unP, String exMail = null) { Atelier unA; DAOFactory db = new DAOFactory(); db.connecter(); String req = "Delete From participer where id = " + unP.Id + " ;"; db.execSQLWrite(req); int i = 0; while (i < unP.LesAtelier.Count) { unA = unP.LesAtelier.ElementAt(i); req = "insert into participer values (" + unP.Id + ", " + unA.Id + ") ;"; i++; db.execSQLWrite(req); } }
// modifie un participant en bdd public void executeSQLmodifInscription(Participant unParticipant) { String req = "update participants set " + " nom = '" + unParticipant.Nom + "' , " + "prenom = '" + unParticipant.Prenom + "' , " + "adresse = '" + unParticipant.Adresse + "' , " + "portable = '" + unParticipant.Portable + "' , " + "type = '" + unParticipant.Type + "' , " + "nombre_Participation = " + unParticipant.NbParticipant + "where id = " + unParticipant.Id + " ;"; DAOFactory db = new DAOFactory(); db.connecter(); db.execSQLWrite(req); }
} // fin getAllParticipant() #region execution BDD inscription // inscript un participant en BDD public void executeSQLinscription(Participant unParticipant) { String req = "insert into participants values ( '" + unParticipant.Nom + "' , '" + unParticipant.Prenom + "' , '" + unParticipant.Adresse + "' , '" + unParticipant.Portable + "' , '" + unParticipant.Type + "' , '" + unParticipant.NbParticipant + "' );"; // req = "insert into participants ( nom, prenom, adresse, portable, type, nombre_Participation) values ( 'aze' , 'aze', 'az', 'aze', 'truc', 1);"; DAOFactory db = new DAOFactory(); db.connecter(); db.execSQLWrite(req); }
// inscript un Benevole en BDD public void executeSQLinscription(Benevoles unParticipant) { String req = "insert into participants values ( '" + unParticipant.Nom + "' , '" + unParticipant.Prenom + "' , '" + unParticipant.Adresse + "' , '" + unParticipant.Portable + "' , '" + unParticipant.Type + "' , " + unParticipant.NbParticipant + " );" + "insert into intervention values ('" + unParticipant.Email + "' , " + 1 + ") ;" + "insert into intervenir values ('" + unParticipant.Email + "', " + unParticipant.Id + ") ;"; DAOFactory db = new DAOFactory(); db.connecter(); db.execSQLWrite(req); }
// ajoute une collection d'atelier a un participant pour la table participer : plusieurs nouvelles occurences possible public void dbAjoutAtelier(Participant unParticipant, List <Atelier> lesAteliers) { unParticipant.updateID(); DAOFactory db = new DAOFactory(); db.connecter(); int i = 0; while (lesAteliers.Count > i) { Atelier unA = lesAteliers[i]; String req = "insert into participer values ( '" + unParticipant.Id + "' , '" + unA.Id + "' ); "; db.execSQLWrite(req); i++; } }