private void frmOccupancyReport_Load(object sender, EventArgs e)
{
DataSet6 ds = new DataSet6();
DataSet6TableAdapters.bookinginvoicereportTableAdapter da = new DataSet6TableAdapters.bookinginvoicereportTableAdapter();
da.Fill(ds.bookinginvoicereport);
Occupancy cr = new Occupancy();
cr.SetDataSource(ds);
cr.SetParameterValue("dateFrom", ucReports.datefrom);
cr.SetParameterValue("dateTo", ucReports.dateto);
crOccupancy.ReportSource = cr;
}
private void Form2_Load(object sender, EventArgs e)
{
SportsFacilitiesEntities ctx = new SportsFacilitiesEntities();
// Members Listing
//DataSet1 ds = new DataSet1();
//DataSet1TableAdapters.MembersTableAdapter da = new DataSet1TableAdapters.MembersTableAdapter();
//da.Fill(ds.Members);
//MemberListing cr = new MemberListing();
//cr.SetDataSource(ds);
//crystalReportViewer1.ReportSource = cr;
// Booking Invoice
//DataSet2 ds = new DataSet2();
//DataSet2TableAdapters.bookinginvoicereportTableAdapter da = new DataSet2TableAdapters.bookinginvoicereportTableAdapter();
//da.Fill(ds.bookinginvoicereport);
//BookingInvoice cr = new BookingInvoice();
//cr.SetDataSource(ds);
//crystalReportViewer1.ReportSource = cr;
// Membership Form
//DataSet3 ds = new DataSet3();
//DataSet3TableAdapters.MembersTableAdapter da = new DataSet3TableAdapters.MembersTableAdapter();
//da.Fill(ds.Members);
//MemberForm cr = new MemberForm();
//cr.SetDataSource(ds);
//crystalReportViewer1.ReportSource = cr;
// Monthly Revenue Report
//DataSet4 ds = new DataSet4();
//DataSet4TableAdapters.revenuereportTableAdapter da = new DataSet4TableAdapters.revenuereportTableAdapter();
//da.Fill(ds.revenuereport);
//MonthlyRevenue cr = new MonthlyRevenue();
//cr.SetDataSource(ds);
//crystalReportViewer1.ReportSource = cr;
// March Revenue Report
//DataSet5 ds = new DataSet5();
//DataSet5TableAdapters.revenuereportTableAdapter da = new DataSet5TableAdapters.revenuereportTableAdapter();
//da.Fill(ds.revenuereport);
//MarchRevenue cr = new MarchRevenue();
//cr.SetDataSource(ds);
//crystalReportViewer1.ReportSource = cr;
//Occupancy Report
//DataSet6 ds = new DataSet6();
//DataSet6TableAdapters.bookinginvoicereportTableAdapter da = new DataSet6TableAdapters.bookinginvoicereportTableAdapter();
//da.Fill(ds.bookinginvoicereport);
//Occupancy cr = new Occupancy();
//cr.SetDataSource(ds);
//crystalReportViewer1.ReportSource = cr;
//Booking Availability Report
DataSet6 ds = new DataSet6();
DataSet6TableAdapters.bookinginvoicereportTableAdapter da = new DataSet6TableAdapters.bookinginvoicereportTableAdapter();
da.Fill(ds.bookinginvoicereport);
BookingAvailability cr = new BookingAvailability();
cr.SetDataSource(ds);
crystalReportViewer1.ReportSource = cr;
}