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 int SetKpiQltTerm() { CheckBox chk; UltraGridRow row; TemplatedColumn col; int intTxrUser = EMP_REF_ID; int intRtn = 0; int intRow = ugrdTerm.Rows.Count; string sBias = "N"; string sEst = "N"; Biz_Bsc_Kpi_Qlt_Est_Term objBSC = new Biz_Bsc_Kpi_Qlt_Est_Term(); DataTable rDt = objBSC.GetSchema(); DataRow rDr = null; for (int i = 0; i < intRow; i++) { row = ugrdTerm.Rows[i]; col = (TemplatedColumn)row.Band.Columns.FromKey("EST_YN"); chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("chkEst"); sEst = (chk.Checked) ? "Y" : "N"; col = (TemplatedColumn)row.Band.Columns.FromKey("BIAS_YN"); chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("chkBias"); sBias = (chk.Checked) ? "Y" : "N"; rDr = rDt.NewRow(); rDr["ESTTERM_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value); rDr["GROUP_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("GROUP_REF_ID").Value); rDr["EST_LEVEL"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("EST_LEVEL").Value); rDr["YMD"] = DataTypeUtility.GetString(row.Cells.FromKey("YMD").Value); rDr["EST_YN"] = sEst; rDr["BIAS_YN"] = sBias; rDr["TXR_USER"] = intTxrUser; rDt.Rows.Add(rDr); } intRtn = objBSC.TrxListData(rDt); return(intRtn); }