/// <summary>
/// Returns a list of WorkflowNote objects
/// </summary>
/// <param name="positionDescriptionID">Position Description ID</param>
/// <param name="dummy">Not used. Any value would be fine. This parameter is uses solely to resolve function signature ambiguity (same function name, same number of parameters and parameter type)</param>
/// <returns>a list of WorkflowNote objects</returns>
public static List <WorkflowNote> GetByPositionDescriptionID(long positionDescriptionID, bool dummy)
{
List <WorkflowNote> list = null;
try
{
DbCommand commandWrapper = GetDbCommand("spr_GetWorkflowNoteByPositionDescriptionID");
commandWrapper.Parameters.Add(new SqlParameter("@positionDescriptionID", positionDescriptionID));
DataTable table = ExecuteDataTable(commandWrapper);
list = WorkflowNote.GetCollection(table);
}
catch (Exception ex)
{
HandleException(ex);
}
return(list);
}
public static List <WorkflowNote> GetByWorkflowRecordID(int workflowRecordID)
{
List <WorkflowNote> list = null;
DbCommand commandWrapper = GetDbCommand("spr_GetWorkflowNoteByWorkflowRecID");
try
{
commandWrapper.Parameters.Add(new SqlParameter("@workflowRecID", workflowRecordID));
DataTable table = ExecuteDataTable(commandWrapper);
list = WorkflowNote.GetCollection(table);
}
catch (Exception ex)
{
HandleException(ex);
}
return(list);
}
public List <WorkflowNote> GetWorkflowNote()
{
List <WorkflowNote> childDataCollection = null;
if (base.ValidateKeyField(this._workflowRecID))
{
try
{
DataTable dt = ExecuteDataTable("spr_GetWorkflowNoteByWorkflowStatusID", this._workflowRecID);
// fill collection list
childDataCollection = WorkflowNote.GetCollection(dt);
}
catch (Exception ex)
{
HandleException(ex);
}
}
return(childDataCollection);
}