Show All My Bookin

0
Hi,   I am creating a table reservation app. Now I want a page to show all availability of tables and show the name of employee who already booked the table. How can I do with data grid?
asked
1 answers
0

You likely have one entity Table with attribute like TableNumber and NumberOfSeats. And another entity Reservation with an attribute 'Starttime' or so. And an entity Employee, with an attribute Name. Table has a 1-* association to Reservation. Reservation has a *-1 association to Employee.

Create a non-persistent entity Timeslot, associated with Table. Upon calling the page, retrieve all reservations within the period that you want to show. Create a list of TimeSlots covering the entire period for each table, being free of a reservation. And link each reservation to the related TimeSlot. This sort of gets you started.

answered