Beispiel #1
0
 /// <summary>Loads a OrderType record using Metadata Parameters.</summary>
 /// <param name="transaction">Contains the parameters and exceptions for this command.</param>
 public static void Load(ParameterList parameters)
 {
     // Accessor for the OrderType Table.
     ServerDataModel.OrderTypeDataTable orderTypeTable = ServerDataModel.OrderType;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     int orderTypeCode = parameters["orderTypeCode"];
     string mnemonic = parameters["mnemonic"];
     string description = parameters["description"];
     object externalId0 = parameters["externalId0"].Value;
     object externalId1 = parameters["externalId1"].Value;
     object externalId2 = parameters["externalId2"].Value;
     object externalId3 = parameters["externalId3"].Value;
     // The row versioning is largely disabled for external operations.
     long rowVersion = long.MinValue;
     // Find the record using the unique identifier.  If it doesn't exist, it will be inserted, if it does exist,
     // it will be updated.
     ServerDataModel.OrderTypeRow orderTypeRow = orderTypeTable.FindByOrderTypeCode(orderTypeCode);
     if ((orderTypeRow == null))
     {
         // Call the internal 'Insert' method to complete the operation.
         MarkThree.Quasar.Core.OrderType.Insert(adoTransaction, sqlTransaction, ref rowVersion, orderTypeCode, mnemonic, description, externalId0, externalId1, externalId2, externalId3);
     }
     else
     {
         // This will bypass the optimistic concurrency checking required by the internal method.
         rowVersion = ((long)(orderTypeRow[orderTypeTable.RowVersionColumn]));
         // Call the internal 'Update' method to complete the operation.
         MarkThree.Quasar.Core.OrderType.Update(adoTransaction, sqlTransaction, ref rowVersion, orderTypeCode, mnemonic, description, externalId0, externalId1, externalId2, externalId3);
     }
     // Return values
     parameters["rowVersion"] = rowVersion;
 }
