protected void loadPIDetails() { int KPI_ID = 0; DataTable dtKPI = objKPI.GetGoal(0, "KPI030", 0); if (dtKPI.Rows[0]["KPI_ID"] != null) { KPI_ID = Convert.ToInt32(dtKPI.Rows[0]["KPI_ID"]); } DataSet ds = BLL_TMSA_PI.Get_KPI_Detail(KPI_ID); DataTable dt = new DataTable(); DataTable dtPIDtl = ds.Tables[1]; dt.Columns.Add(new DataColumn("sno", typeof(int))); dt.Columns.Add(new DataColumn("PID", typeof(string))); dt.Columns.Add(new DataColumn("value", typeof(string))); dt.Columns.Add(new DataColumn("PIName", typeof(string))); string exp = ""; if (dtPIDtl.Rows.Count > 0) { foreach (DataRow row in dtPIDtl.Rows) { dt.Rows.Add(new object[] { Convert.ToInt32(row["SerialNumber"].ToString()), row["PI_ID"].ToString(), row["value"].ToString(), row["Name"].ToString() }); exp = exp + row["value"].ToString(); } lblFormula.Text = "KPI Formula : " + exp; DataTable dt_PI = dt; dt_PI.DefaultView.RowFilter = "PID <> ''"; DataList1.DataSource = dt_PI.DefaultView; DataList1.DataBind(); } }
protected void loadPIDetails() { DataSet ds = BLL_TMSA_PI.Get_KPI_Detail(UDFLib.ConvertIntegerToNull(hiddenKPIID.Value)); if (ds.Tables[0].Rows.Count > 0) { ltKPI.Text = ds.Tables[0].Rows[0]["Name"].ToString(); hiddenKPIName.Value = ds.Tables[0].Rows[0]["Name"].ToString(); DataTable dt = new DataTable(); DataTable dtPIDtl = ds.Tables[1]; dt.Columns.Add(new DataColumn("sno", typeof(int))); dt.Columns.Add(new DataColumn("PID", typeof(string))); dt.Columns.Add(new DataColumn("value", typeof(string))); dt.Columns.Add(new DataColumn("PIName", typeof(string))); string exp = ""; foreach (DataRow row in dtPIDtl.Rows) { dt.Rows.Add(new object[] { Convert.ToInt32(row["SerialNumber"].ToString()), row["PI_ID"].ToString(), row["value"].ToString(), row["Name"].ToString() }); exp = exp + row["value"].ToString(); } lblFormula.Text = "KPI Formula : " + exp; DataTable dt_PI = dt; dt_PI.DefaultView.RowFilter = "PID <> ''"; DataList1.DataSource = dt_PI.DefaultView; DataList1.DataBind(); } }
private void loadFormula() { DataSet ds = BLL_TMSA_PI.Get_KPI_Detail(UDFLib.ConvertIntegerToNull(hiddenKPIID.Value)); DataTable dtPIDtl = ds.Tables[1]; string exp = ""; foreach (DataRow row in dtPIDtl.Rows) { exp = exp + row["value"].ToString(); } lblFormula.Text = "KPI Formula : " + exp; loadPIDetails(); }
private void BindDetails() { DataTable dt = BLL_TMSA_PI.Get_KPI_Detail(UDFLib.ConvertIntegerToNull(ViewState["KPI_ID"])).Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; if (dr["Interval"] != null) { ddlIntervalUnit.SelectedValue = dr["Interval"].ToString(); } txtItemDescription.Text = dr["Description"].ToString(); txtPIName.Text = dr["Name"].ToString(); txtPICode.Text = dr["Code"].ToString(); } BindPI(); }
private void loadFormula() { DataTable dtKPI = objKPI.GetGoal(0, "KPI030", 0); string KPI_ID = dtKPI.Rows[0]["KPI_ID"].ToString(); hdnKPIID.Value = KPI_ID; DataSet ds = BLL_TMSA_PI.Get_KPI_Detail(UDFLib.ConvertIntegerToNull(KPI_ID)); DataTable dtPIDtl = ds.Tables[1]; string exp = ""; foreach (DataRow row in dtPIDtl.Rows) { exp = exp + row["value"].ToString(); } lblFormula.Text = "KPI Formula : " + exp; loadPIDetails(); }
protected void Page_Load(object sender, EventArgs e) { UserAccessValidation(); if (!IsPostBack) { BindCategory(); BindInterval(); ddlOperator.SelectedValue = "0"; txtNumber.Text = ""; LoadQueryList(); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("sno", typeof(int))); dt.Columns.Add(new DataColumn("PID", typeof(string))); dt.Columns.Add(new DataColumn("value", typeof(string))); dt.Columns.Add(new DataColumn("PIName", typeof(string))); // dt.PrimaryKey = new DataColumn[] { dt.Columns["sno"] }; hdnKPIID.Value = Request.QueryString["KPI_ID"];//21 if (hdnKPIID.Value == "0") { lblCode1.Visible = false; // lblCode2.Visible = false; lblCode3.Visible = false; lblFormula1.Visible = false; // lblFormula2.Visible = false; lblFormula3.Visible = false; } else { DataSet ds = BLL_TMSA_PI.Get_KPI_Detail(UDFLib.ConvertIntegerToNull(hdnKPIID.Value)); DataTable dtDtl = ds.Tables[0]; DataTable dtPIDtl = ds.Tables[1]; txtKPIName.Text = dtDtl.Rows[0]["Name"].ToString(); txtKPIDesc.Text = dtDtl.Rows[0]["Description"].ToString(); txtTimePeriod.Text = dtDtl.Rows[0]["Time_Period"].ToString(); txtMeasure.Text = dtDtl.Rows[0]["Measurement_Detail"].ToString(); txtURL.Text = dtDtl.Rows[0]["URL"].ToString(); lblCode3.Text = dtDtl.Rows[0]["Code"].ToString(); if (ddlCategory.Items.FindByValue(dtDtl.Rows[0]["Category"].ToString()) != null) { ddlCategory.SelectedValue = dtDtl.Rows[0]["Category"].ToString() != "" ? dtDtl.Rows[0]["Category"].ToString() : "0"; } else { ddlCategory.SelectedValue = "0"; } //if (ddlListSource.Items.FindByValue(dtDtl.Rows[0]["DataSource"].ToString()) != null) // ddlListSource.SelectedValue = dtDtl.Rows[0]["DataSource"].ToString() != "" ? dtDtl.Rows[0]["DataSource"].ToString() : "0"; //else // ddlListSource.SelectedValue = "0"; // ddlCategory.SelectedValue = dtDtl.Rows[0]["Category"].ToString(); if (ddlInterval.Items.FindByValue(dtDtl.Rows[0]["Interval"].ToString()) != null) { ddlInterval.SelectedValue = dtDtl.Rows[0]["Interval"].ToString() != "" ? dtDtl.Rows[0]["Interval"].ToString() : "0"; } else { ddlInterval.SelectedValue = "0"; } if (ddlStatus.Items.FindByValue(dtDtl.Rows[0]["KPI_Status"].ToString()) != null) { ddlStatus.SelectedValue = dtDtl.Rows[0]["KPI_Status"].ToString() != "" ? dtDtl.Rows[0]["KPI_Status"].ToString() : "2"; } else { ddlStatus.SelectedValue = "2"; } if (ddlKPIApplicableFor.Items.FindByValue(dtDtl.Rows[0]["KPI_ApplicableFor"].ToString()) != null) //Added to display the preselected value from database. { ddlKPIApplicableFor.SelectedValue = dtDtl.Rows[0]["KPI_ApplicableFor"].ToString() != "" ? dtDtl.Rows[0]["KPI_ApplicableFor"].ToString() : "0"; } else { ddlKPIApplicableFor.SelectedValue = "2"; } string exp = ""; foreach (DataRow row in dtPIDtl.Rows) { dt.Rows.Add(new object[] { Convert.ToInt32(row["SerialNumber"].ToString()), row["PI_ID"].ToString(), row["value"].ToString(), row["Name"].ToString() }); exp = exp + row["value"].ToString(); } lblFormula3.Text = exp; dtlFormula.DataSource = dt; dtlFormula.DataBind(); DataTable dt_PI = dt; dt_PI.DefaultView.RowFilter = "PID <> ''"; DataList1.DataSource = dt_PI.DefaultView; DataList1.DataBind(); } ViewState["dtFormula"] = dt; Bind_PI(ddlInterval.SelectedValue); } }
/// <summary> /// Method to load PIs for PMS overdue KPI and display formula /// </summary> protected void loadPIDetails() { try { int KPI_ID1 = Convert.ToInt16(hdnKPI1.Value); int KPI_ID2 = Convert.ToInt16(hdnKPI2.Value); int KPI_ID3 = Convert.ToInt16(hdnKPI3.Value); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("sno", typeof(int))); dt.Columns.Add(new DataColumn("PID", typeof(string))); dt.Columns.Add(new DataColumn("value", typeof(string))); dt.Columns.Add(new DataColumn("PIName", typeof(string))); DataSet ds = BLL_TMSA_PI.Get_KPI_Detail(KPI_ID1); DataTable dtPIDtl = ds.Tables[1]; string exp = ""; if (dtPIDtl.Rows.Count > 0) { foreach (DataRow row in dtPIDtl.Rows) { dt.Rows.Add(new object[] { Convert.ToInt32(row["SerialNumber"].ToString()), row["PI_ID"].ToString(), row["value"].ToString(), row["Name"].ToString() }); exp = exp + row["value"].ToString(); } lblFormula.Text = "Non Critical Rate: " + exp; DataTable dt_PI1 = dt; dt_PI1.DefaultView.RowFilter = "PID <> ''"; dt_PI1.DefaultView.Sort = "PID asc"; DataList1.DataSource = dt_PI1.DefaultView; DataList1.DataBind(); } ds.Clear(); dt.Clear(); dtPIDtl.Clear(); ds = BLL_TMSA_PI.Get_KPI_Detail(KPI_ID2); dtPIDtl = ds.Tables[1]; exp = ""; if (dtPIDtl.Rows.Count > 0) { foreach (DataRow row in dtPIDtl.Rows) { dt.Rows.Add(new object[] { Convert.ToInt32(row["SerialNumber"].ToString()), row["PI_ID"].ToString(), row["value"].ToString(), row["Name"].ToString() }); exp = exp + row["value"].ToString(); } lblFormula2.Text = "Critical Rate: " + exp; DataTable dt_PI1 = dt; dt_PI1.DefaultView.RowFilter = "PID <> ''"; dt_PI1.DefaultView.Sort = "PID asc"; DataList2.DataSource = dt_PI1.DefaultView; DataList2.DataBind(); } ds.Clear(); dt.Clear(); dtPIDtl.Clear(); ds = BLL_TMSA_PI.Get_KPI_Detail(KPI_ID3); dtPIDtl = ds.Tables[1]; exp = ""; if (dtPIDtl.Rows.Count > 0) { foreach (DataRow row in dtPIDtl.Rows) { dt.Rows.Add(new object[] { Convert.ToInt32(row["SerialNumber"].ToString()), row["PI_ID"].ToString(), row["value"].ToString(), row["Name"].ToString() }); exp = exp + row["value"].ToString(); } lblFormula3.Text = "KPI030 Formula : " + exp; DataTable dt_PI1 = dt; dt_PI1.DefaultView.RowFilter = "PID <> ''"; dt_PI1.DefaultView.Sort = "PID asc"; DataList3.DataSource = dt_PI1.DefaultView; DataList3.DataBind(); } } catch (Exception ex) { //UDFLib.WriteExceptionLog(ex); } }