/// <summary>
        /// Date Created:   04/10/2011
        /// Created By:     Gabriel Oquialda
        /// (description)   Get vehicle manifest
        /// </summary>
        private void GetVehicleManifest()
        {
            DataTable VehicleManifestDataTable = null;

            try
            {
                VehicleManifestDataTable = SeafarerTravelBLL.GetSFVehicleTravelListView(
                    GlobalCode.Field2String(Session["DateFrom"]), GlobalCode.Field2String(Session["DateTo"]), GlobalCode.Field2String(Session["strPendingFilter"]),
                    uoDropDownListFilterBy.SelectedValue, uoTextBoxFilter.Text.Trim(), GlobalCode.Field2String(Session["UserName"]),
                    uoDropDownListStatus.SelectedValue, uoDropDownListNationality.SelectedValue, uoDropDownListGender.SelectedValue,
                    uoDropDownListRank.SelectedValue, uoDropDownListVessel.SelectedValue, GlobalCode.Field2String(Session["Region"]),
                    GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["City"]), GlobalCode.Field2String(Session["Port"]),
                    GlobalCode.Field2String(Session["Hotel"]), Session["Vehicle"].ToString(), GlobalCode.Field2String(Session["UserRole"]));

                //VehicleManifestDataTable = SeafarerTravelBLL.GetVehicleManifest(GlobalCode.Field2String(Session["DateFrom"]), GlobalCode.Field2String(Session["DateTo"]),
                //    Session["UserName"].ToString(), GlobalCode.Field2String(Session["strPendingFilter"]), GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]),
                //    GlobalCode.Field2String(Session["City"]), uoDropDownListStatus.SelectedValue, uoDropDownListFilterBy.SelectedValue, uoTextBoxFilter.Text.Trim(),
                //    GlobalCode.Field2String(Session["Port"]), GlobalCode.Field2String(Session["Hotel"]), Session["Vehicle"].ToString(), uoDropDownListVessel.SelectedValue,
                //    uoDropDownListNationality.SelectedValue, uoDropDownListGender.SelectedValue, uoDropDownListRank.SelectedValue);

                uoListViewVehicle.DataSource = VehicleManifestDataTable;
                uoListViewVehicle.DataBind();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (VehicleManifestDataTable != null)
                {
                    VehicleManifestDataTable.Dispose();
                }
            }
        }
Esempio n. 2
0
        /// <summary>
        /// Date Created: 08/07/2011
        /// Created By: Marco Abejar
        /// (description) Get seafarer air travel info
        /// ----------------------------------------------------------------
        /// Date Created: 22/07/2011
        /// Modifed By: Josephine Gad
        /// (description) uogridviewAirTravelInfo to uoListViewAirTravelInfo
        /// ----------------------------------------------------------------
        /// Date Created: 02/08/2011
        /// Modifed By: Josephine Gad
        /// (description) Add parameter seafarer name
        /// ----------------------------------------------------------------
        /// Date Modified: 05/08/2011
        /// Modifed By: Josephine Gad
        /// (description) Add Date Range parameter
        /// </summary>
        private void GetSFAirTravelDetails()
        {
            DataTable AirDataTable = null;

            try
            {
                //string DateFromString = (uoHiddenFieldDateFrom.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateFrom.Value);
                //string DateToString = (uoHiddenFieldDateTo.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateTo.Value);

                //AirDataTable = SeafarerTravelBLL.GetSFAirTravelDetails(strSFStatus, strFlightDateRange, strAirStatusFilter, uoTextBoxName.Text,
                //    DateFromString, DateToString, GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2String(Session["Region"]), uoHiddenFieldFilterBy.Value);
                AirDataTable = SeafarerTravelBLL.GetSFAirTravelDetails(GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString(), uoHiddenFieldDateTo.Value,
                                                                       GlobalCode.Field2String(Session["strAirStatusFilter"]), GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2String(Session["strPendingFilter"]),
                                                                       GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["City"]),
                                                                       uoDropDownListStatus.SelectedValue, uoDropDownListFilterBy.SelectedValue, uoTextBoxFilter.Text.Trim(),
                                                                       GlobalCode.Field2String(Session["Port"]), uoDropDownListVessel.SelectedValue, uoDropDownListNationality.SelectedValue,
                                                                       uoDropDownListGender.SelectedValue, uoDropDownListRank.SelectedValue);

                uoListViewAirTravelInfo.DataSource = AirDataTable;
                uoListViewAirTravelInfo.DataBind();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (AirDataTable != null)
                {
                    AirDataTable.Dispose();
                }
            }
        }
Esempio n. 3
0
        /// <summary>
        /// Date Created:   24/10/2011
        /// Created By:     Josephine Gad
        /// (description)   Show/Hide Scan button
        /// </summary>
        /// <param name="TravelReqID"></param>
        /// <param name="ManualReqID"></param>
        /// <param name="UserID"></param>
        /// <returns></returns>
        protected bool ShowScanBtn(object TravelReqID, object ManualReqID)
        {
            bool bReturn = false;

            bReturn = SeafarerTravelBLL.IsLOEScanned(TravelReqID.ToString(), ManualReqID.ToString(), uoHiddenFieldUser.Value);
            return(bReturn);
        }
        /// <summary>
        /// Date Created:   13/10/2011
        /// Created By:     Josephine Gad
        /// (description)   Get list of rank
        /// </summary>
        private void GetRank()
        {
            DataTable dt = null;

            try
            {
                dt = SeafarerTravelBLL.GetRankByVessel(uoDropDownListVessel.SelectedValue);
                ListItem item = new ListItem("--Select Rank--", "0");
                uoDropDownListRank.Items.Clear();
                uoDropDownListRank.Items.Add(item);
                uoDropDownListRank.DataSource     = dt;
                uoDropDownListRank.DataTextField  = "RankName";
                uoDropDownListRank.DataValueField = "RankID";
                uoDropDownListRank.DataBind();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (dt != null)
                {
                    dt.Dispose();
                }
            }
        }
        /// <summary>
        /// Date Created:  12/12/2011
        /// Created By:    Muhallidin G Wali
        /// description    Use load time
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        private string GetDateCount(DateTime day)
        {
            IDataReader dt      = null;
            string      sReturn = "";

            try
            {
                dt = SeafarerTravelBLL.GetTravelRequestDashboard(1, GlobalCode.Field2DateTime(day.ToString("MM/dd/yyyy")), MUser.GetUserName(), GlobalCode.Field2String(Session["UserRole"]));

                if (dt.Read())
                {
                    if (dt["SIGNON"].ToString() != "0")
                    {
                        sReturn += " <span style=\"color:Green;\">*</span> ";
                    }
                    if (dt["SIGNOFF"].ToString() != "0")
                    {
                        sReturn += " <span style=\"color:Red;\">*</span> ";
                    }
                }
                return(sReturn);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (dt != null)
                {
                    dt.Dispose();
                }
            }
        }