Beispiel #2
0
        /// <summary>Inserts a OrderType record.</summary>
        /// <param name="transaction">Commits or rejects a set of commands as a unit</param>
        /// <param name="orderTypeCode">The value for the OrderTypeCode column.</param>
        /// <param name="mnemonic">The value for the Mnemonic column.</param>
        /// <param name="description">The value for the Description column.</param>
        /// <param name="externalId0">The value for the ExternalId0 column.</param>
        /// <param name="externalId1">The value for the ExternalId1 column.</param>
        /// <param name="externalId2">The value for the ExternalId2 column.</param>
        /// <param name="externalId3">The value for the ExternalId3 column.</param>
        public static void Insert(AdoTransaction adoTransaction, SqlTransaction sqlTransaction, ref long rowVersion, int orderTypeCode, string mnemonic, string description, object externalId0, object externalId1, object externalId2, object externalId3)
        {
            // Accessor for the OrderType Table.
            ServerDataModel.OrderTypeDataTable orderTypeTable = ServerDataModel.OrderType;
            // Apply Defaults
            if ((externalId0 == null))
            {
                externalId0 = System.DBNull.Value;
            }
            if ((externalId1 == null))
            {
                externalId1 = System.DBNull.Value;
            }
            if ((externalId2 == null))
            {
                externalId2 = System.DBNull.Value;
            }
            if ((externalId3 == null))
            {
                externalId3 = System.DBNull.Value;
            }
            // Increment the row version
            rowVersion = ServerDataModel.RowVersion.Increment();
            // Insert the record into the ADO database.
            ServerDataModel.OrderTypeRow orderTypeRow = orderTypeTable.NewOrderTypeRow();
            orderTypeRow[orderTypeTable.RowVersionColumn]    = rowVersion;
            orderTypeRow[orderTypeTable.OrderTypeCodeColumn] = orderTypeCode;
            orderTypeRow[orderTypeTable.MnemonicColumn]      = mnemonic;
            orderTypeRow[orderTypeTable.DescriptionColumn]   = description;
            orderTypeRow[orderTypeTable.ExternalId0Column]   = externalId0;
            orderTypeRow[orderTypeTable.ExternalId1Column]   = externalId1;
            orderTypeRow[orderTypeTable.ExternalId2Column]   = externalId2;
            orderTypeRow[orderTypeTable.ExternalId3Column]   = externalId3;
            orderTypeTable.AddOrderTypeRow(orderTypeRow);
            adoTransaction.DataRows.Add(orderTypeRow);
            // Insert the record into the SQL database.
            SqlCommand sqlCommand = new SqlCommand("insert \"OrderType\" (\"rowVersion\",\"OrderTypeCode\",\"Mnemonic\",\"Description\",\"Extern" +
                                                   "alId0\",\"ExternalId1\",\"ExternalId2\",\"ExternalId3\") values (@rowVersion,@orderType" +
                                                   "Code,@mnemonic,@description,@externalId0,@externalId1,@externalId2,@externalId3)" +
                                                   "");

            sqlCommand.Connection  = sqlTransaction.Connection;
            sqlCommand.Transaction = sqlTransaction;
            sqlCommand.Parameters.Add(new SqlParameter("@rowVersion", SqlDbType.BigInt, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rowVersion));
            sqlCommand.Parameters.Add(new SqlParameter("@orderTypeCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, orderTypeCode));
            sqlCommand.Parameters.Add(new SqlParameter("@mnemonic", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, mnemonic));
            sqlCommand.Parameters.Add(new SqlParameter("@description", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, description));
            sqlCommand.Parameters.Add(new SqlParameter("@externalId0", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, externalId0));
            sqlCommand.Parameters.Add(new SqlParameter("@externalId1", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, externalId1));
            sqlCommand.Parameters.Add(new SqlParameter("@externalId2", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, externalId2));
            sqlCommand.Parameters.Add(new SqlParameter("@externalId3", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, externalId3));
            sqlCommand.ExecuteNonQuery();
        }
Beispiel #3
0
 /// <summary>Initializes the static elements of an Object.</summary>
 static OrderType()
 {
     // The table must be locked before the indices can be read into an accelerator array.
     ServerDataModel.OrderTypeLock.AcquireReaderLock(System.Threading.Timeout.Infinite);
     // Accessor for the OrderType Table.
     ServerDataModel.OrderTypeDataTable orderTypeTable = ServerDataModel.OrderType;
     // This does an indirect lookup operation using the views created for the ExternalId columns.  Take the index of the user
     // identifier column calcualted above and use it to find a record containing the external identifier.
     OrderType.externalKeyArray = new DataView[] {
             orderTypeTable.UKOrderTypeExternalId0,
             orderTypeTable.UKOrderTypeExternalId1,
             orderTypeTable.UKOrderTypeExternalId2,
             orderTypeTable.UKOrderTypeExternalId3};
     // The table must be released after the array is constructed.
     ServerDataModel.OrderTypeLock.ReleaseReaderLock();
 }
Beispiel #4
0
 /// <summary>Archives a OrderType record using Metadata Parameters.</summary>
 /// <param name="transaction">Contains the parameters and exceptions for this command.</param>
 public static void Archive(ParameterList parameters)
 {
     // Accessor for the OrderType Table.
     ServerDataModel.OrderTypeDataTable orderTypeTable = ServerDataModel.OrderType;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     int orderTypeCode = parameters["orderTypeCode"];
     // The row versioning is largely disabled for external operations.
     long rowVersion = long.MinValue;
     // 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.
     ServerDataModel.OrderTypeRow orderTypeRow = orderTypeTable.FindByOrderTypeCode(orderTypeCode);
     rowVersion = ((long)(orderTypeRow[orderTypeTable.RowVersionColumn]));
     // Call the internal method to complete the operation.
     MarkThree.Quasar.Core.OrderType.Archive(adoTransaction, sqlTransaction, rowVersion, orderTypeCode);
 }
Beispiel #5
0
        /// <summary>Archives a OrderType record.</summary>
        /// <param name="transaction">Commits or rejects a set of commands as a unit</param>
        /// <param name="RowVersion">The version number of this row.</param>
        /// <param name="orderTypeCode">The value for the OrderTypeCode column.</param>
        /// <param name="archive">true to archive the object, false to unarchive it.</param>
        public static void Archive(AdoTransaction adoTransaction, SqlTransaction sqlTransaction, long rowVersion, int orderTypeCode)
        {
            // Accessor for the OrderType Table.
            ServerDataModel.OrderTypeDataTable orderTypeTable = ServerDataModel.OrderType;
            // Rule #1: Make sure the record exists before updating it.
            ServerDataModel.OrderTypeRow orderTypeRow = orderTypeTable.FindByOrderTypeCode(orderTypeCode);
            if ((orderTypeRow == null))
            {
                throw new Exception(string.Format("The OrderType table does not have an element identified by {0}", orderTypeCode));
            }
            // Rule #2: Optimistic Concurrency Check
            if ((orderTypeRow.RowVersion != rowVersion))
            {
                throw new System.Exception("This record is busy.  Please try again later.");
            }
            // Archive the child records.
            for (int index = 0; (index < orderTypeRow.GetOrderRows().Length); index = (index + 1))
            {
                ServerDataModel.OrderRow childOrderRow = orderTypeRow.GetOrderRows()[index];
                Order.Archive(adoTransaction, sqlTransaction, childOrderRow.RowVersion, childOrderRow.OrderId);
            }
            for (int index = 0; (index < orderTypeRow.GetPlacementRows().Length); index = (index + 1))
            {
                ServerDataModel.PlacementRow childPlacementRow = orderTypeRow.GetPlacementRows()[index];
                Placement.Archive(adoTransaction, sqlTransaction, childPlacementRow.RowVersion, childPlacementRow.PlacementId);
            }
            // Increment the row version
            rowVersion = ServerDataModel.RowVersion.Increment();
            // Delete the record in the ADO database.
            orderTypeRow[orderTypeTable.RowVersionColumn] = rowVersion;
            adoTransaction.DataRows.Add(orderTypeRow);
            orderTypeRow.Delete();
            // Archive the record in the SQL database.
            SqlCommand sqlCommand = new SqlCommand("update \"OrderType\" set \"IsArchived\" = 1 where \"OrderTypeCode\"=@orderTypeCode");

            sqlCommand.Connection  = sqlTransaction.Connection;
            sqlCommand.Transaction = sqlTransaction;
            sqlCommand.Parameters.Add(new SqlParameter("@orderTypeCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, orderTypeCode));
            sqlCommand.ExecuteNonQuery();
        }
Beispiel #6
0
 /// <summary>Finds a a OrderType 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 OrderType Table.
     ServerDataModel.OrderTypeDataTable orderTypeTable = ServerDataModel.OrderType;
     // 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 = OrderType.GetExternalKeyIndex(configurationId, parameterId);
     System.Data.DataView externalKeyView = OrderType.externalKeyArray[externalKeyIndex];
     int recordIndex = externalKeyView.Find(new object[] {
                 externalId});
     if ((recordIndex == -1))
     {
         return int.MinValue;
     }
     return ((int)(externalKeyView[recordIndex].Row[orderTypeTable.OrderTypeCodeColumn]));
 }
Beispiel #7
0
 /// <summary>Updates a OrderType 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 OrderType Table.
     ServerDataModel.OrderTypeDataTable orderTypeTable = ServerDataModel.OrderType;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     string externalOrderTypeCode = parameters["orderTypeCode"];
     object mnemonic = parameters["mnemonic"].Value;
     object description = parameters["description"].Value;
     // The row versioning is largely disabled for external operations.
     long rowVersion = long.MinValue;
     // Resolve External Identifiers
     int orderTypeCode = OrderType.FindRequiredKey(configurationId, "orderTypeCode", externalOrderTypeCode);
     // This will bypass the internal optimistic concurrency checking by providing the current rowVersion to the 
     // internal method.
     ServerDataModel.OrderTypeRow orderTypeRow = orderTypeTable.FindByOrderTypeCode(orderTypeCode);
     rowVersion = ((long)(orderTypeRow[orderTypeTable.RowVersionColumn]));
     // Call the internal method to complete the operation.
     MarkThree.Quasar.Core.OrderType.Update(adoTransaction, sqlTransaction, ref rowVersion, orderTypeCode, mnemonic, description, null, null, null, null);
     // Return values.
     parameters["rowVersion"] = rowVersion;
 }
Beispiel #8
0
        /// <summary>Updates a OrderType record.</summary>
        /// <param name="transaction">Commits or rejects a set of commands as a unit</param>
        /// <param name="rowVersion">The version number of the row</param>
        /// <param name="orderTypeCode">The value for the OrderTypeCode column.</param>
        /// <param name="mnemonic">The value for the Mnemonic column.</param>
        /// <param name="description">The value for the Description column.</param>
        /// <param name="externalId0">The value for the ExternalId0 column.</param>
        /// <param name="externalId1">The value for the ExternalId1 column.</param>
        /// <param name="externalId2">The value for the ExternalId2 column.</param>
        /// <param name="externalId3">The value for the ExternalId3 column.</param>
        public static void Update(AdoTransaction adoTransaction, SqlTransaction sqlTransaction, ref long rowVersion, int orderTypeCode, object mnemonic, object description, object externalId0, object externalId1, object externalId2, object externalId3)
        {
            // Accessor for the OrderType Table.
            ServerDataModel.OrderTypeDataTable orderTypeTable = ServerDataModel.OrderType;
            // Rule #1: Make sure the record exists before updating it.
            ServerDataModel.OrderTypeRow orderTypeRow = orderTypeTable.FindByOrderTypeCode(orderTypeCode);
            if ((orderTypeRow == null))
            {
                throw new Exception(string.Format("The OrderType table does not have an element identified by {0}", orderTypeCode));
            }
            // Rule #2: Optimistic Concurrency Check
            if ((orderTypeRow.RowVersion != rowVersion))
            {
                throw new System.Exception("This record is busy.  Please try again later.");
            }
            // Apply Defaults
            if ((mnemonic == null))
            {
                mnemonic = orderTypeRow[orderTypeTable.MnemonicColumn];
            }
            if ((description == null))
            {
                description = orderTypeRow[orderTypeTable.DescriptionColumn];
            }
            if ((externalId0 == null))
            {
                externalId0 = orderTypeRow[orderTypeTable.ExternalId0Column];
            }
            if ((externalId1 == null))
            {
                externalId1 = orderTypeRow[orderTypeTable.ExternalId1Column];
            }
            if ((externalId2 == null))
            {
                externalId2 = orderTypeRow[orderTypeTable.ExternalId2Column];
            }
            if ((externalId3 == null))
            {
                externalId3 = orderTypeRow[orderTypeTable.ExternalId3Column];
            }
            // Increment the row version
            rowVersion = ServerDataModel.RowVersion.Increment();
            // Update the record in the ADO database.
            orderTypeRow[orderTypeTable.RowVersionColumn]  = rowVersion;
            orderTypeRow[orderTypeTable.MnemonicColumn]    = mnemonic;
            orderTypeRow[orderTypeTable.DescriptionColumn] = description;
            orderTypeRow[orderTypeTable.ExternalId0Column] = externalId0;
            orderTypeRow[orderTypeTable.ExternalId1Column] = externalId1;
            orderTypeRow[orderTypeTable.ExternalId2Column] = externalId2;
            orderTypeRow[orderTypeTable.ExternalId3Column] = externalId3;
            adoTransaction.DataRows.Add(orderTypeRow);
            // Update the record in the SQL database.
            SqlCommand sqlCommand = new SqlCommand("update \"OrderType\" set \"RowVersion\"=@rowVersion,\"Mnemonic\"=@mnemonic,\"Description" +
                                                   "\"=@description,\"ExternalId0\"=@externalId0,\"ExternalId1\"=@externalId1,\"ExternalId" +
                                                   "2\"=@externalId2,\"ExternalId3\"=@externalId3 where \"OrderTypeCode\"=@orderTypeCode");

            sqlCommand.Connection  = sqlTransaction.Connection;
            sqlCommand.Transaction = sqlTransaction;
            sqlCommand.Parameters.Add(new SqlParameter("@rowVersion", SqlDbType.BigInt, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rowVersion));
            sqlCommand.Parameters.Add(new SqlParameter("@orderTypeCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, orderTypeCode));
            sqlCommand.Parameters.Add(new SqlParameter("@mnemonic", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, mnemonic));
            sqlCommand.Parameters.Add(new SqlParameter("@description", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, description));
            sqlCommand.Parameters.Add(new SqlParameter("@externalId0", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, externalId0));
            sqlCommand.Parameters.Add(new SqlParameter("@externalId1", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, externalId1));
            sqlCommand.Parameters.Add(new SqlParameter("@externalId2", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, externalId2));
            sqlCommand.Parameters.Add(new SqlParameter("@externalId3", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, externalId3));
            // Update the record in the SQL database.
            sqlCommand.ExecuteNonQuery();
        }