private void memberListToolStripMenuItem_Click(object sender, EventArgs e) { sf = new Sportsfacilities(); SportsfacilitiesTableAdapters.CustomersTableAdapter ta = new SportsfacilitiesTableAdapters.CustomersTableAdapter(); ta.Fill(sf.Customers); SFCustomer cr = new SFCustomer(); cr.SetDataSource(sf); crystalReportViewer1.ReportSource = cr; DisplayResults(); }
private void bookingToolStripMenuItem_Click(object sender, EventArgs e) { //create dataset reportbooktxn //SELECT b.VenueID, b.BookedDate, b.BookedHour, b.CustomerID, b.Status, v.VenueName // FROM BookingTransaction AS b INNER JOIN // Venue AS v ON b.VenueID = v.VenueID //WHERE(b.Status IN // (SELECT Status // FROM BookingTransaction // WHERE(Status = 'confirmed'))) sf = new Sportsfacilities(); SportsfacilitiesTableAdapters.ReportbookingtxnTableAdapter ta = new SportsfacilitiesTableAdapters.ReportbookingtxnTableAdapter(); ta.Fill(sf.Reportbookingtxn); sfbkreport cr = new sfbkreport(); cr.SetDataSource(sf); crystalReportViewer1.ReportSource = cr; DisplayResults(); }
private void demograhpicTrendToolStripMenuItem_Click(object sender, EventArgs e) { //create dataset trendchart //SELECT b.CustomerID, c.MemberCategory, b.BookedDate, b.BookedHour //FROM BookingTransaction AS b INNER JOIN //Customers AS c ON b.CustomerID = c.CustomerID //WHERE(b.Status IN //(SELECT Status // FROM BookingTransaction // WHERE(Status = 'confirmed'))) sf = new Sportsfacilities(); SportsfacilitiesTableAdapters.TrendchartTableAdapter ta = new SportsfacilitiesTableAdapters.TrendchartTableAdapter(); ta.Fill(sf.Trendchart); demographic cr = new demographic(); cr.SetDataSource(sf); crystalReportViewer1.ReportSource = cr; DisplayResults(); }