public void SuppRdv(DateTime date)
{
RendezVous rdvToDelete = (from rdv in Globals.DataClass.RendezVous
where date == rdv.Date
select rdv).First <RendezVous>();
MPRendezVous mPRendezVous = (from rdv in Globals.DataClass.MPRendezVous
where rdvToDelete.Id == rdv.IdRendezVous && rdvToDelete.IdPatient == rdv.IdPatient && rdvToDelete.IdMedecin == rdv.IdMedecin
orderby rdv.Id descending
select rdv).First <MPRendezVous>();
Globals.DataClass.MPRendezVous.DeleteOnSubmit(mPRendezVous);
Globals.DataClass.SubmitChanges();
Globals.DataClass.RendezVous.DeleteOnSubmit(rdvToDelete);
Globals.DataClass.SubmitChanges();
//System.IO.File.Copy($@"{Globals.CurrentDirectoryPath}\\MCDatabase.mdf", $@"{Globals.CurrentDirectoryPath}\\restauration\\MCDatabase.mdf", true);
}
public void SuppRdv(string nomPatient, string prenomPatient)
{
nomPatient = nomPatient.ToUpper();
prenomPatient = prenomPatient.ToUpper();
RendezVous rdvToDelete = (from personne in Globals.DataClass.Personne
where nomPatient == personne.nom && prenomPatient == personne.prenom
join patient in Globals.DataClass.Patient on personne.Id equals patient.IdPersonne
join rdv in Globals.DataClass.RendezVous on patient.Id equals rdv.IdPatient
orderby rdv.Id descending
select rdv).First <RendezVous>();
MPRendezVous mPRendezVous = (from rdv in Globals.DataClass.MPRendezVous
where rdvToDelete.Id == rdv.IdRendezVous && rdvToDelete.IdPatient == rdv.IdPatient && rdvToDelete.IdMedecin == rdv.IdMedecin
orderby rdv.Id descending
select rdv).First <MPRendezVous>();
Globals.DataClass.MPRendezVous.DeleteOnSubmit(mPRendezVous);
Globals.DataClass.SubmitChanges();
Globals.DataClass.RendezVous.DeleteOnSubmit(rdvToDelete);
Globals.DataClass.SubmitChanges();
//System.IO.File.Copy($@"{Globals.CurrentDirectoryPath}\\MCDatabase.mdf", $@"{Globals.CurrentDirectoryPath}\\restauration\\MCDatabase.mdf", true);
}
public bool AddRdv(DateTime date, byte idMedecin, string nomPatient, string prenomPatient, bool important, string notes)
{
nomPatient = nomPatient.ToUpper();
prenomPatient = prenomPatient.ToUpper();
IQueryable <RendezVous> checkRdv = (from rdvCheck in Globals.DataClass.RendezVous
where date == rdvCheck.Date
select rdvCheck);
if (checkRdv.Count() == 0)
{
IQueryable <Patient> patientRdv = (from personne in Globals.DataClass.Personne
where nomPatient == personne.nom && prenomPatient == personne.prenom
join patient in Globals.DataClass.Patient on personne.Id equals patient.IdPersonne
select patient);
if (patientRdv.Count() != 0)
{
Patient pers = patientRdv.First <Patient>();
RendezVous rdv = new RendezVous
{
Date = date,
IdPatient = pers.Id,
IdMedecin = idMedecin,
Important = important,
Fait = false,
Note = notes,
Notified = false
};
Globals.DataClass.RendezVous.InsertOnSubmit(rdv);
Globals.DataClass.SubmitChanges();
MPRendezVous mPRdv = new MPRendezVous
{
IdMedecin = idMedecin,
IdPatient = pers.Id,
IdRendezVous = rdv.Id
};
Globals.DataClass.MPRendezVous.InsertOnSubmit(mPRdv);
Globals.DataClass.SubmitChanges();
}
else
{
PersonneClasse newPatient = new PersonneClasse();
newPatient.AddPatientPersonne(nomPatient, prenomPatient, "01/01/1998", "Indéfini", "0123456789", "Homme", "170", "60", "/", "Indéfini", "Indéfini");
Patient addedPatient = (from personne in Globals.DataClass.Personne
where nomPatient == personne.nom && prenomPatient == personne.prenom
join patient in Globals.DataClass.Patient on personne.Id equals patient.IdPersonne
select patient).First <Patient>();
RendezVous rdv = new RendezVous
{
Date = date,
IdPatient = addedPatient.Id,
IdMedecin = idMedecin,
Important = important,
Fait = false,
Note = notes,
Notified = false
};
Globals.DataClass.RendezVous.InsertOnSubmit(rdv);
Globals.DataClass.SubmitChanges();
MPRendezVous mPRdv = new MPRendezVous
{
IdMedecin = idMedecin,
IdPatient = addedPatient.Id,
IdRendezVous = rdv.Id
};
Globals.DataClass.MPRendezVous.InsertOnSubmit(mPRdv);
Globals.DataClass.SubmitChanges();
}
//System.IO.File.Copy($@"{Globals.CurrentDirectoryPath}\\MCDatabase.mdf", $@"{Globals.CurrentDirectoryPath}\\restauration\\MCDatabase.mdf", true);
return(true);
}
else
{
return(false);
}
}