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