示例#1
0
 /// <summary>Loads a LotHandling 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 LotHandling Table.
     ServerDataModel.LotHandlingDataTable lotHandlingTable = ServerDataModel.LotHandling;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     int lotHandlingCode = parameters["lotHandlingCode"];
     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.LotHandlingRow lotHandlingRow = lotHandlingTable.FindByLotHandlingCode(lotHandlingCode);
     if ((lotHandlingRow == null))
     {
         // Call the internal 'Insert' method to complete the operation.
         MarkThree.Quasar.Core.LotHandling.Insert(adoTransaction, sqlTransaction, ref rowVersion, lotHandlingCode, mnemonic, description, externalId0, externalId1, externalId2, externalId3);
     }
     else
     {
         // This will bypass the optimistic concurrency checking required by the internal method.
         rowVersion = ((long)(lotHandlingRow[lotHandlingTable.RowVersionColumn]));
         // Call the internal 'Update' method to complete the operation.
         MarkThree.Quasar.Core.LotHandling.Update(adoTransaction, sqlTransaction, ref rowVersion, lotHandlingCode, mnemonic, description, externalId0, externalId1, externalId2, externalId3);
     }
     // Return values
     parameters["rowVersion"] = rowVersion;
 }
示例#2
0
        /// <summary>Inserts a LotHandling record.</summary>
        /// <param name="transaction">Commits or rejects a set of commands as a unit</param>
        /// <param name="lotHandlingCode">The value for the LotHandlingCode 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 lotHandlingCode, string mnemonic, string description, object externalId0, object externalId1, object externalId2, object externalId3)
        {
            // Accessor for the LotHandling Table.
            ServerDataModel.LotHandlingDataTable lotHandlingTable = ServerDataModel.LotHandling;
            // 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.LotHandlingRow lotHandlingRow = lotHandlingTable.NewLotHandlingRow();
            lotHandlingRow[lotHandlingTable.RowVersionColumn]      = rowVersion;
            lotHandlingRow[lotHandlingTable.LotHandlingCodeColumn] = lotHandlingCode;
            lotHandlingRow[lotHandlingTable.MnemonicColumn]        = mnemonic;
            lotHandlingRow[lotHandlingTable.DescriptionColumn]     = description;
            lotHandlingRow[lotHandlingTable.ExternalId0Column]     = externalId0;
            lotHandlingRow[lotHandlingTable.ExternalId1Column]     = externalId1;
            lotHandlingRow[lotHandlingTable.ExternalId2Column]     = externalId2;
            lotHandlingRow[lotHandlingTable.ExternalId3Column]     = externalId3;
            lotHandlingTable.AddLotHandlingRow(lotHandlingRow);
            adoTransaction.DataRows.Add(lotHandlingRow);
            // Insert the record into the SQL database.
            SqlCommand sqlCommand = new SqlCommand("insert \"LotHandling\" (\"rowVersion\",\"LotHandlingCode\",\"Mnemonic\",\"Description\",\"Ex" +
                                                   "ternalId0\",\"ExternalId1\",\"ExternalId2\",\"ExternalId3\") values (@rowVersion,@lotHa" +
                                                   "ndlingCode,@mnemonic,@description,@externalId0,@externalId1,@externalId2,@extern" +
                                                   "alId3)");

            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("@lotHandlingCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, lotHandlingCode));
            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();
        }
示例#3
0
 /// <summary>Archives a LotHandling 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 LotHandling Table.
     ServerDataModel.LotHandlingDataTable lotHandlingTable = ServerDataModel.LotHandling;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     int lotHandlingCode = parameters["lotHandlingCode"];
     // 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.LotHandlingRow lotHandlingRow = lotHandlingTable.FindByLotHandlingCode(lotHandlingCode);
     rowVersion = ((long)(lotHandlingRow[lotHandlingTable.RowVersionColumn]));
     // Call the internal method to complete the operation.
     MarkThree.Quasar.Core.LotHandling.Archive(adoTransaction, sqlTransaction, rowVersion, lotHandlingCode);
 }