Esempio n. 6
0
        /// <summary>
        /// Date Created:   08/07/2011
        /// Created By:     Marco Abejar
        /// (description)   Get seafarer port info
        /// ------------------------------------------------------
        /// Modified Date:  21/07/2011
        /// Modified By:    Josephine Gad
        /// (description)   Make header Onsigning/Offsigning dynamic
        /// ------------------------------------------------------
        /// Date Modified:  02/08/2011
        /// Modifed By:     Josephine Gad
        /// (description)   Add Date Range parameter
        /// ------------------------------------------------------
        /// Date Created:   05/08/2011
        /// Modifed By:     Josephine gad
        /// (description)   Add parameter seafarer's name, Close DataTable
        /// </summary>
        private void GetSFPortTravelDetails()
        {
            DataTable PortDataTable = null;

            try
            {
                PortDataTable = SeafarerTravelBLL.GetSFPortTravelDetails(GlobalCode.Field2String(Session["DateFrom"]),
                                                                         GlobalCode.Field2String(Session["DateTo"]), uoHiddenFieldUser.Value, GlobalCode.Field2String(Session["strPendingFilter"]),
                                                                         GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["City"]),
                                                                         uoDropDownListStatus.SelectedValue, uoDropDownListFilterBy.SelectedValue, uoTextBoxFilter.Text.Trim(),
                                                                         GlobalCode.Field2String(Session["Port"]), uoDropDownListVessel.SelectedValue,
                                                                         uoDropDownListNationality.SelectedValue, uoDropDownListGender.SelectedValue,
                                                                         uoDropDownListRank.SelectedValue, uoHiddenFieldRole.Value);

                uolistviewPortTravelInfo.DataSource = PortDataTable;
                uolistviewPortTravelInfo.DataBind();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (PortDataTable != null)
                {
                    PortDataTable.Dispose();
                }
            }
        }
