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;
}