示例#4
0
        /// <summary>Archives a LotHandling 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="lotHandlingCode">The value for the LotHandlingCode 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 lotHandlingCode)
        {
            // Accessor for the LotHandling Table.
            ServerDataModel.LotHandlingDataTable lotHandlingTable = ServerDataModel.LotHandling;
            // Rule #1: Make sure the record exists before updating it.
            ServerDataModel.LotHandlingRow lotHandlingRow = lotHandlingTable.FindByLotHandlingCode(lotHandlingCode);
            if ((lotHandlingRow == null))
            {
                throw new Exception(string.Format("The LotHandling table does not have an element identified by {0}", lotHandlingCode));
            }
            // Rule #2: Optimistic Concurrency Check
            if ((lotHandlingRow.RowVersion != rowVersion))
            {
                throw new System.Exception("This record is busy.  Please try again later.");
            }
            // Archive the child records.
            for (int index = 0; (index < lotHandlingRow.GetAccountRows().Length); index = (index + 1))
            {
                ServerDataModel.AccountRow childAccountRow = lotHandlingRow.GetAccountRows()[index];
                Account.ArchiveChildren(adoTransaction, sqlTransaction, childAccountRow.RowVersion, childAccountRow.AccountId);
            }
            // Increment the row version
            rowVersion = ServerDataModel.RowVersion.Increment();
            // Delete the record in the ADO database.
            lotHandlingRow[lotHandlingTable.RowVersionColumn] = rowVersion;
            adoTransaction.DataRows.Add(lotHandlingRow);
            lotHandlingRow.Delete();
            // Archive the record in the SQL database.
            SqlCommand sqlCommand = new SqlCommand("update \"LotHandling\" set \"IsArchived\" = 1 where \"LotHandlingCode\"=@lotHandlingCod" +
                                                   "e");

            sqlCommand.Connection  = sqlTransaction.Connection;
            sqlCommand.Transaction = sqlTransaction;
            sqlCommand.Parameters.Add(new SqlParameter("@lotHandlingCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, lotHandlingCode));
            sqlCommand.ExecuteNonQuery();
        }
示例#5
0
 /// <summary>Updates a LotHandling 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 LotHandling Table.
     ServerDataModel.LotHandlingDataTable lotHandlingTable = ServerDataModel.LotHandling;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     string externalLotHandlingCode = parameters["lotHandlingCode"];
     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 lotHandlingCode = LotHandling.FindRequiredKey(configurationId, "lotHandlingCode", externalLotHandlingCode);
     // This will bypass the internal optimistic concurrency checking by providing the current rowVersion to the 
     // internal method.
     ServerDataModel.LotHandlingRow lotHandlingRow = lotHandlingTable.FindByLotHandlingCode(lotHandlingCode);
     rowVersion = ((long)(lotHandlingRow[lotHandlingTable.RowVersionColumn]));
     // Call the internal method to complete the operation.
     MarkThree.Quasar.Core.LotHandling.Update(adoTransaction, sqlTransaction, ref rowVersion, lotHandlingCode, mnemonic, description, null, null, null, null);
     // Return values.
     parameters["rowVersion"] = rowVersion;
 }
示例#6
0
        /// <summary>Updates a LotHandling 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="lotHandlingCode">The value for the LotHandlingCode 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 lotHandlingCode, object mnemonic, object description, object externalId0, object externalId1, object externalId2, object externalId3)
        {
            // Accessor for the LotHandling Table.
            ServerDataModel.LotHandlingDataTable lotHandlingTable = ServerDataModel.LotHandling;
            // Rule #1: Make sure the record exists before updating it.
            ServerDataModel.LotHandlingRow lotHandlingRow = lotHandlingTable.FindByLotHandlingCode(lotHandlingCode);
            if ((lotHandlingRow == null))
            {
                throw new Exception(string.Format("The LotHandling table does not have an element identified by {0}", lotHandlingCode));
            }
            // Rule #2: Optimistic Concurrency Check
            if ((lotHandlingRow.RowVersion != rowVersion))
            {
                throw new System.Exception("This record is busy.  Please try again later.");
            }
            // Apply Defaults
            if ((mnemonic == null))
            {
                mnemonic = lotHandlingRow[lotHandlingTable.MnemonicColumn];
            }
            if ((description == null))
            {
                description = lotHandlingRow[lotHandlingTable.DescriptionColumn];
            }
            if ((externalId0 == null))
            {
                externalId0 = lotHandlingRow[lotHandlingTable.ExternalId0Column];
            }
            if ((externalId1 == null))
            {
                externalId1 = lotHandlingRow[lotHandlingTable.ExternalId1Column];
            }
            if ((externalId2 == null))
            {
                externalId2 = lotHandlingRow[lotHandlingTable.ExternalId2Column];
            }
            if ((externalId3 == null))
            {
                externalId3 = lotHandlingRow[lotHandlingTable.ExternalId3Column];
            }
            // Increment the row version
            rowVersion = ServerDataModel.RowVersion.Increment();
            // Update the record in the ADO database.
            lotHandlingRow[lotHandlingTable.RowVersionColumn]  = rowVersion;
            lotHandlingRow[lotHandlingTable.MnemonicColumn]    = mnemonic;
            lotHandlingRow[lotHandlingTable.DescriptionColumn] = description;
            lotHandlingRow[lotHandlingTable.ExternalId0Column] = externalId0;
            lotHandlingRow[lotHandlingTable.ExternalId1Column] = externalId1;
            lotHandlingRow[lotHandlingTable.ExternalId2Column] = externalId2;
            lotHandlingRow[lotHandlingTable.ExternalId3Column] = externalId3;
            adoTransaction.DataRows.Add(lotHandlingRow);
            // Update the record in the SQL database.
            SqlCommand sqlCommand = new SqlCommand("update \"LotHandling\" set \"RowVersion\"=@rowVersion,\"Mnemonic\"=@mnemonic,\"Descripti" +
                                                   "on\"=@description,\"ExternalId0\"=@externalId0,\"ExternalId1\"=@externalId1,\"External" +
                                                   "Id2\"=@externalId2,\"ExternalId3\"=@externalId3 where \"LotHandlingCode\"=@lotHandlin" +
                                                   "gCode");

            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("@lotHandlingCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, lotHandlingCode));
            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();
        }