private void CampingBookingsHistoryReport_Click(object sender, EventArgs e)
{
ResultSet rs = new ResultSet(dal.GetDataReader("BookingHistoryTable JOIN CustomerTable ON BookingHistoryTable.CustomerID = CustomerTable.CustomerID", "1=1", "BookingID, CustomerTable.CustomerID, CustomerName, StartDate, GroupSize, PricePerNight, TotalPrice, NightsStayed"));
ReportForm reportForm = new ReportForm(rs, "Booking ID", "Customer ID", "Customer Name", "Start Date", "Group Size", "Price per Night", "Total Price", "Nights Stayed");
reportForm.SetFormTitle("Booking History Report");
reportForm.SetDateFilterColumn(3);
OpenForm(reportForm);
}
private void ToursSightseeingReportButton_Click(object sender, EventArgs e)
{
ResultSet rs = new ResultSet(dal.GetDataReader("([Customer-BusTripTable] JOIN [CustomerTable] ON [Customer-BusTripTable].CustomerID = CustomerTable.CustomerID) JOIN BusTripTable ON [Customer-BusTripTable].BusTripID = BusTripTable.BusTripID", "1=1", "BusTripTable.BusTripID, [Date], TimeSlot, Trip, CustomerTable.CustomerID, CustomerName, [Customer-BusTripTable].GroupSize, Price"));
ReportForm reportForm = new ReportForm(rs, "BusTripID", "Date", "TimeSlot", "Trip", "CustomerID", "CustomerName", "GroupSize", "Price");
reportForm.SetFormTitle("Sightseeing Tours Report");
reportForm.SetDateFilterColumn(1);
OpenForm(reportForm);
}
private void ToursCyclingToursReportButton_Click(object sender, EventArgs e)
{
ResultSet rs = new ResultSet(dal.GetDataReader("([Customer-CyclingTourTable] JOIN [CustomerTable] ON [Customer-CyclingTourTable].CustomerID = CustomerTable.CustomerID) JOIN CyclingTourTable ON [Customer-CyclingTourTable].CyclingTourID = CyclingTourTable.CyclingTourID", "1=1", "CyclingTourTable.CyclingTourID, [Date], TimeSlot, CustomerTable.CustomerID, CustomerName, [Customer-CyclingTourTable].NumberCyclists, NumberBicycles, Price"));
ReportForm reportForm = new ReportForm(rs, "CyclingTourID", "Date", "TimeSlot", "CustomerID", "CustomerName", "NumberCyclists", "NumberBicycles", "Price");
reportForm.SetFormTitle("Cycling Tours Report");
reportForm.SetDateFilterColumn(1);
OpenForm(reportForm);
}
private void ToursCyclingLessonsReportButton_Click(object sender, EventArgs e)
{
ResultSet rs = new ResultSet(dal.GetDataReader("((CyclingLessonTable JOIN [Child-CyclingLessonTable] ON CyclingLessonTable.LessonID = [Child-CyclingLessonTable].LessonID) JOIN ChildTable ON [Child-CyclingLessonTable].ChildID = ChildTable.ChildID) JOIN CustomerTable ON ChildTable.CustomerID = CustomerTable.CustomerID", "1=1", "CyclingLessonTable.LessonID, ChildTable.ChildID, ChildName, ChildLevel, CustomerTable.CustomerID, CustomerName, [Date], TimeSlot, NumberChildren"));
ReportForm reportForm = new ReportForm(rs, "LessonID", "ChildID", "ChildName", "ChildLevel", "CustomerID", "CustomerName", "Date", "TimeSlot", "NumberChildren");
reportForm.SetFormTitle("Cycling Lessons Report");
reportForm.SetDateFilterColumn(6);
OpenForm(reportForm);
}
private void ToursCyclingCertificationReportButton_Click(object sender, EventArgs e)
{
ResultSet rs = new ResultSet(dal.GetDataReader("(CertificationBookingsTable JOIN ChildTable ON CertificationBookingsTable.ChildID = ChildTable.ChildID) JOIN CustomerTable ON ChildTable.ChildID = CustomerTable.CustomerID", "1=1", "CertificationBookingID, ChildTable.ChildID, ChildName, CustomerTable.CustomerID, CustomerName, [Level], Price"));
ReportForm reportForm = new ReportForm(rs, "CertBookingID", "ChildID", "ChildName", "CustomerID", "CustomerName", "Level", "Price");
reportForm.SetFormTitle("Cycling Certifications Report");
reportForm.SetDateFilterColumn(-1);
OpenForm(reportForm);
}
private void HireEquipmentLoansHistoryButton_Click(object sender, EventArgs e)
{
ResultSet rs = new ResultSet(dal.GetDataReader("(EquipmentTable JOIN EquipmentLoansHistoryTable ON EquipmentTable.EquipmentID = EquipmentLoansHistoryTable.EquipmentID) JOIN CustomerTable ON EquipmentLoansHistoryTable.CustomerID = CustomerTable.CustomerID", "1=1", "EquipmentLoansHistoryID, CustomerTable.CustomerID, CustomerName, EquipmentTable.EquipmentID, EquipmentName, StartDate, Duration, Quantity, RentalPrice"));
ReportForm reportForm = new ReportForm(rs, "LoanHistoryID", "CustomerID", "CustomerName", "EquipmentID", "EquipmentName", "StartDate", "Duration", "Quantity", "RentalPrice");
reportForm.SetFormTitle("Equipment Loans History Report");
reportForm.SetDateFilterColumn(10);
OpenForm(reportForm);
}
private void CurrentBookingsReportButton_Click(object sender, EventArgs e)
{
ResultSet rs = new ResultSet(dal.GetDataReader("((BookingTable JOIN CustomerTable ON BookingTable.CustomerID = CustomerTable.CustomerID) JOIN CampingBookingsTable ON BookingTable.BookingID = CampingBookingsTable.BookingID)", "((BookingTable JOIN CustomerTable ON BookingTable.CustomerID = CustomerTable.CustomerID) JOIN PitchBookingsTable ON BookingTable.BookingID = PitchBookingsTable.BookingID)", "BookingTable.BookingID, CustomerTable.CustomerID, CustomerName, StartDate, GroupSize, NightsStayed, PricePerNight, TotalPrice, Type", "BookingTable.BookingID, CustomerTable.CustomerID, CustomerName, StartDate, GroupSize, NightsStayed, PricePerNight, TotalPrice, RentedSpace"));
ReportForm reportForm = new ReportForm(rs, "Booking ID", "Customer ID", "Customer Name", "Start Date", "Group Size", "Nights Stayed", "Price per Night", "Total Price", "Type");
reportForm.SetFormTitle("Current Bookings Report");
reportForm.SetDateFilterColumn(3);
OpenForm(reportForm);
}