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(); } }