Ejemplo n.º 1
0
        //---------------------------------------------------------------------------------------

        protected void btnRefresh_Click(object sender, EventArgs e)
        {
            int  resourceId      = 0;
            bool driverOrVehicle = false;

            if (this.VehiclesRadioButton.Checked)
            {
                int.TryParse(this.cboVehicle.SelectedValue, out resourceId);
                driverOrVehicle = true;
            }
            else if (this.DriversRadioButton.Checked)
            {
                int.TryParse(this.cboDriver.SelectedValue, out resourceId);
                driverOrVehicle = false;
            }

            Facade.IInstruction facInstruction = new Orchestrator.Facade.Instruction();

            DataSet dsRouteDeviation = facInstruction.GetRouteDeviationReport(resourceId, driverOrVehicle, dteStartDate.SelectedDate.Value,
                                                                              dteEndDate.SelectedDate.Value, Convert.ToInt32(this.txtDeviationPerc.Value.Value), Convert.ToInt32(this.txtEstimatedDistance.Value.Value));

            NameValueCollection reportParams = new NameValueCollection();

            reportParams.Add("StartDate", dteStartDate.SelectedDate.Value.ToString("dd/MM/yy"));
            reportParams.Add("EndDate", dteEndDate.SelectedDate.Value.ToString("dd/MM/yy"));

            // Configure the Session variables used to pass data to the report
            Session[Orchestrator.Globals.Constants.ReportTypeSessionVariable]       = eReportType.RouteDeviation;
            Session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable]  = dsRouteDeviation;
            Session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable]   = String.Empty;
            Session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable] = "Table";
            Session[Orchestrator.Globals.Constants.ReportParamsSessionVariable]     = reportParams;

            // Show the user control
            reportViewer.Visible = true;
        }
Ejemplo n.º 2
0
        //---------------------------------------------------------------------------------------

        protected void btnExport_Click(object sender, EventArgs e)
        {
            int  resourceId      = 0;
            bool driverOrVehicle = false;

            if (this.VehiclesRadioButton.Checked)
            {
                int.TryParse(this.cboVehicle.SelectedValue, out resourceId);
                driverOrVehicle = true;
            }
            else if (this.DriversRadioButton.Checked)
            {
                int.TryParse(this.cboDriver.SelectedValue, out resourceId);
                driverOrVehicle = false;
            }

            Facade.IInstruction facInstruction = new Orchestrator.Facade.Instruction();

            DataSet dsRouteDeviation = facInstruction.GetRouteDeviationReport(resourceId, driverOrVehicle, dteStartDate.SelectedDate.Value, dteEndDate.SelectedDate.Value,
                                                                              Convert.ToInt32(this.txtDeviationPerc.Value.Value), Convert.ToInt32(this.txtEstimatedDistance.Value.Value));

            Session["__ExportDS"] = dsRouteDeviation.Tables[0];
            Response.Redirect("../reports/csvexport.aspx?filename=RouteDeviationByDateRange" + resourceId.ToString() + ".CSV");
        }