private void Button_PatientCategory_Click(object sender, RoutedEventArgs e) { PatientCategorys patientCategorys = ((FrameworkElement)sender).DataContext as PatientCategorys; patientSearchViewModel.DisplayPatientInfo = (from pc in patientSearchViewModel.ListPatientInfo where pc.Patient_PatientCategorys.Any(w => w.PatientCategory_ID == patientCategorys.PatientCategory_ID) select pc).ToList(); }
/// <summary> /// /// </summary> /// <param name="patientCategorys"></param> public void InsertPatientCategorys(PatientCategorys patientCategorys) { using (var ide = new iDentalEntities()) { ide.PatientCategorys.Add(patientCategorys); ide.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="patientCategorys"></param> /// <param name="newTitle"></param> public void DeletePatientCategorys(PatientCategorys patientCategorys) { using (var ide = new iDentalEntities()) { var deleteItem = ide.PatientCategorys.Where(w => w.PatientCategory_ID == patientCategorys.PatientCategory_ID).First(); deleteItem.Patients.Remove(new Patients()); ide.PatientCategorys.Remove(deleteItem); ide.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="patientCategorys"></param> /// <param name="newTitle"></param> public void UpdatePatientCategorysTitle(PatientCategorys patientCategorys, string newTitle) { using (var ide = new iDentalEntities()) { PatientCategorys updateItem = (from pc in ide.PatientCategorys where pc.PatientCategory_ID == patientCategorys.PatientCategory_ID select pc).First(); updateItem.PatientCategory_Title = newTitle; ide.SaveChanges(); } }
private void Button_CategoryDelete_Click(object sender, RoutedEventArgs e) { try { PatientCategorys patientCategorys = ((FrameworkElement)sender).DataContext as PatientCategorys; if (MessageBox.Show("確定刪除<" + patientCategorys.PatientCategory_Title + ">分類?\r\n如果是的話,所有擁有此分類的病患分類也會被取消", "提示", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { tablePatientCategorys.DeletePatientCategorys(patientCategorys); DataContext = new PatientCategorySettingViewModel(); } } catch (Exception ex) { ErrorLog.ErrorMessageOutput(ex.ToString()); MessageBox.Show("資料刪除中發生錯誤", "錯誤", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void Button_CategoryAdd_Click(object sender, RoutedEventArgs e) { try { PatientCategorys patientCategorys = new PatientCategorys() { PatientCategory_Title = textBoxCategoryInput.Text }; tablePatientCategorys.InsertPatientCategorys(patientCategorys); DataContext = new PatientCategorySettingViewModel(); } catch (Exception ex) { ErrorLog.ErrorMessageOutput(ex.ToString()); MessageBox.Show("新增病患類別錯誤", "錯誤", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void DataGrid_Update_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e) { try { string editTex = ((TextBox)e.EditingElement).Text; PatientCategorys patientCategorys = e.Row.DataContext as PatientCategorys; if (!patientCategorys.PatientCategory_Title.Equals(editTex)) { if (MessageBox.Show("確定將<" + patientCategorys.PatientCategory_Title + ">修改為<" + editTex + ">?\r\n如果是的話,所有擁有此分類的病患分類也會被更動", "提示", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { tablePatientCategorys.UpdatePatientCategorysTitle(patientCategorys, editTex); } else { DataContext = new PatientCategorySettingViewModel(); } } } catch (Exception ex) { ErrorLog.ErrorMessageOutput(ex.ToString()); MessageBox.Show("資料修改中發生錯誤", "錯誤", MessageBoxButton.OK, MessageBoxImage.Error); } }