private Settings LoadSettings(bool includeFileSettings = true)
{
_isLoading = true;
var settings = SettingsHandler.Get();
if (includeFileSettings)
{
SourceType = settings.FileType.ToEnum <SourceType>();
txtFilePath.Text = settings.FilePath;
LoadSheetNames();
Delimiter = settings.Delimiter.ToEnum <DelimiterType>();
cboSheetName.Text = settings.SheetName;
}
LoadConnections(cboConnectionTarget, settings.GetConnectionItems());
LoadConnections(cboConnectionSource, settings.GetConnectionItems());
var selectedConnectionItem = settings.GetConnectionItems().SingleOrDefault(x => x.ConnectionString == settings.SelectedConnectionString);
if (selectedConnectionItem != null)
{
cboConnectionSource.SelectedText = settings.SelectedConnectionString;
cboConnectionTarget.SelectedText = settings.SelectedConnectionString;
}
cboConnectionTarget.SelectedValue = settings.SelectedConnectionString;
cboTableNameTarget.Text = settings.TableName;
_isLoading = false;
lblResultCount.Text = string.Empty;
lblVersion.Text = $"Version: {AssemblyExtender.DisplayVersion()} ({AssemblyExtender.BuildDate().ToShortDateString()}) {AssemblyExtender.AssemblyCompany()}";
return(settings);
}
private async Task InitializeAsync()
{
_assembly = Assembly.GetExecutingAssembly();
_socketClient = new DiscordSocketClient(new DiscordSocketConfig
{
AlwaysDownloadUsers = true,
ConnectionTimeout = 3 * 60 * 1000,
DefaultRetryMode = RetryMode.AlwaysRetry,
HandlerTimeout = 3 * 60 * 1000,
ExclusiveBulkDelete = true
});
_socketClient.Ready += SocketClient_Ready;
//_provider.GetRequiredService<DatabaseHandler>().BuildConfiguration(out _config);
CultureInfo.DefaultThreadCurrentCulture = new CultureInfo("de-DE");
ConsoleHelper.PrintHeader();
/*Metrics.Collector = new CollectorConfiguration()
* .Batch.AtInterval(TimeSpan.FromSeconds(5))
* .WriteTo.InfluxDB("http://127.0.0.1:8086", nameof(BonusBot))
* .CreateCollector();*/
_settingsHandler = new SettingsHandler();
var botToken = _settingsHandler.Get <string>(SettingsDefault.Token);
ConsoleHelper.Log(LogSeverity.Debug, "Core", "Using token for bot: " + botToken);
await _socketClient.LoginAsync(TokenType.Bot, botToken);
await _socketClient.StartAsync();
await Task.Delay(-1);
}
private void AddConnection()
{
var f = new Connection();
var dialogResult = f.ShowDialog();
if (dialogResult == DialogResult.OK)
{
var settings = SettingsHandler.Get();
settings.ConnectionStrings.Add(f.ConnectionString);
LoadConnections(cboConnectionTarget, settings.GetConnectionItems());
SaveSettings();
LoadSettings(false);
}
}
private void GetSettings()
{
var settings = SettingsHandler.Get();
ConnectionItems = new BindingList <ConnectionItem>(settings.ConnectionStrings.Select(x => new ConnectionItem(x)).OrderBy(c => c.DisplayName).ToList());
if (ConnectionItems.Any(c => c.ConnectionString == settings.SelectedConnection))
{
SelectedConnectionString = settings.SelectedConnection;
LoadTables();
}
txtSqlView.Text = settings.SqlView;
txtSqlProcedure.Text = settings.SqlProcedure;
if (Environment.UserName == "jal")
{
txtSqlProcedure.Text = "EXEC usp_ExtExportGetTasks @ServerId=0, @ExternalSystemId=2, @MaxProcessingTimeInMinutes=5 AS Task, Customer, Activity, Helper";
}
}