public static ExerciceBaseConfig LoadLastConfigPourExercice(string nomExo)
{
ExerciceBaseConfig config = LoadExerciceBaseConfig();
var patientSingleton = Singleton.getInstance().PatientSingleton;
using (ReaPlanDBEntities db = new ReaPlanDBEntities())
{
PatientDB pat = (from p in db.PatientDBs
where p.Id1 == patientSingleton.ID1 &&
p.Id2 == patientSingleton.ID2 &&
p.DateNaissance == patientSingleton.DateNaiss
select p).FirstOrDefault();
if (pat != null)
{
JeuDB jeu = (from j in db.JeuDBs
where j.NomJeu == nomExo
select j).FirstOrDefault();
if (jeu != null)
{
ExerciceDB exo = (from e in db.ExerciceDBs
where e.IdPatient == pat.IdPatient &&
e.IdJeu == jeu.IdJeu
orderby e.Date
orderby e.Heure descending
select e).FirstOrDefault();
if (exo != null)
{
ConfigJeuDB conf = (from c in db.ConfigJeuDBs
where c.IdExercice == exo.IdExercice
select c).FirstOrDefault();
if (conf != null)
{
config.Init = (byte)conf.Initialisation;
config.RaideurLat = (byte)conf.RaideurLat;
config.RaideurLong = (byte)conf.RaideurLong;
config.Vitesse = (byte)conf.Vitesse;
}
}
}
}
return(config);
}
}
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();
}
}
