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