protected void ControlLoadData()
        {
            ddlSales.DataSource     = UserBLL.UserGetByRole((int)Roles.Sales);
            ddlSales.DataTextField  = "Username";
            ddlSales.DataValueField = "Id";
            ddlSales.DataBind();
            ddlSales.Items.Insert(0, new ListItem("Unbound Sales", "0"));
            ddlSales.Items.Insert(0, "-- Sales in charge --");

            ddlTrips.DataSource     = PaymentReportBLL.TripGetAll();
            ddlTrips.DataTextField  = "Name";
            ddlTrips.DataValueField = "Id";
            ddlTrips.DataBind();
            ddlTrips.Items.Insert(0, "-- Service --");

            if (Request.QueryString["ti"] != null)
            {
                ddlTrips.SelectedValue = Request.QueryString["ti"];
            }

            txtFrom.Text = DateTimeUtil.DateGetDefaultFromDate().ToString("dd/MM/yyyy");
            if (Request.QueryString["f"] != null)
            {
                txtFrom.Text = Request.QueryString["f"];
            }

            txtTo.Text = DateTimeUtil.DateGetDefaultToDate().ToString("dd/MM/yyyy");
            if (Request.QueryString["t"] != null)
            {
                txtTo.Text = Request.QueryString["t"];
            }

            if (Request.QueryString["an"] != null)
            {
                txtAgency.Text = Request.QueryString["an"];
            }

            if (Request.QueryString["bi"] != null)
            {
                txtBookingCode.Text = Request.QueryString["bi"];
            }

            if (Request.QueryString["si"] != null)
            {
                ddlSales.SelectedValue = Request.QueryString["si"];
            }
        }
        protected void Page_Unload(object sender, EventArgs e)
        {
            if (paymentReportBLL != null)
            {
                paymentReportBLL.Dispose();
                paymentReportBLL = null;
            }

            if (userBLL != null)
            {
                userBLL.Dispose();
                userBLL = null;
            }

            if (permissionBLL != null)
            {
                permissionBLL.Dispose();
                permissionBLL = null;
            }
        }