/// <summary>
/// Load all data to respective controls ,when user View job.
/// </summary>
/// <param name="drWorklistDetails"> Data row of unique key combination of Vessel ID, Office Id and Worklist ID.</param>
protected void fillvalue(DataRow drWorklistDetails)
{
try
{
if (drWorklistDetails != null)
{
int _OfficeID = Convert.ToInt32(drWorklistDetails["office_id"]);
int WorklistID = Convert.ToInt32(drWorklistDetails["worklist_id"]);
int VesselID = Convert.ToInt32(drWorklistDetails["vessel_id"]);
txtFollowupDate.Text = DateTime.Today.ToString("dd/MM/yyyy");
DataSet dtsJobDetails = objBLL.Get_JobDetails_ByID(_OfficeID, WorklistID, VesselID);
if (dtsJobDetails != null)
{
hdnOfficeID.Value = _OfficeID.ToString();
hdnVesselID.Value = VesselID.ToString();
hdnWorklistlID.Value = WorklistID.ToString();
Session["hdnOfficeID"] = _OfficeID.ToString();
Session["hdnVesselIDl"] = VesselID.ToString();
Session["hdnWorklistlID"] = WorklistID.ToString();
string temp = "";
hplCloseThisJob.Visible = false;
hplRework.Visible = false;
lblWorklistTitle.Text = "";
txtWorklistStatusRemark.Text = "";
lblFunction.Text = "";
lblFunction.Text = dtsJobDetails.Tables[0].Rows[0]["Function_Text"].ToString();
lblLocation.Text = "";
lblLocation.Text = dtsJobDetails.Tables[0].Rows[0]["Location_Text"].ToString();
lblSubLocation.Text = "";
lblSubLocation.Text = dtsJobDetails.Tables[0].Rows[0]["Sub_Location_Text"].ToString();
hplCloseThisJob.Visible = false;
if (dtsJobDetails.Tables[0].Rows[0]["VERIFIED_BY"].ToString() == "")
{
if (dtsJobDetails.Tables[0].Rows[0]["WL_TYPE"].ToString() == "NCR" || (dtsJobDetails.Tables[0].Rows[0]["WL_TYPE"].ToString() != "NCR" && dtsJobDetails.Tables[0].Rows[0]["DATE_COMPLETED"].ToString() != "") || (dtsJobDetails.Tables[0].Rows[0]["WL_TYPE"].ToString() != "NCR" && dtsJobDetails.Tables[0].Rows[0]["Vessel_ID"].ToString() == "11"))
{
if (objBLL.Get_Worklist_Access_ByUser(Convert.ToInt32(Session["USERID"]), "CLOSE", dtsJobDetails.Tables[0].Rows[0]["WL_TYPE"].ToString()))
{
hplCloseThisJob.Visible = true;
}
}
}
hplRework.Visible = false;
if (dtsJobDetails.Tables[0].Rows[0]["DATE_COMPLETED"].ToString() != "")
{
if (objBLL.Get_Worklist_Access_ByUser(Convert.ToInt32(Session["USERID"]), "REWORK", dtsJobDetails.Tables[0].Rows[0]["WL_TYPE"].ToString()))
{
hplRework.Visible = true;
}
}
string CREATED_DATE = dtsJobDetails.Tables[0].Rows[0]["CREATED_DATE"].ToString() == "" ? "" : "<br>" + dtsJobDetails.Tables[0].Rows[0]["CREATED_DATE"].ToString();
string MODIFIED_DATE = dtsJobDetails.Tables[0].Rows[0]["MODIFIED_DATE"].ToString() == "" ? "" : "<br>" + dtsJobDetails.Tables[0].Rows[0]["MODIFIED_DATE"].ToString();
string VERIFIED_DATE = dtsJobDetails.Tables[0].Rows[0]["VERIFIED_DATE"].ToString() == "" ? "" : "<br>" + dtsJobDetails.Tables[0].Rows[0]["VERIFIED_DATE"].ToString();
string COMPLETED_DATE = dtsJobDetails.Tables[0].Rows[0]["DATE_COMPLETED"].ToString() == "" ? "" : "<br>" + dtsJobDetails.Tables[0].Rows[0]["DATE_COMPLETED"].ToString();
if (dtsJobDetails.Tables[0].Rows.Count > 0)
{
this.Title = "Job: " + dtsJobDetails.Tables[0].Rows[0]["WLID_DISPLAY"].ToString() + "/" + dtsJobDetails.Tables[0].Rows[0]["VESSEL_SHORT_NAME"].ToString();
lblVesselName.Text = dtsJobDetails.Tables[0].Rows[0]["Vessel_Name"].ToString();
lblVesselName.NavigateUrl = "../../Crew/CrewListHistory.aspx?VesselID=" + dtsJobDetails.Tables[0].Rows[0]["VESSEL_ID"].ToString();
lblVesselCode.Text = dtsJobDetails.Tables[0].Rows[0]["Vessel_Code"].ToString();
lblVesselCode.NavigateUrl = "../../Crew/CrewListHistory.aspx?VesselID=" + dtsJobDetails.Tables[0].Rows[0]["VESSEL_ID"].ToString();
lbljobCode.Text = dtsJobDetails.Tables[0].Rows[0]["WLID_DISPLAY"].ToString();
lblJobStatus.Text = dtsJobDetails.Tables[0].Rows[0]["WL_STATUS_DISPLAY"].ToString();
lblReqsnStatus.Text = " - " + dtsJobDetails.Tables[0].Rows[0]["REQSN_STATUS"].ToString();
if (dtsJobDetails.Tables[0].Rows[0]["VESSEL_ID"].ToString().ToUpper() != "11" && dtsJobDetails.Tables[0].Rows[0]["WORKLIST_ID"].ToString() == "0")
{
pnlViewCrewInvolve.Visible = false;
}
lblCompletedOn.Text = "";
if (dtsJobDetails.Tables[0].Rows[0]["DATE_COMPLETED"].ToString() != "")
{
temp = Convert.ToDateTime(dtsJobDetails.Tables[0].Rows[0]["DATE_COMPLETED"].ToString()).ToString("dd-MMM-yyyy").ToString();
lblCompletedOn.Text = temp == "01-Jan-1900" ? "" : temp;
}
if (dtsJobDetails.Tables[0].Rows[0]["WL_TYPE"].ToString() == "NCR")
{
lblNCRNo.Text = dtsJobDetails.Tables[0].Rows[0]["NCR_NUM"].ToString() + " / " + dtsJobDetails.Tables[0].Rows[0]["NCR_YEAR"].ToString();
lblNCRNoCap.Visible = true;
pnlNCRRelated.Visible = true;
pnlRootCause.Visible = false;
lblCompletedOnCaption.Text = "Closed On/By";
}
else
{
lblNCRNo.Text = "";
lblNCRNoCap.Visible = false;
pnlNCRRelated.Visible = false;
pnlRootCause.Visible = false;
}
try
{
if (dtsJobDetails.Tables[0].Rows[0]["Verified_By_Name"].ToString() != "")
{
pnlRootCause.Visible = true;
lknCompletedBy.Text = dtsJobDetails.Tables[0].Rows[0]["Verified_By_Name"].ToString() + VERIFIED_DATE;
if (dtsJobDetails.Tables[0].Rows[0]["Verified_By_CrewID"].ToString() != "")
{
lknCompletedBy.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + dtsJobDetails.Tables[0].Rows[0]["Verified_By_CrewID"].ToString();
}
}
else
{
lknCompletedBy.Visible = false;
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
lknCompletedBy.Visible = false;
}
if (dtsJobDetails.Tables[0].Rows[0]["DATE_COMPLETED"].ToString() != "")
{
lblCompletedOn.Text = dtsJobDetails.Tables[0].Rows[0]["Modified_By_Name"].ToString() + COMPLETED_DATE;
if (dtsJobDetails.Tables[0].Rows[0]["Modified_By_Name"].ToString() != "")
{
lblCompletedOn.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + dtsJobDetails.Tables[0].Rows[0]["Modified_By_CrewID"].ToString();
}
}
else
{
lblCompletedOn.Visible = false;
}
if (dtsJobDetails.Tables[0].Rows[0]["DATE_RAISED"].ToString() != "")
{
temp = Convert.ToDateTime(dtsJobDetails.Tables[0].Rows[0]["DATE_RAISED"].ToString()).ToString("dd/MM/yyyy");
lblRaisedOn.Text = temp == "01-Jan-1900" ? "" : temp;
}
if (dtsJobDetails.Tables[0].Rows[0]["DATE_ESTMTD_CMPLTN"].ToString() != "")
{
temp = Convert.ToDateTime(dtsJobDetails.Tables[0].Rows[0]["DATE_ESTMTD_CMPLTN"].ToString()).ToString("dd/MM/yyyy");
lblExpectedCompletion.Text = temp == "01-Jan-1900" ? "" : temp;
}
lblPIC.Text = dtsJobDetails.Tables[0].Rows[0]["PIC_Name"].ToString();
lblDeptonShip.Text = dtsJobDetails.Tables[0].Rows[0]["onship_DEPT"].ToString();
lblDeptinOffice.Text = dtsJobDetails.Tables[0].Rows[0]["INOFFICE_DEPT"].ToString();
lbljobType.Text = dtsJobDetails.Tables[0].Rows[0]["Worklist_Type"].ToString();//dtsJobDetails.Tables[0].Rows[0]["NCR"].ToString() == "0" ? "JOB" : "NCR";
lblAssignedBy.Text = dtsJobDetails.Tables[0].Rows[0]["AssignorName"].ToString();
// Added for Vetting
if (lblAssignedBy.Text == "Vetting")
{
pnlVetting.Visible = true;
}
else
{
pnlVetting.Visible = false;
}
lnkRequisitionNumber.Text = Convert.ToString(dtsJobDetails.Tables[0].Rows[0]["REQSN_MSG_REF"].ToString()) == "0" ? "" : dtsJobDetails.Tables[0].Rows[0]["REQSN_MSG_REF"].ToString();
if (dtsJobDetails.Tables[0].Rows[0]["DOCUMENT_CODE"].ToString() != "")
{
lnkRequisitionNumber.NavigateUrl = "~/Purchase/RequisitionSummary.aspx?REQUISITION_CODE=" + dtsJobDetails.Tables[0].Rows[0]["REQSN_MSG_REF"].ToString() + "&Document_Code=" + dtsJobDetails.Tables[0].Rows[0]["DOCUMENT_CODE"].ToString() + "&Vessel_Code=" + VesselID.ToString();
}
else
{
lnkRequisitionNumber.NavigateUrl = "";
}
lblNature.Text = dtsJobDetails.Tables[0].Rows[0]["NATURENAME"].ToString();
lblPrimary.Text = dtsJobDetails.Tables[0].Rows[0]["PRIMARYNAME"].ToString();
lblSecondary.Text = dtsJobDetails.Tables[0].Rows[0]["SECONDARYNAME"].ToString();
lblMinorCategory.Text = Convert.ToString(dtsJobDetails.Tables[0].Rows[0]["CATEGORY_MINOR"]) == "-1" ? "" : Convert.ToString(dtsJobDetails.Tables[0].Rows[0]["MINORNAME"]);
lbldescription.Text = dtsJobDetails.Tables[0].Rows[0]["JOB_DESCRIPTION"].ToString().Replace("\n", "<br>");
lblCauses.Text = dtsJobDetails.Tables[0].Rows[0]["Causes"].ToString().Replace("\n", "<br>");
lblCorrectiveAction.Text = dtsJobDetails.Tables[0].Rows[0]["Correc_Action"].ToString().Replace("\n", "<br>");
lblPreventiveAction.Text = dtsJobDetails.Tables[0].Rows[0]["Preven_Action"].ToString().Replace("\n", "<br>");
lblDeferToDD.Text = (dtsJobDetails.Tables[0].Rows[0]["DEFER_TO_DD"].ToString() == "0") ? "NO" : "YES";
lblPriority.Text = dtsJobDetails.Tables[0].Rows[0]["Priority_Name"].ToString();
lblInspector.Text = dtsJobDetails.Tables[0].Rows[0]["Inspector_Name"].ToString();
lblPSCSIRE.Text = dtsJobDetails.Tables[0].Rows[0]["PSC_SIRE_Name"].ToString();
if (dtsJobDetails.Tables[0].Rows[0]["INSPECTION_DATE"].ToString() != "")
{
lblInspectionDate.Text = DateTime.Parse(dtsJobDetails.Tables[0].Rows[0]["INSPECTION_DATE"].ToString()).ToString("dd/MM/yyyy");
}
else
{
lblInspectionDate.Text = "";
}
if (dtsJobDetails.Tables[0].Rows[0]["Verified_By_CrewID"].ToString() != "")
{
lnkVerifiedBy.Text = dtsJobDetails.Tables[0].Rows[0]["Verified_By_Name"].ToString() + VERIFIED_DATE;
lnkVerifiedBy.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + dtsJobDetails.Tables[0].Rows[0]["Verified_By_CrewID"].ToString();
}
else
{
lnkVerifiedBy.Visible = false;
}
//------------- Followup list ------------------
LoadFollowUps(_OfficeID, VesselID, WorklistID);
//--------------Attachments --------------------
Load_Attachments(VesselID, WorklistID, _OfficeID, GetSessionUserID());
if (dtsJobDetails.Tables[0].Rows[0]["AssignorName"].ToString().ToUpper() == "CREW COMPLAINT")
{
Load_CrewComplaintsLog();
pnlCrewComplaint.Visible = true;
}
else
{
pnlCrewComplaint.Visible = false;
}
if (WorklistID != 0 && (dtsJobDetails.Tables[0].Rows[0]["DATE_COMPLETED"].ToString() == "01/01/1900" || dtsJobDetails.Tables[0].Rows[0]["DATE_COMPLETED"].ToString() == ""))
{
btnEditJob.Visible = true;
}
else
{
btnEditJob.Visible = false;
}
//--- Enable/Disable Follow-up and Attachments
if (dtsJobDetails.Tables[0].Rows[0]["IsVessel"].ToString() == "1")
{
if (UDFLib.ConvertToInteger(dtsJobDetails.Tables[0].Rows[0]["WORKLIST_ID"].ToString()) == 0)
{
ImgBtnAddFollowup.Visible = false;
pnlAddAttachment.Visible = false;
}
else
{
ImgBtnAddFollowup.Visible = (string.IsNullOrWhiteSpace(lblCompletedOn.Text) != true) ? false : true;
pnlAddAttachment.Visible = (string.IsNullOrWhiteSpace(lblCompletedOn.Text) != true) ? false : true;
}
}
else
{
ImgBtnAddFollowup.Visible = (string.IsNullOrWhiteSpace(lblCompletedOn.Text) != true) ? false : true;
pnlAddAttachment.Visible = (string.IsNullOrWhiteSpace(lblCompletedOn.Text) != true) ? false : true;
}
}
// Bind vetting and observation details
if (dtsJobDetails.Tables[1].Rows.Count > 0)
{
lblVetting.Text = dtsJobDetails.Tables[1].Rows[0]["VettingName"].ToString();
lblSelectedObs.Text = dtsJobDetails.Tables[1].Rows[0]["Description"].ToString();
txtObersvation.Text = dtsJobDetails.Tables[1].Rows[0]["Description"].ToString();
BindObservationJobs(int.Parse(dtsJobDetails.Tables[1].Rows[0]["Observation_ID"].ToString()), "Observation");
BindVettingJobs(int.Parse(dtsJobDetails.Tables[1].Rows[0]["Vetting_ID"].ToString()), "Vetting");
}
// Bind Observation Response
if (dtsJobDetails.Tables[2].Rows.Count > 0)
{
GvObservation.DataSource = dtsJobDetails.Tables[2];
GvObservation.DataBind();
}
}
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
UpdatePanel2.Update();
}
