private void SetSelectedGroupList() { Biz_Bsc_Validation_Group_User objBSC = new Biz_Bsc_Validation_Group_User(); objBSC.Iestterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTerm); objBSC.Igroup_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstGroup); DataSet rDs = objBSC.GetEstEmpListPerLevel( objBSC.Iestterm_ref_id , objBSC.Igroup_ref_id , PageUtility.GetIntByValueDropDownList(ddlEstLevel)); ugrdVaidationUserGrid.Clear(); ugrdVaidationUserGrid.DataSource = rDs; ugrdVaidationUserGrid.DataBind(); //lblUserName.Text = ""; //this.IValidationUserID = 0; Biz_Bsc_Kpi_Qlt_Est_Term objTrm = new Biz_Bsc_Kpi_Qlt_Est_Term(); DataSet tDs = objTrm.GetAllList (objBSC.Iestterm_ref_id , PageUtility.GetIntByValueDropDownList(ddlEstGroup) , PageUtility.GetIntByValueDropDownList(ddlEstLevel)); ugrdTerm.Clear(); ugrdTerm.DataSource = tDs; ugrdTerm.DataBind(); }
private void SetEstStatusGrid() { Biz_Bsc_Validation_Group_User objBSC = new Biz_Bsc_Validation_Group_User(); DataSet rDs = objBSC.GetEstStatusPerEmp(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo) , PageUtility.GetByValueDropDownList(ddlMonthInfo)); ugrdEstStatus.Clear(); ugrdEstStatus.DataSource = rDs; ugrdEstStatus.DataBind(); }
private void SetSelectedGroupList() { Biz_Bsc_Validation_Group_User objBSC = new Biz_Bsc_Validation_Group_User(); objBSC.Iestterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTerm); objBSC.Igroup_ref_id = (hdfGroupRefID.Value == "") ? 0 : Convert.ToInt32(hdfGroupRefID.Value.ToString()); DataSet rDs = objBSC.GetAllList(objBSC.Iestterm_ref_id, objBSC.Igroup_ref_id); ugrdSelectedGrid.Clear(); ugrdSelectedGrid.DataSource = rDs; ugrdSelectedGrid.DataBind(); }
protected int AddUserToGroup() { CheckBox chk; UltraGridRow row; TemplatedColumn col; bool isOK = false; string isSuccessed = "0"; int intTxrUser = gUserInfo.Emp_Ref_ID; int intRtn = 0; int intRow = ugrdTargetGrid.Rows.Count; Biz_Bsc_Validation_Group_User objBSC = new Biz_Bsc_Validation_Group_User(); for (int i = 0; i < intRow; i++) { row = ugrdTargetGrid.Rows[i]; col = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox"); if (chk.Checked) { chk.Checked = false; objBSC.Iemp_ref_id = Convert.ToInt32(row.Cells.FromKey("EMP_REF_ID").Value.ToString()); objBSC.Iestterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTerm); objBSC.Igroup_ref_id = (hdfGroupRefID.Value == "") ? 0 : Convert.ToInt32(hdfGroupRefID.Value.ToString()); objBSC.Iuse_yn = "Y"; objBSC.Itxr_user = intTxrUser; objBSC.Idescriptions = ""; intRtn += objBSC.InsertData(objBSC.Iestterm_ref_id , objBSC.Igroup_ref_id , objBSC.Iemp_ref_id , objBSC.Idescriptions , objBSC.Iuse_yn , objBSC.Itxr_user); } } return(intRtn); }
private void SetSelectedGroupList() { //Biz_Bsc_Validation_Group_User objBSC = new Biz_Bsc_Validation_Group_User(); //objBSC.Iestterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTerm); //objBSC.Igroup_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstGroup); //DataSet rDs = objBSC.GetAllList(objBSC.Iestterm_ref_id, objBSC.Igroup_ref_id); Biz_Bsc_Validation_Group_User objBSC = new Biz_Bsc_Validation_Group_User(); objBSC.Iestterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTerm); objBSC.Igroup_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstGroup); DataSet rDs = objBSC.GetEstEmpListPerLevel( objBSC.Iestterm_ref_id , objBSC.Igroup_ref_id , PageUtility.GetIntByValueDropDownList(ddlEstLevel)); ugrdVaidationUserGrid.Clear(); ugrdVaidationUserGrid.DataSource = rDs; ugrdVaidationUserGrid.DataBind(); }
protected int RemoveUserFromGroup() { CheckBox chk; UltraGridRow row; TemplatedColumn col; bool isOK = false; string isSuccessed = "0"; int intTxrUser = gUserInfo.Emp_Ref_ID; int intRtn = 0; int intRow = ugrdSelectedGrid.Rows.Count; Biz_Bsc_Validation_Group_User objBSC = new Biz_Bsc_Validation_Group_User(); for (int i = 0; i < intRow; i++) { row = ugrdSelectedGrid.Rows[i]; col = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox"); if (chk.Checked) { chk.Checked = false; objBSC.Iestterm_ref_id = Convert.ToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value.ToString()); objBSC.Igroup_ref_id = Convert.ToInt32(row.Cells.FromKey("GROUP_REF_ID").Value.ToString()); objBSC.Iemp_ref_id = Convert.ToInt32(row.Cells.FromKey("EMP_REF_ID").Value.ToString()); objBSC.Itxr_user = intTxrUser; intRtn += objBSC.DeleteData(objBSC.Iestterm_ref_id , objBSC.Igroup_ref_id , objBSC.Iemp_ref_id , objBSC.Itxr_user); } } return(intRtn); }