/// <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); }