/// <summary>
/// Builds the DbCommand to get a list of a task's dependencies
/// </summary>
/// <param name="daMgr">DataAccessMgr object</param>
/// <returns>DbCommand Object with DbNull Parameter values</returns>
static DbCommand BuildCmdGetTaskDependencies(DataAccessMgr daMgr)
{
DbTableDmlMgr dmlSelectMgr = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE
, Constants.TaskDependencies);
string jointable = dmlSelectMgr.AddJoin(DataAccess.Constants.SCHEMA_CORE
, Constants.TaskProcessingQueue
, DbTableJoinType.Inner
, j => j.AliasedColumn(Constants.WaitTaskQueueCode)
== j.JoinAliasedColumn(Constants.TaskQueueCode)
, Constants.TaskId);
dmlSelectMgr.SetWhereCondition(w => w.Column(Constants.TaskQueueCode) == w.Parameter(Constants.TaskQueueCode));
dmlSelectMgr.AddOrderByColumnAscending(Constants.TaskQueueCode);
dmlSelectMgr.AddOrderByColumnAscending(DataAccess.Constants.SCHEMA_CORE, Constants.TaskProcessingQueue, Constants.TaskId);
return(daMgr.BuildSelectDbCommand(dmlSelectMgr, null));
}
/// <summary>
/// Builds the DbCommand to get a list of task processing queue records
/// sorted by StatusDateTime.
/// </summary>
/// <param name="daMgr">DataAccessMgr object</param>
/// <returns>DbCommand Object with DbNull Parameter values</returns>
static DbCommand BuildCmdGetTPQListByStatusDateTime(DataAccessMgr daMgr)
{
DbTableDmlMgr dmlSelectMgr = daMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE
, Constants.TaskProcessingQueue);
string joinTable = dmlSelectMgr.AddJoin(DataAccess.Constants.SCHEMA_CORE
, Constants.TaskStatusCodes
, DbTableJoinType.Inner
, j => j.AliasedColumn(Constants.StatusCode)
== j.JoinAliasedColumn(Constants.StatusCode)
, Constants.StatusName);
dmlSelectMgr.SetWhereCondition(w => w.AliasedColumn(Constants.StatusCode)
== w.Parameter(Constants.StatusCode));
dmlSelectMgr.AddOrderByColumnAscending(Constants.StatusCode);
dmlSelectMgr.AddOrderByColumnDescending(Constants.StatusDateTime);
dmlSelectMgr.AddOrderByColumnAscending(Constants.TaskQueueCode);
return(daMgr.BuildSelectDbCommand(dmlSelectMgr, null));
}