private void addNewParent_Click(object sender, RoutedEventArgs e)
{
Parent parent = new Parent();
try
{
parent.nom = parentnomTxtBox.Text;
parent.prenom = parentprenomTxtBox.Text;
parent.adresse = parentAddressTextBox.Text;
parent.code_postale = parentcodePostalTxtBox.Text;
parent.ville = parentvilleTxtBox.Text;
parent.telephone = parenttelephoneTxtBox.Text;
parent.province = parentProvincecomboBox.SelectedItem.ToString();
parent.ref_parent = refParentTextBox.Text;
myDataBase.Parents.Add(parent);
myDataBase.SaveChanges();
MessageBox.Show("New Parent added successfully!");
parentnomTxtBox.Text = "";
parentprenomTxtBox.Text = "";
parentAddressTextBox.Text = "";
parentcodePostalTxtBox.Text = "";
parentvilleTxtBox.Text = "";
parenttelephoneTxtBox.Text = "";
refParentTextBox.Text = "";
fillCombo();
closeParent();
}
catch (Exception ex)
{
MessageBox.Show("Oops! Something went wrong : \n" + ex.Message);
}
}
private void ajouterBtn_Click(object sender, RoutedEventArgs e)
{
Medecin meds = new Medecin();
meds.nom = nomTxtBox.Text;
meds.prenom = prenomTxtBox.Text;
meds.specialite = specialiteTxtBox.Text;
myDataBase.Medecins.Add(meds);
try
{
myDataBase.SaveChanges();
MessageBox.Show("New doctors added successfully!");
}
catch (Exception ex)
{
MessageBox.Show("Oops! Something went wrong : \n" + ex.Message);
}
fillCombo();
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
string patientRef = nssComboBox.Text;
int whichBed = 0;
MessageBoxResult res = MessageBox.Show("Do you really want to discharge " + nssComboBox.Text, "ATTENTION!", MessageBoxButton.YesNo, MessageBoxImage.Exclamation);
if (res == MessageBoxResult.Yes)
{
var query =
from pat in myDataBase.Dossier_Admission
where pat.nss == patientRef
select pat;
foreach (Dossier_Admission pat in query)
{
pat.date_conge = DateTime.Today;
whichBed = (int)pat.numero_lits;
}
var query2 =
from bed in myDataBase.Lits
where bed.Numero_Lit == whichBed
select bed;
foreach (Lit bed in query2)
{
bed.occupe = false;
}
myDataBase.SaveChanges();
loadCombo();
MessageBox.Show("Patient successfully discharged");
}
else
{
MessageBox.Show("Patient was not discharged");
}
}
catch (Exception)
{
MessageBox.Show("Oops! Something went wrong: \n");
}
}
