public string UpdateOrInsert() { try { var Table = DatabaseContext.GetTable <SymptomsDiagnose>(); SymptomsDiagnose SD = new SymptomsDiagnose(); string SymptomsSelectedItem = (string)cmbSymptoms.SelectedItem; string DiagnosesSelectedItem = (string)cmbDiagnoses.SelectedItem; SD.SymptomID = Convert.ToInt32(SymptomsSelectedItem.Substring(0, SymptomsSelectedItem.IndexOf(' '))); SD.DiagnoseID = Convert.ToInt32(DiagnosesSelectedItem.Substring(0, DiagnosesSelectedItem.IndexOf(' '))); SD.ProbabYes = (double)nudYes.Value; SD.ProbabNo = (double)nudNo.Value; var Queue = from T in Table where (T.SymptomID == SD.SymptomID && T.DiagnoseID == SD.DiagnoseID) select T; if (Queue.Count() != 0) { return("Такое правило уже существует. Пара Симптом-Диагноз должна быть уникальной"); } Table.InsertOnSubmit(SD); } catch (Exception Ex) { return("Неизвестная ошибка: " + Ex.Message); } return(null); }
public SymptomDiagnoseAddEdit(System.Data.Linq.DataContext DatabaseContext, SymptomsDiagnose SD) : this(DatabaseContext) { InitializeComponent(); }