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 = 0;
gvBunkerReport.DataSource = BLL_OPS_VoyageReports.Get_BunkerReportIndex(Convert.ToInt32(ViewState["iVesselID"]), Convert.ToInt32(ViewState["iPortID"]), 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"]));
gvBunkerReport.DataBind();
ucCustomPagerItems.CountTotalRec = Record_count.ToString();
ucCustomPagerItems.BuildPager();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["BunkerReportId"] != null)
{
string[] filters = Request.QueryString["filters"].Split('~');
DataTable dtReports = BLL_OPS_VoyageReports.Get_BunkerReportIndex(Convert.ToInt32(filters[0]), Convert.ToInt32(filters[1]), filters[2], filters[3], Convert.ToInt32(filters[4]));
dtReports.PrimaryKey = new DataColumn[] { dtReports.Columns["BUNKER_REPORT_ID"] };
ctlRecordNavigationReport.InitRecords(dtReports);
DataRow dr = dtReports.Rows.Find(Int32.Parse(Request.QueryString["BunkerReportId"]));
ctlRecordNavigationReport.CurrentIndex = dtReports.Rows.IndexOf(dr);
BindReport(dr);
}
}
}
protected void btnView_Click(object sender, ImageClickEventArgs e)
{
if (ViewState["sFromDT"].ToString() == "")
{
ViewState["sFromDT"] = "1900/01/01";
}
if (ViewState["sToDT"].ToString() == "")
{
ViewState["sToDT"] = "1900/01/01";
}
DataTable dt = BLL_OPS_VoyageReports.Get_BunkerReportIndex(Convert.ToInt32(ViewState["iVesselID"]), Convert.ToInt32(ViewState["iPortID"]), ViewState["sFromDT"].ToString(), ViewState["sToDT"].ToString(), Convert.ToInt32(ViewState["iFleetID"]));
string[] HeaderCaptions = { "Date", "Voyage", "Port", "Commenced Bunkering", "Completed Bunkering", "Quantity Bunkered", "Grade" };
string[] DataColumnsNames = { "REPORT_DATE", "VOYAGE", "PORT_NAME", "COMMENCED_BUNKERING", "COMPLETED_BUNKERING", "QUANTITY_BUNKERED_Fuel_Oil", "QUANTITY_BUNKERED_Fuel_Oil_Type" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsNames, "BunkerReport", "BunkerReport", "");
}
