} // MapDataFields (System.Data.DataRow currentRow)

        public Boolean Save(Mercury.Server.Data.SqlDatabase sqlDatabase)
        {
            Boolean success = false;

            StringBuilder sqlStatement = new StringBuilder();

            sqlStatement.Append("EXEC SecurityAuthority_InsertUpdate ");

            sqlStatement.Append(Id.ToString() + ", '" + NameSql + "', " + ((Int32)SecurityAuthorityType).ToString() + ", ");

            sqlStatement.Append("'" + Protocol + "', '" + ServerName + "', '" + Domain + "', ");

            sqlStatement.Append("'" + MemberContext + "', '" + ProviderContext + "', '" + AssociateContext + "', ");

            sqlStatement.Append("'" + AgentName + "', '" + agentPassword + "', ");

            sqlStatement.Append("'" + ProviderAssemblyPath + "', '" + ProviderAssemblyName + "', ");

            sqlStatement.Append("'" + ProviderNamespace + "', '" + ProviderClassName + "', '" + ConfigurationSection + "'");

            sqlStatement.Append(", '" + modifiedAccountInfo.SecurityAuthorityNameSql + "', '" + modifiedAccountInfo.UserAccountIdSql + "', '" + modifiedAccountInfo.UserAccountNameSql + "'");

            success = sqlDatabase.ExecuteSqlStatement(sqlStatement.ToString());

            return(success);
        }
        public Boolean Delete(Mercury.Server.Data.SqlDatabase sqlDatabase)
        {
            Boolean success = false;

            StringBuilder sqlStatement = new StringBuilder();

            sqlStatement.Append("EXEC Environment_Delete " + Id);

            success = sqlDatabase.ExecuteSqlStatement(sqlStatement.ToString());

            return(success);
        }
        } // MapDataFields (System.Data.DataRow currentRow)

        public Boolean Save(Mercury.Server.Data.SqlDatabase sqlDatabase)
        {
            Boolean success = false;

            StringBuilder sqlStatement = new StringBuilder();

            sqlStatement.Append("EXEC SecurityGroupPermission_InsertUpdate " + securityAuthorityId + ", '" + securityGroupId + "', " + permissionId + ", ");
            sqlStatement.Append(Convert.ToByte(isGranted) + ", " + Convert.ToByte(isDenied));
            sqlStatement.Append(", '" + modifiedAccountInfo.SecurityAuthorityName + "', '" + modifiedAccountInfo.UserAccountId + "', '" + modifiedAccountInfo.UserAccountName + "'");

            success = sqlDatabase.ExecuteSqlStatement(sqlStatement.ToString());

            return(success);
        }
Esempio n. 4
0
        public Boolean Save(Mercury.Server.Data.SqlDatabase environmentDatabase)
        {
            Boolean success = false;

            StringBuilder sqlStatement = new StringBuilder();

            sqlStatement.Append("EXEC RolePermission_InsertUpdate ");

            sqlStatement.Append(roleId.ToString() + ", ");

            sqlStatement.Append(permissionId.ToString() + ", ");

            sqlStatement.Append(Convert.ToByte(isGranted) + ", ");

            sqlStatement.Append(Convert.ToByte(isDenied) + ", ");

            sqlStatement.Append("'" + modifiedAccountInfo.SecurityAuthorityNameSql + "', '" + modifiedAccountInfo.UserAccountIdSql + "', '" + modifiedAccountInfo.UserAccountNameSql + "'");

            success = environmentDatabase.ExecuteSqlStatement(sqlStatement.ToString());

            return(success);
        }