private void Load_LashingGearInventoryReport_Details(int Main_Report_ID, int Vessel_ID)
 {
     try
     {
         DataSet ds = BLL_LGInventoryReport.Get_LGI_REPORT_Log(Main_Report_ID, Vessel_ID);
         if (ds.Tables[1].Rows.Count > 0)
         {
             lblReportDate.Text      = ds.Tables[1].Rows[0]["RptDate"].ToString();
             lblVesselName.Text      = ds.Tables[1].Rows[0]["Vessel_Name"].ToString();
             txtremarks.Text         = ds.Tables[1].Rows[0]["Remarks"].ToString();
             lblMasterSignature.Text = ds.Tables[1].Rows[0]["MasterName"].ToString();
             //lblmasterDate.Text = ds.Tables[1].Rows[0]["CrewMsDate"].ToString();
             lblchiefofficer.Text = ds.Tables[1].Rows[0]["COName"].ToString();
             //lblchiefofficerdate.Text = ds.Tables[1].Rows[0]["CrewCoDate"].ToString();
         }
         GridView_LashingInventoryRPT.DataSource = ds.Tables[0];
         GridView_LashingInventoryRPT.DataBind();
         objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5 }, "Units Received", "HeaderStyle-css");
         objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7 }, "Operational Losses or Condemned", "HeaderStyle-css");
         //UserAccessValidation();
     }
     catch
     {
     }
 }
    //private void Load_LashingGearInventoryReport_Details(int Main_Report_ID, int Vessel_ID)
    //{

    //}
    protected void ImgExpExcel_Click(object sender, ImageClickEventArgs e)
    {
        //string VESSEL = UDFLib.ConvertStringToNull(lblVesselName.Text);

        string VESSEL   = Convert.ToString(lblVesselName.Text);
        string rptddate = Convert.ToString(lblReportDate.Text);

        string  str = "lashing Gear Inventory Report" + "   " + "Vessel Name: " + VESSEL + "  " + "Report Date:" + rptddate + ".";
        DataSet ds  = BLL_LGInventoryReport.Get_LGI_REPORT_Log(UDFLib.ConvertToInteger(Request.QueryString["DtlID"]), UDFLib.ConvertToInteger(Request.QueryString["VID"]));

        string[] HeaderCaptions  = { "Item Description", "Model", "Opening R.O.B.", "Owner", "Charterer", "Owner", "Charterer", "Units Refurbished/Repaired", "Units Claimed from Stevedores", "Closing R.O.B.", "Requirement per Cargo Securing Manual", "Supply Required" };
        string[] DataColumnsName = { "Item_Description", "Model_No", "OpeningROB", "UR_Owner_No", "UR_Charterer_No", "OP_Owner_No", "OP_Charterer_No", "UNIT_Repaired_No", "Unit_Claimed_No", "ClosingROB", "Carg_Securing_Mannual_No", "SupplyReq" };
        GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, "lashingGearInventoryReport", str);
    }