Ejemplo n.º 1
0
        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();
        }
Ejemplo n.º 2
0
        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();
        }
Ejemplo n.º 3
0
        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();
        }