/// <summary>Loads a Blotter 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 Blotter Table. ServerDataModel.BlotterDataTable blotterTable = ServerDataModel.Blotter; // 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; string externalBlotterId = parameters["blotterId"]; object externalBlockOrderStylesheetId = parameters["blockOrderStylesheetId"].Value; object externalPlacementStylesheetId = parameters["placementStylesheetId"].Value; object externalExecutionStylesheetId = parameters["executionStylesheetId"].Value; object externalTicketStylesheetId = parameters["ticketStylesheetId"].Value; object externalAlgorithmId = parameters["algorithmId"].Value; object externalTypeCode = parameters["typeCode"].Value; string externalBlotterTypeCode = parameters["blotterTypeCode"]; object defaultBlotter = parameters["defaultBlotter"].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 int blotterId = Object.FindKey(configurationId, "blotterId", externalBlotterId); object blockOrderStylesheetId = Stylesheet.FindOptionalKey(configurationId, "blockOrderStylesheetId", externalBlockOrderStylesheetId); object placementStylesheetId = Stylesheet.FindOptionalKey(configurationId, "placementStylesheetId", externalPlacementStylesheetId); object executionStylesheetId = Stylesheet.FindOptionalKey(configurationId, "executionStylesheetId", externalExecutionStylesheetId); object ticketStylesheetId = Stylesheet.FindOptionalKey(configurationId, "ticketStylesheetId", externalTicketStylesheetId); object algorithmId = Algorithm.FindOptionalKey(configurationId, "algorithmId", externalAlgorithmId); object typeCode = Type.FindOptionalKey(configurationId, "typeCode", externalTypeCode); int blotterTypeCode = BlotterType.FindRequiredKey(configurationId, "blotterTypeCode", externalBlotterTypeCode); ServerDataModel.BlotterRow blotterRow = blotterTable.FindByBlotterId(blotterId); // 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 ((blotterRow == 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 = Blotter.GetExternalKeyIndex(configurationId, "blotterId"); object[] externalIdArray = new object[8]; externalIdArray[externalKeyIndex] = externalBlotterId; 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.Quasar.Core.Blotter.Insert(adoTransaction, sqlTransaction, ref rowVersion, description, externalId0, externalId1, externalId2, externalId3, externalId4, externalId5, externalId6, externalId7, groupPermission, hidden, name, owner, ownerPermission, readOnly, worldPermission, blockOrderStylesheetId, placementStylesheetId, executionStylesheetId, ticketStylesheetId, algorithmId, typeCode, blotterTypeCode, defaultBlotter); } 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)(blotterRow[blotterTable.RowVersionColumn])); // Call the internal method to complete the operation. MarkThree.Quasar.Core.Blotter.Update(adoTransaction, sqlTransaction, ref rowVersion, description, null, null, null, null, null, null, null, null, groupPermission, hidden, name, owner, ownerPermission, readOnly, worldPermission, blotterId, blockOrderStylesheetId, placementStylesheetId, executionStylesheetId, ticketStylesheetId, algorithmId, typeCode, blotterTypeCode, defaultBlotter); } // Return values. parameters["rowVersion"] = rowVersion; }