public void LoadSettings() { Reset(); if (Globals.GetSetting != null) { DBServer = Globals.GetSetting("DBServer"); DBCatalog = Globals.GetSetting("DBCatalog"); DBWinSecurity = Globals.GetSetting("DBIntegratedSecurity").SafeInt(1).SafeBool(); DBUser = Globals.GetSetting("DBUser"); if (this.PasswordEncryptionService != null) { DBPassword = this.PasswordEncryptionService.DecryptString(Globals.GetSetting("DBPassword").SafeString()); } DBSavePasswords = Globals.GetSetting("DBSavePasswords").SafeBool(); ConnectionTimeout = Globals.GetSetting("DBConnectionTimeout").SafeInt(15); CommandTimeout = Globals.GetSetting("DBCommandTimeout").SafeInt(40); } else if (!String.IsNullOrEmpty(Globals.RegistrySectionKey)) { KSRegistry cReg = new KSRegistry(); cReg.sectionKey = Globals.RegistrySectionKey; cReg.valueKey = "DBServer"; cReg.defaultValue = String.Empty; DBServer = cReg.value.SafeString(); cReg.valueKey = "DBCatalog"; cReg.defaultValue = String.Empty; DBCatalog = cReg.value.SafeString(); cReg.valueKey = "DBIntegratedSecurity"; cReg.defaultValue = true; DBWinSecurity = cReg.value.SafeBool(); cReg.valueKey = "DBSavePasswords"; cReg.defaultValue = true; DBSavePasswords = cReg.value.SafeBool(); cReg.valueKey = "DBUser"; cReg.defaultValue = String.Empty; DBUser = cReg.value.SafeString(); if (this.PasswordEncryptionService != null) { cReg.valueKey = "DBPassword"; cReg.defaultValue = String.Empty; DBPassword = this.PasswordEncryptionService.DecryptString(cReg.value.SafeString()); } cReg.valueKey = "DBConnectionTimeout"; cReg.defaultValue = 15; ConnectionTimeout = cReg.value.SafeInt(15); cReg.valueKey = "DBCommandTimeout"; cReg.defaultValue = 40; CommandTimeout = cReg.value.SafeInt(40); } }
public void SaveSettings() { if (Globals.SaveSetting != null) { Globals.SaveSetting("DBServer", DBServer); Globals.SaveSetting("DBPort", DBPort); Globals.SaveSetting("DBCatalog", DBCatalog); Globals.SaveSetting("DBIntegratedSecurity", DBWinSecurity.ToInt().ToString()); if (!DBWinSecurity) { Globals.SaveSetting("DBSavePasswords", DBSavePasswords.ToInt().ToString()); Globals.SaveSetting("DBUser", DBUser); if (CanSavePasswords) { Globals.SaveSetting("DBPassword", this.PasswordEncryptionService.EncryptString(DBPassword)); } } else { Globals.SaveSetting("DBSavePasswords", String.Empty); Globals.SaveSetting("DBUser", String.Empty); Globals.SaveSetting("DBPassword", String.Empty); } Globals.SaveSetting("DBConnectionTimeout", ConnectionTimeout.ToString()); Globals.SaveSetting("DBCommandTimeout", CommandTimeout.ToString()); } else if (!String.IsNullOrEmpty(Globals.RegistrySectionKey)) { KSRegistry cReg = new KSRegistry(); cReg.sectionKey = Globals.RegistrySectionKey; cReg.valueKey = "DBServer"; cReg.defaultValue = String.Empty; cReg.value = DBServer; cReg.valueKey = "DBPort"; cReg.defaultValue = String.Empty; cReg.value = DBPort; cReg.valueKey = "DBCatalog"; cReg.defaultValue = String.Empty; cReg.value = DBCatalog; cReg.valueKey = "DBIntegratedSecurity"; cReg.defaultValue = false; cReg.value = DBWinSecurity; if (!DBWinSecurity) { cReg.valueKey = "DBSavePasswords"; cReg.defaultValue = false; cReg.value = DBSavePasswords.ToInt(); cReg.valueKey = "DBUser"; cReg.defaultValue = String.Empty; cReg.value = DBUser; if (CanSavePasswords) { cReg.valueKey = "DBPassword"; cReg.defaultValue = String.Empty; cReg.value = this.PasswordEncryptionService.EncryptString(DBPassword); } } else { cReg.valueKey = "DBSavePasswords"; cReg.defaultValue = String.Empty; cReg.value = String.Empty; cReg.valueKey = "DBUser"; cReg.defaultValue = String.Empty; cReg.value = String.Empty; cReg.valueKey = "DBPassword"; cReg.defaultValue = String.Empty; cReg.value = String.Empty; } cReg.valueKey = "DBConnectionTimeout"; cReg.defaultValue = 20; cReg.value = ConnectionTimeout; cReg.valueKey = "DBCommandTimeout"; cReg.defaultValue = 40; cReg.value = CommandTimeout; } }