public void WriteDatabaseMetaData(RootNodeInfo rootTreeNode, IDatabaseConnector databaseConnector) { var cryptographyProvider = new LegacyRijndaelCryptographyProvider(); string strProtected; if (rootTreeNode != null) { if (rootTreeNode.Password) { var password = rootTreeNode.PasswordString.ConvertToSecureString(); strProtected = cryptographyProvider.Encrypt("ThisIsProtected", password); } else { strProtected = cryptographyProvider.Encrypt("ThisIsNotProtected", Runtime.EncryptionKey); } } else { strProtected = cryptographyProvider.Encrypt("ThisIsNotProtected", Runtime.EncryptionKey); } var cmd = databaseConnector.DbCommand("DELETE FROM tblRoot"); cmd.ExecuteNonQuery(); if (rootTreeNode != null) { cmd = databaseConnector.DbCommand( "INSERT INTO tblRoot (Name, Export, Protected, ConfVersion) VALUES(\'" + MiscTools.PrepareValueForDB(rootTreeNode.Name) + "\', 0, \'" + strProtected + "\'," + ConnectionsFileInfo.ConnectionFileVersion.ToString(CultureInfo.InvariantCulture) + ")"); cmd.ExecuteNonQuery(); } else { Runtime.MessageCollector.AddMessage(MessageClass.ErrorMsg, $"UpdateRootNodeTable: rootTreeNode was null. Could not insert!"); } }
public Version Upgrade() { Runtime.MessageCollector.AddMessage(MessageClass.InformationMsg, "Upgrading database from version 2.3 to version 2.4."); const string sqlText = @" ALTER TABLE tblCons ADD UseCredSsp bit NOT NULL DEFAULT 1, InheritUseCredSsp bit NOT NULL DEFAULT 0;"; var dbCommand = _databaseConnector.DbCommand(sqlText); dbCommand.ExecuteNonQuery(); return(new Version(2, 4)); }
public Version Upgrade() { Runtime.MessageCollector.AddMessage(MessageClass.InformationMsg, "Upgrading database from version 2.2 to version 2.3."); const string sqlText = @" ALTER TABLE tblCons ADD EnableFontSmoothing bit NOT NULL DEFAULT 0, EnableDesktopComposition bit NOT NULL DEFAULT 0, InheritEnableFontSmoothing bit NOT NULL DEFAULT 0, InheritEnableDesktopComposition bit NOT NULL DEFAULT 0;"; var dbCommand = _databaseConnector.DbCommand(sqlText); dbCommand.ExecuteNonQuery(); return(new Version(2, 3)); }
public Version Upgrade() { Runtime.MessageCollector.AddMessage(MessageClass.InformationMsg, "Upgrading database from version 2.4 to version 2.5."); const string sqlText = @" ALTER TABLE tblCons ADD LoadBalanceInfo varchar (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, AutomaticResize bit NOT NULL DEFAULT 1, InheritLoadBalanceInfo bit NOT NULL DEFAULT 0, InheritAutomaticResize bit NOT NULL DEFAULT 0;"; var dbCommand = _databaseConnector.DbCommand(sqlText); dbCommand.ExecuteNonQuery(); return(new Version(2, 5)); }
public Version Upgrade() { Runtime.MessageCollector.AddMessage(MessageClass.InformationMsg, "Upgrading database from version 2.6 to version 2.7."); const string sqlText = @" ALTER TABLE tblCons ADD RedirectClipboard bit NOT NULL DEFAULT 0, InheritRedirectClipboard bit NOT NULL DEFAULT 0; UPDATE tblRoot SET ConfVersion='2.7'"; var dbCommand = _databaseConnector.DbCommand(sqlText); dbCommand.ExecuteNonQuery(); return(new Version(2, 7)); }
public SqlConnectionListMetaData GetDatabaseMetaData(IDatabaseConnector databaseConnector) { SqlConnectionListMetaData metaData; DbDataReader dbDataReader = null; try { var dbCommand = databaseConnector.DbCommand("SELECT * FROM tblRoot"); if (!databaseConnector.IsConnected) { databaseConnector.Connect(); } dbDataReader = dbCommand.ExecuteReader(); if (!dbDataReader.HasRows) { return(null); // assume new empty database } else { dbDataReader.Read(); } metaData = new SqlConnectionListMetaData { Name = dbDataReader["Name"] as string ?? "", Protected = dbDataReader["Protected"] as string ?? "", Export = (bool)dbDataReader["Export"], ConfVersion = new Version(Convert.ToString(dbDataReader["confVersion"], CultureInfo.InvariantCulture)) }; } catch (Exception ex) { Runtime.MessageCollector.AddMessage(MessageClass.ErrorMsg, $"Retrieving database version failed. {ex}"); throw; } finally { if (dbDataReader != null && !dbDataReader.IsClosed) { dbDataReader.Close(); } } return(metaData); }
public Version Upgrade() { Runtime.MessageCollector.AddMessage(MessageClass.InformationMsg, "Upgrading database from version 2.5 to version 2.6."); const string sqlText = @" ALTER TABLE tblCons ADD RDPMinutesToIdleTimeout int NOT NULL DEFAULT 0, RDPAlertIdleTimeout bit NOT NULL DEFAULT 0, SoundQuality varchar (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL DEFAULT 'Dynamic', InheritRDPMinutesToIdleTimeout bit NOT NULL DEFAULT 0, InheritRDPAlertIdleTimeout bit NOT NULL DEFAULT 0, InheritSoundQuality bit NOT NULL DEFAULT 0; UPDATE tblRoot SET ConfVersion='2.6'"; var dbCommand = _databaseConnector.DbCommand(sqlText); dbCommand.ExecuteNonQuery(); return(new Version(2, 6)); }
public SqlConnectionsUpdateChecker() { _dbConnector = DatabaseConnectorFactory.DatabaseConnectorFromSettings(); _dbQuery = _dbConnector.DbCommand("SELECT * FROM tblUpdate"); _lastDatabaseUpdateTime = default(DateTime); }