/// <summary>Updates a EquityType 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 EquityType Table. ServerDataModel.EquityTypeDataTable equityTypeTable = ServerDataModel.EquityType; // Extract the parameters from the command batch. AdoTransaction adoTransaction = parameters["adoTransaction"]; SqlTransaction sqlTransaction = parameters["sqlTransaction"]; object configurationId = parameters["configurationId"].Value; string externalEquityTypeCode = parameters["equityTypeCode"]; object description = parameters["description"].Value; // The row versioning is largely disabled for external operations. long rowVersion = long.MinValue; // Resolve External Identifiers int equityTypeCode = EquityType.FindRequiredKey(configurationId, "equityTypeCode", externalEquityTypeCode); // This will bypass the internal optimistic concurrency checking by providing the current rowVersion to the // internal method. ServerDataModel.EquityTypeRow equityTypeRow = equityTypeTable.FindByEquityTypeCode(equityTypeCode); rowVersion = ((long)(equityTypeRow[equityTypeTable.RowVersionColumn])); // Call the internal method to complete the operation. MarkThree.Quasar.Core.EquityType.Update(adoTransaction, sqlTransaction, ref rowVersion, equityTypeCode, description, null, null, null, null); // Return values. parameters["rowVersion"] = rowVersion; }
/// <summary>Loads a Equity 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 Equity Table. ServerDataModel.EquityDataTable equityTable = ServerDataModel.Equity; // 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 externalCountryId = parameters["countryId"]; object externalTypeCode = parameters["typeCode"].Value; object symbol = parameters["symbol"].Value; string externalEquityId = parameters["equityId"]; object issuerId = parameters["issuerId"].Value; object externalExchangeId = parameters["exchangeId"].Value; string externalSettlementId = parameters["settlementId"]; object externalSecurityTypeCode = parameters["securityTypeCode"].Value; string externalEquityTypeCode = parameters["equityTypeCode"]; object priceFactor = parameters["priceFactor"].Value; object quantityFactor = parameters["quantityFactor"].Value; object sharesOutstanding = parameters["sharesOutstanding"].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 countryId = Country.FindRequiredKey(configurationId, "countryId", externalCountryId); object typeCode = Type.FindOptionalKey(configurationId, "typeCode", externalTypeCode); int equityId = Security.FindKey(configurationId, "equityId", externalEquityId); object exchangeId = Exchange.FindOptionalKey(configurationId, "exchangeId", externalExchangeId); int settlementId = Security.FindRequiredKey(configurationId, "settlementId", externalSettlementId); object securityTypeCode = SecurityType.FindOptionalKey(configurationId, "securityTypeCode", externalSecurityTypeCode); int equityTypeCode = EquityType.FindRequiredKey(configurationId, "equityTypeCode", externalEquityTypeCode); ServerDataModel.EquityRow equityRow = equityTable.FindByEquityId(equityId); // 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 ((equityRow == 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 = Equity.GetExternalKeyIndex(configurationId, "equityId"); object[] externalIdArray = new object[8]; externalIdArray[externalKeyIndex] = externalEquityId; 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.Equity.Insert(adoTransaction, sqlTransaction, ref rowVersion, description, externalId0, externalId1, externalId2, externalId3, externalId4, externalId5, externalId6, externalId7, groupPermission, hidden, name, owner, ownerPermission, readOnly, worldPermission, countryId, typeCode, symbol, issuerId, exchangeId, settlementId, securityTypeCode, equityTypeCode, priceFactor, quantityFactor, sharesOutstanding); } 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)(equityRow[equityTable.RowVersionColumn])); // Call the internal method to complete the operation. MarkThree.Quasar.Core.Equity.Update(adoTransaction, sqlTransaction, ref rowVersion, description, null, null, null, null, null, null, null, null, groupPermission, hidden, name, owner, ownerPermission, readOnly, worldPermission, countryId, typeCode, symbol, equityId, issuerId, exchangeId, settlementId, securityTypeCode, equityTypeCode, priceFactor, quantityFactor, sharesOutstanding); } // Return values. parameters["rowVersion"] = rowVersion; }