private void Ajouter_Click(object sender, RoutedEventArgs e) { if (Date_naiss.Text == "" || Prenom.Text == "" || Nom.Text == "" || Adresse.Text == "" || Sexe.Text == "" || Poids.Text == "" || Taille.Text == "" || Etat_sante.Text == "" || Maladie.Text == "") { MessageBox.Show("Veuillez remplir toutes les informations!"); if (Date_naiss.Text == "") { Date_naiss.BorderBrush = Brushes.Red; } else { Date_naiss.BorderBrush = Brushes.Black; } if (Prenom.Text == "") { Prenom.BorderBrush = Brushes.Red; } else { Prenom.BorderBrush = Brushes.Black; } if (Nom.Text == "") { Nom.BorderBrush = Brushes.Red; } else { Nom.BorderBrush = Brushes.Black; } if (Adresse.Text == "") { Adresse.BorderBrush = Brushes.Red; } else { Adresse.BorderBrush = Brushes.Black; } if (Sexe.Text == "") { Sexe.BorderBrush = Brushes.Red; } else { Sexe.BorderBrush = Brushes.Black; } if (Poids.Text == "") { Poids.BorderBrush = Brushes.Red; } else { Poids.BorderBrush = Brushes.Black; } if (Taille.Text == "") { Taille.BorderBrush = Brushes.Red; } else { Taille.BorderBrush = Brushes.Black; } if (Etat_sante.Text == "") { Etat_sante.BorderBrush = Brushes.Red; } else { Etat_sante.BorderBrush = Brushes.Black; } if (Maladie.Text == "") { Maladie.BorderBrush = Brushes.Red; } else { Maladie.BorderBrush = Brushes.Black; } } else { try { pers.AddPatientPersonne(Nom.Text, Prenom.Text, Date_naiss.Text, Adresse.Text, Num_tel.Text, Sexe.Text, Taille.Text, Poids.Text, Groupage.Text, Maladie.Text, Etat_sante.Text); Globals.NomPatient = Nom.Text; Globals.PrenomPatient = Prenom.Text; DateTime date = Date_naiss.SelectedDate.Value; Globals.AdressePatient = Adresse.Text; Globals.Age = DateTime.Today.Year - date.Year; Dialog.IsOpen = true; }catch { MessageBox.Show("une erreur s'est produite, le patient n'a pas été ajouté"); } } }
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); } }