Esempio n. 7
0
        private void GetSFVehicleTravelDetails(string strSFStatus, string strFlightDateRange)
        {
            /// <summary>
            /// Date Created: 14/07/2011
            /// Created By: Marco Abejar
            /// (description) Selecting list of vehicle travel details
            /// ------------------------------------------------------
            /// Date Modified: 27/07/2011
            /// Modified By: Josephine Gad
            /// (description) Make header ONSIGNING/OFFSIGNING dynamic
            /// ------------------------------------------------------
            /// Date Modified: 08/05/2011
            /// Modifed By: Josephine Gad
            /// (description) Add Date Range parameter, Close DataTable
            /// </summary>
            ///
            DataTable VehicleDataTable = null;

            try
            {
                string DateFromString = (uoHiddenFieldDateFrom.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateFrom.Value);
                string DateToString   = (uoHiddenFieldDateTo.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateTo.Value);

                VehicleDataTable = SeafarerTravelBLL.GetSFVehicleTravelDetails(strSFStatus, strFlightDateRange, uoTextBoxName.Text,
                                                                               DateFromString, DateToString, GlobalCode.Field2String(Session["UserName"]), uoDropDownListMapRef.SelectedValue, uoHiddenFieldFilterBy.Value);
                uolistviewVehicleTravelInfo.DataSource = VehicleDataTable;
                uolistviewVehicleTravelInfo.DataBind();

                Label ucLabelONOFF = (Label)uolistviewVehicleTravelInfo.FindControl("ucLabelONOFF");
                if (ucLabelONOFF != null)
                {
                    if (Session["strSFStatus"] == "ON")
                    {
                        ucLabelONOFF.Text = "Onsigning";
                    }
                    else
                    {
                        ucLabelONOFF.Text = "Offsigning";
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (VehicleDataTable != null)
                {
                    VehicleDataTable.Dispose();
                }
            }
        }
Esempio n. 8
0
        private void loadSFPendingCounter()
        {
            /// <summary>
            /// Date Created: 04/08/2011
            /// Created By: Marco Abejar
            /// (description) quick link for pending transactions
            /// </summary>

            Session["strSFStatus"]          = Request.QueryString["st"];
            Session["strSFFlightDateRange"] = Request.QueryString["dt"];
            uoPendingAirTrans.Text          = SeafarerTravelBLL.GetPendingTransactionCount(GlobalCode.Field2String(Session["strSFStatus"]), GlobalCode.Field2String(Session["strSFFlightDateRange"]), "Air", uoHiddenFieldDateFrom.Value, uoHiddenFieldDateTo.Value, uoHiddenFieldFilterBy.Value);
            uoPendingHotelTrans.Text        = SeafarerTravelBLL.GetPendingTransactionCount(GlobalCode.Field2String(Session["strSFStatus"]), GlobalCode.Field2String(Session["strSFFlightDateRange"]), "Hotel", uoHiddenFieldDateFrom.Value, uoHiddenFieldDateTo.Value, uoHiddenFieldFilterBy.Value);
            uoPendingVehicleTrans.Text      = SeafarerTravelBLL.GetPendingTransactionCount(GlobalCode.Field2String(Session["strSFStatus"]), GlobalCode.Field2String(Session["strSFFlightDateRange"]), "Vehicle", uoHiddenFieldDateFrom.Value, uoHiddenFieldDateTo.Value, uoHiddenFieldFilterBy.Value);
        }
Esempio n. 9
0
        private void loadSeafarerCount()
        {
            /// <summary>
            /// Date Created: 08/08/2011
            /// Created By: Marco Abejar
            /// (description) quick link for seafarer count
            /// </summary>

            Session["strSFStatus"] = Request.QueryString["st"];
            uohl0_3Count.Text      = SeafarerTravelBLL.GetSeafarerCountByDateRange(GlobalCode.Field2String(Session["strSFStatus"]), "0-3", uoHiddenFieldFilterBy.Value);
            uohl4_7Count.Text      = SeafarerTravelBLL.GetSeafarerCountByDateRange(GlobalCode.Field2String(Session["strSFStatus"]), "4-7", uoHiddenFieldFilterBy.Value);
            uohl8_15Count.Text     = SeafarerTravelBLL.GetSeafarerCountByDateRange(GlobalCode.Field2String(Session["strSFStatus"]), "8-15", uoHiddenFieldFilterBy.Value);
            uohl16_30Count.Text    = SeafarerTravelBLL.GetSeafarerCountByDateRange(GlobalCode.Field2String(Session["strSFStatus"]), "16-30", uoHiddenFieldFilterBy.Value);
            uohl31_100Count.Text   = SeafarerTravelBLL.GetSeafarerCountByDateRange(GlobalCode.Field2String(Session["strSFStatus"]), "31-100", uoHiddenFieldFilterBy.Value);
        }
Esempio n. 10
0
        private void loadSFFlightStatusCounter()
        {
            /// <summary>
            /// Date Created: 04/08/2011
            /// Created By: Marco Abejar
            /// (description) quick link for flight status count
            /// </summary>

            Session["strSFStatus"]          = Request.QueryString["st"];
            Session["strSFFlightDateRange"] = Request.QueryString["dt"];
            uoFlownFlightCount.Text         = SeafarerTravelBLL.GetAirStatusCount(GlobalCode.Field2String(Session["strSFStatus"]), GlobalCode.Field2String(Session["strSFFlightDateRange"]), "Flown", uoHiddenFieldDateFrom.Value, uoHiddenFieldDateTo.Value, uoHiddenFieldFilterBy.Value);
            uoArrivedFlightCount.Text       = SeafarerTravelBLL.GetAirStatusCount(GlobalCode.Field2String(Session["strSFStatus"]), GlobalCode.Field2String(Session["strSFFlightDateRange"]), "Arrived", uoHiddenFieldDateFrom.Value, uoHiddenFieldDateTo.Value, uoHiddenFieldFilterBy.Value);
            uoDelayedFlightCount.Text       = SeafarerTravelBLL.GetAirStatusCount(GlobalCode.Field2String(Session["strSFStatus"]), GlobalCode.Field2String(Session["strSFFlightDateRange"]), "Delayed", uoHiddenFieldDateFrom.Value, uoHiddenFieldDateTo.Value, uoHiddenFieldFilterBy.Value);
            uoCancelledFlightCount.Text     = SeafarerTravelBLL.GetAirStatusCount(GlobalCode.Field2String(Session["strSFStatus"]), GlobalCode.Field2String(Session["strSFFlightDateRange"]), "Cancelled", uoHiddenFieldDateFrom.Value, uoHiddenFieldDateTo.Value, uoHiddenFieldFilterBy.Value);
        }
Esempio n. 11
0
 /// <summary>
 /// Date Created:   13/10/2011
 /// Created By:     Josephine Gad
 /// (description)   Get list of rank
 /// </summary>
 private void GetCostCenter()
 {
     try
     {
         string[] arg      = new string[2];
         char[]   splitter = { '-' };
         arg = SeafarerTravelBLL.GetCostCenterByRank(uoDropDownListRank.SelectedValue).Split(splitter);
         uoTextBoxCostCenter.Text        = arg[1].ToString();
         uoHiddenFieldCostCenterID.Value = arg[0].ToString();
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        /// <summary>
        /// Created By:    Josephine Gad
        /// Date Created:  16/08/2012
        /// Description:   Tag Seafarer
        /// ---------------------------------
        /// Modified By:    Mabejar
        /// Date Modified:  10/04/2013
        /// Description:    Add TagTime
        /// ---------------------------------
        /// Modified By:    Josephine Gad
        /// Date Modified:  19/Jul/2013
        /// Description:    Add Rec Loc, E1ID, Status On/Off and Audit Trail data
        /// </summary>
        /// <param name="sIdBigint"></param>
        /// <param name="sTRId"></param>
        /// <param name="sAirport"></param>
        /// <param name="sPort"></param>
        private void TagSeafarer(string sIdBigint, string sTRId, string sAirport, string sPort, string sRecLoc, string sE1Id, string sStatusOnOff)
        {
            string sUser    = uoHiddenFieldUser.Value;
            string sRole    = uoHiddenFieldRole.Value;
            string sTagTime = uoHiddenFieldTagTime.Value;

            string   strLogDescription = "Tag Seafarer by Meet & Greet";
            string   strFunction       = "TagSeafarer";
            DateTime dateNow           = CommonFunctions.GetCurrentDateTime();

            SeafarerTravelBLL.InsertTag(sIdBigint, sTRId, sUser, sRole, sAirport, sPort, "0", sTagTime,
                                        sRecLoc, sE1Id, sStatusOnOff, strLogDescription, strFunction, Path.GetFileName(Request.Path),
                                        TimeZone.CurrentTimeZone.StandardName.ToString(), CommonFunctions.GetDateTimeGMT(dateNow));

            BindSeaportManifest();
        }
Esempio n. 13
0
        /// <summary>
        /// Date Created: 25/07/2011
        /// Created By: Ryan Bautista
        /// (description) Load all hotel travel details.
        /// ------------------------------------------------------
        /// Date Modified: 27/07/2011
        /// Modified By: Josephine Gad
        /// (description) Make header ONSIGNING/OFFSIGNING dynamic
        /// ------------------------------------------------------
        /// Date Modified:  09/08/2011
        /// Modified By:    Josephine Gad
        /// (description)   Close DataTable
        /// </summary>
        private void GetSFHotelTravelDetails(string strSFStatus, string strFlightDateRange)
        {
            DataTable HotelDataTable = null;

            try
            {
                string DateFromString = (uoHiddenFieldDateFrom.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateFrom.Value);
                string DateToString   = (uoHiddenFieldDateTo.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateTo.Value);

                HotelDataTable = SeafarerTravelBLL.GetSFHotelTravelList(strSFStatus, strFlightDateRange,
                                                                        DateFromString, DateToString, uoTextBoxName.Text, GlobalCode.Field2String(Session["UserName"]), uoDropDownListMapRef.SelectedValue,
                                                                        uoHiddenFieldFilterBy.Value);
                uolistviewHotelInfo.DataSource = HotelDataTable;
                uolistviewHotelInfo.DataBind();

                Label ucLabelONOFF = (Label)uolistviewHotelInfo.FindControl("ucLabelONOFF");
                if (ucLabelONOFF != null)
                {
                    if (Session["strSFStatus"] == "ON")
                    {
                        ucLabelONOFF.Text = "Onsigning";
                    }
                    else
                    {
                        ucLabelONOFF.Text = "Offsigning";
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (HotelDataTable != null)
                {
                    HotelDataTable.Dispose();
                }
            }
        }
Esempio n. 14
0
        /// <summary>
        /// Date Created:   25/07/2011
        /// Created By:     Ryan Bautista
        /// (description)   Search hotel travel details
        /// ------------------------------------------------------
        /// Date Modified:  09/08/2011
        /// Modified By:    Josephine Gad
        /// (description)   Close DataTable
        /// </summary>
        private void GetSFHotelTravelListSearch(string strSFStatus, string strFlightDateRange, string SFname)
        {
            DataTable dt = null;

            try
            {
                dt = SeafarerTravelBLL.GetSFHotelTravelListSearch(strSFStatus, strFlightDateRange, SFname);
                uolistviewHotelInfo.DataSource = dt;
                uolistviewHotelInfo.DataBind();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (dt != null)
                {
                    dt.Dispose();
                }
            }
        }
Esempio n. 15
0
        /// <summary>
        /// Created By:     Josephine Gad
        /// Date Created:   14/Jun/2013
        /// description     Add Fields for Audit Trail Use
        /// </summary>
        private void AddUpdateConfirmation(string sIdBigint, string sTRId, string sBranch, string sConfirmation)
        {
            string strLogDescription;
            string sConfirmationNo = GlobalCode.Field2String((Request.QueryString["tType"]));

            if (sConfirmation.Trim() == "")
            {
                strLogDescription = "Hotel Confirmation No. Added";
            }
            else
            {
                strLogDescription = "Hotel Confirmation No. Edited";
            }
            DateTime dateNow = CommonFunctions.GetCurrentDateTime();

            SeafarerTravelBLL.UpdateConfirmation(sIdBigint, sTRId, GlobalCode.Field2String(Session["UserName"]),
                                                 GlobalCode.Field2String(Session["UserRole"]), sBranch, sConfirmation, strLogDescription,
                                                 "AddUpdateConfirmation", Path.GetFileName(Request.UrlReferrer.AbsolutePath),
                                                 CommonFunctions.GetDateTimeGMT(dateNow), dateNow);

            OpenParent();
            Session["ConfirmationTag"] = "1";
        }
Esempio n. 16
0
        private void GetSFTravelList(string strSFStatus, string strFlightDateRange, string strPendingFilter, string strAirStatusFilter)
        {
            /// <summary>
            /// Date Created: 08/07/2011
            /// Created By: Marco Abejar
            /// (description) Get general view of seafarers list with regards to flight sched
            /// ---------------------------------------------------------------------------------------------------
            /// Date Modified: 20/07/2011
            /// Modifed By: Josephine Gad
            /// (description) Change the GridView uogridviewGeneralListInfo to ListView uoListViewGeneralList
            /// ---------------------------------------------------------------------------------------------------
            /// Date Modified: 01/08/2011
            /// Modified By: Josephine Gad
            /// (description) Add seafarer name parameter
            /// ---------------------------------------------------------------------------------------------------
            /// Date Modified: 05/08/2011
            /// Modifed By: Josephine Gad
            /// (description) Add Date Range parameter, Add Try and Catch, Hide Vessel Column if Group By is Vessel
            /// </summary>

            DataView GeneralListDataView = null;

            try
            {
                string DateFromString = (uoHiddenFieldDateFrom.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateFrom.Value);
                string DateToString   = (uoHiddenFieldDateTo.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateTo.Value);

                GeneralListDataView = SeafarerTravelBLL.GetSFTravelList(strSFStatus, strFlightDateRange, strPendingFilter, strAirStatusFilter, uoTextBoxName.Text,
                                                                        DateFromString, DateToString, GlobalCode.Field2String(Session["UserName"]), uoDropDownListRegion.SelectedValue, uoHiddenFieldFilterBy.Value).DefaultView;
                GeneralListDataView.Sort         = uoDropDownListGroupBy.SelectedValue + ", Name ";
                uoListViewGeneralList.DataSource = GeneralListDataView;
                uoListViewGeneralList.DataBind();

                Label HeaderLabel;
                Label HeaderFlightLabel;
                HeaderLabel       = (Label)uoListViewGeneralList.FindControl("ucLabelDate");
                HeaderFlightLabel = (Label)uoListViewGeneralList.FindControl("ucLabelFlightDate");
                if (HeaderLabel != null)
                {
                    if (strSFStatus == "ON")
                    {
                        HeaderLabel.Text       = "Onsigning";
                        HeaderFlightLabel.Text = "Arrival Date";
                    }
                    else
                    {
                        HeaderLabel.Text       = "Offsigning";
                        HeaderFlightLabel.Text = "Departure Date";
                    }
                }

                HtmlControl VesselHeader = (HtmlControl)uoListViewGeneralList.FindControl("ucTHVessel");
                HtmlControl OnOffHeader  = (HtmlControl)uoListViewGeneralList.FindControl("ucTHOnOffDate");
                HtmlControl FlightHeader = (HtmlControl)uoListViewGeneralList.FindControl("ucTHFlightDate");
                HtmlControl Port         = (HtmlControl)uoListViewGeneralList.FindControl("ucTHPort");

                if (VesselHeader != null)
                {
                    if (uoDropDownListGroupBy.SelectedValue == "Vessel")
                    {
                        VesselHeader.Visible = false;
                        OnOffHeader.Visible  = true;
                        FlightHeader.Visible = true;
                        Port.Visible         = true;
                    }
                    //else
                    //{
                    //    VesselHeader.Visible = true;
                    //    OnOffHeader.Visible = false;
                    //    FlightHeader.Visible = false;
                    //}

                    else if (uoDropDownListGroupBy.SelectedValue == "OnOffDate")
                    {
                        VesselHeader.Visible = true;
                        OnOffHeader.Visible  = false;
                        FlightHeader.Visible = true;
                        Port.Visible         = true;
                    }
                    else if (uoDropDownListGroupBy.SelectedValue == "colArrivalDate")
                    {
                        VesselHeader.Visible = true;
                        OnOffHeader.Visible  = true;
                        FlightHeader.Visible = false;
                        Port.Visible         = true;
                    }
                    else if (uoDropDownListGroupBy.SelectedValue == "colPortNameVarchar")
                    {
                        VesselHeader.Visible = true;
                        OnOffHeader.Visible  = true;
                        FlightHeader.Visible = true;
                        Port.Visible         = false;
                    }
                    else
                    {
                        VesselHeader.Visible = true;
                        OnOffHeader.Visible  = false;
                        FlightHeader.Visible = false;
                        Port.Visible         = true;
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (GeneralListDataView != null)
                {
                    GeneralListDataView.Dispose();
                }
            }
        }
Esempio n. 17
0
        /// <summary>
        /// Date Created:   16/11/2011
        /// Created By:     Josephine Gad
        /// (description)   Create excel file of hotel manifest and email
        /// ---------------------------------------------------------------------------
        /// </summary>
        private void BindPortManifestExcel()
        {
            DataTable dt = null;

            try
            {
                SeafarerTravelBLL bll = new SeafarerTravelBLL();
                dt = bll.GetSFPortTravelDetailsWithCount(GlobalCode.Field2String(Session["DateFrom"]), Session["Date"].ToString(),
                                                         uoHiddenFieldUser.Value, GlobalCode.Field2String(Session["strPendingFilter"]), GlobalCode.Field2String(Session["Region"]),
                                                         GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["City"]), uoDropDownListStatus.SelectedValue,
                                                         uoDropDownListFilterBy.SelectedValue, uoTextBoxFilter.Text.Trim(), GlobalCode.Field2String(Session["Port"]),
                                                         uoDropDownListVessel.SelectedValue, uoDropDownListNationality.SelectedValue,
                                                         uoDropDownListGender.SelectedValue, uoDropDownListRank.SelectedValue, uoHiddenFieldRole.Value,
                                                         Int16.Parse(uoHiddenFieldByVessel.Value), Int16.Parse(uoHiddenFieldByName.Value),
                                                         Int16.Parse(uoHiddenFieldByRecLoc.Value), Int16.Parse(uoHiddenFieldByE1ID.Value),
                                                         Int16.Parse(uoHiddenFieldByDateOnOff.Value), Int16.Parse(uoHiddenFieldByStatus.Value),
                                                         Int16.Parse(uoHiddenFieldByPort.Value), Int16.Parse(uoHiddenFieldByRank.Value),
                                                         Int16.Parse(uoHiddenFieldByPortStatus.Value), Int16.Parse(uoHiddenFieldByNationality.Value),
                                                         0, uolistviewPortTravelInfoPager.TotalRowCount);

                uoGridViewPortManifest.Visible = true;
                if (dt.Rows.Count > 0)
                {
                    uoGridViewPortManifest.DataSource = dt;
                }
                else
                {
                    uoGridViewPortManifest.EmptyDataText = "No Record.";
                }
                uoGridViewPortManifest.DataBind();


                ////auto save
                string   FilePath = MapPath("~/Extract/PortManifest/");
                string   sDate    = DateTime.Now.ToString(TravelMartVariable.DateTimeFormatFileExtension);
                FileInfo FileName = new FileInfo(FilePath + "PortManifest_" + sDate + ".xls");
                Response.Clear();
                Response.ClearContent();
                StringWriter   stringWrite = new StringWriter();
                HtmlTextWriter htmlWrite   = new HtmlTextWriter(stringWrite);
                uoGridViewPortManifest.RenderControl(htmlWrite);
                FileStream   fs      = new FileStream(FileName.FullName, FileMode.Create);
                StreamWriter sWriter = new StreamWriter(fs, Encoding.GetEncoding("UTF-8"));
                sWriter.Write(stringWrite.ToString().Trim());
                sWriter.Close();
                fs.Close();
                //Use below line instead of Response.End() to avoid Error: Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.;
                HttpContext.Current.ApplicationInstance.CompleteRequest();
                ManifestSendEmail("Travelmart: Port Manifest", "This is a sample Port Manifest", FileName.FullName);
                AlertMessage("Email sent.");
            }
            catch (Exception ex)
            {
                DateTime currentDate = CommonFunctions.GetCurrentDateTime();
                ErrorBLL.InsertError(ex.Message, ex.StackTrace.ToString(), Request.Url.AbsolutePath,
                                     currentDate, CommonFunctions.GetDateTimeGMT(currentDate), GlobalCode.Field2String(Session["UserName"]));
                AlertMessage(ex.Message);
            }
            finally
            {
                if (dt != null)
                {
                    dt.Dispose();
                }
                uoGridViewPortManifest.Visible = false;
            }
        }
Esempio n. 18
0
        protected void uoCalendarDashboard_DayRender(object sender, DayRenderEventArgs e)
        {
            DateTime day = e.Day.Date;
            //DataTable dt = null;
            IDataReader dr = null;

            try
            {
                string sPendingFilter = "0";
                string sRegion        = "0";
                string sCountry       = "0";
                string sCity          = "0";
                string sPort          = "0";
                string sHotel         = "0";
                string sVehicle       = "0";

                sPendingFilter = GlobalCode.Field2Int(Session["strPendingFilter"]).ToString();
                sRegion        = GlobalCode.Field2Int(Session["Region"]).ToString();
                sCountry       = GlobalCode.Field2Int(Session["Country"]).ToString();
                sCity          = GlobalCode.Field2Int(Session["City"]).ToString();
                sPort          = GlobalCode.Field2Int(Session["Port"]).ToString();
                sHotel         = GlobalCode.Field2Int(Session["Hotel"]).ToString();
                sVehicle       = GlobalCode.Field2Int(Session["Vehicle"]).ToString();

                dr = SeafarerTravelBLL.GetTravelManifestDashboard(day.ToString("MM/dd/yyyy"), day.ToString("MM/dd/yyyy"), GlobalCode.Field2String(Session["UserName"]),
                                                                  sPendingFilter, sRegion, sCountry,
                                                                  sCity, "", "1", "", sPort, sHotel,
                                                                  sVehicle, "0", "0", "0", "0", uoHiddenFieldRole.Value);
                if (dr.Read())
                {
                    //Label lblOnOff = new Label();
                    //lblOnOff.Text = "<br/>On:" + dr["SignOn"].ToString() + "<br/>";
                    //lblOnOff.Text += "Off:" + dr["SignOff"].ToString() + "<br/>";
                    //lblOnOff.ForeColor = Color.Red;
                    //lblOnOff.Font.Size = 8;
                    //e.Cell.Controls.Add(lblOnOff);
                    ////e.Cell.ToolTip = "On:" + dr["SignOn"].ToString() + " Off: " + dr["SignOff"].ToString();
                    ////e.Cell.CssClass = "testCSS";

                    if (dr["SignOn"].ToString() != "0")
                    {
                        Label lblOn = new Label();
                        lblOn.Text      = "*";
                        lblOn.ForeColor = Color.Green;
                        e.Cell.Controls.Add(lblOn);
                    }
                    if (dr["SignOff"].ToString() != "0")
                    {
                        Label lblOff = new Label();
                        lblOff.Text      = "*";
                        lblOff.ForeColor = Color.Red;
                        e.Cell.Controls.Add(lblOff);
                    }
                    e.Cell.CssClass = "hoverDate";
                    e.Cell.ID       = day.ToString("MM_dd_yyyy");
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (dr != null)
                {
                    dr.Close();
                    dr.Dispose();
                }
            }
        }
        /// <summary>
        /// Date Created:  09/12/2011
        /// Created By:    Josephine Gad
        /// description    Create calendar
        /// ----------------------------------------------
        /// Date Modified:  14/12/2011
        /// Modified By:    Muhallidin G Wali
        /// (description)   Optimized calendar binding
        /// ----------------------------------------------
        /// Date Modified:  27/12/2011
        /// Modified By:    Josephine Gad
        /// (description)   Optimization (close IDataReader Res)
        /// ----------------------------------------------
        /// </summary>
        private void BindCalendar()
        {
            bool        boolBindAgain = false;
            IDataReader Res           = null;

            try
            {
                string CalendarString = "";
                string CalendarAsterisk;
                string sID;

                DateTime dSelectedDate = DateTime.Parse(GlobalCode.Field2String(Session["DateFrom"]));
                string   sMonthYear    = dSelectedDate.ToString("MMMM yyyy");
                string   sUser         = "";
                if (Request.QueryString["ufn"].ToString() != null)
                {
                    sUser = Request.QueryString["ufn"].ToString();
                }


                string sSelectedDate = "";

                //string sURL = Request.Url.AbsolutePath;
                string sURL = "/Manifest.aspx";

                if (Cache["CalendarDashboard"] == null)
                {
                    CalendarString  = "<table id=\"uoCalendarDashboard\" cellspacing=\"0\" cellpadding=\"2\" title=\"Calendar\" border=\"0\" ";
                    CalendarString += " style=\"width:300px;height:190px;font-size:9pt;font-family:Verdana;color:Black;border-width:1px;border-style:solid;border-color:White;background-color:#ECDFC4;border-collapse:collapse;\"> ";
                    //First row of calendar
                    CalendarString += " <tr> <td colspan=\"7\" style=\"background-color:White;border-color:Black;border-width:4px;border-style:solid;\"> ";
                    CalendarString += " <table cellspacing=\"0\" border=\"0\" style=\"color:#333399;font-family:Verdana;font-size:12pt;font-weight:bold;width:100%;border-collapse:collapse;\"> ";
                    CalendarString += " <tr> ";
                    CalendarString += " 	<td valign=\"bottom\" style=\"color:#333333;font-size:8pt;font-weight:bold;width:15%;\"> ";
                    //CalendarString += "		    <a href=\"" + Request.Url.AbsolutePath + "?ufn=" + sUser + "&mt=" + dSelectedDate.AddMonths(-1).Month.ToString() + "\" style=\"color:#333333\" title=\"Go to the previous month\"> " + sPrevMonth + " </a> </td> ";
                    //CalendarString +=                  sPrevMonth + "</td> ";
                    CalendarString += "     </td> ";
                    CalendarString += "     <td align=\"center\" style=\"width:70%;\">" + sMonthYear + " </td> ";
                    CalendarString += "     <td align=\"right\" valign=\"bottom\" style=\"color:#333333;font-size:8pt;font-weight:bold;width:15%;\"> ";
                    //CalendarString += "       <a href=\"" + Request.Url.AbsolutePath + "?ufn=" + sUser + "&mt=" + dSelectedDate.AddMonths(1).Month.ToString() + "\" style=\"color:#333333\" title=\"Go to the next month\">" + sNextMonth + "</a> </td> ";
                    //CalendarString +=                sNextMonth + "</td> ";
                    CalendarString += "     </td> ";
                    CalendarString += " </tr> </table> </td> </tr> ";

                    //Second row of calendar (Header)
                    CalendarString += " <tr> <th align=\"center\" abbr=\"Sunday\" scope=\"col\" style=\"font-size:8pt;font-weight:bold;\">Sun</th> ";
                    CalendarString += "      <th align=\"center\" abbr=\"Monday\" scope=\"col\" style=\"font-size:8pt;font-weight:bold;\">Mon</th> ";
                    CalendarString += "      <th align=\"center\" abbr=\"Tuesday\" scope=\"col\" style=\"font-size:8pt;font-weight:bold;\">Tue</th> ";
                    CalendarString += "      <th align=\"center\" abbr=\"Wednesday\" scope=\"col\" style=\"font-size:8pt;font-weight:bold;\">Wed</th> ";
                    CalendarString += "      <th align=\"center\" abbr=\"Thursday\" scope=\"col\" style=\"font-size:8pt;font-weight:bold;\">Thu</th> ";
                    CalendarString += "      <th align=\"center\" abbr=\"Friday\" scope=\"col\" style=\"font-size:8pt;font-weight:bold;\">Fri</th> ";
                    CalendarString += "      <th align=\"center\" abbr=\"Saturday\" scope=\"col\" style=\"font-size:8pt;font-weight:bold;\">Sat</th> </tr> ";



                    Res = SeafarerTravelBLL.GetTravelRequestDashboard(0, dSelectedDate, MUser.GetUserName(), GlobalCode.Field2String(Session["UserRole"]));
                    List <DashboardCounter> DBCountet = new List <DashboardCounter>();

                    while (Res.Read())
                    {
                        DBCountet.Add(new DashboardCounter()
                        {
                            DataOnOff = DateTime.Parse(Res["DataOnOff"].ToString()), DateOnOffName = Res["DateOnOffName"].ToString(), SINGON = Res["SIGNON"].ToString(), SINGOFF = Res["SIGNOFF"].ToString()
                        });
                    }

                    DateTime dDay = DateTime.Now;

                    int count = 0;

                    for (int iRow = 1; iRow <= 6; iRow++)
                    {
                        CalendarString += " <tr> ";
                        for (int iCol = 1; iCol <= 7; iCol++)
                        {
                            //add asterisk if there is ON or OFF crew
                            CalendarAsterisk = "";

                            if (DBCountet.Count > 0)
                            {
                                dDay = GlobalCode.Field2DateTime(DBCountet[count].DataOnOff);
                                if (DBCountet[count].SINGON != "0")
                                {
                                    CalendarAsterisk += " <span style=\"color:Green;\">*</span> ";
                                }
                                if (DBCountet[count].SINGOFF != "0")
                                {
                                    CalendarAsterisk += " <span style=\"color:Red;\">*</span> ";
                                }
                            }

                            sID = " id=\"" + dDay.ToString("MM_dd_yyyy") + "\"";
                            if (CalendarAsterisk.Trim() != "")
                            {
                                sID += " class=\"hoverDate\" ";
                            }

                            if (dDay.Month != dSelectedDate.Month)
                            {
                                CalendarString += "<td " + sID + " align=\"left\" style=\"font-size:8.5pt; color:#999999;border-color:#666699;border-width:1px;border-style:solid;width:14%;\"> ";
                                CalendarString += "     <a href=\"" + sURL + "?ufn=" + sUser + "&dt=" + dDay.ToString("MM_dd_yyyy") + "\" style=\"color:#999999\" title=\"" + dDay.ToString("MMMM dd") + "\">" + dDay.ToString("dd") + "</a> ";
                            }
                            else
                            {
                                if (dDay == dSelectedDate)
                                {
                                    //make style bold if selected
                                    CalendarString += " <td " + sID + " align=\"left\" style=\"white-space: nowrap;font-size:8.5pt; color:Black;background-color:#FFFFCC;border-color:#666699;border-width:1px;border-style:solid;font-weight:bold;width:14%;\"> ";
                                    sSelectedDate   = dDay.ToString("MM/dd/yyyy") + ",<td " + sID + " align=\"left\" style=\"white-space: nowrap;font-size:8.5pt; color:Black;background-color:#FFFFCC;border-color:#666699;border-width:1px;border-style:solid;font-weight:bold;width:14%;\">";
                                }
                                else
                                {
                                    CalendarString += " <td " + sID + " align=\"left\" style=\"font-size:8.5pt; border-color:#666699;border-width:1px;border-style:solid;width:14%;\"> ";
                                }
                                CalendarString += "     <a href=\"" + sURL + "?ufn=" + sUser + "&dt=" + dDay.ToString("MM_dd_yyyy") + "\" style=\"color:Black\" title=\"" + dDay.ToString("MMMM dd") + "\"> " + dDay.ToString("dd") + " </a> ";
                            }

                            //add asterisk if there is ON or OFF crew

                            CalendarString += CalendarAsterisk;
                            CalendarString += " </td> ";

                            count += 1;
                        }

                        CalendarString += " </tr> ";
                    }
                    CalendarString += "</table>";

                    //Store calendar string in Cache for 5 minutes
                    Cache.Insert("CalendarDashboard", CalendarString, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(300));
                    Cache.Insert("CalendarSelectedDate", sSelectedDate, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(300));
                }
                else
                {
                    sSelectedDate = Cache["CalendarSelectedDate"].ToString();
                    string[] sSelectedArray = sSelectedDate.Split(",".ToCharArray());
                    if (sSelectedArray[0].ToString() != dSelectedDate.ToString("MM/dd/yyyy"))
                    {
                        DateTime dDay = DateTime.Parse(sSelectedArray[0]);

                        if (dDay.Month != dSelectedDate.Month)
                        {
                            Cache.Remove("CalendarDashboard");
                            boolBindAgain = true;
                            return;
                        }

                        CalendarString = Cache["CalendarDashboard"].ToString();
                        string sSelectedOldStyle;
                        string sSelectedNewStyle;
                        string sSelectedDateNew;

                        string sOld;
                        string sIDOld;
                        string sIDNew;
                        //add asterisk if there is ON or OFF crew for OLD Selected
                        CalendarAsterisk = GetDateCount(dDay);
                        sIDOld           = " id=\"" + dDay.ToString("MM_dd_yyyy") + "\"";
                        if (CalendarAsterisk.Trim() != "")
                        {
                            sIDOld += " class=\"hoverDate\" ";
                        }

                        //add asterisk if there is ON or OFF crew for NEW Selected
                        //CalendarAsterisk = GetDateCount(dSelectedDate);

                        sIDNew = " id=\"" + dSelectedDate.ToString("MM_dd_yyyy") + "\"";
                        if (CalendarAsterisk.Trim() != "")
                        {
                            sIDNew += " class=\"hoverDate\" ";
                        }

                        sOld           = "<td " + sIDOld + " align=\"left\" style=\"font-size:8.5pt; color:#999999;border-color:#666699;border-width:1px;border-style:solid;width:14%;\"> ";
                        CalendarString = CalendarString.Replace(sSelectedArray[1], sOld);

                        if (dDay.Month != dSelectedDate.Month)
                        {
                            //style of new selected date
                            sSelectedOldStyle = "<td " + sIDNew + " align=\"left\" style=\"font-size:8.5pt; color:#999999;border-color:#666699;border-width:1px;border-style:solid;width:14%;\">";
                            sSelectedNewStyle = "<td " + sIDNew + " align=\"left\" style=\"white-space: nowrap;font-size:8.5pt; color:Black;background-color:#FFFFCC;border-color:#666699;border-width:1px;border-style:solid;font-weight:bold;width:14%;\">";
                            CalendarString    = CalendarString.Replace(sSelectedOldStyle, sSelectedNewStyle);
                        }
                        else
                        {
                            //style of new selected date
                            sSelectedOldStyle = "<td " + sIDNew + " align=\"left\" style=\"font-size:8.5pt; border-color:#666699;border-width:1px;border-style:solid;width:14%;\">";
                            sSelectedNewStyle = "<td " + sIDNew + " align=\"left\" style=\"white-space: nowrap;font-size:8.5pt; color:Black;background-color:#FFFFCC;border-color:#666699;border-width:1px;border-style:solid;font-weight:bold;width:14%;\">";
                            CalendarString    = CalendarString.Replace(sSelectedOldStyle, sSelectedNewStyle);
                        }
                        sSelectedDateNew              = dSelectedDate.ToString("MM/dd/yyyy") + ",<td " + sIDNew + " align=\"left\" style=\"white-space: nowrap;font-size:8.5pt; color:Black;background-color:#FFFFCC;border-color:#666699;border-width:1px;border-style:solid;font-weight:bold;width:14%;\">";
                        Cache["CalendarDashboard"]    = CalendarString;
                        Cache["CalendarSelectedDate"] = sSelectedDateNew;
                    }
                }
                CalendarString         = Cache["CalendarDashboard"].ToString();
                ucLiteralCalendar.Text = CalendarString;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (boolBindAgain)
                {
                    BindCalendar();
                }
                if (Res != null)
                {
                    Res.Close();
                    Res.Dispose();
                }
            }
        }
Esempio n. 20
0
        /// Date Created:   16/11/2011
        /// Created By:     Josephine Gad
        /// (description)   Create excel file of hotel manifest and email
        /// ---------------------------------------------------------------------------
        /// </summary>
        private void BindVehicleManifestExcel()
        {
            string strLogDescription;
            string strFunction;

            DataTable dt = null;

            try
            {
                dt = SeafarerTravelBLL.GetSFVehicleTravelListView(
                    GlobalCode.Field2String(Session["DateFrom"]), GlobalCode.Field2String(Session["DateTo"]), GlobalCode.Field2String(Session["strPendingFilter"]),
                    uoDropDownListFilterBy.SelectedValue, uoTextBoxFilter.Text.Trim(), GlobalCode.Field2String(Session["UserName"]),
                    uoDropDownListStatus.SelectedValue, uoDropDownListNationality.SelectedValue, uoDropDownListGender.SelectedValue,
                    uoDropDownListRank.SelectedValue, uoDropDownListVessel.SelectedValue, GlobalCode.Field2String(Session["Region"]),
                    GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["City"]), GlobalCode.Field2String(Session["Port"]),
                    GlobalCode.Field2String(Session["Hotel"]), Session["Vehicle"].ToString(), GlobalCode.Field2String(Session["UserRole"]));

                uoGridViewVehicleManifest.Visible = true;
                if (dt.Rows.Count > 0)
                {
                    uoGridViewVehicleManifest.DataSource = dt;
                }
                else
                {
                    uoGridViewVehicleManifest.EmptyDataText = "No Record.";
                }
                uoGridViewVehicleManifest.DataBind();


                ////auto save
                string   FilePath = MapPath("~/Extract/VehicleManifest/");
                string   sDate    = DateTime.Now.ToString(TravelMartVariable.DateTimeFormatFileExtension);
                FileInfo FileName = new FileInfo(FilePath + "VehicleManifest_" + sDate + ".xls");
                Response.Clear();
                Response.ClearContent();
                StringWriter   stringWrite = new StringWriter();
                HtmlTextWriter htmlWrite   = new HtmlTextWriter(stringWrite);
                uoGridViewVehicleManifest.RenderControl(htmlWrite);
                FileStream   fs      = new FileStream(FileName.FullName, FileMode.Create);
                StreamWriter sWriter = new StreamWriter(fs, Encoding.GetEncoding("UTF-8"));
                sWriter.Write(stringWrite.ToString().Trim());
                sWriter.Close();
                fs.Close();
                //Use below line instead of Response.End() to avoid Error: Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.;
                HttpContext.Current.ApplicationInstance.CompleteRequest();
                ManifestSendEmail("Travelmart: Vehicle Manifest", "This is a sample Vehicle Manifest", FileName.FullName);
                AlertMessage("Email sent.");

                //Insert log audit trail (Gabriel Oquialda - 17/11/2011)
                strLogDescription = "Vehicle manifest as .xls file was sent to e-mail.";
                strFunction       = "BindVehicleManifestExcel";

                DateTime dateNow = CommonFunctions.GetCurrentDateTime();

                //BLL.AuditTrailBLL.InsertLogAuditTrail(strLogDescription, strFunction, Path.GetFileName(Request.Path),
                //                                      CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, GlobalCode.Field2String(Session["UserName"]));
            }
            catch (Exception ex)
            {
                DateTime currentDate = CommonFunctions.GetCurrentDateTime();
                ErrorBLL.InsertError(ex.Message, ex.StackTrace.ToString(), Request.Url.AbsolutePath,
                                     currentDate, CommonFunctions.GetDateTimeGMT(currentDate), GlobalCode.Field2String(Session["UserName"]));
                AlertMessage(ex.Message);
            }
            finally
            {
                if (dt != null)
                {
                    dt.Dispose();
                }
                uoGridViewVehicleManifest.Visible = false;
            }
        }