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();
}
}
