/// <summary>Updates a Stylesheet 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 Stylesheet Table.
ServerMarketData.StylesheetDataTable stylesheetTable = ServerMarketData.Stylesheet;
// Extract the parameters from the command batch.
AdoTransaction adoTransaction = parameters["adoTransaction"];
SqlTransaction sqlTransaction = parameters["sqlTransaction"];
object configurationId = parameters["configurationId"].Value;
object name = parameters["name"].Value;
string externalStylesheetId = ((string)(parameters["stylesheetId"]));
object externalStylesheetTypeCode = parameters["stylesheetTypeCode"].Value;
object text = parameters["text"].Value;
// The row versioning is largely disabled for external operations.
long rowVersion = long.MinValue;
// Resolve External Identifiers
int stylesheetId = Stylesheet.FindRequiredKey(configurationId, "stylesheetId", externalStylesheetId);
object stylesheetTypeCode = StylesheetType.FindOptionalKey(configurationId, "stylesheetTypeCode", externalStylesheetTypeCode);
// 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.StylesheetRow stylesheetRow = stylesheetTable.FindByStylesheetId(stylesheetId);
rowVersion = ((long)(stylesheetRow[stylesheetTable.RowVersionColumn]));
// Call the internal method to complete the operation.
MarkThree.Guardian.Core.Stylesheet.Update(adoTransaction, sqlTransaction, ref rowVersion, null, null, name, stylesheetId, stylesheetTypeCode, text);
// Return values.
parameters["rowVersion"] = rowVersion;
}
/// <summary>Loads a Stylesheet 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 Stylesheet Table.
ServerMarketData.StylesheetDataTable stylesheetTable = ServerMarketData.Stylesheet;
// Extract the parameters from the command batch.
AdoTransaction adoTransaction = parameters["adoTransaction"];
SqlTransaction sqlTransaction = parameters["sqlTransaction"];
object configurationId = parameters["configurationId"].Value;
object externalId0 = parameters["externalId0"].Value;
object externalId1 = parameters["externalId1"].Value;
string name = parameters["name"];
object externalStylesheetId = parameters["stylesheetId"].Value;
string externalStylesheetTypeCode = parameters["stylesheetTypeCode"];
string text = parameters["text"];
// 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 stylesheetId = Stylesheet.FindKey(configurationId, "stylesheetId", externalStylesheetId);
int stylesheetTypeCode = StylesheetType.FindRequiredKey(configurationId, "stylesheetTypeCode", externalStylesheetTypeCode);
// 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 ((stylesheetId == 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 = Stylesheet.GetExternalKeyIndex(configurationId, "stylesheetId");
object[] externalIdArray = new object[2];
externalIdArray[externalKeyIndex] = externalStylesheetId;
externalId0 = externalIdArray[0];
externalId1 = externalIdArray[1];
// Call the internal method to complete the operation.
MarkThree.Guardian.Core.Stylesheet.Insert(adoTransaction, sqlTransaction, ref rowVersion, externalId0, externalId1, name, stylesheetTypeCode, text);
}
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.StylesheetRow stylesheetRow = stylesheetTable.FindByStylesheetId(stylesheetId);
rowVersion = ((long)(stylesheetRow[stylesheetTable.RowVersionColumn]));
// Call the internal method to complete the operation.
MarkThree.Guardian.Core.Stylesheet.Update(adoTransaction, sqlTransaction, ref rowVersion, externalId0, externalId1, name, stylesheetId, stylesheetTypeCode, text);
}
// Return values.
parameters["rowVersion"] = rowVersion;
}
/// <summary>Inserts a Stylesheet record.</summary>
/// <param name="transaction">Commits or rejects a set of commands as a unit</param>
/// <param name="externalId0">The value for the ExternalId0 column.</param>
/// <param name="externalId1">The value for the ExternalId1 column.</param>
/// <param name="name">The value for the Name column.</param>
/// <param name="stylesheetTypeCode">The value for the StylesheetTypeCode column.</param>
/// <param name="text">The value for the Text column.</param>
public static int Insert(AdoTransaction adoTransaction, SqlTransaction sqlTransaction, ref long rowVersion, object externalId0, object externalId1, string name, int stylesheetTypeCode, string text)
{
// Accessor for the Stylesheet Table.
ServerMarketData.StylesheetDataTable stylesheetTable = ServerMarketData.Stylesheet;
// 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.StylesheetRow stylesheetRow = stylesheetTable.NewStylesheetRow();
stylesheetRow[stylesheetTable.RowVersionColumn] = rowVersion;
stylesheetRow[stylesheetTable.ExternalId0Column] = externalId0;
stylesheetRow[stylesheetTable.ExternalId1Column] = externalId1;
stylesheetRow[stylesheetTable.NameColumn] = name;
stylesheetRow[stylesheetTable.StylesheetTypeCodeColumn] = stylesheetTypeCode;
stylesheetRow[stylesheetTable.TextColumn] = text;
stylesheetTable.AddStylesheetRow(stylesheetRow);
adoTransaction.DataRows.Add(stylesheetRow);
// Insert the record into the SQL database.
SqlCommand sqlCommand = new SqlCommand("insert \"Stylesheet\" (\"rowVersion\",\"ExternalId0\",\"ExternalId1\",\"Name\",\"StylesheetI" +
"d\",\"StylesheetTypeCode\",\"Text\") values (@rowVersion,@externalId0,@externalId1,@n" +
"ame,@stylesheetId,@stylesheetTypeCode,@text)");
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("@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("@name", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, name));
sqlCommand.Parameters.Add(new SqlParameter("@stylesheetId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, stylesheetRow[stylesheetTable.StylesheetIdColumn]));
sqlCommand.Parameters.Add(new SqlParameter("@stylesheetTypeCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, stylesheetTypeCode));
sqlCommand.Parameters.Add(new SqlParameter("@text", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, text));
sqlCommand.ExecuteNonQuery();
// Return Statements
return(stylesheetRow.StylesheetId);
}
/// <summary>Archives a Stylesheet 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 Stylesheet Table.
ServerMarketData.StylesheetDataTable stylesheetTable = ServerMarketData.Stylesheet;
// Extract the parameters from the command batch.
AdoTransaction adoTransaction = parameters["adoTransaction"];
SqlTransaction sqlTransaction = parameters["sqlTransaction"];
object configurationId = parameters["configurationId"].Value;
string externalStylesheetId = parameters["stylesheetId"];
// 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 stylesheetId = Stylesheet.FindRequiredKey(configurationId, "stylesheetId", externalStylesheetId);
// 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.StylesheetRow stylesheetRow = stylesheetTable.FindByStylesheetId(stylesheetId);
rowVersion = ((long)(stylesheetRow[stylesheetTable.RowVersionColumn]));
// Call the internal method to complete the operation.
MarkThree.Guardian.Core.Stylesheet.Archive(adoTransaction, sqlTransaction, rowVersion, stylesheetId);
}
/// <summary>Archives a StylesheetType 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="stylesheetTypeCode">The value for the StylesheetTypeCode 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 stylesheetTypeCode)
{
// Accessor for the StylesheetType Table.
ServerMarketData.StylesheetTypeDataTable stylesheetTypeTable = ServerMarketData.StylesheetType;
// Rule #1: Make sure the record exists before updating it.
ServerMarketData.StylesheetTypeRow stylesheetTypeRow = stylesheetTypeTable.FindByStylesheetTypeCode(stylesheetTypeCode);
if ((stylesheetTypeRow == null))
{
throw new Exception(string.Format("The StylesheetType table does not have an element identified by {0}", stylesheetTypeCode));
}
// Rule #2: Optimistic Concurrency Check
if ((stylesheetTypeRow.RowVersion != rowVersion))
{
throw new System.Exception("This record is busy. Please try again later.");
}
// Archive the child records.
for (int index = 0; (index < stylesheetTypeRow.GetStylesheetRows().Length); index = (index + 1))
{
ServerMarketData.StylesheetRow childStylesheetRow = stylesheetTypeRow.GetStylesheetRows()[index];
Stylesheet.Archive(adoTransaction, sqlTransaction, childStylesheetRow.RowVersion, childStylesheetRow.StylesheetId);
}
// Increment the row version
rowVersion = ServerMarketData.RowVersion.Increment();
// Delete the record in the ADO database.
stylesheetTypeRow[stylesheetTypeTable.RowVersionColumn] = rowVersion;
adoTransaction.DataRows.Add(stylesheetTypeRow);
stylesheetTypeRow.Delete();
// Archive the record in the SQL database.
SqlCommand sqlCommand = new SqlCommand("update \"StylesheetType\" set \"IsArchived\" = 1 where \"StylesheetTypeCode\"=@styleshe" +
"etTypeCode");
sqlCommand.Connection = sqlTransaction.Connection;
sqlCommand.Transaction = sqlTransaction;
sqlCommand.Parameters.Add(new SqlParameter("@stylesheetTypeCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, stylesheetTypeCode));
sqlCommand.ExecuteNonQuery();
}
/// <summary>Deletes a Stylesheet 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="stylesheetId">The value for the StylesheetId column.</param>
/// <param name="archive">true to archive the object, false to unarchive it.</param>
public static void Delete(AdoTransaction adoTransaction, SqlTransaction sqlTransaction, long rowVersion, int stylesheetId)
{
// Accessor for the Stylesheet Table.
ServerMarketData.StylesheetDataTable stylesheetTable = ServerMarketData.Stylesheet;
// Rule #1: Make sure the record exists before updating it.
ServerMarketData.StylesheetRow stylesheetRow = stylesheetTable.FindByStylesheetId(stylesheetId);
if ((stylesheetRow == null))
{
throw new Exception(string.Format("The Stylesheet table does not have an element identified by {0}", stylesheetId));
}
// Rule #2: Optimistic Concurrency Check
if ((stylesheetRow.RowVersion != rowVersion))
{
throw new System.Exception("This record is busy. Please try again later.");
}
// Delete the child records.
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterAdvertisementStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterAdvertisementStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterDestinationOrderDetailStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterDestinationOrderDetailStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterDestinationOrderStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterDestinationOrderStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterExecutionDetailStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterExecutionDetailStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterExecutionStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterExecutionStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterMatchStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterMatchStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterMatchHistoryStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterMatchHistoryStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterSourceOrderDetailStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterSourceOrderDetailStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterSourceOrderStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterSourceOrderStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
for (int index = 0; (index < stylesheetRow.GetBlotterRowsByStylesheetBlotterWorkingOrderStylesheetId().Length); index = (index + 1))
{
ServerMarketData.BlotterRow childBlotterRow = stylesheetRow.GetBlotterRowsByStylesheetBlotterWorkingOrderStylesheetId()[index];
Blotter.DeleteChildren(adoTransaction, sqlTransaction, childBlotterRow.RowVersion, childBlotterRow.BlotterId);
}
// Increment the row version
rowVersion = ServerMarketData.RowVersion.Increment();
// Delete the record in the ADO database.
stylesheetRow[stylesheetTable.RowVersionColumn] = rowVersion;
adoTransaction.DataRows.Add(stylesheetRow);
stylesheetRow.Delete();
// Delete the record in the SQL database.
SqlCommand sqlCommand = new SqlCommand("update \"Stylesheet\" set \"IsDeleted\" = 1 where \"StylesheetId\"=@stylesheetId");
sqlCommand.Connection = sqlTransaction.Connection;
sqlCommand.Transaction = sqlTransaction;
sqlCommand.Parameters.Add(new SqlParameter("@stylesheetId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, stylesheetId));
sqlCommand.ExecuteNonQuery();
}
/// <summary>Updates a Stylesheet 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="externalId0">The value for the ExternalId0 column.</param>
/// <param name="externalId1">The value for the ExternalId1 column.</param>
/// <param name="name">The value for the Name column.</param>
/// <param name="stylesheetId">The value for the StylesheetId column.</param>
/// <param name="stylesheetTypeCode">The value for the StylesheetTypeCode column.</param>
/// <param name="text">The value for the Text column.</param>
public static void Update(AdoTransaction adoTransaction, SqlTransaction sqlTransaction, ref long rowVersion, object externalId0, object externalId1, object name, int stylesheetId, object stylesheetTypeCode, object text)
{
// Accessor for the Stylesheet Table.
ServerMarketData.StylesheetDataTable stylesheetTable = ServerMarketData.Stylesheet;
// Rule #1: Make sure the record exists before updating it.
ServerMarketData.StylesheetRow stylesheetRow = stylesheetTable.FindByStylesheetId(stylesheetId);
if ((stylesheetRow == null))
{
throw new Exception(string.Format("The Stylesheet table does not have an element identified by {0}", stylesheetId));
}
// Rule #2: Optimistic Concurrency Check
if ((stylesheetRow.RowVersion != rowVersion))
{
throw new System.Exception("This record is busy. Please try again later.");
}
// Apply Defaults
if ((externalId0 == null))
{
externalId0 = stylesheetRow[stylesheetTable.ExternalId0Column];
}
if ((externalId1 == null))
{
externalId1 = stylesheetRow[stylesheetTable.ExternalId1Column];
}
if ((name == null))
{
name = stylesheetRow[stylesheetTable.NameColumn];
}
if ((stylesheetTypeCode == null))
{
stylesheetTypeCode = stylesheetRow[stylesheetTable.StylesheetTypeCodeColumn];
}
if ((text == null))
{
text = stylesheetRow[stylesheetTable.TextColumn];
}
// Increment the row version
rowVersion = ServerMarketData.RowVersion.Increment();
// Update the record in the ADO database.
stylesheetRow[stylesheetTable.RowVersionColumn] = rowVersion;
stylesheetRow[stylesheetTable.ExternalId0Column] = externalId0;
stylesheetRow[stylesheetTable.ExternalId1Column] = externalId1;
stylesheetRow[stylesheetTable.NameColumn] = name;
stylesheetRow[stylesheetTable.StylesheetTypeCodeColumn] = stylesheetTypeCode;
stylesheetRow[stylesheetTable.TextColumn] = text;
adoTransaction.DataRows.Add(stylesheetRow);
// Update the record in the SQL database.
SqlCommand sqlCommand = new SqlCommand("update \"Stylesheet\" set \"RowVersion\"=@rowVersion,\"ExternalId0\"=@externalId0,\"Exte" +
"rnalId1\"=@externalId1,\"Name\"=@name,\"StylesheetTypeCode\"=@stylesheetTypeCode,\"Tex" +
"t\"=@text where \"StylesheetId\"=@stylesheetId");
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("@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("@name", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, name));
sqlCommand.Parameters.Add(new SqlParameter("@stylesheetId", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, stylesheetId));
sqlCommand.Parameters.Add(new SqlParameter("@stylesheetTypeCode", SqlDbType.Int, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, stylesheetTypeCode));
sqlCommand.Parameters.Add(new SqlParameter("@text", SqlDbType.NVarChar, 0, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, text));
// Update the record in the SQL database.
sqlCommand.ExecuteNonQuery();
}
