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