private void ReadNumLitInCombo()
{
using (NLHContext context = new NLHContext())
{
comboLit.ItemsSource = context.Lits.Where(l => l.Occupe == false).Select(l => l.NumLit).ToList();
}
}
private void ReadMedecinInCombo()
{
using (NLHContext context = new NLHContext())
{
comboMedecin.ItemsSource = context.Medecins.Select(m => m.IdMedecin + ") " + m.Prenom + " " + m.Nom).ToList();
}
}
private void LoadPatientsInGrid()
{
using (NLHContext context = new NLHContext())
{
var results = context.Patients.Join(context.CompagnieAssurances,
p => p.IdCompagnie,
c => c.IdCompagnie,
(p, c) => new { p, c })
.Join(context.Parents,
pt => pt.p.RefParent,
pr => pr.RefParent,
(pt, pr) => new { pt, pr })
.Select(x => new
{
Patient = x.pt.p,
CompanyName = x.pt.c.NomCompagnie,
Parent = x.pr
});
foreach (var patient in results)
{
dataGridPatients.Items.Add(patient);
}
}
}
public void ReadPatientsInCombo()
{
using (NLHContext context = new NLHContext())
{
comboPatients.ItemsSource = context.DossierAdmissions.ToList();
}
}
private void btnSavePatient_Click(object sender, RoutedEventArgs e)
{
string idComp = GetNumero(comboAssurances.Text);
string refParent = GetNumero(comboParents.Text);
using (var context = new NLHContext())
{
var patient = new Patient
{
DateNaissance = datePickerBirthdate.SelectedDate,
Nom = txtNomPt.Text,
Prenom = txtPrenomPt.Text,
Adresse = txtAdressePt.Text,
Ville = txtVillePt.Text,
Province = txtProvincePt.Text,
CodePostal = txtCodePostalPt.Text,
Telephone = txtPhonePt.Text,
IdCompagnie = Convert.ToInt32(idComp),
RefParent = Convert.ToInt32(refParent)
};
context.Patients.Add(patient);
context.SaveChanges();
MessageBox.Show("Nouveau patient ajouté !", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void btnSupprimer_Click(object sender, RoutedEventArgs e)
{
using (NLHContext context = new NLHContext())
{
Medecin med = dataGridMedecins.SelectedItem as Medecin;
var deleteMed = context.Medecins.Where(m => m.IdMedecin == med.IdMedecin).SingleOrDefault();
var nbrDos = context.DossierAdmissions.Count(d => d.IdMedecin == deleteMed.IdMedecin);
if (nbrDos > 0)
{
MessageBox.Show("Ce médecin a déjà un patient", "Attention", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
MessageBoxResult messageBoxResult = MessageBox.Show("Êtes-vous sûr ?", "Confirmation de suppression", MessageBoxButton.YesNo, MessageBoxImage.Warning);
if (messageBoxResult == MessageBoxResult.Yes)
{
context.Medecins.Remove(deleteMed);
dataGridMedecins.Items.Remove(med);
context.SaveChanges();
Clear();
MessageBox.Show("Médecin supprimé !", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
}
private void ReadParentsInCombo()
{
using (var context = new NLHContext())
{
comboParents.ItemsSource = context.Parents.Select(p => p.RefParent + ") " + p.Prenom + " " + p.Nom).ToList();
}
}
private void ReadCompagnieAssurancesInCombo()
{
using (NLHContext context = new NLHContext())
{
comboAssurances.ItemsSource = context.CompagnieAssurances.Select(c => c.IdCompagnie + ") " + c.NomCompagnie).ToList();
}
}
private void txtSearchName_TextChanged(object sender, TextChangedEventArgs e)
{
// clear datagrid
gridDossiers.Items.Clear();
using (NLHContext context = new NLHContext())
{
var filtered = context.DossierAdmissions
.Join(context.Patients, d => d.NSS, p => p.NSS, (d, p) => new { d, p })
.Join(context.Medecins, ds => ds.d.IdMedecin, m => m.IdMedecin, (ds, m) => new { ds, m })
.Select(x => new
{
Dossier = x.ds.d,
Patient = x.ds.p,
Medecin = x.m,
})
.Where(elem => elem.Patient.Nom.Contains(txtSearchName.Text) || elem.Patient.Prenom.Contains(txtSearchName.Text));
foreach (var element in filtered)
{
gridDossiers.Items.Add(element);
}
}
}
private void ReadNSSInCombo()
{
using (NLHContext context = new NLHContext())
{
var patients = context.Patients.ToList().Select(p => p.NSS + ") " + p.Prenom + " " + p.Nom);
comboNSS.ItemsSource = patients;
}
}
private void LoadDataGrid()
{
dataGridMedecins.Items.Clear();
using (NLHContext context = new NLHContext())
{
context.Medecins.ToList().ForEach(medecin => dataGridMedecins.Items.Add(medecin));
}
}
private void btnAjouter_Click(object sender, RoutedEventArgs e)
{
using (NLHContext context = new NLHContext())
{
// validate if fields are empty
if (txtPrenom.Text == string.Empty || txtNom.Text == string.Empty || txtSpecialite.Text == string.Empty)
{
MessageBox.Show("Une ou plus des champs est vide", "Erreur", MessageBoxButton.OK, MessageBoxImage.Error);
}
else if ((string)btnAjouter.Content == "Ajouter")
{
Medecin medecin = new Medecin
{
Prenom = txtPrenom.Text.Trim(),
Nom = txtNom.Text.Trim(),
Specialite = txtSpecialite.Text.Trim()
};
context.Medecins.Add(medecin);
dataGridMedecins.Items.Add(medecin);
context.SaveChanges();
Clear();
MessageBox.Show("Nouveau médecin ajouté !", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
}
else if ((string)btnAjouter.Content == "Modifier")
{
var med = dataGridMedecins.SelectedItem as Medecin;
med.Prenom = txtPrenom.Text;
med.Nom = txtNom.Text;
med.Specialite = txtSpecialite.Text;
context.Entry(med).State = EntityState.Modified;
context.SaveChanges();
MessageBox.Show("Médecin modifié !", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
LoadDataGrid();
}
}
}
private void LoadDossiersInGrid()
{
using (NLHContext context = new NLHContext())
{
var results = context.DossierAdmissions.Join(context.Patients, d => d.NSS, p => p.NSS, (d, p) => new { d, p })
.Join(context.Medecins, ds => ds.d.IdMedecin, m => m.IdMedecin, (ds, m) => new { ds, m })
.Select(x => new
{
Dossier = x.ds.d,
Patient = x.ds.p,
Medecin = x.m
});
foreach (var r in results)
{
gridDossiers.Items.Add(r);
}
}
}
private void btnDonneConge_Click(object sender, RoutedEventArgs e)
{
using (NLHContext context = new NLHContext())
{
var idDossier = (comboPatients.SelectedItem as DossierAdmission).IdAdmission;
var dos = context.DossierAdmissions.Include(d => d.Lit).Where(d => d.IdAdmission == idDossier).Single();
dos.DateConge = DateTime.Now;
dos.Lit.Occupe = false;
context.Entry(dos).State = EntityState.Modified;
context.SaveChanges();
MessageBox.Show("Congé donné le " + dos.DateConge, "Info", MessageBoxButton.OK, MessageBoxImage.Information);
MessageBox.Show("Lit " + dos.NumLit + " dans le département " + dos.Lit.IdDepartement + " est libéré !", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void btnSaveParent_Click(object sender, RoutedEventArgs e)
{
using (var context = new NLHContext())
{
var parent = new Parent
{
Nom = txtNomPr.Text,
Prenom = txtPrenomPr.Text,
Adresse = txtAdressePr.Text,
Ville = txtVillePr.Text,
Province = txtProvincePr.Text,
CodePostal = txtCodePostalPr.Text,
Telephone = txtPhonePr.Text
};
context.Parents.Add(parent);
context.SaveChanges();
MessageBox.Show("Nouveau parent ajouté !", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
string nss = GetNumero(comboNSS.Text);
string idMed = GetNumero(comboMedecin.Text);
using (NLHContext context = new NLHContext())
{
DossierAdmission dossier = new DossierAdmission()
{
Chirurgie = (bool)checkChirurgie.IsChecked,
NSS = Convert.ToInt32(nss),
DateAdmission = DateTime.Now,
NumLit = Convert.ToInt32(comboLit.Text),
IdMedecin = Convert.ToInt32(idMed)
};
context.DossierAdmissions.Add(dossier);
context.SaveChanges();
MessageBox.Show("Ajouter!", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
