public static DBConnectionDetails Load(LogHandler Logger) { if (Logger.DebugMode) { Logger.LogTrace("Enter Load DBConnection Method"); } DBConnectionDetails _ReturnObject = null; if (File.Exists("./DBConnectionConfig.json")) { try { String _LoadedFile = Encoding.UTF8.GetString(File.ReadAllBytes("./DBConnectionConfig.json")); _ReturnObject = Newtonsoft.Json.JsonConvert.DeserializeObject <DBConnectionDetails>(_LoadedFile); _ReturnObject.DBPassword = Decrypt(_ReturnObject.DBPassword, _ReturnObject.DBServer, _ReturnObject.DBUsername); Logger.LogInformation("Found and loaded saved Database Connection Settings file."); } catch (Exception ex) { Logger.LogError("Found but could not load saved Database Connection Settings file." + ex.Message); _ReturnObject = new DBConnectionDetails(); } } else { _ReturnObject = new DBConnectionDetails(); } return(_ReturnObject); }
public UIMainScreen() { //Create the logger InitializeComponent(); Logger = new ODL.Common.LogHandler(); #if DEBUG Logger.DebugMode = true; #endif Logger.LogTableUpdated += RefreshLogGrid; Logger.LogInformation("Welcome to OpenDataLoader."); if (Logger.DebugMode) { Logger.LogDebug("Created Logger"); } //Populate dropdown for dbtype if (Logger.DebugMode) { Logger.LogTrace("Creating Dropdown Selections"); } List <KeyValuePair <String, String> > lstDBTypes = new List <KeyValuePair <String, String> >(); Array DBtypes = Enum.GetValues(typeof(ODL.Common.SupportedDatabases)); foreach (ODL.Common.SupportedDatabases _entry in DBtypes) { lstDBTypes.Add(new KeyValuePair <String, String>(_entry.ToString(), ((int)_entry).ToString())); } cmbDatabaseType.DisplayMember = "Key"; cmbDatabaseType.ValueMember = "Value"; cmbDatabaseType.DataSource = lstDBTypes; //Populate the dropdowns for the File Source and File Type cmbFileSource.DisplayMember = "Key"; cmbFileSource.ValueMember = "Value"; cmbFileSource.DataSource = ConvolutedWayToMakeNestedDropdowns(); if (Logger.DebugMode) { Logger.LogTrace("Loading DBConfig from json (if available)"); } //Load config from json ConnectionDetails = ODL.Common.DatabaseUtils.Load(Logger); txtDBUsername.Text = ConnectionDetails.DBUsername; txtDBPassword.Text = ConnectionDetails.DBPassword; txtDBServer.Text = ConnectionDetails.DBServer; txtDBCatalog.Text = ConnectionDetails.DBCatalog; txtDBPort.Text = ConnectionDetails.DBPort.ToString(); cmbDatabaseType.Text = ConnectionDetails.DBType.ToString(); }