private void LoadReport() { DateTime today = DateTime.UtcNow; today = today.Subtract(today.TimeOfDay); int identityId = 0; int.TryParse(cboClient.SelectedValue, out identityId); Facade.IOrganisation facOrganisation = new Facade.Organisation(); Facade.IJob facJob = new Facade.Job(); DataSet dsReport = facJob.GetJobPricingData(identityId, dteStartDate.SelectedDate.Value, dteEndDate.SelectedDate.Value); if (dsReport.Tables[1].Rows.Count == 0) { lblError.Text = "No completed delivery and returns for client " + cboClient.Text + " for period " + dteStartDate.SelectedDate.Value.ToString("dd/MM/yy") + " to " + dteEndDate.SelectedDate.Value.ToString("dd/MM/yy"); lblError.Visible = true; reportViewer.Visible = false; } else { lblError.Visible = false; NameValueCollection reportParams = new NameValueCollection(); reportParams.Add("IdentityID", cboClient.SelectedValue); 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.JobPricing; Session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable] = dsReport; Session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable] = String.Empty; Session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable] = "Table1"; Session[Orchestrator.Globals.Constants.ReportParamsSessionVariable] = reportParams; if (cboClient.SelectedValue != "") { reportViewer.IdentityId = int.Parse(cboClient.SelectedValue); } // Show the user control reportViewer.Visible = true; } }
private void btnExportToCSV_Click(object sender, EventArgs e) { if (Page.IsValid) { int identityId = 0; int.TryParse(cboClient.SelectedValue, out identityId); DateTime start = dteStartDate.SelectedDate.Value; start = start.Subtract(start.TimeOfDay); DateTime end = dteEndDate.SelectedDate.Value; end = end.Subtract(end.TimeOfDay).Add(new TimeSpan(23, 59, 59)); Facade.IJob facJob = new Facade.Job(); DataSet dsReport = facJob.GetJobPricingData(identityId, dteStartDate.SelectedDate.Value, dteEndDate.SelectedDate.Value); Session["__ExportDS"] = dsReport.Tables[1]; Server.Transfer("../Reports/csvexport.aspx?filename=runpricing.csv"); } }