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 static void InscriptionTherapeute(string nom, string prenom, string login, string pass, bool isAdmin) { //permet au TU de donner la fausse BD if (conn == null) { bdd = new ReaPlanDBEntities(); } else { bdd = new ReaPlanDBEntities(conn); } nom = nom.ToUpper(); using (bdd) { //Cryptage du mot de passe if (pass != null) { string passwordTmp = login.ToLower() + pass; UTF8Encoding textConverter = new UTF8Encoding(); byte[] passBytes = textConverter.GetBytes(passwordTmp); pass = Convert.ToBase64String(new SHA384Managed().ComputeHash(passBytes)); } TherapeuteDB thera = TherapeuteDB.CreateTherapeuteDB(nom, prenom, login, pass); if (isAdmin == true) { thera.Administrateur = true; } bdd.AddToTherapeuteDBs(thera); bdd.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()); }
public void Init() { dateNaissance = DateTime.Now; EntityConnection connection = Effort.EntityConnectionFactory.CreateTransient("name=ReaPlanDBEntities"); context = new ReaPlanDBEntities(connection); //creation d'un patient test dans la fausse BD PatientDB patient = PatientDB.CreatePatientDB("pat", "paul", dateNaissance, "M", (decimal)172, (decimal)66, 123, 26); context.AddToPatientDBs(patient); context.SaveChanges(); PatientData.conn = connection; }
public void Init() { EntityConnection connection = Effort.EntityConnectionFactory.CreateTransient("name=ReaPlanDBEntities"); context = new ReaPlanDBEntities(connection); //creation d'un faux therapeute adminstrateur pass = "******";// = admin thera = TherapeuteDB.CreateTherapeuteDB("pedro", "drope", "admin", pass); thera.Administrateur = true; context.AddToTherapeuteDBs(thera); //creation d'un faux therapeute non adminstrateur pass = "******";// = 123456 thera = TherapeuteDB.CreateTherapeuteDB("jacko", "michel", "jackmich", pass); thera.Administrateur = false; context.AddToTherapeuteDBs(thera); context.SaveChanges(); AdminData.conn = connection; }
public static void AjoutPartieDataBaseJeu(ExerciceBaseConfig config) { Singleton singlePatient = Singleton.getInstance(); string dossier = singlePatient.Patient.Nom + singlePatient.Patient.Prenom + singlePatient.Patient.DateDeNaissance.ToString().Replace("/", string.Empty); ExerciceReeducation exo = new ExerciceReeducation(); exo.CalculerMoyenneEtCV(dossier); using (ReaPlanDBEntities bdd = new ReaPlanDBEntities()) { var requete = from c in bdd.JeuDBs where c.NomJeu == "MvtsComplexes" select c; var jeuBD = requete.FirstOrDefault(); var requeteP = from c in bdd.PatientDBs where c.Nom == singlePatient.PatientSingleton.Nom && c.Prenom == singlePatient.PatientSingleton.Prenom && c.DateNaissance == singlePatient.PatientSingleton.DateNaiss.Date select c; var patient = requeteP.FirstOrDefault(); var requeteA = from c in bdd.TherapeuteDBs where c.Nom == singlePatient.Admin.Nom && c.Prenom == singlePatient.Admin.Prenom && c.Login == singlePatient.Admin.NomUtilisateur select c; var thera = requeteA.FirstOrDefault(); ExerciceDB ex = new ExerciceDB() { Date = DateTime.Now, Heure = DateTime.Now.TimeOfDay, IdPatient = patient.IdPatient, IdUtilisateur = thera.IdUtilisateur, IdJeu = jeuBD.IdJeu }; bdd.AddToExerciceDBs(ex); bdd.SaveChanges(); //Recherche de l'id du dernier ex fait par le patient var requeteExDB = from c in bdd.ExerciceDBs select c; var exDB = requeteExDB.AsEnumerable().LastOrDefault(); //Enregistrement de la config ConfigJeuDB configJeu = new ConfigJeuDB() { IdExercice = exDB.IdExercice, RaideurLat = config.RaideurLat, RaideurLong = config.RaideurLong, Vitesse = config.Vitesse, Initialisation = config.Init }; bdd.AddToConfigJeuDBs(configJeu); bdd.SaveChanges(); //Ajout pour vitesse var requeteParamAmplitude = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "Vitesse" && c.IdJeu == jeuBD.IdJeu select c; var paramJeuAmplitude = requeteParamAmplitude.FirstOrDefault(); ParametreExDB paramExDBAmplitude = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramJeuAmplitude.IdParametreJeuDB, Resultat = (decimal)exo.VitesseMoyenne, CoefficientVariation = (decimal)exo.CVVitesseMoyenne, }; bdd.AddToParametreExDBs(paramExDBAmplitude); bdd.SaveChanges(); ////Ajout pour init var requeteParamVitM = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "Init" && c.IdJeu == jeuBD.IdJeu select c; var paramjeuVitM = requeteParamVitM.FirstOrDefault(); ParametreExDB paramExDBVitM = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramjeuVitM.IdParametreJeuDB, Resultat = (decimal)exo.InitMoyen, EcartType = (decimal)exo.CVInit }; bdd.AddToParametreExDBs(paramExDBVitM); bdd.SaveChanges(); //Ajout pour klat var requeteParamVitMax = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "AssisLat" && c.IdJeu == jeuBD.IdJeu select c; var paramjeuVitMax = requeteParamVitMax.FirstOrDefault(); ParametreExDB paramExDBVitMax = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramjeuVitMax.IdParametreJeuDB, Resultat = (decimal)exo.RaideurLatMoyenne, CoefficientVariation = (decimal)exo.CVRaideurLat }; bdd.AddToParametreExDBs(paramExDBVitMax); bdd.SaveChanges(); //Ajout pour klong var requeteParamSt = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "AssisLong" && c.IdJeu == jeuBD.IdJeu select c; var paramjeuSt = requeteParamSt.FirstOrDefault(); ParametreExDB paramExDBSt = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramjeuSt.IdParametreJeuDB, Resultat = (decimal)exo.RaideurLongMoyenne, CoefficientVariation = (decimal)exo.CVRaideurLong }; bdd.AddToParametreExDBs(paramExDBSt); bdd.SaveChanges(); //Ajout pour nbrMouvement var requeteParamSM = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "NbMouvements" && c.IdJeu == jeuBD.IdJeu select c; var paramjeuSM = requeteParamSM.FirstOrDefault(); ParametreExDB paramExDBSM = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramjeuSM.IdParametreJeuDB, Resultat = (decimal)exo.NbrMouvement, }; bdd.AddToParametreExDBs(paramExDBSM); bdd.SaveChanges(); } }
private static void AjoutPartieDataBaseCircle(Circle exo) { Singleton singlePatient = Singleton.getInstance(); using (ReaPlanDBEntities bdd = new ReaPlanDBEntities()) { var requete = from c in bdd.JeuDBs where c.NomJeu == "Circle" select c; var jeuBD = requete.FirstOrDefault(); var requeteP = from c in bdd.PatientDBs where c.Nom == singlePatient.PatientSingleton.Nom && c.Prenom == singlePatient.PatientSingleton.Prenom && c.DateNaissance == singlePatient.PatientSingleton.DateNaiss select c; var patient = requeteP.FirstOrDefault(); var requeteA = from c in bdd.TherapeuteDBs where c.Nom == singlePatient.Admin.Nom && c.Prenom == singlePatient.Admin.Prenom && c.Login == singlePatient.Admin.NomUtilisateur select c; var thera = requeteA.FirstOrDefault(); ExerciceDB ex = new ExerciceDB() { Date = DateTime.Now, Heure = DateTime.Now.TimeOfDay, IdPatient = patient.IdPatient, IdUtilisateur = thera.IdUtilisateur, IdJeu = jeuBD.IdJeu }; bdd.AddToExerciceDBs(ex); bdd.SaveChanges(); //Recherche de l'id du dernier ex fait par le patient var requeteExDB = from c in bdd.ExerciceDBs select c; var exDB = requeteExDB.AsEnumerable().LastOrDefault(); //Ajout pour amplitude var requeteParamPrecision = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "ShapeAccuracy" && c.IdJeu == jeuBD.IdJeu select c; var paramJeuPrecision = requeteParamPrecision.FirstOrDefault(); ParametreExDB paramExDBPrecision = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramJeuPrecision.IdParametreJeuDB, Resultat = (decimal)exo.ShapeAccuracy, CoefficientVariation = (decimal)exo.CVShapeAccuracy, EcartType = (decimal)exo.EcartTypeSA }; bdd.AddToParametreExDBs(paramExDBPrecision); bdd.SaveChanges(); //Ajout pour vitesse moyenne var requeteParamVitM = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "Speed" && c.IdJeu == jeuBD.IdJeu select c; var paramjeuVitM = requeteParamVitM.FirstOrDefault(); ParametreExDB paramExDBVitM = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramjeuVitM.IdParametreJeuDB, Resultat = (decimal)exo.VitesseMoy, CoefficientVariation = (decimal)exo.CVVitesseMoy, EcartType = (decimal)exo.EcartTypeVMoy }; bdd.AddToParametreExDBs(paramExDBVitM); bdd.SaveChanges(); //Ajout pour vitesse max var requeteParamVitMax = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "PeakSpeed" && c.IdJeu == jeuBD.IdJeu select c; var paramjeuVitMax = requeteParamVitMax.FirstOrDefault(); ParametreExDB paramExDBVitMax = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramjeuVitMax.IdParametreJeuDB, Resultat = (decimal)exo.VitesseMax, CoefficientVariation = (decimal)exo.CVVitesseMax, EcartType = (decimal)exo.EcartTypeVMax }; bdd.AddToParametreExDBs(paramExDBVitMax); bdd.SaveChanges(); //Ajout pour speedMetric var requeteParamSM = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "SpeedMetric" && c.IdJeu == jeuBD.IdJeu select c; var paramjeuSM = requeteParamSM.FirstOrDefault(); ParametreExDB paramExDBSM = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramjeuSM.IdParametreJeuDB, Resultat = (decimal)exo.SpeedMetric, CoefficientVariation = (decimal)exo.CVSpeedMetric, EcartType = (decimal)exo.EcartTypeSM }; bdd.AddToParametreExDBs(paramExDBSM); bdd.SaveChanges(); //Ajout pour speedMetric var requeteParamJM = from c in bdd.ParametreJeuDBs where c.LibelleParametre == "Jerk" && c.IdJeu == jeuBD.IdJeu select c; var paramjeuJM = requeteParamJM.FirstOrDefault(); ParametreExDB paramExDBJM = new ParametreExDB() { IdExercice = exDB.IdExercice, IdParametreJeuDB = paramjeuJM.IdParametreJeuDB, Resultat = (decimal)exo.JerkMetric, CoefficientVariation = (decimal)exo.CVJerkMetric, EcartType = (decimal)exo.EcartTypeJM }; bdd.AddToParametreExDBs(paramExDBJM); bdd.SaveChanges(); } }