protected void btnView_Click(object sender, ImageClickEventArgs e) { string sFromDate = ""; string sToDate = ""; if (ViewState["sFromDT"].ToString() == "") { sFromDate = "1900/01/01"; } else { sFromDate = ViewState["sFromDT"].ToString(); } if (ViewState["sToDT"].ToString() == "") { sToDate = "1900/01/01"; } else { sToDate = ViewState["sToDT"].ToString(); } int Record_count = ucCustomPagerItems.isCountRecord; DataTable dtReport = BLL_AXSG_OPS_VoyageReport_Chem.Get_DailyVoyageReportIndex_Chem(ViewState["sReportType"].ToString(), Convert.ToInt32(ViewState["iVesselID"]), Convert.ToInt32(ViewState["iLocationID"]), sFromDate, sToDate, Convert.ToInt32(ViewState["iFleetID"]), null, null, ref Record_count, UDFLib.ConvertStringToNull(ViewState["Sort_Column"]), UDFLib.ConvertStringToNull(ViewState["Sort_Direction"])); string[] HeaderCaptions = { "Vessel", "Report Date", "Report Type", "Voyage", "Location", "Next Port", "UTC HR", "Average Speed", "HSFO %S ROB", "LSFO %S ROB", "DO %S ROB" }; string[] DataColumnsName = { "VESSEL_NAME", "TELEGRAM_DATE", "TELEGRAM_TYPE_TEXT", "VOYAGE", "LOCATION_NAME", "NEXT_PORT", "UTC_HR", "AVERAGE_SPEED", "HO_ROB", "LSFO_ROB", "DO_ROB" }; GridViewExportUtil.ShowExcel(dtReport, HeaderCaptions, DataColumnsName, "VoyageReportList", "Voyage Report List", ""); }
protected void BindItems() { string sFromDate = ""; string sToDate = ""; if (ViewState["sFromDT"].ToString() == "") { sFromDate = "1900/01/01"; } else { sFromDate = ViewState["sFromDT"].ToString(); } if (ViewState["sToDT"].ToString() == "") { sToDate = "1900/01/01"; } else { sToDate = ViewState["sToDT"].ToString(); } int Record_count = 1; gvVoyageReport.DataSource = BLL_AXSG_OPS_VoyageReport_Chem.Get_DailyVoyageReportIndex_Chem(ViewState["sReportType"].ToString(), Convert.ToInt32(ViewState["iVesselID"]), Convert.ToInt32(ViewState["iLocationID"]), sFromDate, sToDate, Convert.ToInt32(ViewState["iFleetID"]), UDFLib.ConvertIntegerToNull(ucCustomPagerItems.CurrentPageIndex), UDFLib.ConvertIntegerToNull(ucCustomPagerItems.PageSize), ref Record_count, UDFLib.ConvertStringToNull(ViewState["Sort_Column"]), UDFLib.ConvertStringToNull(ViewState["Sort_Direction"])); gvVoyageReport.DataBind(); ucCustomPagerItems.CountTotalRec = Record_count.ToString(); ucCustomPagerItems.BuildPager(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["TelegramID"] != null && Request.QueryString["VesselID"] != null && Request.QueryString["ReportType"] != null) { string[] filters = Request.QueryString["filters"].Split('~'); DataTable dtReports = BLL_AXSG_OPS_VoyageReport_Chem.Get_VoyageReportIndex_AXSG(Request.QueryString["ReportType"].ToString(), Convert.ToInt32(Request.QueryString["VesselID"].ToString()), Convert.ToInt32(filters[2]), filters[3], filters[4], Convert.ToInt32(filters[5])); dtReports.PrimaryKey = new DataColumn[] { dtReports.Columns["TELEGRAM_ID"] }; DataRow dr = dtReports.Rows.Find(decimal.Parse(Request.QueryString["TelegramID"].ToString())); BindReport(dr); BindFormViewWithData(Convert.ToInt32(Request.QueryString["VesselID"].ToString()), decimal.Parse(Request.QueryString["TelegramID"].ToString())); } } else { } }
protected void BindFormViewWithData(int VesselID, decimal TelegramID) { DataSet ds = BLL_AXSG_OPS_VoyageReport_Chem.Get_DailyNoonReport_DL_AXSG(VesselID, TelegramID); DataTable dt = ds.Tables[0]; string telegramhour = Convert.ToString(dt.Rows[0]["Telegram_Date_HH"]); if (!string.IsNullOrEmpty(telegramhour)) { if (telegramhour.Length == 1) { dt.Rows[0]["Telegram_Date_HH"] = "0" + dt.Rows[0]["Telegram_Date_HH"].ToString(); } } string telegramminutes = Convert.ToString(dt.Rows[0]["Telegram_Date_MI"]); if (!string.IsNullOrEmpty(telegramminutes)) { if (telegramminutes.Length == 1) { dt.Rows[0]["Telegram_Date_MI"] = "0" + dt.Rows[0]["Telegram_Date_MI"].ToString(); } } string etbhours = Convert.ToString(dt.Rows[0]["ETB_HH"]); if (!string.IsNullOrEmpty(etbhours)) { if (etbhours.Length == 1) { dt.Rows[0]["ETB_HH"] = "0" + etbhours; } } string etbmin = Convert.ToString(dt.Rows[0]["ETB_MI"]); if (!string.IsNullOrEmpty(etbmin)) { if (etbmin.Length == 1) { dt.Rows[0]["ETB_MI"] = "0" + etbmin; } } string etshours = Convert.ToString(dt.Rows[0]["ETD_HH"]); if (!string.IsNullOrEmpty(etbhours)) { if (etshours.Length == 1) { dt.Rows[0]["ETD_HH"] = "0" + etshours; } } string etsmin = Convert.ToString(dt.Rows[0]["ETD_MI"]); if (!string.IsNullOrEmpty(etbmin)) { if (etsmin.Length == 1) { dt.Rows[0]["ETD_MI"] = "0" + etsmin; } } dt.AcceptChanges(); fvnoonreport.DataSource = dt; fvnoonreport.DataBind(); GridView gdShifting = (GridView)fvnoonreport.FindControl("gdShifting"); if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { string fromshifttime = Convert.ToString(ds.Tables[1].Rows[i]["SHIFTFROMTIME"]); string fromtimehh = ""; string fromtimemm = ""; string[] fromtime = fromshifttime.Split(':'); if (fromtime.Length > 0) { fromtimehh = Convert.ToString(fromtime[0]); fromtimemm = Convert.ToString(fromtime[1]); } if (!string.IsNullOrEmpty(fromtimehh)) { if (fromtimehh.Length == 1) { fromtimehh = "0" + fromtimehh; } } if (!string.IsNullOrEmpty(fromtimemm)) { if (fromtimemm.Length == 1) { fromtimemm = "0" + fromtimemm; } } fromshifttime = fromtimehh + ":" + fromtimemm; ds.Tables[1].Rows[i]["SHIFTFROMTIME"] = fromshifttime; string Toshifttime = Convert.ToString(ds.Tables[1].Rows[i]["SHIFTTILLTIME"]); string totimehh = ""; string totimemm = ""; string[] totime = Toshifttime.Split(':'); if (totime.Length > 0) { totimehh = Convert.ToString(totime[0]); totimemm = Convert.ToString(totime[1]); } if (!string.IsNullOrEmpty(totimehh)) { if (totimehh.Length == 1) { totimehh = "0" + totimehh; } } if (!string.IsNullOrEmpty(totimemm)) { if (totimemm.Length == 1) { totimemm = "0" + totimemm; } } Toshifttime = totimehh + ":" + totimemm; ds.Tables[1].Rows[i]["SHIFTTILLTIME"] = Toshifttime; ds.Tables[1].AcceptChanges(); } gdShifting.DataSource = ds.Tables[1]; gdShifting.DataBind(); } if (dt.Rows[0]["Master"].ToString() != "" && dt.Rows[0]["Master"].ToString() != "0") { lnkMaster.Text = dt.Rows[0]["MasterDetail"].ToString(); lnkMaster.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + dt.Rows[0]["Master"].ToString(); lnkMaster.Target = "_blank"; imgMaster.ImageUrl = "../uploads/CrewImages/" + dt.Rows[0]["PhotoUrl1"].ToString(); lnkMaster.Visible = true; imgMaster.Visible = true; } else { lnkMaster.Visible = false; imgMaster.Visible = false; } if (dt.Rows[0]["ChiefEngineer"].ToString() != "" && dt.Rows[0]["ChiefEngineer"].ToString() != "0") { lnkChiefEngineer.Text = dt.Rows[0]["CEDetail"].ToString(); lnkChiefEngineer.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + dt.Rows[0]["ChiefEngineer"].ToString(); lnkChiefEngineer.Target = "_blank"; imgChiefEngineer.ImageUrl = "../uploads/CrewImages/" + dt.Rows[0]["PhotoURL2"].ToString(); lnkChiefEngineer.Visible = true; imgChiefEngineer.Visible = true; } else { lnkChiefEngineer.Visible = false; imgChiefEngineer.Visible = false; } }
protected void BindFormViewWithData(int VesselID, decimal TelegramID) { DataSet ds = BLL_AXSG_OPS_VoyageReport_Chem.Get_DailyNoonReport_DL_AXSG(VesselID, TelegramID); DataTable dt = ds.Tables[0]; //EOP string eophh = Convert.ToString(dt.Rows[0]["EOP_HH"]); if (!string.IsNullOrEmpty(eophh)) { if (eophh.Length == 1) { dt.Rows[0]["EOP_HH"] = "0" + dt.Rows[0]["EOP_HH"].ToString(); } } string eopmm = Convert.ToString(dt.Rows[0]["EOP_MI"]); if (!string.IsNullOrEmpty(eopmm)) { if (eopmm.Length == 1) { dt.Rows[0]["EOP_MI"] = "0" + dt.Rows[0]["EOP_MI"].ToString(); } } //ETB string etbhh = Convert.ToString(dt.Rows[0]["ETB_HH"]); if (!string.IsNullOrEmpty(etbhh)) { if (etbhh.Length == 1) { dt.Rows[0]["ETB_HH"] = "0" + dt.Rows[0]["ETB_HH"].ToString(); } } string etbmm = Convert.ToString(dt.Rows[0]["ETB_MI"]); if (!string.IsNullOrEmpty(etbmm)) { if (etbmm.Length == 1) { dt.Rows[0]["ETB_MI"] = "0" + dt.Rows[0]["ETB_MI"].ToString(); } } //ETS string etshh = Convert.ToString(dt.Rows[0]["ETS_HH"]); if (!string.IsNullOrEmpty(etshh)) { if (etshh.Length == 1) { dt.Rows[0]["ETS_HH"] = "0" + dt.Rows[0]["ETS_HH"].ToString(); } } string etsmm = Convert.ToString(dt.Rows[0]["ETS_MI"]); if (!string.IsNullOrEmpty(etbmm)) { if (etbmm.Length == 1) { dt.Rows[0]["ETS_MI"] = "0" + dt.Rows[0]["ETS_MI"].ToString(); } } //ETA Next Port string etahh = Convert.ToString(dt.Rows[0]["ETA_Next_Port_HH"]); if (!string.IsNullOrEmpty(etahh)) { if (etahh.Length == 1) { dt.Rows[0]["ETA_Next_Port_HH"] = "0" + dt.Rows[0]["ETA_Next_Port_HH"].ToString(); } } string etami = Convert.ToString(dt.Rows[0]["ETA_Next_Port_MI"]); if (!string.IsNullOrEmpty(etami)) { if (etami.Length == 1) { dt.Rows[0]["ETA_Next_Port_MI"] = "0" + dt.Rows[0]["ETA_Next_Port_MI"].ToString(); } } if (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["HO_BunkerSampleLandingStatus"]))) { dt.Rows[0]["HO_BunkerSampleLandingStatus"] = "-"; } if (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["DieselOil_BunkerSampleLandingStatus"]))) { dt.Rows[0]["DieselOil_BunkerSampleLandingStatus"] = "-"; } if (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["LubeOil_BunkerSampleLandingStatus"]))) { dt.Rows[0]["LubeOil_BunkerSampleLandingStatus"] = "-"; } dt.AcceptChanges(); fvArrival.DataSource = dt; fvArrival.DataBind(); if (dt.Rows[0]["Master"].ToString() != "" && dt.Rows[0]["Master"].ToString() != "0") { lnkMaster.Text = dt.Rows[0]["MasterDetail"].ToString(); lnkMaster.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + dt.Rows[0]["Master"].ToString(); lnkMaster.Target = "_blank"; imgMaster.ImageUrl = "../uploads/CrewImages/" + dt.Rows[0]["PhotoUrl1"].ToString(); lnkMaster.Visible = true; imgMaster.Visible = true; } else { lnkMaster.Visible = false; imgMaster.Visible = false; } if (dt.Rows[0]["ChiefEngineer"].ToString() != "" && dt.Rows[0]["ChiefEngineer"].ToString() != "0") { lnkChiefEngineer.Text = dt.Rows[0]["CEDetail"].ToString(); lnkChiefEngineer.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + dt.Rows[0]["ChiefEngineer"].ToString(); lnkChiefEngineer.Target = "_blank"; imgChiefEngineer.ImageUrl = "../uploads/CrewImages/" + dt.Rows[0]["PhotoURL2"].ToString(); lnkChiefEngineer.Visible = true; imgChiefEngineer.Visible = true; } else { lnkChiefEngineer.Visible = false; imgChiefEngineer.Visible = false; } }
protected void BindFormViewWithData(int VesselID, decimal TelegramID) { DataSet ds = BLL_AXSG_OPS_VoyageReport_Chem.Get_DailyNoonReport_DL_AXSG(VesselID, TelegramID); DataTable dt = ds.Tables[0]; string telegramhour = Convert.ToString(dt.Rows[0]["Telegram_Date_HH"]); if (!string.IsNullOrEmpty(telegramhour)) { if (telegramhour.Length == 1) { dt.Rows[0]["Telegram_Date_HH"] = "0" + dt.Rows[0]["Telegram_Date_HH"].ToString(); } } string telegramminutes = Convert.ToString(dt.Rows[0]["Telegram_Date_MI"]); if (!string.IsNullOrEmpty(telegramminutes)) { if (telegramminutes.Length == 1) { dt.Rows[0]["Telegram_Date_MI"] = "0" + dt.Rows[0]["Telegram_Date_MI"].ToString(); } } string etahh = Convert.ToString(dt.Rows[0]["ETA_Next_Port_HH"]); if (!string.IsNullOrEmpty(etahh)) { if (etahh.Length == 1) { dt.Rows[0]["ETA_Next_Port_HH"] = "0" + dt.Rows[0]["ETA_Next_Port_HH"].ToString(); } } string etami = Convert.ToString(dt.Rows[0]["ETA_Next_Port_MI"]); if (!string.IsNullOrEmpty(etami)) { if (etami.Length == 1) { dt.Rows[0]["ETA_Next_Port_MI"] = "0" + dt.Rows[0]["ETA_Next_Port_MI"].ToString(); } } dt.AcceptChanges(); ViewState["SeaReport"] = dt; fvnoonreport.DataSource = dt; fvnoonreport.DataBind(); fvCargoTanks.DataSource = ds.Tables[2]; fvCargoTanks.DataBind(); if (dt.Rows[0]["Master"].ToString() != "" && dt.Rows[0]["Master"].ToString() != "0") { lnkMaster.Text = dt.Rows[0]["MasterDetail"].ToString(); lnkMaster.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + dt.Rows[0]["Master"].ToString(); lnkMaster.Target = "_blank"; imgMaster.ImageUrl = "../uploads/CrewImages/" + dt.Rows[0]["PhotoUrl1"].ToString(); lnkMaster.Visible = true; imgMaster.Visible = true; } else { lnkMaster.Visible = false; imgMaster.Visible = false; } if (dt.Rows[0]["ChiefEngineer"].ToString() != "" && dt.Rows[0]["ChiefEngineer"].ToString() != "0") { lnkChiefEngineer.Text = dt.Rows[0]["CEDetail"].ToString(); lnkChiefEngineer.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + dt.Rows[0]["ChiefEngineer"].ToString(); lnkChiefEngineer.Target = "_blank"; imgChiefEngineer.ImageUrl = "../uploads/CrewImages/" + dt.Rows[0]["PhotoURL2"].ToString(); lnkChiefEngineer.Visible = true; imgChiefEngineer.Visible = true; } else { lnkChiefEngineer.Visible = false; imgChiefEngineer.Visible = false; } }