protected void uoBtnSaveToExcel_Click(object sender, EventArgs e)
        {
            DataTable dt = null;

            try
            {
                TravelRequestBLL TRBLL = new TravelRequestBLL();
                dt = TRBLL.GetTRRestrictedNationalityExport(uoHiddenFieldUser.Value);

                if (dt.Rows.Count > 0)
                {
                    CreateFile(dt);
                }
                else
                {
                    AlertMessage("There is no record to export.");
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (dt != null)
                {
                    dt.Dispose();
                }
            }
        }
예제 #2
0
        protected void uoButtonExport_Click(object sender, EventArgs e)
        {
            DataTable dt = null;

            try
            {
                dt = TravelRequestBLL.GetPortAgentRequestExport(0, uoHiddenFieldUser.Value, uoHiddenFieldSortBy.Value);

                if (dt.Rows.Count > 0)
                {
                    CreateFile(dt);
                }
                else
                {
                    AlertMessage("No Record to Export!");
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (dt != null)
                {
                    dt.Dispose();
                }
            }
        }
예제 #3
0
        /// <summary>
        /// Author:         Josephine Gad
        /// Created Date:   17/08/2012
        /// (description):  Refresh listview
        /// </summary>
        private void BindSeaportManifest()
        {
            uoDivAirport.Visible = false;
            uoDivSeaport.Visible = true;

            uoListViewTRAir.DataSource = null;
            uoListViewTRSea.DataSource = null;
            List <MeetGreetTravelRequestGenericClass> list = new List <MeetGreetTravelRequestGenericClass>();

            if (uoHiddenFieldLoadType.Value == "0" || uoHiddenFieldLoadType.Value == "2")
            {
                TravelRequestBLL bll = new TravelRequestBLL();
                list = bll.GetMeetGreetTravelRequestPage(GlobalCode.Field2TinyInt(uoHiddenFieldLoadType.Value), uoHiddenFieldUser.Value,
                                                         uoHiddenFieldRole.Value, uoHiddenFieldSeaportID.Value, "0", GlobalCode.Field2DateTime(uoHiddenFieldDate.Value),
                                                         0, DataPager1.PageSize, "0", "1", "", "0", "0", "0", "", GlobalCode.Field2TinyInt(uoRadioButtonListView.SelectedValue)
                                                         , uoHiddenFieldSortBy.Value);
            }
            if (uoHiddenFieldLoadType.Value == "0")
            {
                BindControls(list);
            }
            else if (uoHiddenFieldLoadType.Value == "2")
            {
                BindCount(list);
            }
            uoListViewTRSea.DataSourceID = "uoObjectDataSourceTR";

            ListViewHeaderSea.DataSource = null;
            ListViewHeaderSea.DataBind();
        }
예제 #4
0
        protected DataTable GetList()
        {
            TravelRequestBLL TRBLL = new TravelRequestBLL();

            return(TRBLL.GetTravelRequestArrivalDepartureSameDateListExport(0, GlobalCode.Field2DateTime(uoHiddenFieldDate.Value),
                                                                            GlobalCode.Field2DateTime(uoHiddenFieldDate.Value), uoHiddenFieldUser.Value, uoHiddenFieldUserRole.Value,
                                                                            uoHiddenFieldOrderBy.Value, 0, 0, GlobalCode.Field2Int(uoDropDownListVessel.SelectedValue),
                                                                            GlobalCode.Field2Int(uoDropDownListFilterBy.SelectedValue),
                                                                            uoTextBoxFilter.Text, GlobalCode.Field2Int(uoDropDownListNationality.SelectedValue),
                                                                            GlobalCode.Field2Int(uoDropDownListGender.SelectedValue),
                                                                            GlobalCode.Field2Int(uoDropDownListRank.SelectedValue),
                                                                            uoDropDownListStatus.SelectedValue, GlobalCode.Field2Int(uoHiddenFieldRegion.Value),
                                                                            GlobalCode.Field2Int(uoHiddenFieldCountry.Value), GlobalCode.Field2Int(uoHiddenFieldCity.Value),
                                                                            GlobalCode.Field2Int(uoHiddenFieldPort.Value)));
        }
예제 #5
0
 protected DataTable GetList()
 { 
     TravelRequestBLL TRBLL = new TravelRequestBLL();
     int RegionID = GlobalCode.Field2Int(uoHiddenFieldRegion.Value);
     return TRBLL.GetNoTravelList(GlobalCode.Field2DateTime(Session["DateFrom"]), GlobalCode.Field2String(Session["UserName"]), RegionID);
 }