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