private void btnAdmission_Click(object sender, RoutedEventArgs e) { if (dgPatientTrouver.SelectedItem != null) { int nbLitsDispo; using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { nbLitsDispo = db.lits .Where(lit => lit.occupe == false) .Count(); } if (nbLitsDispo > 0) { nouvelleAdmission nouvelleAdmission = new nouvelleAdmission(dgPatientTrouver.SelectedItem as patient, cetEmploye); nouvelleAdmission.ShowDialog(); } else { MessageBox.Show("Aucun lit n'est disponible en ce moment.", "Attention" , MessageBoxButton.OK, MessageBoxImage.Exclamation); } } else { MessageBox.Show("Veuillez selectionner un patient tout d'abord", "Attention" , MessageBoxButton.OK, MessageBoxImage.Error); } }
private void btnAjouter_Click(object sender, RoutedEventArgs e) { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { try { commentaire_patient nouveauCommentaire = new commentaire_patient { id_client = cePatient.id, id_medecin = cetEmploye.id, commentaire = txtCommentaire.Text, date = DateTime.Now }; db.commentaire_patient.Add(nouveauCommentaire); db.SaveChanges(); this.Close(); }catch (Exception ex) { MessageBox.Show("Une erreur s'est produite : \n" + ex.Message.ToString(), "Attention" , MessageBoxButton.OK, MessageBoxImage.Error); this.Close(); } } }
private void comboBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { patientInfo.Clear(); patientHistorique.Clear(); int idClient = Convert.ToInt16(cboPatient.SelectedValue); using (db = new NorthenLightsHopitalEntities()) { View_dossier_nom_prenom toAdd = db.View_dossier_nom_prenom .Where(pat => pat.id_client == idClient) .ToList() .Where(pat => pat.date_conge == null) .FirstOrDefault(); if (toAdd != null) { patientInfo.Add(toAdd); } IEnumerable <View_nom_medecin> afficherHistorique = db.View_nom_medecin .Where(pat => pat.id_client == idClient) .ToList() .Where(pat => pat.date_conge != null) .ToList(); foreach (var ligne in afficherHistorique) { patientHistorique.Add(ligne); } } }
private void dgPatientTrouver_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (e.OriginalSource != null) { Type type = e.OriginalSource.GetType(); if (type == typeof(DataGrid) && dgPatientTrouver.SelectedItem != null) { patient cePatient = dgPatientTrouver.SelectedItem as patient; using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { if ((db.dossier_admission .Where(dos => dos.id_client == cePatient.id) .ToList() .Where(dos => dos.date_conge == null) .ToList() .Count()) < 1) { btnAdmission.IsEnabled = true; } else { btnAdmission.IsEnabled = false; } } btnMiseAJour.IsEnabled = true; } else if (dgPatientTrouver.CurrentItem == null) { btnAdmission.IsEnabled = false; btnMiseAJour.IsEnabled = false; } } }
private void txtRecherche_KeyUp(object sender, KeyEventArgs e) { if (patientTrouver.Count() > 0) { patientTrouver.Clear(); dgPatientTrouver.Items.Refresh(); } if (txtRecherche.Text.Length > 1) { string[] aChercher = txtRecherche.Text.Split(' ', ','); foreach (string mot in aChercher) { using (db = new NorthenLightsHopitalEntities()) { var trouver = db.patients .Where(pat => pat.nom.ToLower().Contains(mot.ToLower()) || pat.prenom.ToLower().Contains(mot.ToLower())) .ToList(); if (trouver != null) { foreach (var patient in trouver) { patient.nom.Trim(); patient.prenom.Trim(); patientTrouver.Add(patient); dgPatientTrouver.Items.Refresh(); } } } } } }
public bool verifierAssurance() { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { return((db.assurances .Where(ass => ass.id_client == dossier.id_client) .Count()) > 0); } }
public assurance verifierAssurance(patient patient) { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { return(db.assurances .Where(pat => pat.id_client == patient.id) .FirstOrDefault()); } }
public void affichertout() { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { var tousPatients = db.patients.ToList(); foreach (var ligne in tousPatients) { patientTrouver.Add(ligne); } } }
public void populateListBox(string type) { listeLitsUp.Clear(); using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { switch (type) { case "standard": listeLits = db.View_lits_informations .Where(acc => acc.id_accomodation == 1 && acc.occupe == false) .ToList(); if (dgLits.Items == null) { freeUpgrade = true; rbSemiPrive.IsChecked = true; } foreach (var lit in listeLits) { listeLitsUp.Add(lit); } litPreselectionner(listeLitsUp); break; case "semi-prive": listeLits = db.View_lits_informations .Where(acc => acc.id_accomodation == 2 && acc.occupe == false) .ToList(); if (dgLits.Items.Count < 1 && freeUpgrade == true) { rbPrive.IsChecked = true; } foreach (var lit in listeLits) { listeLitsUp.Add(lit); } litPreselectionner(listeLitsUp); break; case "prive": listeLits = db.View_lits_informations .Where(acc => acc.id_accomodation == 3 && acc.occupe == false) .ToList(); foreach (var lit in listeLits) { listeLitsUp.Add(lit); } litPreselectionner(listeLitsUp); break; } } }
public AccueilAdmin(employe emp) { InitializeComponent(); cetEmploye = emp; listeEmployes = new ObservableCollection <employe>(); using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { cbxRole.DataContext = db.roles.ToList(); } dgEmployes.DataContext = listeEmployes; }
public void populateCombobox() { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { cbxRaisonAdmission.DataContext = db.raison_admission.ToList(); cbxDepartement.DataContext = db.departements.ToList(); cbxMedecin.DataContext = db.employes .Where(emp => emp.id_role == 2) .ToList(); } }
public DonnerConge(int id) { InitializeComponent(); using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { dossier = db.dossier_admission .Where(dos => dos.id == id) .FirstOrDefault(); } id_admission = id; estAssurer = verifierAssurance(); }
private void btnConge_Click(object sender, RoutedEventArgs e) { int patient = 0; patient = (int)cboPatient.SelectedValue; using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { var dossier = db.dossier_admission .Where(dos => dos.id_client == (int)cboPatient.SelectedValue && dos.date_conge == null) .FirstOrDefault(); if (dossier != null) { DonnerConge choixDate = new DonnerConge(dossier.id); choixDate.Show(); } } }
public AccueilMedecin(employe emp) { InitializeComponent(); employe = emp; patientInfo = new ObservableCollection <View_dossier_nom_prenom>(); patientHistorique = new ObservableCollection <View_nom_medecin>(); dgHistorique.DataContext = patientHistorique; dgPatients.DataContext = patientInfo; lblGreeting.Content = "Bonjour, " + emp.prenom.TrimEnd() + " " + emp.nom.Trim(); using (db = new NorthenLightsHopitalEntities()) { cboPatient.DataContext = db.View_dossier_nom_prenom .Where(pat => pat.id_medecin == employe.id) .GroupBy(pat => pat.id_client) .Select(pati => pati.FirstOrDefault()) .ToList(); } }
private void cbxRole_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (listeEmployes.Count > 0) { listeEmployes.Clear(); dgEmployes.Items.Refresh(); } if (cbxRole.SelectedIndex != -1) { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { IEnumerable <employe> liste = db.employes .Where(emp => emp.id_role == (int)cbxRole.SelectedValue) .ToList(); foreach (employe ligne in liste) { listeEmployes.Add(ligne); } } } }
private void btnAppliquer_Click(object sender, RoutedEventArgs e) { DateTime choix = (DateTime)conge.SelectedDate; if (choix != null) { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { db.dossier_admission .Where(dos => dos.id == id_admission) .ToList() .FirstOrDefault().date_conge = choix; db.SaveChanges(); db.lits .Where(li => li.id == dossier.id_lit) .ToList() .ForEach(li => li.occupe = false); db.accomodation_sejour .Where(acc => acc.id_dossier_admission == id_admission) .ToList() .ForEach(acc => acc.date_fin = choix); db.SaveChanges(); IEnumerable <View_accomodation_information> aFacturer = db.View_accomodation_information .Where(acc => acc.id_dossier_admission == id_admission) .ToList(); messageSucces(); nouvelleFacture(aFacturer); } } else { MessageBox.Show("Vous devez sélectionner une date.", "Attention" , MessageBoxButton.OK, MessageBoxImage.Warning); } }
private void btnSupprimer_Click(object sender, RoutedEventArgs e) { if (dgEmployes.SelectedItem != null) { employe employeSel = dgEmployes.SelectedItem as employe; var result = MessageBox.Show("Voulez-vous vraiment supprimer cet usager ?", "Attention" , MessageBoxButton.YesNo, MessageBoxImage.Exclamation); if (result == MessageBoxResult.Yes) { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { var empASup = db.employes .Where(emp => emp.id == employeSel.id) .FirstOrDefault(); if (empASup != null) { db.employes.Remove(empASup); db.SaveChanges(); } } } actualiser(); } }
public Accueil() { InitializeComponent(); db = new NorthenLightsHopitalEntities(); }
private void btnValider_Click(object sender, RoutedEventArgs e) { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { if (dgLits.SelectedItem != null) { accomodation_sejour nouvelAccTelevision = null; accomodation_sejour nouvelAccTelephone = null; try { dossier_admission nouvelAdmission = new dossier_admission { id_client = int.Parse(admissionData["id_client"]), id_medecin = int.Parse(admissionData["id_medecin"]), date_admission = Convert.ToDateTime(admissionData["date_admission"]), raison_admission = admissionData["raison_admission"], id_lit = litChoisi.id }; db.dossier_admission.Add(nouvelAdmission); db.SaveChanges(); int idDossier = nouvelAdmission.id; if (ckbxTelephone.IsChecked == true) { nouvelAccTelephone = new accomodation_sejour { id_dossier_admission = idDossier, id_accomodation = 5, date_debut = nouvelAdmission.date_admission, upgrade_sans_frais = false }; } if (ckbxTelevision.IsChecked == true) { nouvelAccTelevision = new accomodation_sejour { id_dossier_admission = idDossier, id_accomodation = 4, date_debut = nouvelAdmission.date_admission, upgrade_sans_frais = false }; } accomodation_sejour nouvelAccChambre = new accomodation_sejour { id_dossier_admission = idDossier, id_accomodation = litChoisi.id_accomodation, date_debut = nouvelAdmission.date_admission, upgrade_sans_frais = freeUpgrade }; if (ckbxTelevision.IsChecked == true) { db.accomodation_sejour.Add(nouvelAccTelephone); } if (ckbxTelephone.IsChecked == true) { db.accomodation_sejour.Add(nouvelAccTelevision); } db.accomodation_sejour.Add(nouvelAccChambre); db.lits .Where(li => li.id == litChoisi.id) .ToList() .FirstOrDefault().occupe = true; db.SaveChanges(); MessageBox.Show("Le patient a ete admis avec succes", "Succes" , MessageBoxButton.OK, MessageBoxImage.Exclamation); this.Close(); } catch (Exception ex) { MessageBox.Show("Une erreur s'est produite : \n" + ex.Message.ToString(), "Attention" , MessageBoxButton.OK, MessageBoxImage.Error); this.Close(); } } } }
private void btnValider_Click(object sender, RoutedEventArgs e) { if (champsRempli()) { try { using (NorthenLightsHopitalEntities db = new NorthenLightsHopitalEntities()) { if (cePatient == null) { patient nouveauPatient = new patient { nom = txtNom.Text, prenom = txtPrenom.Text, date_naissance = (DateTime)dateNais.SelectedDate, proche_parent = txtParent.Text }; db.patients.Add(nouveauPatient); db.SaveChanges(); int idPatient = nouveauPatient.id; if (ckbxAss.IsChecked == true) { assurance nouvellePolice = new assurance { no_police = int.Parse(txtAssNoPol.Text), nom_societe_assurance = txtAssNom.Text, id_client = idPatient }; db.assurances.Add(nouvellePolice); db.SaveChanges(); } } else { patient aModif = cePatient; aModif.date_naissance = (DateTime)dateNais.SelectedDate; aModif.nom = txtNom.Text; aModif.prenom = txtPrenom.Text; aModif.proche_parent = txtParent.Text; if (ckbxAss.IsChecked == true) { assurance nouvellePolice = new assurance { no_police = int.Parse(txtAssNoPol.Text), nom_societe_assurance = txtAssNom.Text, id_client = aModif.id }; db.assurances.Add(nouvellePolice); } db.Entry(aModif).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } succes(); } catch (Exception ex) { MessageBox.Show("Une erreur s'est produite : \n" + ex.Message.ToString(), "Attention" , MessageBoxButton.OK, MessageBoxImage.Error); this.Close(); } } else { MessageBox.Show("Veuillez remplir tous les champs.", "ATTENTION" , MessageBoxButton.OK, MessageBoxImage.Error); } }