} // 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); }
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); }