/// <summary>
/// method
/// saves the roles that may edit the decision state for an item to the database
/// </summary>
/// <param name="lItemID"></param>
/// <returns></returns>
protected CStatus SaveCLIDSEdit(long lItemID)
{
CChecklistItemData clid = new CChecklistItemData(BaseMstr.BaseData);
CStatus status = clid.DeleteAllCLItemDSRoles(ChecklistID, lItemID);
if (!status.Status)
{
return(status);
}
string strDSSelect = "ITEM_ID = " + lItemID.ToString();
DataRow[] adr = DSChangeable.Select(strDSSelect);
foreach (DataRow dr in adr)
{
CCLIDSEditDataItem di = new CCLIDSEditDataItem();
di.ChecklistID = ChecklistID;
di.ItemID = lItemID;
di.UserRoleID = Convert.ToInt64(dr["USER_ROLE_ID"]);
status = clid.InsertCLItemDSRole(di);
if (!status.Status)
{
return(status);
}
}
return(new CStatus());
}
/// <summary>
/// Used to insert a decision state role that has access to a checklist/item
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CStatus InsertCLItemDSRole(CCLIDSEditDataItem data)
{
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(
SessionID,
ClientIP,
UserID);
//add the rest of the parameters
pList.AddInputParameter("pi_nChecklistID", data.ChecklistID);
pList.AddInputParameter("pi_nItemID", data.ItemID);
pList.AddInputParameter("pi_nUserRoleID", data.UserRoleID);
//execute the SP
return(DBConn.ExecuteOracleSP("PCK_CHECKLIST_ITEM.InsertCLItemDSRole", pList));
}
