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