I am developing a facilities E-booking system using ASP and MS Access Database.
Currently my problem is preventing a new user from booking the same facility which is
already booked at a given time period.
E.g User 1 books Room 1 0n 7th Apr 07 from 8 am - 11 am.
Then user 2 wants to book the same Room 1 on the same 7th Apr 07 but from 10 am onwards.
Even though this not possible in real world, I don't know the coding so as to alert
user 2 that the booking can't be done as there is an existing booking at this time.
Please help me solve this problem.
Many Thanks in Advance.
Page 1 of 1
1 Replies - 2923 Views - Last Post: 12 March 2007 - 09:04 AM
Replies To: Preventing Duplicate Booking of a facility
Re: Preventing Duplicate Booking of a facility
Posted 12 March 2007 - 09:04 AM
what is the UI that you're using like? because if you've got a timeline, you could block out the times that are already booked for that room, and then in the options for booking, perhaps a drop down, have it dynamically driven that if they choose a certian start them, the end time that it shows will be before the next booking so that times don't over lap, it's one possibility...
Page 1 of 1