public List <WorkflowGroupPermission> GetAllWorkflowGroupPermissionsByGroupID(int workflowGroupID)
{
List <WorkflowGroupPermission> listCollection = new List <WorkflowGroupPermission>();
if (workflowGroupID > 0)
{
DataTable dataItems = ExecuteDataTable("spr_GetAllPermissionsByGroupID", workflowGroupID);
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
WorkflowGroupPermission item = new WorkflowGroupPermission();
item.WorkflowGroupRecID = dataItems.Rows[i].Field <int>("WorkflowGroupRecID");
item.WorkflowGroupID = dataItems.Rows[i].Field <int>("WorkflowGroupID");
item.WorkflowGroupName = dataItems.Rows[i].Field <string>("WorkflowGroupName");
item.PermissionID = dataItems.Rows[i].Field <int>("PermissionID");
item.PermissionName = dataItems.Rows[i].Field <string>("PermissionName");
listCollection.Add(item);
}
}
else
{
throw new Exception("You cannot create a Workflow Group Permission collection from a null data table.");
}
}
return(listCollection);
}
public void Delete(WorkflowGroupPermission workflowGroupPermission)
{
if (base.ValidateKeyField(workflowGroupPermission.WorkflowGroupRecID))
{
try
{
ExecuteNonQuery("spr_DeleteWorkflowGroupPermission", workflowGroupPermission.WorkflowGroupRecID);
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
//Workflow Group Permission
#region General CRUD Methods
public long Add(WorkflowGroupPermission workflowGroupPermission)
{
long returnCode = -1;
DbCommand commandWrapper = GetDbCommand("spr_AddWorkflowGroupPermission");
try
{
SqlParameter returnParam = new SqlParameter("@WorkflowGroupRecID", SqlDbType.Int);
returnParam.Direction = ParameterDirection.Output;
commandWrapper.Parameters.Add(returnParam);
if (workflowGroupPermission.WorkflowGroupRecID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupRecID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupRecID", workflowGroupPermission.WorkflowGroupRecID));
}
if (workflowGroupPermission.WorkflowGroupID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupID", workflowGroupPermission.WorkflowGroupID));
}
if (workflowGroupPermission.PermissionID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@PermissionID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@PermissionID", workflowGroupPermission.PermissionID));
}
ExecuteNonQuery(commandWrapper);
workflowGroupPermission.WorkflowGroupRecID = (int)returnParam.Value;
}
catch (Exception ex)
{
HandleException(ex);
}
return(returnCode);
}
public WorkflowGroupPermission GetWorkflowGroupPermission(int loadByID)
{
WorkflowGroupPermission workflowGroupPermission = new WorkflowGroupPermission();
// Load Object by ID
DataTable returnTable;
try
{
returnTable = ExecuteDataTable("spr_GetWorkflowGroupPermissionByID", loadByID);
workflowGroupPermission = loadWorkflowGroupPermissionData(returnTable);
}
catch (Exception ex)
{
HandleException(ex);
}
return(workflowGroupPermission);
}
public void Update(WorkflowGroupPermission workflowGroupPermission)
{
if (base.ValidateKeyField(workflowGroupPermission.WorkflowGroupRecID))
{
DbCommand commandWrapper = GetDbCommand("spr_UpdateWorkflowGroupPermission");
try
{
if (workflowGroupPermission.WorkflowGroupRecID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupRecID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupRecID", workflowGroupPermission.WorkflowGroupRecID));
}
if (workflowGroupPermission.WorkflowGroupID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@WorkflowGroupID", workflowGroupPermission.WorkflowGroupID));
}
if (workflowGroupPermission.PermissionID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@PermissionID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@PermissionID", workflowGroupPermission.PermissionID));
}
ExecuteNonQuery(commandWrapper);
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
protected virtual WorkflowGroupPermission FillWorkflowGroupPermissionObjectFromRowData(DataRow returnRow)
{
WorkflowGroupPermission workflowGroupPermission = new WorkflowGroupPermission();
if (returnRow["WorkflowGroupRecID"] != DBNull.Value)
{
workflowGroupPermission.WorkflowGroupRecID = Convert.ToInt32(returnRow["WorkflowGroupRecID"]);
}
if (returnRow["WorkflowGroupID"] != DBNull.Value)
{
workflowGroupPermission.WorkflowGroupID = Convert.ToInt32(returnRow["WorkflowGroupID"]);
}
if (returnRow["PermissionID"] != DBNull.Value)
{
workflowGroupPermission.PermissionID = Convert.ToInt32(returnRow["PermissionID"]);
}
return(workflowGroupPermission);
}
public bool Equals(Object obj)
{
WorkflowGroupPermission workflowGroupPermissionObj = obj as WorkflowGroupPermission;
return((workflowGroupPermissionObj == null) ? false : (this.WorkflowGroupRecID == workflowGroupPermissionObj.WorkflowGroupRecID));
}