示例#1
0
 /// <summary>Updates a Holiday 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 Holiday Table.
     ServerMarketData.HolidayDataTable holidayTable = ServerMarketData.Holiday;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     object externalCountryId = parameters["countryId"].Value;
     object date = parameters["date"].Value;
     string externalHolidayId = ((string)(parameters["holidayId"]));
     object externalHolidayTypeCode = parameters["holidayTypeCode"].Value;
     // The row versioning is largely disabled for external operations.
     long rowVersion = long.MinValue;
     // Resolve External Identifiers
     object countryId = Country.FindOptionalKey(configurationId, "countryId", externalCountryId);
     int holidayId = Holiday.FindRequiredKey(configurationId, "holidayId", externalHolidayId);
     object holidayTypeCode = HolidayType.FindOptionalKey(configurationId, "holidayTypeCode", externalHolidayTypeCode);
     // 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.
     ServerMarketData.HolidayRow holidayRow = holidayTable.FindByHolidayId(holidayId);
     rowVersion = ((long)(holidayRow[holidayTable.RowVersionColumn]));
     // Call the internal method to complete the operation.
     MarkThree.Guardian.Core.Holiday.Update(adoTransaction, sqlTransaction, ref rowVersion, countryId, date, null, null, holidayId, holidayTypeCode);
     // Return values.
     parameters["rowVersion"] = rowVersion;
 }
