public static void SupPatient(string nom, string prenom, DateTime dateNaissance) { //permet au TU de donner la fausse BD if (conn == null) { context = new ReaPlanDBEntities(); string dossier = "Files/Patients/" + nom + prenom + dateNaissance.ToShortDateString().ToString().Replace("/", string.Empty); if (Directory.Exists(dossier)) { DirectoryInfo directory = new DirectoryInfo(dossier); directory.Delete(true); } } else { context = new ReaPlanDBEntities(conn); } using (context) { var requete = from c in context.PatientDBs where c.Nom == nom && c.Prenom == prenom && c.DateNaissance == dateNaissance select c; var patient = requete.FirstOrDefault(); var requeteEx = from c in context.ExerciceDBs where c.IdPatient == patient.IdPatient select c; //requeteEx.ToList().ForEach((ExerciceDB ex) => // { // var requeteParamEx = from c in context.ParametreExDBs // where c.IdExercice == ex.IdExercice // select c; // requeteParamEx.ToList().ForEach((ParametreExDB ParamEx) => // { // context.DeleteObject(ParamEx); // context.SaveChanges(); // }); // context.DeleteObject(ex); // context.SaveChanges(); // }); if (patient != null) { context.DeleteObject(patient); context.SaveChanges(); } } }
public void Admin_Pas_Dans_La_Bd() { var requete = from c in context.TherapeuteDBs where c.Administrateur == true select c; var admin = requete.FirstOrDefault(); context.DeleteObject(admin); context.SaveChanges(); Assert.IsFalse(AdminData.AdminInBd()); }