public static Task<bool> AddMyTemplateDiagnosis(TemplateDiagnosis item) { MySqlConnection сonnection = new MySqlConnection(Worker.ConnectionString); MySqlCommand command = сonnection.CreateCommand(); var task = new Task<bool>(() => { if (item.MyNameTemplate == "") { command.CommandText = ("INSERT INTO worker_has_templatediagnosis (worker_idWorker, templatediagnosis_idTemplateDiagnosis) " + "VALUES('" + Worker.IdWorker + "', '" + item.IdTemplateDiagnosis + "')"); } else { command.CommandText = ("INSERT INTO worker_has_templatediagnosis (worker_idWorker, templatediagnosis_idTemplateDiagnosis, MyNameTemplate) " + "VALUES('" + Worker.IdWorker + "', '" + item.IdTemplateDiagnosis + "', '" + item.MyNameTemplate + "')"); } try { сonnection.Open(); command.ExecuteNonQuery(); Serialize(DateLastUpdate); } catch (Exception e) { WpfMessageBox.Show("Помилка при підключенні до серверу. \n Звернітся до адміністратора!"); Exceptions.AddException(e); return false; } return true; }); task.Start(); return task; }
private void ListBoxMyTemplates_SelectionChanged(object sender, SelectionChangedEventArgs e) { foreach (var templateDiagnosisList in TemplateDiagnosis.ListMyTemplateDiagnosisWithNumber) { if (templateDiagnosisList.Key == ListBoxMyTemplates.SelectedIndex + 1) { MyTemplate = templateDiagnosisList.Value; TemplateInfo.Show(templateDiagnosisList.Value.Diagnosis, templateDiagnosisList.Value.Recommendation); ButtonMyToAll.IsEnabled = true; ButtonEditNameTemplate.IsEnabled = true; } } }