protected void getJobDetails(int OFFICE_ID, int WORKLIST_ID, int VESSEL_ID)
{
try
{
DataSet dtsJobDetails = objBLL.Get_JobDetails_ByID(OFFICE_ID, WORKLIST_ID, VESSEL_ID);
if (dtsJobDetails.Tables[0].Rows.Count > 0)
{
if (dtsJobDetails.Tables[0].Rows[0]["IsVessel"].ToString() == "1")
{
txtSubject.Text = "Worklist Job: " + dtsJobDetails.Tables[0].Rows[0]["WORKLIST_ID"].ToString() + "/" + dtsJobDetails.Tables[0].Rows[0]["VESSEL_SHORT_NAME"].ToString();
}
else
{
txtSubject.Text = "Worklist Job: " + dtsJobDetails.Tables[0].Rows[0]["WORKLIST_ID"].ToString() + "/" + dtsJobDetails.Tables[0].Rows[0]["VESSEL_SHORT_NAME"].ToString() + "/PIC:" + dtsJobDetails.Tables[0].Rows[0]["PIC_Name"].ToString();
}
string msgBody = "";
msgBody += "\n\nVessel: " + dtsJobDetails.Tables[0].Rows[0]["vessel_name"].ToString();
msgBody += "\nJob Code: " + dtsJobDetails.Tables[0].Rows[0]["WORKLIST_ID"].ToString();
msgBody += "\nDescription: " + dtsJobDetails.Tables[0].Rows[0]["JOB_DESCRIPTION"].ToString();
msgBody += "\n\n<a href='www.google.com'>View Job</a>";
txtMailBody.Text = msgBody;
}
}
catch (Exception ex)
{
string js = "alert('Error in loading data!! Error: " + ex.Message + "');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "errorloadingedit", js, true);
}
}
protected void Send_Mail_Job_Details(int OFFICE_ID, int WORKLIST_ID, int VESSEL_ID)
{
try
{
string msgSubject = "";
string msgTo = "";
string msgCC = "";
string msgBCC = "";
DataSet dtsJobDetails = objBLL.Get_JobDetails_ByID(OFFICE_ID, WORKLIST_ID, VESSEL_ID);
if (dtsJobDetails.Tables[0].Rows.Count > 0)
{
if (dtsJobDetails.Tables[0].Rows[0]["IsVessel"].ToString() == "1")
{
msgSubject = "Worklist Job: " + dtsJobDetails.Tables[0].Rows[0]["WORKLIST_ID"].ToString() + "/" + dtsJobDetails.Tables[0].Rows[0]["VESSEL_SHORT_NAME"].ToString();
}
else
{
msgSubject = "Worklist Job: " + dtsJobDetails.Tables[0].Rows[0]["WORKLIST_ID"].ToString() + "/" + dtsJobDetails.Tables[0].Rows[0]["VESSEL_SHORT_NAME"].ToString() + "/PIC:" + dtsJobDetails.Tables[0].Rows[0]["PIC_Name"].ToString();
}
string msgBody = "";
msgBody += "Vessel: " + dtsJobDetails.Tables[0].Rows[0]["vessel_name"].ToString();
msgBody += "<br>Job Code: " + dtsJobDetails.Tables[0].Rows[0]["WORKLIST_ID"].ToString();
msgBody += "<br>Description: " + dtsJobDetails.Tables[0].Rows[0]["JOB_DESCRIPTION"].ToString();
msgBody += "<br><br><a href='http://" + Request.ServerVariables["SERVER_NAME"].ToString() + "/" + ConfigurationManager.AppSettings["APP_NAME"].ToUpper() + "/Technical/worklist/ViewJob.aspx?OFFID=" + OFFICE_ID.ToString() + "&WLID=" + WORKLIST_ID.ToString() + "&VID=" + VESSEL_ID.ToString() + "'>View Job Details</a>";
msgBody += "<br><br>Regards,<br>" + Session["USERFULLNAME"].ToString();
int MsgID = objCrew.Send_CrewNotification(0, 0, 0, 5, msgTo, msgCC, msgBCC, msgSubject, msgBody, "", "MAIL", "", GetSessionUserID(), "DRAFT");
if (MsgID > 0)
{
string js = "window.open('../../Crew/EmailEditor.aspx?ID=" + MsgID + "&Discard=1');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "SendMail" + MsgID, js, true);
}
}
}
catch (Exception ex)
{
string js = "alert('Error in loading data!! Error: " + ex.Message + "');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "errorloadingedit", js, true);
}
}
/// <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();
}
