private async Task UpdateColumns()
{
var loadId = Guid.NewGuid();
_columnsLoadId = loadId;
_columnsLoadControl.PushLoad();
try {
var sourceColumns = await GetSourceColumns();
if (_columnsLoadId == loadId)
{
_columnsControl.SetSourceColumns(sourceColumns);
UpdateTargetColumns();
_columnsLoadControl.ClearError();
_columnsError.Value = null;
}
} catch (UncaughtErrorScriptException ex) {
if (_columnsLoadId == loadId)
{
_columnsError.Value = $"Error importing the CSV file:\r\n{ex.ErrorMessage}";
_columnsLoadControl.SetError(_columnsError.Value);
}
} catch (Exception ex) {
if (_columnsLoadId == loadId)
{
_columnsError.Value = $"Error importing the CSV file:\r\n{ex.Message}";
_columnsLoadControl.SetError(_columnsError.Value);
}
} finally {
_columnsLoadControl.PopLoad();
}
}
private async Task UpdateScriptAndOutputPreview()
{
var errorMessage = GetErrorMessage();
// Import Script pane
if (errorMessage == null)
{
_sqlLoadControl.ClearError();
_sqlControl.SqlText = GetImportSql();
}
else
{
_sqlLoadControl.SetError(errorMessage);
}
// Preview pane
if (errorMessage == null)
{
_outputPreviewLoadControl.ClearError();
var loadId = Guid.NewGuid();
_outputPreviewLoadId = loadId;
_outputPreviewLoadControl.PushLoad();
try {
var dt = await Task.Run(() => {
var tableName = Guid.NewGuid().ToString();
try {
_manager.ExecuteScript(GetImportSql(100, tableName));
return(_manager.ExecuteScript($"SELECT * FROM {tableName.DoubleQuote()}").DataTables[0]);
} finally {
_manager.ExecuteScript($"DROP TABLE IF EXISTS {tableName.DoubleQuote()}");
}
});
if (_outputPreviewLoadId == loadId)
{
_outputPreviewControl.SetTable(dt.ToDataTable(), disposeTable: true);
}
} catch (UncaughtErrorScriptException ex) {
if (_outputPreviewLoadId == loadId)
{
_outputPreviewLoadControl.SetError($"Error importing the CSV file:\r\n{ex.ErrorMessage}");
}
} catch (Exception ex) {
if (_outputPreviewLoadId == loadId)
{
_outputPreviewLoadControl.SetError($"Error importing the CSV file:\r\n{ex.Message}");
}
} finally {
_outputPreviewLoadControl.PopLoad();
}
}
else
{
_outputPreviewLoadControl.SetError(errorMessage);
}
}