/// <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>
/// method
/// moves the values from the grid view to the data table
/// </summary>
protected void MoveValuesFromGVtoDT()
{
foreach (GridViewRow gvr in gvChecklistItems.Rows)
{
CheckBox chkItemActive = (CheckBox)gvr.FindControl("chkItemActive");
TextBox txtTSTimePeriod = (TextBox)gvr.FindControl("txtTSTimePeriod");
DropDownList ddlUnit = (DropDownList)gvr.FindControl("ddlUnit");
TextBox txtSortOrder = (TextBox)gvr.FindControl("txtSortOrder");
CheckBoxList cblDSChangeable = (CheckBoxList)gvr.FindControl("cblDSChangeable");
if (chkItemActive == null ||
txtTSTimePeriod == null ||
ddlUnit == null ||
txtSortOrder == null ||
cblDSChangeable == null)
{
return;
}
foreach (DataRow dr in Items.Rows)
{
string strItemID = dr["ITEM_ID"].ToString();
if (gvChecklistItems.DataKeys[gvr.RowIndex].Value.ToString() == strItemID)
{
dr["CLI_TS_TIME_PERIOD"] = (string.IsNullOrEmpty(txtTSTimePeriod.Text)) ? "0" : txtTSTimePeriod.Text;
dr["TIME_UNIT_ID"] = ddlUnit.SelectedValue;
dr["SORT_ORDER"] = (string.IsNullOrEmpty(txtSortOrder.Text)) ? "0" : txtSortOrder.Text;
dr["ACTIVE_ID"] = Convert.ToInt32((chkItemActive.Checked) ? k_ACTIVE_ID.Active : k_ACTIVE_ID.Inactive);
string strDSSelect = "ITEM_ID = " + strItemID;
DataRow[] adrDSChangeable = DSChangeable.Select(strDSSelect);
foreach (DataRow drDSChangeable in adrDSChangeable)
{
drDSChangeable.Delete();
}
foreach (ListItem li in cblDSChangeable.Items)
{
if (li.Selected)
{
DataRow drDSChangeable = DSChangeable.NewRow();
drDSChangeable["CHECKLIST_ID"] = ChecklistID;
drDSChangeable["ITEM_ID"] = strItemID;
drDSChangeable["USER_ROLE_ID"] = li.Value;
DSChangeable.Rows.Add(drDSChangeable);
}
}
break;
}
}
}
}
/// <summary>
/// method
/// loads the values from the data row into the grid view row controls
/// </summary>
/// <param name="gvr"></param>
protected void LoadGridViewRowValues(GridViewRow gvr)
{
DataRowView drv = (DataRowView)gvr.DataItem;
if (drv == null)
{
return;
}
DataRow dr = drv.Row;
if (dr == null)
{
return;
}
Button btnStates = (Button)gvr.FindControl("btnStates");
CheckBox chkItemActive = (CheckBox)gvr.FindControl("chkItemActive");
TextBox txtTSTimePeriod = (TextBox)gvr.FindControl("txtTSTimePeriod");
DropDownList ddlUnit = (DropDownList)gvr.FindControl("ddlUnit");
TextBox txtSortOrder = (TextBox)gvr.FindControl("txtSortOrder");
Label lblItemLabel = (Label)gvr.FindControl("lblItemLabel");
CheckBoxList cblDSChangeable = (CheckBoxList)gvr.FindControl("cblDSChangeable");
if (btnStates == null ||
chkItemActive == null ||
txtTSTimePeriod == null ||
ddlUnit == null ||
txtSortOrder == null ||
lblItemLabel == null ||
cblDSChangeable == null)
{
return;
}
btnStates.Attributes.Add("ITEM_ID", dr["ITEM_ID"].ToString());
btnStates.Enabled = (Convert.ToInt32(dr["CHECKLIST_ID"]) < 1) ? false : true;
chkItemActive.Checked = (Convert.ToInt64(dr["ACTIVE_ID"]) == (long)k_ACTIVE_ID.Active) ? true : false;
txtTSTimePeriod.Text = dr["CLI_TS_TIME_PERIOD"].ToString();
ddlUnit.SelectedValue = dr["TIME_UNIT_ID"].ToString();
txtSortOrder.Text = dr["SORT_ORDER"].ToString();
lblItemLabel.Text = dr["ITEM_LABEL"].ToString();
DataRow[] draDSSelect = DSChangeable.Select("ITEM_ID = " + dr["ITEM_ID"].ToString());
CCheckBoxList cbl = new CCheckBoxList();
cbl.CheckSelected(cblDSChangeable, draDSSelect);
}
/// <summary>
/// method
/// validates the user input for an item
/// </summary>
/// <param name="dr"></param>
/// <param name="plistStatus"></param>
/// <returns></returns>
protected CStatus ValidateItem(DataRow dr, out CParameterList plistStatus)
{
plistStatus = new CParameterList();
CStatus status = new CStatus();
string strTSTimePeriod = dr["CLI_TS_TIME_PERIOD"].ToString();
if (string.IsNullOrEmpty(strTSTimePeriod) || Convert.ToInt32(strTSTimePeriod) < 1)
{
plistStatus.AddInputParameter("ERROR_CE_TIMEPERIOD", Resources.ErrorMessages.ERROR_CE_TIMEPERIOD);
}
string strUnitID = dr["TIME_UNIT_ID"].ToString();
if (string.IsNullOrEmpty(strUnitID) || Convert.ToInt32(strUnitID) < 1)
{
plistStatus.AddInputParameter("ERROR_CE_TIMEUNITS", Resources.ErrorMessages.ERROR_CE_TIMEUNITS);
}
string strSortOrder = dr["SORT_ORDER"].ToString();
if (string.IsNullOrEmpty(strSortOrder) || Convert.ToInt32(strSortOrder) < 1)
{
plistStatus.AddInputParameter("ERROR_CE_SORTORDER", Resources.ErrorMessages.ERROR_CE_SORTORDER);
}
string strDSSelect = "ITEM_ID = " + dr["ITEM_ID"].ToString();
if (DSChangeable.Select(strDSSelect).Count() < 1)
{
plistStatus.AddInputParameter("ERROR_CE_DSCHANGE", Resources.ErrorMessages.ERROR_CE_DSCHANGE);
}
if (plistStatus.Count > 0)
{
status.Status = false;
status.StatusCode = k_STATUS_CODE.Failed;
}
return(status);
}
