// Datagrid Medecins Menu Click-droit/Supprimer
private void menuSuppMed_Click(object sender, RoutedEventArgs e)
{
if (dgMedecins.SelectedItem == null)
{
return;
}
if (empEdit != null && (dgMedecins.SelectedItem as MedView).ID == empEdit.ID)
{
addMode();
}
MedView medViewSelection = dgMedecins.SelectedItem as MedView;
Employe delEmp = mgr.BDD.Employes.Where(x => x.ID == medViewSelection.ID).FirstOrDefault();
Medecin delMed = mgr.BDD.Medecins.Where(x => x.MedID == medViewSelection.MedID).FirstOrDefault();
MessageBoxResult confirmer = MessageBox.Show(
"Êtes-vous sûr de vouloir supprimer le médecin " + delEmp.Prenom + " " + delEmp.Nom + "?",
"Confirmez",
MessageBoxButton.YesNo,
MessageBoxImage.Hand);
if (confirmer == MessageBoxResult.Yes)
{
mgr.BDD.Medecins.Remove(delMed);
mgr.BDD.Employes.Remove(delEmp);
mgr.SaveChanges();
actualiser();
}
}
// Button Ajouter/Enregistrer
private void btnOk_Click(object sender, RoutedEventArgs e)
{
if (checkFields())
{
if (!editing)
{
// Ajout
Employe emp = new Employe();
emp.Nom = txtNom.Text;
emp.Prenom = txtPrenom.Text;
emp.USR = txtUsr.Text;
emp.PSW = txtPsw.Password;
emp.DepID = (cbDepts.SelectedItem as Departement).ID;
mgr.BDD.Employes.Add(emp);
mgr.SaveChanges();
if ((cbDepts.SelectedItem as Departement).NomDept == "Medical")
{
// Ajout Medecin
mgr.BDD.Entry(emp).GetDatabaseValues();
Medecin med = new Medecin();
med.EmpID = emp.ID;
med.DepMedID = (cbDeptsMed.SelectedItem as DepartementMedical).ID;
mgr.BDD.Medecins.Add(med);
mgr.SaveChanges();
}
actualiser();
MessageBox.Show("Employé Ajouté!", "Succès!", MessageBoxButton.OK);
}
else
{
// Edition Employé
empEdit.Nom = txtNom.Text;
empEdit.Prenom = txtPrenom.Text;
empEdit.USR = txtUsr.Text;
empEdit.PSW = txtPsw.Password;
empEdit.DepID = (cbDepts.SelectedItem as Departement).ID;
if (editingMed)
{
// Edition Medecin
medEdit.DepMedID = (cbDeptsMed.SelectedItem as DepartementMedical).ID;
}
mgr.SaveChanges();
actualiser();
addMode();
MessageBox.Show("Modification(s) effectuée(s)!", "Succès!", MessageBoxButton.OK);
}
}
else
{
// En cas d'erreur
MessageBox.Show(message, "Erreur d'entrée", MessageBoxButton.OK, MessageBoxImage.Exclamation);
message = String.Empty;
}
}
public void actualiser()
{
string term = txtSearch.Text;
Medecin userMed = mgr.BDD.Medecins.Where(x => x.EmpID == mgr.User.ID).SingleOrDefault();
if (term != String.Empty)
{
dgSejours.DataContext = mgr.BDD.SejMedViews.Where(x => x.MedID == userMed.MedID && x.DateFin == null && (x.Nom.Contains(term) || x.Prenom.Contains(term))).ToList();
}
else
{
dgSejours.DataContext = mgr.BDD.SejMedViews.Where(x => x.MedID == userMed.MedID && x.DateFin == null).ToList();
}
}
// Datagrid Medecins Menu Click-droit/Edit
private void menuEditMed_Click(object sender, RoutedEventArgs e)
{
if (dgMedecins.SelectedItem == null)
{
return;
}
editMode();
editingMed = true;
cbDepts.IsEnabled = false;
MedView medViewSelection = dgMedecins.SelectedItem as MedView;
empEdit = mgr.BDD.Employes.Where(x => x.ID == medViewSelection.ID).FirstOrDefault();
medEdit = mgr.BDD.Medecins.Where(x => x.MedID == medViewSelection.MedID).FirstOrDefault();
txtNom.Text = empEdit.Nom;
txtPrenom.Text = empEdit.Prenom;
txtUsr.Text = empEdit.USR;
txtPsw.Password = empEdit.PSW;
cbDepts.SelectedItem = empEdit.Departement;
cbDeptsMed.SelectedItem = medEdit.DepartementMedical;
}