示例#2
0
        /// <summary>Archives a Holiday 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="holidayId">The value for the HolidayId 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 holidayId)
        {
            // Accessor for the Holiday Table.
            ServerMarketData.HolidayDataTable holidayTable = ServerMarketData.Holiday;
            // Rule #1: Make sure the record exists before updating it.
            ServerMarketData.HolidayRow holidayRow = holidayTable.FindByHolidayId(holidayId);
            if ((holidayRow == null))
            {
                throw new Exception(string.Format("The Holiday table does not have an element identified by {0}", holidayId));
            }
            // Rule #2: Optimistic Concurrency Check
            if ((holidayRow.RowVersion != rowVersion))
            {
                throw new System.Exception("This record is busy.  Please try again later.");
            }
            // Archive the child records.
            // Increment the row version
            rowVersion = ServerMarketData.RowVersion.Increment();
            // Delete the record in the ADO database.
            holidayRow[holidayTable.RowVersionColumn] = rowVersion;
            adoTransaction.DataRows.Add(holidayRow);
            holidayRow.Delete();
            // Archive the record in the SQL database.
            SqlCommand sqlCommand = new SqlCommand("update \"Holiday\" set \"IsArchived\" = 1 where \"HolidayId\"=@holidayId");

            sqlCommand.Connection  = sqlTransaction.Connection;
            sqlCommand.Transaction = sqlTransaction;
            sqlCommand.Parameters.Add(new SqlParameter("@holidayId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, holidayId));
            sqlCommand.ExecuteNonQuery();
        }
示例#3
0
        /// <summary>Archives a Country 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="countryId">The value for the CountryId 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 countryId)
        {
            // Accessor for the Country Table.
            ServerMarketData.CountryDataTable countryTable = ServerMarketData.Country;
            // Rule #1: Make sure the record exists before updating it.
            ServerMarketData.CountryRow countryRow = countryTable.FindByCountryId(countryId);
            if ((countryRow == null))
            {
                throw new Exception(string.Format("The Country table does not have an element identified by {0}", countryId));
            }
            // Rule #2: Optimistic Concurrency Check
            if ((countryRow.RowVersion != rowVersion))
            {
                throw new System.Exception("This record is busy.  Please try again later.");
            }
            // Archive the child records.
            for (int index = 0; (index < countryRow.GetAccountBaseRows().Length); index = (index + 1))
            {
                ServerMarketData.AccountBaseRow childAccountBaseRow = countryRow.GetAccountBaseRows()[index];
                AccountBase.ArchiveChildren(adoTransaction, sqlTransaction, childAccountBaseRow.RowVersion, childAccountBaseRow.AccountBaseId);
            }
            for (int index = 0; (index < countryRow.GetHolidayRows().Length); index = (index + 1))
            {
                ServerMarketData.HolidayRow childHolidayRow = countryRow.GetHolidayRows()[index];
                Holiday.Archive(adoTransaction, sqlTransaction, childHolidayRow.RowVersion, childHolidayRow.HolidayId);
            }
            for (int index = 0; (index < countryRow.GetProvinceRows().Length); index = (index + 1))
            {
                ServerMarketData.ProvinceRow childProvinceRow = countryRow.GetProvinceRows()[index];
                Province.Archive(adoTransaction, sqlTransaction, childProvinceRow.RowVersion, childProvinceRow.ProvinceId);
            }
            for (int index = 0; (index < countryRow.GetSecurityRows().Length); index = (index + 1))
            {
                ServerMarketData.SecurityRow childSecurityRow = countryRow.GetSecurityRows()[index];
                Security.ArchiveChildren(adoTransaction, sqlTransaction, childSecurityRow.RowVersion, childSecurityRow.SecurityId);
            }
            // Increment the row version
            rowVersion = ServerMarketData.RowVersion.Increment();
            // Delete the record in the ADO database.
            countryRow[countryTable.RowVersionColumn] = rowVersion;
            adoTransaction.DataRows.Add(countryRow);
            countryRow.Delete();
            // Archive the record in the SQL database.
            SqlCommand sqlCommand = new SqlCommand("update \"Country\" set \"IsArchived\" = 1 where \"CountryId\"=@countryId");

            sqlCommand.Connection  = sqlTransaction.Connection;
            sqlCommand.Transaction = sqlTransaction;
            sqlCommand.Parameters.Add(new SqlParameter("@countryId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, countryId));
            sqlCommand.ExecuteNonQuery();
        }
示例#4
0
 /// <summary>Loads a Holiday 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 Holiday Table.
     ServerMarketData.HolidayDataTable holidayTable = ServerMarketData.Holiday;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     string externalCountryId = parameters["countryId"];
     System.DateTime date = parameters["date"];
     object externalId0 = parameters["externalId0"].Value;
     object externalId1 = parameters["externalId1"].Value;
     object externalHolidayId = parameters["holidayId"].Value;
     string externalHolidayTypeCode = parameters["holidayTypeCode"];
     // 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);
     int holidayId = Holiday.FindKey(configurationId, "holidayId", externalHolidayId);
     int holidayTypeCode = HolidayType.FindRequiredKey(configurationId, "holidayTypeCode", externalHolidayTypeCode);
     // 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 ((holidayId == int.MinValue))
     {
         // 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 = Holiday.GetExternalKeyIndex(configurationId, "holidayId");
         object[] externalIdArray = new object[2];
         externalIdArray[externalKeyIndex] = externalHolidayId;
         externalId0 = externalIdArray[0];
         externalId1 = externalIdArray[1];
         // Call the internal method to complete the operation.
         MarkThree.Guardian.Core.Holiday.Insert(adoTransaction, sqlTransaction, ref rowVersion, countryId, date, externalId0, externalId1, holidayTypeCode);
     }
     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.
         ServerMarketData.HolidayRow holidayRow = holidayTable.FindByHolidayId(holidayId);
         rowVersion = ((long)(holidayRow[holidayTable.RowVersionColumn]));
         // Call the internal method to complete the operation.
         MarkThree.Guardian.Core.Holiday.Update(adoTransaction, sqlTransaction, ref rowVersion, countryId, date, externalId0, externalId1, holidayId, holidayTypeCode);
     }
     // Return values.
     parameters["rowVersion"] = rowVersion;
 }
示例#5
0
        /// <summary>Inserts a Holiday record.</summary>
        /// <param name="transaction">Commits or rejects a set of commands as a unit</param>
        /// <param name="countryId">The value for the CountryId column.</param>
        /// <param name="date">The value for the Date column.</param>
        /// <param name="externalId0">The value for the ExternalId0 column.</param>
        /// <param name="externalId1">The value for the ExternalId1 column.</param>
        /// <param name="holidayTypeCode">The value for the HolidayTypeCode column.</param>
        public static int Insert(AdoTransaction adoTransaction, SqlTransaction sqlTransaction, ref long rowVersion, int countryId, System.DateTime date, object externalId0, object externalId1, int holidayTypeCode)
        {
            // Accessor for the Holiday Table.
            ServerMarketData.HolidayDataTable holidayTable = ServerMarketData.Holiday;
            // Apply Defaults
            if ((externalId0 == null))
            {
                externalId0 = System.DBNull.Value;
            }
            if ((externalId1 == null))
            {
                externalId1 = System.DBNull.Value;
            }
            // Increment the row version
            rowVersion = ServerMarketData.RowVersion.Increment();
            // Insert the record into the ADO database.
            ServerMarketData.HolidayRow holidayRow = holidayTable.NewHolidayRow();
            holidayRow[holidayTable.RowVersionColumn]      = rowVersion;
            holidayRow[holidayTable.CountryIdColumn]       = countryId;
            holidayRow[holidayTable.DateColumn]            = date;
            holidayRow[holidayTable.ExternalId0Column]     = externalId0;
            holidayRow[holidayTable.ExternalId1Column]     = externalId1;
            holidayRow[holidayTable.HolidayTypeCodeColumn] = holidayTypeCode;
            holidayTable.AddHolidayRow(holidayRow);
            adoTransaction.DataRows.Add(holidayRow);
            // Insert the record into the SQL database.
            SqlCommand sqlCommand = new SqlCommand("insert \"Holiday\" (\"rowVersion\",\"CountryId\",\"Date\",\"ExternalId0\",\"ExternalId1\",\"Ho" +
                                                   "lidayId\",\"HolidayTypeCode\") values (@rowVersion,@countryId,@date,@externalId0,@e" +
                                                   "xternalId1,@holidayId,@holidayTypeCode)");

            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("@countryId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, countryId));
            sqlCommand.Parameters.Add(new SqlParameter("@date", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, date));
            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("@holidayId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, holidayRow[holidayTable.HolidayIdColumn]));
            sqlCommand.Parameters.Add(new SqlParameter("@holidayTypeCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, holidayTypeCode));
            sqlCommand.ExecuteNonQuery();
            // Return Statements
            return(holidayRow.HolidayId);
        }
示例#6
0
 /// <summary>Archives a Holiday 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 Holiday Table.
     ServerMarketData.HolidayDataTable holidayTable = ServerMarketData.Holiday;
     // Extract the parameters from the command batch.
     AdoTransaction adoTransaction = parameters["adoTransaction"];
     SqlTransaction sqlTransaction = parameters["sqlTransaction"];
     object configurationId = parameters["configurationId"].Value;
     string externalHolidayId = parameters["holidayId"];
     // The row versioning is largely disabled for external operations.
     long rowVersion = long.MinValue;
     // Find the internal identifier using the primar key elements.
     // identifier is used to determine if a record exists with the same key.
     int holidayId = Holiday.FindRequiredKey(configurationId, "holidayId", externalHolidayId);
     // 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.
     ServerMarketData.HolidayRow holidayRow = holidayTable.FindByHolidayId(holidayId);
     rowVersion = ((long)(holidayRow[holidayTable.RowVersionColumn]));
     // Call the internal method to complete the operation.
     MarkThree.Guardian.Core.Holiday.Archive(adoTransaction, sqlTransaction, rowVersion, holidayId);
 }
示例#7
0
        /// <summary>Updates a Holiday 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="countryId">The value for the CountryId column.</param>
        /// <param name="date">The value for the Date column.</param>
        /// <param name="externalId0">The value for the ExternalId0 column.</param>
        /// <param name="externalId1">The value for the ExternalId1 column.</param>
        /// <param name="holidayId">The value for the HolidayId column.</param>
        /// <param name="holidayTypeCode">The value for the HolidayTypeCode column.</param>
        public static void Update(AdoTransaction adoTransaction, SqlTransaction sqlTransaction, ref long rowVersion, object countryId, object date, object externalId0, object externalId1, int holidayId, object holidayTypeCode)
        {
            // Accessor for the Holiday Table.
            ServerMarketData.HolidayDataTable holidayTable = ServerMarketData.Holiday;
            // Rule #1: Make sure the record exists before updating it.
            ServerMarketData.HolidayRow holidayRow = holidayTable.FindByHolidayId(holidayId);
            if ((holidayRow == null))
            {
                throw new Exception(string.Format("The Holiday table does not have an element identified by {0}", holidayId));
            }
            // Rule #2: Optimistic Concurrency Check
            if ((holidayRow.RowVersion != rowVersion))
            {
                throw new System.Exception("This record is busy.  Please try again later.");
            }
            // Apply Defaults
            if ((countryId == null))
            {
                countryId = holidayRow[holidayTable.CountryIdColumn];
            }
            if ((date == null))
            {
                date = holidayRow[holidayTable.DateColumn];
            }
            if ((externalId0 == null))
            {
                externalId0 = holidayRow[holidayTable.ExternalId0Column];
            }
            if ((externalId1 == null))
            {
                externalId1 = holidayRow[holidayTable.ExternalId1Column];
            }
            if ((holidayTypeCode == null))
            {
                holidayTypeCode = holidayRow[holidayTable.HolidayTypeCodeColumn];
            }
            // Increment the row version
            rowVersion = ServerMarketData.RowVersion.Increment();
            // Update the record in the ADO database.
            holidayRow[holidayTable.RowVersionColumn]      = rowVersion;
            holidayRow[holidayTable.CountryIdColumn]       = countryId;
            holidayRow[holidayTable.DateColumn]            = date;
            holidayRow[holidayTable.ExternalId0Column]     = externalId0;
            holidayRow[holidayTable.ExternalId1Column]     = externalId1;
            holidayRow[holidayTable.HolidayTypeCodeColumn] = holidayTypeCode;
            adoTransaction.DataRows.Add(holidayRow);
            // Update the record in the SQL database.
            SqlCommand sqlCommand = new SqlCommand("update \"Holiday\" set \"RowVersion\"=@rowVersion,\"CountryId\"=@countryId,\"Date\"=@date" +
                                                   ",\"ExternalId0\"=@externalId0,\"ExternalId1\"=@externalId1,\"HolidayTypeCode\"=@holida" +
                                                   "yTypeCode where \"HolidayId\"=@holidayId");

            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("@countryId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, countryId));
            sqlCommand.Parameters.Add(new SqlParameter("@date", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, date));
            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("@holidayId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, holidayId));
            sqlCommand.Parameters.Add(new SqlParameter("@holidayTypeCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, holidayTypeCode));
            // Update the record in the SQL database.
            sqlCommand.ExecuteNonQuery();
        }