public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { BookingReceipt rpt = new BookingReceipt(); rpt.Site = this.Site; return(rpt); }
private void ViewBookingReceipt_Load(object sender, EventArgs e) { BookingReceipt bookingReceipt = new BookingReceipt(); this.Text = $"Booking Receipt #{bookingId}"; bookingReceipt.Database.Tables[0].SetDataSource(context.Bookings .Where(x => x.BookingID == bookingId) .Select(x => new { x.BookingID, FacilityID = x.FacilityID ?? 0, MemberID = x.MemberID ?? 0, BookingDate = x.BookingDate ?? new DateTime(), Timeslot = x.Timeslot ?? 0, DateRequested = x.DateRequested ?? new DateTime(), Status = x.Status == 1 ? "Booked" : "Cancelled" })); bookingReceipt.Database.Tables[1].SetDataSource(context.Members .Where(x => x.MemberID == context.Bookings.Where(y => y.BookingID == bookingId).FirstOrDefault().MemberID) .Select(x => new { x.FirstName, x.LastName })); bookingReceipt.Database.Tables[2].SetDataSource(context.Facilities .Where(x => x.FacilityID == context.Bookings.Where(y => y.BookingID == bookingId).FirstOrDefault().FacilityID) .Select(x => new { x.Name, OpeningTime = x.OpeningTime ?? new DateTime() })); BookingReceiptCrystalReport.ReportSource = bookingReceipt; }