public DatabaseConnectionInfo GetCcsOwnerConnectionDetails() { DatabaseConnectionInfo info = null; OracleConnection connection = new OracleConnection(ConnectionString); connection.Open(); OracleCommand command = new OracleCommand(); command.Connection = connection; command.CommandText = string.Format("select server,port,schema,dbuser,dbuserpwd,auxinfo from databaseservice where servicetype = 'ORACLE' and rownum <= 1"); command.CommandType = CommandType.Text; OracleDataReader dr = command.ExecuteReader(); while (dr.Read()) { info = new DatabaseConnectionInfo(); info.Host = Conversion.ToString(dr["server"]); info.Port = Conversion.ToString(dr["port"]); info.Schema = Conversion.ToString(dr["schema"]); info.UserId = Conversion.ToString(dr["dbuser"]); info.Password = Conversion.ToString(dr["dbuserpwd"]); info.Service = Conversion.ToString(dr["auxinfo"]); } connection.Dispose(); return(info); }
private DatabaseConnectionInfo GetCcsOwnerDatabaseConfigurationInfo(DatabaseConnectionInfo pawnSecConnectionInfo) { Database database = new Database(pawnSecConnectionInfo.ConnectionString); DatabaseConnectionInfo encryptedInfo = database.GetCcsOwnerConnectionDetails(); DatabaseConnectionInfo decryptedInfo = new DatabaseConnectionInfo(); decryptedInfo.Host = EncryptionUtil.Decrypt(encryptedInfo.Host, Resources.PublicKey, true); decryptedInfo.Password = EncryptionUtil.Decrypt(encryptedInfo.Password, Resources.PublicKey, true); decryptedInfo.Port = EncryptionUtil.Decrypt(encryptedInfo.Port, Resources.PublicKey, true); decryptedInfo.Schema = EncryptionUtil.Decrypt(encryptedInfo.Schema, Resources.PublicKey, true); decryptedInfo.Service = EncryptionUtil.Decrypt(encryptedInfo.Service, Resources.PublicKey, true); decryptedInfo.UserId = EncryptionUtil.Decrypt(encryptedInfo.UserId, Resources.PublicKey, true); return(decryptedInfo); }
private DatabaseConnectionInfo GetPawnSecDatabaseConfigurationInfo(ClxApplication application, ConfigurationKey key) { string configValue = ConfigurationReader.GetInstance().GetConfigurationContents(application, key); XmlDocument xmlDocument = new XmlDocument(); xmlDocument.LoadXml(configValue); XmlNodeList list = xmlDocument.GetElementsByTagName("setting"); DatabaseConnectionInfo info = new DatabaseConnectionInfo(); foreach (XmlNode n in list) { string decryptedValue = EncryptionUtil.Decrypt(n.ChildNodes[0].InnerText, Resources.PrivateKey, true); switch (n.Attributes["name"].Value) { case "PawnSecDBUser": info.UserId = decryptedValue; break; case "PawnSecDBPassword": info.Password = decryptedValue; break; case "PawnSecDBSchema": info.Schema = decryptedValue; break; case "PawnSecDBPort": info.Port = decryptedValue; break; case "PawnSecDBHost": info.Host = decryptedValue; break; case "PawnSecDBService": info.Service = decryptedValue; break; } } return(info); }