protected void uiLinkButtonGetReport_Click(object sender, EventArgs e) { Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource(); GetPilotScheduleTableAdapter ta = new GetPilotScheduleTableAdapter(); rds.Name = "ScheduleDataSet"; ta.ClearBeforeFill = true; try { CultureInfo provider = CultureInfo.InvariantCulture; provider = new CultureInfo("fr-FR"); DateTime? From = null; DateTime? To = null; if (!string.IsNullOrEmpty(uiTextBoxFrom.Text)) { From = DateTime.ParseExact(uiTextBoxFrom.Text, "dd/MM/yyyy", provider); } if (!string.IsNullOrEmpty(uiTextBoxTo.Text)) { To = DateTime.ParseExact(uiTextBoxTo.Text, "dd/MM/yyyy", provider); } Pilot current = new Pilot(); current.GetPilotByUserName(Page.User.Identity.Name); if(current.RowCount > 0 ) rds.Value = ta.GetData(current.PilotID, From, To); else rds.Value = ta.GetData(0, From, To); } catch (Exception ex) { throw; } uiReportViewer.LocalReport.DataSources.Clear(); uiReportViewer.LocalReport.DataSources.Add(rds); //uiReportViewer.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("From", uiTextBoxFrom.Text)); //uiReportViewer.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("To", uiTextBoxTo.Text)); uiReportViewer.LocalReport.Refresh(); }
protected void uiLinkButtonGetReport_Click(object sender, EventArgs e) { ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer2.LocalReport.DataSources.Clear(); ReportViewer3.LocalReport.DataSources.Clear(); ReportViewer4.LocalReport.DataSources.Clear(); ReportViewer5.LocalReport.DataSources.Clear(); ReportViewer6.LocalReport.DataSources.Clear(); ReportViewer7.LocalReport.DataSources.Clear(); Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource(); Microsoft.Reporting.WebForms.ReportDataSource rds2 = new Microsoft.Reporting.WebForms.ReportDataSource(); GetPilotReportTableAdapter ta = new GetPilotReportTableAdapter(); GetPAXReportTableAdapter taP = new GetPAXReportTableAdapter(); GetFlyHoursReportTableAdapter taF = new GetFlyHoursReportTableAdapter(); GetPilotScheduleTableAdapter taS = new GetPilotScheduleTableAdapter(); CalculatePerDiemTableAdapter TPD = new CalculatePerDiemTableAdapter(); GetPerDiemLogTableAdapter TPDL = new GetPerDiemLogTableAdapter(); GetAirPlaneActualBurnOffTableAdapter APBO = new GetAirPlaneActualBurnOffTableAdapter(); GetSectorsActualBurnOffTableAdapter SBO = new GetSectorsActualBurnOffTableAdapter(); ta.ClearBeforeFill = true; taP.ClearBeforeFill = true; taF.ClearBeforeFill = true; taS.ClearBeforeFill = true; TPD.ClearBeforeFill = true; TPDL.ClearBeforeFill = true; APBO.ClearBeforeFill = true; SBO.ClearBeforeFill = true; try { DateTime? From = null; DateTime? To = null; From = uiRadDatePickerFrom.SelectedDate; To = uiRadDatePickerTo.SelectedDate; switch (uiRadioButtonListReports.SelectedValue) { case "0": rds.Name = "PilotDataSet"; rds.Value = ta.GetData(Convert.ToInt32(uiDropDownListPilots.SelectedValue), From, To); ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("From", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerFrom.SelectedDate))); ReportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("To", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerTo.SelectedDate))); ReportViewer1.LocalReport.Refresh(); ReportViewer1.Visible = true; ReportViewer2.Visible = false; ReportViewer3.Visible = false; ReportViewer4.Visible = false; ReportViewer5.Visible = false; ReportViewer6.Visible = false; ReportViewer7.Visible = false; break; case "1": rds.Name = "PAXDataSet"; rds.Value = taP.GetData(From, To,Convert.ToInt32(uiDropDownListAirplane.SelectedValue)); ReportViewer3.LocalReport.DataSources.Add(rds); ReportViewer3.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("From", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerFrom.SelectedDate))); ReportViewer3.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("To", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerTo.SelectedDate))); ReportViewer3.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("Airplane", uiDropDownListAirplane.SelectedValue)); ReportViewer3.LocalReport.Refresh(); ReportViewer1.Visible = false; ReportViewer2.Visible = false; ReportViewer3.Visible = true; ReportViewer4.Visible = false; ReportViewer5.Visible = false; ReportViewer6.Visible = false; ReportViewer7.Visible = false; break; case "2": rds.Name = "FlyHoursDataSet"; rds.Value = taF.GetData(From, To); ReportViewer4.LocalReport.DataSources.Add(rds); ReportViewer4.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("From", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerFrom.SelectedDate))); ReportViewer4.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("To", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerTo.SelectedDate))); ReportViewer4.LocalReport.Refresh(); ReportViewer1.Visible = false; ReportViewer2.Visible = false; ReportViewer3.Visible = false; ReportViewer4.Visible = true; ReportViewer5.Visible = false; ReportViewer6.Visible = false; ReportViewer7.Visible = false; break; case "3": rds.Name = "ScheduleDataSet"; if(!Roles.IsUserInRole(Page.User.Identity.Name,"Pilot")) { rds.Value = taS.GetData(0,From, To); } else { Pilot p = new Pilot(); p.GetPilotByUserName(Page.User.Identity.Name); rds.Value = taS.GetData(p.PilotID, From, To); } ReportViewer5.LocalReport.DataSources.Add(rds); //ReportViewer5.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("From", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerFrom.SelectedDate))); //ReportViewer5.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("To", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerTo.SelectedDate))); ReportViewer5.LocalReport.Refresh(); ReportViewer1.Visible = false; ReportViewer2.Visible = false; ReportViewer3.Visible = false; ReportViewer4.Visible = false; ReportViewer5.Visible = true; ReportViewer6.Visible = false; ReportViewer7.Visible = false; break; case "4": rds.Name = "PerDiemDataSet"; rds2.Name = "PerdiemLogDataSet"; rds.Value = TPD.GetData(From, To, Convert.ToInt32(uiDropDownListPilots.SelectedValue)); rds2.Value = TPDL.GetData(From, To, Convert.ToInt32(uiDropDownListPilots.SelectedValue)); ReportViewer2.LocalReport.DataSources.Add(rds); ReportViewer2.LocalReport.DataSources.Add(rds2); ReportViewer2.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("RateParameter", uiTextBoxRate.Text)); ReportViewer2.LocalReport.Refresh(); ReportViewer1.Visible = false; ReportViewer2.Visible = true; ReportViewer3.Visible = false; ReportViewer4.Visible = false; ReportViewer5.Visible = false; ReportViewer6.Visible = false; ReportViewer7.Visible = false; break; case "5": rds.Name = "PerDiemDataSet"; rds2.Name = "PerdiemLogDataSet"; rds.Value = TPD.GetData(From, To, Convert.ToInt32(uiDropDownListPilots.SelectedValue)); rds2.Value = TPDL.GetData(From, To, Convert.ToInt32(uiDropDownListPilots.SelectedValue)); ReportViewer2.LocalReport.DataSources.Add(rds); ReportViewer2.LocalReport.DataSources.Add(rds2); ReportViewer2.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("RateParameter", uiTextBoxRate.Text)); ReportViewer2.LocalReport.Refresh(); ReportViewer1.Visible = false; ReportViewer2.Visible = true; ReportViewer3.Visible = false; ReportViewer4.Visible = false; ReportViewer5.Visible = false; ReportViewer6.Visible = false; ReportViewer7.Visible = false; break; case "6": rds.Name = "AirplaneActualBurnOffDataSet"; rds.Value = APBO.GetData(Convert.ToInt32(uiDropDownListAirplane.SelectedValue),From, To); ReportViewer6.LocalReport.DataSources.Add(rds); ReportViewer6.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("StartDate", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerFrom.SelectedDate))); ReportViewer6.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("EndDate", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerTo.SelectedDate))); ReportViewer6.LocalReport.Refresh(); ReportViewer1.Visible = false; ReportViewer2.Visible = false; ReportViewer3.Visible = false; ReportViewer4.Visible = false; ReportViewer5.Visible = false; ReportViewer6.Visible = true; ReportViewer7.Visible = false; break; case "7": rds.Name = "SectorActualBurnOffDataSet"; rds.Value = SBO.GetData(Convert.ToInt32(uiDropDownListFrom.SelectedValue), Convert.ToInt32(uiDropDownListTo.SelectedValue), From, To); ReportViewer7.LocalReport.DataSources.Add(rds); ReportViewer7.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("StartDate", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerFrom.SelectedDate))); ReportViewer7.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("EndDate", string.Format("{0:MM/dd/yyyy}", uiRadDatePickerTo.SelectedDate))); ReportViewer7.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("FromAirPort", uiDropDownListFrom.SelectedValue)); ReportViewer7.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("ToAirPort", uiDropDownListTo.SelectedValue)); ReportViewer7.LocalReport.Refresh(); ReportViewer1.Visible = false; ReportViewer2.Visible = false; ReportViewer3.Visible = false; ReportViewer4.Visible = false; ReportViewer5.Visible = false; ReportViewer6.Visible = false; ReportViewer7.Visible = true; break; default: break; } } catch (Exception ex) { } }