/// <summary>Finds a a BlotterType record using a configuration and an external identifier.</summary> /// <param name="configurationId">Specified which mappings (user id columns) to use when looking up external identifiers.</param> /// <param name="externalId">The external identifier for the record.</param> public static int FindRequiredKey(object configurationId, string parameterId, string externalId) { // Look up the internal identifier using the configuration to select the ExternalId column and the external identifier to identify the record int internalId = BlotterType.FindKey(configurationId, parameterId, externalId); if ((internalId == int.MinValue)) { throw new Exception(string.Format("The BlotterType table does not have a record identified by \'{0}\'", externalId)); } // Return the internal identifier. return internalId; }
/// <summary>Finds a a BlotterType record using a configuration and an external identifier.</summary> /// <param name="configurationId">Specified which mappings (user id columns) to use when looking up external identifiers.</param> /// <param name="externalId">The external (user supplied) identifier for the record.</param> public static object FindOptionalKey(object configurationId, string parameterId, object externalId) { // Look up the internal identifier using the the configuration to specify which ExternalId column to use as an index. object internalId = null; if ((externalId != null)) { internalId = BlotterType.FindKey(configurationId, parameterId, ((string)(externalId))); if ((((int)(internalId)) == int.MinValue)) { throw new Exception(string.Format("The BlotterType table does not have a record identified by \'{0}\'", externalId)); } } // Return the internal identifier. return internalId; }
/// <summary>Updates a Blotter record using Metadata Parameters.</summary> /// <param name="transaction">Contains the parameters and exceptions for this command.</param> public new static void Update(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; object name = parameters["name"].Value; object owner = parameters["owner"].Value; object ownerPermission = parameters["ownerPermission"].Value; object readOnly = parameters["readOnly"].Value; object worldPermission = parameters["worldPermission"].Value; string externalBlotterId = ((string)(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; object externalBlotterTypeCode = parameters["blotterTypeCode"].Value; 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.FindRequiredKey(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); object blotterTypeCode = BlotterType.FindOptionalKey(configurationId, "blotterTypeCode", externalBlotterTypeCode); // This disables the concurrency checking logic by finding the current row version and passing it to the // internal method. ServerDataModel.BlotterRow blotterRow = blotterTable.FindByBlotterId(blotterId); 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; }
/// <summary>Finds a a BlotterType record using a configuration and an external identifier.</summary> /// <param name="configurationId">Specified which mappings (user id columns) to use when looking up external identifiers.</param> /// <param name="parameterId">The name of the parameter as specified in the configuration table.</param> /// <param name="externalId">The external (user supplied) identifier for the record.</param> public static int FindKey(object configurationId, string parameterId, object externalId) { // A missing key will never match a column. if ((externalId == null)) { return int.MinValue; } // Accessor for the BlotterType Table. ServerDataModel.BlotterTypeDataTable blotterTypeTable = ServerDataModel.BlotterType; // Look for the record using the external identifier. The configuration selected the key to use, which effectively // selected the external id column to use for the search. If a record is found in the view, a translation still needs // to be made back to the original table before an index to the record can be returned to the caller. int externalKeyIndex = BlotterType.GetExternalKeyIndex(configurationId, parameterId); System.Data.DataView externalKeyView = BlotterType.externalKeyArray[externalKeyIndex]; int recordIndex = externalKeyView.Find(new object[] { externalId}); if ((recordIndex == -1)) { return int.MinValue; } return ((int)(externalKeyView[recordIndex].Row[blotterTypeTable.BlotterTypeCodeColumn])); }
/// <summary>Updates a BlotterType record using Metadata Parameters.</summary> /// <param name="transaction">Contains the parameters and exceptions for this command.</param> public static void Update(ParameterList parameters) { // Accessor for the BlotterType Table. ServerDataModel.BlotterTypeDataTable blotterTypeTable = ServerDataModel.BlotterType; // Extract the parameters from the command batch. AdoTransaction adoTransaction = parameters["adoTransaction"]; SqlTransaction sqlTransaction = parameters["sqlTransaction"]; object configurationId = parameters["configurationId"].Value; string externalBlotterTypeCode = parameters["blotterTypeCode"]; object description = parameters["description"].Value; // The row versioning is largely disabled for external operations. long rowVersion = long.MinValue; // Resolve External Identifiers int blotterTypeCode = BlotterType.FindRequiredKey(configurationId, "blotterTypeCode", externalBlotterTypeCode); // This will bypass the internal optimistic concurrency checking by providing the current rowVersion to the // internal method. ServerDataModel.BlotterTypeRow blotterTypeRow = blotterTypeTable.FindByBlotterTypeCode(blotterTypeCode); rowVersion = ((long)(blotterTypeRow[blotterTypeTable.RowVersionColumn])); // Call the internal method to complete the operation. MarkThree.Quasar.Core.BlotterType.Update(adoTransaction, sqlTransaction, ref rowVersion, blotterTypeCode, description, null, null); // Return values. parameters["rowVersion"] = rowVersion; }
/// <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; }