//public static XDocument LoadFileResult(string dossier,string exercice) //{ // XDocument fileResult = XDocument.Load(@"../../Files/Patients/" + dossier + "/Evaluation/" + exercice + ".xml"); // return fileResult; //} //public static XDocument LoadFileNorme(string exercice) //{ // XDocument fileNorme = XDocument.Load(@"../../Files/Normes/Evaluation/" + exercice + ".xml"); // return fileNorme; //} public static List <PointEvoEval> ReturnVal(int nomParametre) { List <PointEvoEval> value = new List <PointEvoEval>(); user = Singleton.getInstance(); using (ReaPlanDBEntities context = new ReaPlanDBEntities()) { var requete = from c in context.PatientDBs where c.Nom == user.PatientSingleton.Nom && c.Prenom == user.PatientSingleton.Prenom && c.DateNaissance == user.PatientSingleton.DateNaiss.Date 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) => { PointEvoEval p = new PointEvoEval(); var resu = from c in context.ParametreExDBs where c.IdParametreJeuDB == nomParametre && c.IdExercice == ex.IdExercice select c; foreach (var item in resu) { if (item.Resultat != null) { p.Moyenne = Convert.ToDouble(item.Resultat); p.Date = ex.Date; value.Add(p); } } //requeteParamEx.ToList().ForEach((ParametreExDB ParamEx) => //{ // context.DeleteObject(ParamEx); // context.SaveChanges(); //}); //context.DeleteObject(ex); //context.SaveChanges(); }); return(value); } }
public static void returnNorme(double[] TabNorme, int valeur) { double constanteA = 0, y0 = 0; double deviationStandard = 0; int age; List <PointEvoEval> value = new List <PointEvoEval>(); user = Singleton.getInstance(); age = CalculateAge(user.PatientSingleton.DateNaiss); using (ReaPlanDBEntities context = new ReaPlanDBEntities()) { var requete = from c in context.PatientDBs where c.Nom == user.PatientSingleton.Nom && c.Prenom == user.PatientSingleton.Prenom && c.DateNaissance == user.PatientSingleton.DateNaiss.Date 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) => { PointEvoEval p = new PointEvoEval(); var resu = from c in context.ParametreJeuDBs where c.IdParametreJeuDB == valeur select c; foreach (var item in resu) { if (item != null) { constanteA = Convert.ToDouble(item.ConstanteA); y0 = Convert.ToDouble(item.Yo); deviationStandard = Convert.ToDouble(item.DeviationStandard); } } }); } TabNorme[0] = (y0 + (constanteA * age) + deviationStandard); TabNorme[1] = deviationStandard; }
public static List <PointEvoEval> ReturnPoint(int param, string nomJeu) { List <PointEvoEval> value = new List <PointEvoEval>(); user = Singleton.getInstance(); using (ReaPlanDBEntities context = new ReaPlanDBEntities()) { var requete = from c in context.PatientDBs where c.Nom == user.PatientSingleton.Nom && c.Prenom == user.PatientSingleton.Prenom && c.DateNaissance == user.PatientSingleton.DateNaiss.Date select c; var patient = requete.FirstOrDefault(); JeuDB jeu = (from j in context.JeuDBs where j.NomJeu == nomJeu select j).FirstOrDefault(); var requeteEx = (from c in context.ExerciceDBs where c.IdPatient == patient.IdPatient && c.IdJeu == jeu.IdJeu select c); //trie les exo par date puis par heure du plus grand au plus petit) var listeExerciceOrdre = requeteEx.OrderByDescending(c => c.Date).ThenBy(h => h.Heure); List <ExerciceDB> listeExo = new List <ExerciceDB>(); //cree une liste d'exo avec seulement le dernier exo de chaque jours for (int i = 0; i < listeExerciceOrdre.Count(); i++) { if (i < listeExerciceOrdre.Count() - 1) { if (listeExerciceOrdre.ToArray().ElementAt(i).Date != listeExerciceOrdre.ToArray().ElementAt(i + 1).Date) { listeExo.Add(listeExerciceOrdre.ToArray().ElementAt(i)); } } else { listeExo.Add(listeExerciceOrdre.ToArray().ElementAt(i)); } } foreach (var exo in listeExo) { PointEvoEval p = new PointEvoEval(); var resu = from c in context.ParametreExDBs where c.IdParametreJeuDB == param && c.IdExercice == exo.IdExercice select c; if (resu.ToArray().Count() != 0) { p.Moyenne = Convert.ToDouble(resu.ToArray().ElementAt(0).Resultat); p.EcartT = Convert.ToDouble(resu.ToArray().ElementAt(0).EcartType); p.CV = Convert.ToDouble(resu.ToArray().ElementAt(0).CoefficientVariation); p.Date = exo.Date; value.Add(p); } } //inverse l'ordre d'apparition des dates value.Reverse(); return(value); } }