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)
{
}
}