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