public int SavePatient(DBLibrary.Patient patient)
{
db.Entry(patient).State = System.Data.Entity.EntityState.Added;
int saveSuccess = db.SaveChanges();
return(saveSuccess);
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
if (dBOperation == DBOperation.ADD)
{
DBLibrary.Patient patient = new DBLibrary.Patient();
patient.FirstName = tbxFirstName.Text.Trim();
patient.LastName = tbxLastName.Text.Trim();
patient.Address = tbxAddress.Text.Trim();
patient.Email = tbxEmail.Text.Trim();
patient.PhoneNo = Int32.Parse(tbxPhone.Text.Trim());
patient.DoctorID = Int32.Parse(tbxDoctorID.Text.Trim());
int saveSuccess = SavePatient(patient);
if (saveSuccess == 1)
{
MessageBox.Show($"Patient {patient.FirstName} {patient.LastName} has been added to the database!", "Save to Database", MessageBoxButton.OK, MessageBoxImage.Information);
RefreshPatientList();
ClearPatientDetails();
stkPatientDetails.Visibility = Visibility.Collapsed;
}
else
{
MessageBox.Show("Error saving patient record.", "Save to Database", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
if (dBOperation == DBOperation.MODIFY)
{
foreach (var patient in db.Patients.Where(t => t.DoctorID == selectedPatient.DoctorID))
{
patient.FirstName = tbxFirstName.Text.Trim();
patient.LastName = tbxLastName.Text.Trim();
patient.Address = tbxAddress.Text.Trim();
patient.Email = tbxEmail.Text.Trim();
patient.PhoneNo = Int32.Parse(tbxPhone.Text.Trim());
patient.DoctorID = Int32.Parse(tbxDoctorID.Text.Trim());
}
int save = db.SaveChanges();
if (save == 1)
{
MessageBox.Show("Patient modified successfully!", "Save to Database", MessageBoxButton.OK, MessageBoxImage.Information);
RefreshPatientList();
ClearPatientDetails();
stkPatientDetails.Visibility = Visibility.Collapsed;
}
}
}
private void lstPatientList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (lstPatientList.SelectedIndex > 0)
{
selectedPatient = patients.ElementAt(lstPatientList.SelectedIndex);
submenuModifySelectedPatient.IsEnabled = true;
submenuDeleteSelectedPatient.IsEnabled = true;
if (dBOperation == DBOperation.ADD)
{
ClearPatientDetails();
}
tbxFirstName.Text = selectedPatient.FirstName;
tbxLastName.Text = selectedPatient.LastName;
tbxAddress.Text = selectedPatient.Address;
tbxEmail.Text = selectedPatient.Email;
tbxPhone.Text = selectedPatient.PhoneNo.ToString();
tbxDoctorID.Text = selectedPatient.DoctorID.ToString();
}
}
