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_ASM_OPS_VoyageReport.Get_DailyVoyageReportIndex(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_ASM_OPS_VoyageReport.Get_DailyVoyageReportIndex(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_ASM_OPS_VoyageReport.Get_VoyageReportIndex_ASM(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_ASM_OPS_VoyageReport.Get_DailyNoonReport_DL_ASM(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_ASM_OPS_VoyageReport.Get_DailyNoonReport_DL_ASM(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();
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_ASM_OPS_VoyageReport.Get_DailyNoonReport_DL_ASM(VesselID, TelegramID);
DataTable dt = ds.Tables[0];
//COP
string cophh = Convert.ToString(dt.Rows[0]["SSP_HH"]);
if (!string.IsNullOrEmpty(cophh))
{
if (cophh.Length == 1)
{
dt.Rows[0]["SSP_HH"] = "0" + dt.Rows[0]["SSP_HH"].ToString();
}
}
string copmm = Convert.ToString(dt.Rows[0]["SSP_HH"]);
if (!string.IsNullOrEmpty(copmm))
{
if (copmm.Length == 1)
{
dt.Rows[0]["SSP_HH"] = "0" + dt.Rows[0]["SSP_HH"].ToString();
}
}
//SBE
string sbehh = Convert.ToString(dt.Rows[0]["SBE_HH"]);
if (!string.IsNullOrEmpty(sbehh))
{
if (sbehh.Length == 1)
{
dt.Rows[0]["SBE_HH"] = "0" + dt.Rows[0]["SBE_HH"].ToString();
}
}
string sbemi = Convert.ToString(dt.Rows[0]["SBE_MI"]);
if (!string.IsNullOrEmpty(sbemi))
{
if (sbemi.Length == 1)
{
dt.Rows[0]["SBE_MI"] = "0" + dt.Rows[0]["SBE_MI"].ToString();
}
}
//POB
string pobhh = Convert.ToString(dt.Rows[0]["POB_HH"]);
if (!string.IsNullOrEmpty(pobhh))
{
if (pobhh.Length == 1)
{
dt.Rows[0]["POB_HH"] = "0" + dt.Rows[0]["POB_HH"].ToString();
}
}
string pobmi = Convert.ToString(dt.Rows[0]["POB_MI"]);
if (!string.IsNullOrEmpty(pobmi))
{
if (pobmi.Length == 1)
{
dt.Rows[0]["POB_MI"] = "0" + dt.Rows[0]["POB_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();
fvdepature.DataSource = dt;
fvdepature.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;
}
}
