public List <WorkflowRule> GetAllWorkflowGroupRulesByGroupID(int workflowGroupID, int staffingObjectTypeID)
{
List <WorkflowRule> listCollection = new List <WorkflowRule>();
if (workflowGroupID > 0)
{
DataTable dataItems = ExecuteDataTable("spr_GetAllRulesByGroupID", workflowGroupID, staffingObjectTypeID);
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
WorkflowRule item = new WorkflowRule();
item.WorkflowRuleID = dataItems.Rows[i].Field <int>("WorkflowRuleID");
item.StaffingObjectCurrentStatusID = dataItems.Rows[i].Field <int>("StaffingObjectCurrentStatusID");
item.StaffingObjectCurrentStatusName = dataItems.Rows[i].Field <string>("WorkflowStatus");
item.StaffingObjectTypeID = dataItems.Rows[i].Field <int>("StaffingObjectTypeID");
item.StaffingObjectTypeName = dataItems.Rows[i].Field <string>("StaffingObjectTypeName");
item.WorkflowGroupID = dataItems.Rows[i].Field <int>("WorkflowGroupID");
item.WorkflowGroupName = dataItems.Rows[i].Field <string>("WorkflowGroupName");
listCollection.Add(item);
}
}
else
{
throw new Exception("You cannot create a Workflow Group Rule collection from a null data table.");
}
}
return(listCollection);
}
public long Add(WorkflowRule workflowRule)
{
long returnCode = -1;
DbCommand commandWrapper = GetDbCommand("spr_AddWorkflowRule");
try
{
SqlParameter returnParam = new SqlParameter("@newWorkflowRuleID", SqlDbType.Int);
returnParam.Direction = ParameterDirection.Output;
commandWrapper.Parameters.Add(returnParam);
commandWrapper.Parameters.Add(new SqlParameter("@staffingObjectCurrentStatusID", workflowRule.StaffingObjectCurrentStatusID));
commandWrapper.Parameters.Add(new SqlParameter("@workflowGroupID", workflowRule.WorkflowGroupID));
commandWrapper.Parameters.Add(new SqlParameter("@staffingObjectTypeID", workflowRule.StaffingObjectTypeID));
ExecuteNonQuery(commandWrapper);
returnCode = Convert.ToInt64(returnParam.Value);
}
catch (Exception ex)
{
HandleException(ex);
}
return(returnCode);
}
public List <WorkflowRule> GetAllWorkflowRules()
{
List <WorkflowRule> listCollection = new List <WorkflowRule>();
DataTable dataItems = ExecuteDataTable("spr_GetAllWorkflowRules");
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
WorkflowRule item = new WorkflowRule();
item.WorkflowRuleID = Convert.ToInt32(dataItems.Rows[i]["WorkflowRuleID"]);
item.StaffingObjectCurrentStatusID = Convert.ToInt32(dataItems.Rows[i]["StaffingObjectCurrentStatusID"]);
item.StaffingObjectCurrentStatusName = dataItems.Rows[i]["WorkflowStatus"].ToString();
item.StaffingObjectTypeID = Convert.ToInt32(dataItems.Rows[i]["StaffingObjectTypeID"]);
item.StaffingObjectTypeName = dataItems.Rows[i]["StaffingObjectTypeName"].ToString();
item.WorkflowGroupID = Convert.ToInt32(dataItems.Rows[i]["WorkflowGroupID"]);
item.WorkflowGroupName = dataItems.Rows[i]["WorkflowGroupName"].ToString();
listCollection.Add(item);
}
}
else
{
throw new Exception("You cannot create a Workflow Rule collection from a null data table.");
}
return(listCollection);
}
protected virtual WorkflowRule FillWorkflowRuleObjectFromRowData(DataRow returnRow)
{
WorkflowRule actionType = new WorkflowRule();
if (returnRow["WorkflowRuleID"] != DBNull.Value)
{
actionType.WorkflowRuleID = (int)returnRow["WorkflowRuleID"];
}
if (returnRow["StaffingObjectCurrentStatusID"] != DBNull.Value)
{
actionType.StaffingObjectCurrentStatusID = (int)returnRow["StaffingObjectCurrentStatusID"];
}
if (returnRow["WorkflowGroupID"] != DBNull.Value)
{
actionType.WorkflowGroupID = (int)returnRow["WorkflowGroupID"];
}
if (returnRow["StaffingObjectTypeID"] != DBNull.Value)
{
actionType.StaffingObjectTypeID = (int)returnRow["StaffingObjectTypeID"];
}
return(null);
}
public bool Update(WorkflowRule workflowRule)
{
bool isSuccessful = false;
if (base.ValidateKeyField(workflowRule.WorkflowRuleID))
{
DbCommand commandWrapper = GetDbCommand("spr_UpdateWorkflowRule");
try
{
if (workflowRule.WorkflowRuleID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowRuleID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowRuleID", workflowRule.WorkflowRuleID));
}
if (workflowRule.StaffingObjectCurrentStatusID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@StaffingObjectCurrentStatusID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@StaffingObjectCurrentStatusID", workflowRule.StaffingObjectCurrentStatusID));
}
if (workflowRule.WorkflowGroupID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupID", workflowRule.WorkflowGroupID));
}
if (workflowRule.StaffingObjectTypeID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@StaffingObjectTypeID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@StaffingObjectTypeID", workflowRule.StaffingObjectTypeID));
}
ExecuteNonQuery(commandWrapper);
isSuccessful = true;
}
catch (Exception ex)
{
HandleException(ex);
}
}
return(isSuccessful);
}
public WorkflowRule GetWorkflowRule(int loadByID)
{
WorkflowRule workflowRule = new WorkflowRule();
// Load Object by ID
DataTable returnTable;
try
{
returnTable = ExecuteDataTable("spr_GetWorkflowRuleByID", loadByID);
workflowRule = loadWorkflowRuleData(returnTable);
}
catch (Exception ex)
{
HandleException(ex);
}
return(workflowRule);
}
public bool Equals(Object obj)
{
WorkflowRule workflowRuleObj = obj as WorkflowRule;
return((workflowRuleObj == null) ? false : (this.WorkflowRuleID == workflowRuleObj.WorkflowRuleID));
}
