private void backgroundWorkerSampleData_DoWork(object sender, DoWorkEventArgs e) { BackgroundWorker worker = sender as BackgroundWorker; // Handle multi-threading if (worker != null && worker.CancellationPending) { e.Cancel = true; } else { worker.ReportProgress(0); // Create the sample data _alertSampleDataCreationInDatabase.SetTextLogging("Commencing sample data set creation.\r\n\r\n"); try { GenerateDatabaseSample(worker); _alertSampleDataCreationInDatabase.SetTextLogging("\r\n\r\nThe configurations (configuration screen) have also been reset to the TEAM defaults to match the sample source-target mapping metadata."); SetStandardConfigurationSettings(); worker.ReportProgress(100); } catch (Exception ex) { MessageBox.Show("An issue occurred creating the sample schemas. The error message is: " + ex, "An issue has occurred", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void backgroundWorkerEventLog_DoWork(object sender, DoWorkEventArgs e) { BackgroundWorker worker = sender as BackgroundWorker; var localEventLog = GlobalParameters.TeamEventLog; // Handle multi-threading if (worker != null && worker.CancellationPending) { e.Cancel = true; } else { backgroundWorkerEventLog.ReportProgress(0); _alertEventLog.SetTextLogging("Event Log.\r\n\r\n"); try { foreach (var individualEvent in localEventLog) { _alertEventLog.SetTextLogging($"{individualEvent.eventTime} - {(EventTypes) individualEvent.eventCode}: {individualEvent.eventDescription}\r\n"); } } catch (Exception ex) { MessageBox.Show("An issue occurred displaying the event log. The error message is: " + ex, "An issue has occurred", MessageBoxButtons.OK, MessageBoxIcon.Warning); } backgroundWorkerEventLog.ReportProgress(100); } }
/// <summary> /// /// Run a SQL command against the provided database connection, capture any errors and report feedback to the Sample data screen. /// </summary> /// <param name="connString"></param> /// <param name="createStatement"></param> /// <param name="worker"></param> /// <param name="progressCounter"></param> /// <param name="targetForm"></param> private static void RunSqlCommandSampleDataForm(string connString, string createStatement, BackgroundWorker worker, int progressCounter, Form_Alert targetForm) { using (var connectionVersion = new SqlConnection(connString)) { var commandVersion = new SqlCommand(createStatement, connectionVersion); try { connectionVersion.Open(); commandVersion.ExecuteNonQuery(); worker.ReportProgress(progressCounter); targetForm.SetTextLogging(createStatement); } catch (Exception ex) { string errorMessage = $"An error has occurred with the following query: \r\n\r\n{createStatement}.\r\n\r\nThe error message is {ex}."; GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, errorMessage)); targetForm.SetTextLogging(errorMessage + "\r\n\r\n"); targetForm.SetTextLogging("This occurred with the following query: " + createStatement + "\r\n\r\n"); } } }