/// <summary>Loads a ComplianceOfficer record using Metadata Parameters.</summary> /// <param name="transaction">Contains the parameters and exceptions for this command.</param> public new static void Load(ParameterList parameters) { // Accessor for the ComplianceOfficer Table. ServerMarketData.ComplianceOfficerDataTable complianceOfficerTable = ServerMarketData.ComplianceOfficer; // Extract the parameters from the command batch. AdoTransaction adoTransaction = parameters["adoTransaction"]; SqlTransaction sqlTransaction = parameters["sqlTransaction"]; object configurationId = parameters["configurationId"].Value; object description = parameters["description"].Value; object groupPermission = parameters["groupPermission"].Value; object hidden = parameters["hidden"].Value; string name = parameters["name"]; object owner = parameters["owner"].Value; object ownerPermission = parameters["ownerPermission"].Value; object readOnly = parameters["readOnly"].Value; object worldPermission = parameters["worldPermission"].Value; object preferences = parameters["preferences"].Value; object externalSystemFolderId = parameters["systemFolderId"].Value; string userName = parameters["userName"]; string externalComplianceOfficerId = parameters["complianceOfficerId"]; object externalTypeCode = parameters["typeCode"].Value; // The row versioning is largely disabled for external operations. The value is returned to the caller in the // event it's needed for operations within the batch. long rowVersion = long.MinValue; // Resolve External Identifiers object systemFolderId = SystemFolder.FindOptionalKey(configurationId, "systemFolderId", externalSystemFolderId); int complianceOfficerId = User.FindKey(configurationId, "complianceOfficerId", externalComplianceOfficerId); object typeCode = Type.FindOptionalKey(configurationId, "typeCode", externalTypeCode); ServerMarketData.ComplianceOfficerRow complianceOfficerRow = complianceOfficerTable.FindByComplianceOfficerId(complianceOfficerId); // The load operation will create a record if it doesn't exist, or update an existing record. The external // identifier is used to determine if a record exists with the same key. if ((complianceOfficerRow == null)) { // Populate the 'externalId' varaibles so that the external identifier can be used to find the row when an // external method is called with the same 'configurationId' parameter. int externalKeyIndex = ComplianceOfficer.GetExternalKeyIndex(configurationId, "complianceOfficerId"); object[] externalIdArray = new object[8]; externalIdArray[externalKeyIndex] = externalComplianceOfficerId; object externalId0 = externalIdArray[0]; object externalId1 = externalIdArray[1]; object externalId2 = externalIdArray[2]; object externalId3 = externalIdArray[3]; object externalId4 = externalIdArray[4]; object externalId5 = externalIdArray[5]; object externalId6 = externalIdArray[6]; object externalId7 = externalIdArray[7]; // Call the internal method to complete the operation. MarkThree.Guardian.Core.ComplianceOfficer.Insert(adoTransaction, sqlTransaction, ref rowVersion, description, externalId0, externalId1, externalId2, externalId3, externalId4, externalId5, externalId6, externalId7, groupPermission, hidden, name, owner, ownerPermission, readOnly, worldPermission, preferences, systemFolderId, userName, typeCode); } else { // While the optimistic concurrency checking is disabled for the external methods, the internal methods // still need to perform the check. This ncurrency checking logic by finding the current row version to be // will bypass the coused when the internal method is called. rowVersion = ((long)(complianceOfficerRow[complianceOfficerTable.RowVersionColumn])); // Call the internal method to complete the operation. MarkThree.Guardian.Core.ComplianceOfficer.Update(adoTransaction, sqlTransaction, ref rowVersion, description, null, null, null, null, null, null, null, null, groupPermission, hidden, name, owner, ownerPermission, readOnly, worldPermission, preferences, systemFolderId, userName, complianceOfficerId, typeCode); } // Return values. parameters["rowVersion"] = rowVersion; }