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