protected void Load_Next_Of_Kin(int CrewID) { DataTable dtNOK = objBLLCrew.Get_Crew_DependentsByCrewID(CrewID, 1); GridView_Dependents.DataBind(); if (dtNOK.Rows.Count > 0) { lblNOKName.Text = dtNOK.Rows[0]["FirstName"].ToString().ToUpper(); lblNOKSurname.Text = dtNOK.Rows[0]["Surname"].ToString().ToUpper(); lblNOKDOB.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(dtNOK.Rows[0]["DOB"])); lblNOKrelationship.Text = dtNOK.Rows[0]["Relationship"].ToString(); lblNOKAddress.Text = dtNOK.Rows[0]["Address"].ToString(); lblNOKCountry.Text = dtNOK.Rows[0]["Country"].ToString().ToUpper(); lblNOKPhone.Text = dtNOK.Rows[0]["Phone"].ToString(); lblA1.Text = dtNOK.Rows[0]["Address1"].ToString(); lblA2.Text = dtNOK.Rows[0]["Address2"].ToString(); lblNOKSSN.Text = dtNOK.Rows[0]["SSN"].ToString(); } DataTable dtAddress = null; if (objAdmin.CRW_GetCDConfiguration("Addressformat").Tables.Count > 0) { dtAddress = objAdmin.CRW_GetCDConfiguration("Addressformat").Tables[0]; } if (dtAddress.Rows.Count > 0) { if (dtAddress.Rows[0]["Value"].ToString() == "True") { tdA1.Visible = false; tdA2.Visible = false; tdA3.Visible = false; tdA4.Visible = false; tdIA1.Visible = true; tdIA2.Visible = true; trUSADDRESS.Visible = false; tdIPA1.Visible = true; tdIPA2.Visible = true; trCountry.Visible = false; tdCountry1.Visible = false; tdCountry2.Visible = false; } else { tdA1.Visible = true; tdA2.Visible = true; tdA3.Visible = true; tdA4.Visible = true; tdIA1.Visible = false; tdIA2.Visible = false; trUSADDRESS.Visible = true; tdIPA1.Visible = false; tdIPA2.Visible = false; trCountry.Visible = true; tdCountry1.Visible = true; tdCountry2.Visible = true; } } }
private void bindGridView() { DataSet ds = obj.CRW_GetCDConfiguration(null); if (ds != null) { GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string strRowId = DataBinder.Eval(e.Row.DataItem, "ID").ToString(); string PlannedInterviewID = DataBinder.Eval(e.Row.DataItem, "PlannedInterviewID").ToString(); string IQID = DataBinder.Eval(e.Row.DataItem, "IQID").ToString(); string Status_Remark = DataBinder.Eval(e.Row.DataItem, "Status_Remark").ToString(); string CrewName = DataBinder.Eval(e.Row.DataItem, "staff_fullname").ToString(); string ManningOfficeStatus = DataBinder.Eval(e.Row.DataItem, "ManningOfficeStatus").ToString(); string CrewStatus = DataBinder.Eval(e.Row.DataItem, "CrewStatus").ToString().ToUpper(); string CrewID_UnAssigned = DataBinder.Eval(e.Row.DataItem, "CrewID_UnAssigned").ToString(); string CrewID_SigningOff = DataBinder.Eval(e.Row.DataItem, "CrewID_SigningOff").ToString(); string Staff_Code_OffSigner = DataBinder.Eval(e.Row.DataItem, "Staff_Code_OffSigner").ToString(); string Staff_Name_OffSigner = DataBinder.Eval(e.Row.DataItem, "Staff_Name_OffSigner").ToString(); string Staff_Code_OnSigner = DataBinder.Eval(e.Row.DataItem, "Staff_Code_OnSigner").ToString(); string Staff_Name_OnSigner = DataBinder.Eval(e.Row.DataItem, "Staff_Name_OnSigner").ToString(); string SignOffFromVessel = DataBinder.Eval(e.Row.DataItem, "OffSignerVessel").ToString(); string SignOnToVessel = DataBinder.Eval(e.Row.DataItem, "Vessel_Name").ToString(); string Available_From_Date = DataBinder.Eval(e.Row.DataItem, "Available_From_Date").ToString(); string Sign_Off_Date = DataBinder.Eval(e.Row.DataItem, "Sign_Off_Date").ToString(); string MDFStaff = DataBinder.Eval(e.Row.DataItem, "MDFStaff").ToString(); int Marks = UDFLib.ConvertToInteger(DataBinder.Eval(e.Row.DataItem, "Marks").ToString()); int AllAvg = UDFLib.ConvertToInteger(DataBinder.Eval(e.Row.DataItem, "AllAvg").ToString()); int Last_Evaluation_Days = UDFLib.ConvertToInteger(DataBinder.Eval(e.Row.DataItem, "Last_Evaluation_Days").ToString()); string CrewID_Sign_On_Validation = DataBinder.Eval(e.Row.DataItem, "Sign_On_Validation").ToString(); if (CrewID_Sign_On_Validation.Contains("Passport is expiring/expired on :")) { CrewID_Sign_On_Validation = CrewID_Sign_On_Validation.Replace("Passport is expiring/expired on :", ""); string str = CrewID_Sign_On_Validation.Substring(0, 10); CrewID_Sign_On_Validation = CrewID_Sign_On_Validation.Replace(str, ""); if (!string.IsNullOrEmpty(str)) { str = UDFLib.ConvertUserDateFormat(str, UDFLib.GetDateFormat()); } CrewID_Sign_On_Validation = "Passport is expiring/expired on :" + str + CrewID_Sign_On_Validation; } if (CrewID_Sign_On_Validation.Contains("Seaman is expiring/expired on :")) { CrewID_Sign_On_Validation = CrewID_Sign_On_Validation.Replace("Seaman is expiring/expired on :", ""); string str = CrewID_Sign_On_Validation.Substring(0, 10); CrewID_Sign_On_Validation = CrewID_Sign_On_Validation.Replace(str, ""); if (!string.IsNullOrEmpty(str)) { str = UDFLib.ConvertUserDateFormat(str, UDFLib.GetDateFormat()); } CrewID_Sign_On_Validation = "Seaman is expiring/expired on :" + str + CrewID_Sign_On_Validation; } DataRow[] dr; DataTable dt = objCrewAdmin.CRW_GetCDConfiguration(null).Tables[0]; if (dt.Rows.Count > 0) { // string confSSN=dt.row string str = "Age"; dr = dt.Select("Key ='" + str + "'"); if (dr.Length > 0) { if (dr[0].ItemArray[3].ToString() == "True" && dr[0].ItemArray[4].ToString() == "False") { GridView1.Columns[GetColumnIndexByName("Age")].Visible = true; } else { GridView1.Columns[GetColumnIndexByName("Age")].Visible = false; } } } switch (CrewStatus) { case "ONBOARD": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_Current"; break; case "EOC DUE": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_SigningOff"; break; case "ON LEAVE": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_SignedOff"; break; case "SIGNON-PLANNED": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_Assigned"; break; case "SIGNOFF-PLANNED": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_Assigned"; break; case "SIGNON-EVENT": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_Planned"; break; case "SIGNOFF-EVENT": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_Planned"; break; case "CANDIDATE": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_Pending"; break; case "NO VOYAGE": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_NoVoyage"; if (Available_From_Date != "") { if (DateTime.Parse(Available_From_Date) < DateTime.Today) { //Available - No Voyage Label lblAvailable_From_Date = (Label)e.Row.FindControl("lblAvailable_From_Date"); if (lblAvailable_From_Date != null) { lblAvailable_From_Date.CssClass = "Ready_NoVoyage"; } } } break; case "INACTIVE": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_Inactive"; break; case "NTBR": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_NTBR"; e.Row.CssClass = "CrewStatus_NTBR_Row"; break; case "REJECTED": e.Row.Cells[e.Row.Cells.Count - 2].CssClass = "CrewStatus_Rejected"; break; } if (Status_Remark != "") { Status_Remark = Status_Remark.Replace("\n", "<br>"); e.Row.Cells[e.Row.Cells.Count - 2].Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[" + Status_Remark + "]"); } if (UDFLib.ConvertToInteger(PlannedInterviewID) > 0) { ImageButton ImgInterview = (ImageButton)(e.Row.FindControl("ImgInterview")); if (ImgInterview != null) { if (UDFLib.ConvertToInteger(IQID) > 0) { ImgInterview.Attributes.Add("onclick", "window.open('CrewInterview.aspx?ID=" + PlannedInterviewID + "&CrewID=" + strRowId + "');"); } else { ImgInterview.Attributes.Add("onclick", "window.open('Interview.aspx?ID=" + PlannedInterviewID + "&CrewID=" + strRowId + "');"); } ImgInterview.ImageUrl = "~/Images/Interview_1.png"; } } else { ImageButton ImgInterview = (ImageButton)(e.Row.FindControl("ImgInterview")); if (ImgInterview != null) { ImgInterview.Visible = false; } } if (CrewID_UnAssigned != "") { ImageButton ImgCrewAssigned = (ImageButton)(e.Row.FindControl("ImgCrewAssigned")); if (ImgCrewAssigned != null) { ImgCrewAssigned.Attributes.Add("onclick", "window.open('CrewDetails.aspx?ID=" + CrewID_UnAssigned + "');"); ImgCrewAssigned.ImageUrl = "~/Images/crew-on.png"; ImgCrewAssigned.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[On-Signer] body=[" + Staff_Code_OnSigner + " - " + Staff_Name_OnSigner + "<br>To Vessel: " + SignOnToVessel + "]"); } } else { ImageButton ImgCrewAssigned = (ImageButton)(e.Row.FindControl("ImgCrewAssigned")); if (ImgCrewAssigned != null) { ImgCrewAssigned.Visible = false; } } if (CrewID_Sign_On_Validation != "") { ImageButton ImgMissingDocuments = (ImageButton)(e.Row.FindControl("ImgMissingDocuments")); if (ImgMissingDocuments != null) { ImgMissingDocuments.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Missing Data] body=[" + CrewID_Sign_On_Validation + "]"); ImgMissingDocuments.Visible = true; ImgMissingDocuments.ImageUrl = "~/Images/folder-error.png"; } } if (CrewID_SigningOff != "") { ImageButton ImgCrewSigningOff = (ImageButton)(e.Row.FindControl("ImgCrewSigningOff")); if (ImgCrewSigningOff != null) { ImgCrewSigningOff.Attributes.Add("onclick", "window.open('CrewDetails.aspx?ID=" + CrewID_SigningOff + "');"); ImgCrewSigningOff.ImageUrl = "~/Images/crew-off.png"; ImgCrewSigningOff.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Off-Signer] body=[" + Staff_Code_OffSigner + " - " + Staff_Name_OffSigner + "<br>From Vessel: " + SignOffFromVessel + "]"); } } else { ImageButton ImgCrewSigningOff = (ImageButton)(e.Row.FindControl("ImgCrewSigningOff")); if (ImgCrewSigningOff != null) { ImgCrewSigningOff.Visible = false; } } if (objUA.Edit > 0) { ImageButton ImgEdit = (ImageButton)(e.Row.FindControl("ImgEdit")); if (ImgEdit != null) { //ImgEdit.Attributes.Add("onclick", "window.open('AddEditCrew.aspx?ID=" + strRowId + "');"); ImgEdit.Attributes.Add("onclick", "window.open('AddEditCrewNew.aspx?crewid=" + strRowId + "');"); ImgEdit.ImageUrl = "~/Images/edit.gif"; } } else { ImageButton ImgEdit = (ImageButton)(e.Row.FindControl("ImgEdit")); if (ImgEdit != null) { ImgEdit.Visible = false; } } Image ImbCOCModified = (Image)e.Row.FindControl("ImbCOCModified"); if (ImbCOCModified != null) { if (DataBinder.Eval(e.Row.DataItem, "COCRemark").ToString() == "") { ImbCOCModified.Visible = false; } else { ImbCOCModified.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[COC Modified] body=[" + DataBinder.Eval(e.Row.DataItem, "COCRemark").ToString().Replace("\n", "<br>") + "]"); } } Label lblX = (Label)e.Row.FindControl("lblX"); if (lblX != null) { int iCount = UDFLib.ConvertToInteger(DataBinder.Eval(e.Row.DataItem, "InterviewCount").ToString()); if (iCount > 0 && iCount <= 2) { lblX.Text = "*"; } if (iCount > 2) { lblX.Text = "**"; } } //Added a check so that only Office User or Admin can Propose or Approve Red/Yellow card(Manning agent should not be able to propose/approve card) if (Session["UTYPE"].ToString() == "OFFICE USER" || Session["UTYPE"].ToString() == "ADMIN") { Image ImgCard = (Image)e.Row.FindControl("ImgCard"); if (ImgCard != null) { if (DataBinder.Eval(e.Row.DataItem, "CardType").ToString() == "") { ImgCard.Visible = false; } else { ImgCard.ImageUrl = "../images/" + DataBinder.Eval(e.Row.DataItem, "CardType").ToString().Replace(" ", "") + "_" + DataBinder.Eval(e.Row.DataItem, "CardsTATUS").ToString() + ".png"; ImgCard.Visible = true; ImgCard.Attributes.Add("onclick", "showDiv('dvProposeYellowCard','" + DataBinder.Eval(e.Row.DataItem, "ID").ToString() + "');"); ImgCard.Attributes.Add("onmouseover", "showRemarks(" + DataBinder.Eval(e.Row.DataItem, "CardID").ToString() + ",event,this);"); } } } if (MDFStaff == "1") { e.Row.Cells[e.Row.Cells.Count - 10].Text = ""; } Label lblMarks = (Label)e.Row.FindControl("lblMarks"); if (lblMarks != null) { if (Marks < AllAvg) { e.Row.Cells[e.Row.Cells.Count - 4].CssClass = "eval-background-pink"; } if (Marks > AllAvg) { e.Row.Cells[e.Row.Cells.Count - 4].CssClass = "eval-background-lightgreen"; } if (Last_Evaluation_Days > 90) { e.Row.Cells[e.Row.Cells.Count - 4].CssClass = "eval-background-yellow"; } e.Row.Cells[e.Row.Cells.Count - 4].ToolTip = "Last evaluation done before: " + Last_Evaluation_Days.ToString() + " days"; } } if (e.Row.RowType == DataControlRowType.Header) { if (ViewState["SORTBYCOLOUMN"] != null) { HtmlImage img = (HtmlImage)e.Row.FindControl(ViewState["SORTBYCOLOUMN"].ToString()); if (img != null) { if (ViewState["SORTDIRECTION"] == null || ViewState["SORTDIRECTION"].ToString() == "0") { img.Src = "~/Images/arrowUp.png"; } else { img.Src = "~/Images/arrowDown.png"; } img.Visible = true; } } } }
protected void ConfidentialityCheck() { DataSet ds = objCrewAdmin.CRW_GetCDConfiguration(null); if (ds != null) { DataTable dt = ds.Tables[0]; string str = ""; DataRow[] dr; if (dt.Rows.Count > 0) { str = "PermanentStatus"; dr = dt.Select("Key ='" + str + "'"); if (dr.Length > 0) { if (dr[0].ItemArray[3].ToString() == "True" && dr[0].ItemArray[4].ToString() == "False") { lblPermanent.Visible = true; tdlblPermanent.Visible = true; tdtxtPermanent.Attributes.Add("class", "data"); tdtxtPermanentEdit.Visible = true; ddlPermamnent.Visible = true; } else { lblPermanent.Visible = false; tdlblPermanent.Visible = false; tdtxtPermanent.Attributes.Remove("class"); tdtxtPermanentEdit.Visible = false; ddlPermamnent.Visible = false; } } str = "HireDate"; dr = dt.Select("Key ='" + str + "'"); if (dr.Length > 0) { if (dr[0].ItemArray[3].ToString() == "True" && dr[0].ItemArray[4].ToString() == "False") { tdHireDatelbl.Visible = true; trHireDatetxt.Visible = true; } else { tdHireDatelbl.Visible = false; trHireDatetxt.Visible = false; } } str = "UUB"; dr = dt.Select("Key ='" + str + "'"); if (dr.Length > 0) { if (dr[0].ItemArray[3].ToString() == "True" && dr[0].ItemArray[4].ToString() == "False") { tdUnion.Visible = true; tdlblUnionBook.Visible = true; tdtxtUnionBook.Visible = true; trtxtUnion.Visible = true; tdlblUnionBookEdit.Visible = true; tddrpUnionBookEdit.Visible = true; } else { tdUnion.Visible = false; tdlblUnionBook.Visible = false; tdtxtUnionBook.Visible = false; trtxtUnion.Visible = false; tdlblUnionBookEdit.Visible = false; tddrpUnionBookEdit.Visible = false; } } } } }