/// <summary> /// Description:Method to bind PI header information /// </summary> protected void BindPIDetails() { try { PI_ID = Convert.ToInt32(Request.QueryString[0]); DataTable dtDetail = BLL_TMSA_PI.Get_PI_Details(PI_ID).Tables[0]; if (dtDetail.Rows.Count > 0) { string sPIName = dtDetail.Rows[0]["Name"].ToString(); string sPICode = dtDetail.Rows[0]["Code"].ToString(); ltPageHeader.Text = ltPageHeader.Text + " [" + sPIName + "(" + sPICode + ")" + " ]"; ViewState["PI_Name"] = sPIName + "(" + sPICode + ")"; string sInterval = dtDetail.Rows[0]["Interval"].ToString(); int MeasuredForSBU = Convert.ToInt32(dtDetail.Rows[0]["MeasuredForSBU"]); if (MeasuredForSBU == 1) { ViewState["MeasuredForSBU"] = MeasuredForSBU; ltSBUValue.Visible = true; txtSBU.Visible = true; rgdItems.Visible = false; } else { ltSBUValue.Visible = false; txtSBU.Visible = false; // BindGrid(); } if (sInterval.ToUpper() == "QUARTER") { ltQtrMonth.Text = " For Quarter :"; ddlQuarter.Visible = true; ddlMonths.Visible = false; } else if (sInterval.ToUpper() == "MONTH") { ltQtrMonth.Text = " For Month :"; ddlQuarter.Visible = false; ddlMonths.Visible = true; } else { ltQtrMonth.Visible = false; ddlQuarter.Visible = false; ddlMonths.Visible = false; } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// Method to bind PI controls /// </summary> protected void BindPIDetail() { try { PI_Id = Convert.ToInt32(Request.QueryString[0]); if (PI_Id != 0) { ddlInterval.Enabled = false; } DataTable dtDetail = BLL_TMSA_PI.Get_PI_Details(PI_Id).Tables[0]; DataTable dtWorklist = BLL_TMSA_PI.Get_PI_Details(PI_Id).Tables[1]; if (dtDetail.Rows.Count > 0) { txtName.Text = dtDetail.Rows[0]["Name"].ToString(); txtPICode.Text = dtDetail.Rows[0]["Code"].ToString(); txtDescription.Text = dtDetail.Rows[0]["Description"].ToString(); txtContext.Text = dtDetail.Rows[0]["Context"].ToString(); string sInterval = dtDetail.Rows[0]["Interval"].ToString(); string sUOM = dtDetail.Rows[0]["UOM"].ToString(); string sDatasource = dtDetail.Rows[0]["Datasource"].ToString(); string sStatus = dtDetail.Rows[0]["PI_Status"].ToString(); MeasuredForSBU = Convert.ToInt16(dtDetail.Rows[0]["MeasuredForSBU"]); IsWorkList = Convert.ToInt16(dtDetail.Rows[0]["IsWorkList"]); IsInspection = Convert.ToInt16(dtDetail.Rows[0]["IsInspectionType"]); IsVetting = Convert.ToInt16(dtDetail.Rows[0]["IsVetting"]); if (ddlStatus.Items.FindByValue(sStatus) != null) { ddlStatus.SelectedValue = sStatus; } IncludeBL = Convert.ToInt16(dtDetail.Rows[0]["IncludeBL"]); if (ddlListSource.Items.FindByValue(sDatasource) != null) { ddlListSource.SelectedValue = sDatasource; } if (MeasuredForSBU == 1) { chkMeasuredForSBU.Checked = true; } if (IncludeBL == 1) { chkBallastLaden.Checked = true; } if (ddlInterval.Items.FindByValue(sInterval) != null) { ddlInterval.SelectedValue = ddlInterval.Items.FindByValue(sInterval).Value; } if (ddlUOM.Items.FindByValue(sUOM) != null) { ddlUOM.SelectedValue = ddlUOM.Items.FindByValue(sUOM).Value; } if (IsWorkList == 1)//For worklist PI { chkIsWorklist.Checked = true; if (ddlInterval.Items.FindByValue("Monthly") != null) { ddlInterval.SelectedValue = "Monthly"; ddlInterval.Enabled = false; } if (ddlUOM.Items.FindByValue("Numbers") != null) { ddlUOM.SelectedValue = "Numbers"; ddlUOM.Enabled = false; } Page.ClientScript.RegisterStartupScript(this.GetType(), "toggleAdvSearch", "toggleAdvSearch()", true); BindNatureForDropDown(); } else { ddlInterval.Enabled = true; ddlUOM.Enabled = true; } if (IsInspection == 1)//For inspection type PI { chkInspection.Checked = true; if (ddlInterval.Items.FindByValue("Monthly") != null) { ddlInterval.SelectedValue = "Monthly"; ddlInterval.Enabled = false; } if (ddlUOM.Items.FindByValue("Numbers") != null) { ddlUOM.SelectedValue = "Numbers"; ddlUOM.Enabled = false; } Page.ClientScript.RegisterStartupScript(this.GetType(), "toggleAdvSearch", "toggleAdvSearch()", true); BindInspectionType(); } else { ddlInterval.Enabled = true; ddlUOM.Enabled = true; } if (IsVetting == 1)//For vetting type PI { chkVetting.Checked = true; if (ddlInterval.Items.FindByValue("Monthly") != null) { ddlInterval.SelectedValue = "Monthly"; ddlInterval.Enabled = false; } if (ddlUOM.Items.FindByValue("Numbers") != null) { ddlUOM.SelectedValue = "Numbers"; ddlUOM.Enabled = false; } Page.ClientScript.RegisterStartupScript(this.GetType(), "toggleAdvSearch", "toggleAdvSearch()", true); BindVettingType(); } else { ddlInterval.Enabled = true; ddlUOM.Enabled = true; } if (IsVetting == 2)//For vetting observations PI { chkObservation.Checked = true; if (ddlInterval.Items.FindByValue("Monthly") != null) { ddlInterval.SelectedValue = "Monthly"; ddlInterval.Enabled = false; } if (ddlUOM.Items.FindByValue("Numbers") != null) { ddlUOM.SelectedValue = "Numbers"; ddlUOM.Enabled = false; } BindVettingObservationCategories(); BindVettingTypeForObservation(); Page.ClientScript.RegisterStartupScript(this.GetType(), "toggleAdvSearch", "toggleAdvSearch()", true); // BindVettingObservations(); } else { ddlInterval.Enabled = true; ddlUOM.Enabled = true; } //To bind the work list setting for PI if (dtWorklist != null && dtWorklist.Rows.Count > 0) { ViewState["Worklist_PIID"] = dtWorklist.Rows[0]["WorkList_PI_ID"].ToString(); Assignor_Ids = dtWorklist.Rows[0]["Assigned_By"].ToString(); chkActivate_Scheduler.Checked = Convert.ToBoolean(dtWorklist.Rows[0]["Activate_Scheduler"]); InspectionType_IDs = dtWorklist.Rows[0]["Inspection_Type"].ToString(); VettingType_IDs = dtWorklist.Rows[0]["Vetting_Type"].ToString(); string[] splitStr; string sValue = "0"; if (IsWorkList == 1) { Job_Type = dtWorklist.Rows[0]["Job_Type"].ToString(); Nature_Ids = dtWorklist.Rows[0]["Nature_List"].ToString(); Primary_IDs = dtWorklist.Rows[0]["Primary_List"].ToString(); Secondary_IDs = dtWorklist.Rows[0]["Secondary_List"].ToString(); Minor_IDs = dtWorklist.Rows[0]["Minor_List"].ToString(); //To select the assignor splitStr = Assignor_Ids.Split(','); ddlAssignor.ClearSelection(); //loop through the array items & add the to Dropdownlist for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString().Trim(); if (ddlAssignor.Items.FindByValue(sValue) != null) { ddlAssignor.Items.FindByValue(sValue).Selected = true; } } //To select the Job type splitStr = Job_Type.Split(','); //loop through the arraylist items & add the to Dropdownlist for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (lstJOB.Items.FindByValue(sValue) != null) { lstJOB.Items.FindByValue(sValue).Selected = true; } } //To select the nature category splitStr = Nature_Ids.Split(','); //loop through the arraylist items & add the to Dropdownlist for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (sValue != "0") { if (ddlNature.Items.FindByValue(sValue) != null) { ddlNature.Items.FindByValue(sValue).Selected = true; } BindPrimaryByNatureID(Convert.ToInt32(sValue)); } } //To select the primary category splitStr = Primary_IDs.Split(','); for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (sValue != "0") { if (ddlPrimary.Items.FindByValue(sValue) != null) { ddlPrimary.Items.FindByValue(sValue).Selected = true; } BindSecondaryByPrimaryID(Convert.ToInt32(sValue)); } else { ddlPrimary.SelectedValue = "0"; } } //To select the secondary category splitStr = Secondary_IDs.Split(','); for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (sValue != "0") { if (ddlSecondary.Items.FindByValue(sValue) != null) { ddlSecondary.Items.FindByValue(sValue).Selected = true; } BindMinorBySecondatyID(Convert.ToInt32(sValue)); } else { ddlSecondary.SelectedValue = "0"; } } //To select the minor category splitStr = Minor_IDs.Split(','); ddlMinor.ClearSelection(); //loop through the arraylist items & add the to Dropdownlist for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (sValue != "0") { if (ddlMinor.Items.FindByValue(sValue) != null) { ddlMinor.Items.FindByValue(sValue).Selected = true; } } else { ddlMinor.SelectedValue = "0"; } } } else if (IsInspection == 1) { //To select the assignor splitStr = Assignor_Ids.Split(','); ddlAssignor.ClearSelection(); chkActivateInspectionScheduler.Checked = Convert.ToBoolean(dtWorklist.Rows[0]["Activate_Scheduler"]); splitStr = InspectionType_IDs.Split(','); //loop through the arraylist items & add the to Dropdownlist for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (ddlInspectionType.Items.FindByValue(sValue) != null) { ddlInspectionType.Items.FindByValue(sValue).Selected = true; } } } else if (IsVetting == 1)//For vetting type { ddlVettingType.ClearSelection(); chkActivateVettingScheduler.Checked = Convert.ToBoolean(dtWorklist.Rows[0]["Activate_Scheduler"]); splitStr = VettingType_IDs.Split(','); //loop through the arraylist items & add the to Dropdownlist for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (ddlVettingType.Items.FindByValue(sValue) != null) { ddlVettingType.Items.FindByValue(sValue).Selected = true; } } } else if (IsVetting == 2)//For vetting observation { lstObservationVettingType.ClearSelection(); chkActivateObservationScheduler.Checked = Convert.ToBoolean(dtWorklist.Rows[0]["Activate_Scheduler"]); Observation_Category = dtWorklist.Rows[0]["Observation_Category"].ToString(); Observation_Type = dtWorklist.Rows[0]["Observation_Type"].ToString(); Observation_Risk_Level = dtWorklist.Rows[0]["Observation_Risk_Level"].ToString(); splitStr = VettingType_IDs.Split(','); //loop through the arraylist items & add the to Dropdownlist for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (lstObservationVettingType.Items.FindByValue(sValue) != null) { lstObservationVettingType.Items.FindByValue(sValue).Selected = true; } } splitStr = Observation_Category.Split(','); for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (lstObservationCategory.Items.FindByValue(sValue) != null) { lstObservationCategory.Items.FindByValue(sValue).Selected = true; } } splitStr = Observation_Type.Split(','); for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (lstObservationType.Items.FindByValue(sValue) != null) { lstObservationType.Items.FindByValue(sValue).Selected = true; } } splitStr = Observation_Risk_Level.Split(','); for (int i = 0; i < splitStr.Length; i++) { sValue = splitStr[i].ToString(); if (lstRiskLevel.Items.FindByValue(sValue) != null) { lstRiskLevel.Items.FindByValue(sValue).Selected = true; } } } } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }