コード例 #1
0
ファイル: PatientData.cs プロジェクト: slove3000/Maze_Circuit
        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();
                }
            }
        }
コード例 #2
0
        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());
        }