how to check availability of dates and validate it using database

csharp , db Cambodia
  • 13 years ago

    I need help on ways and guidance how to design the check availability of dates for the hotel booking system. In this system, user has to check the available dates and rooms before they can proceed with the details in making the room reservations. therefore, the system will check in the database whether number of rooms and nights that user trying to reserve is available or not. If it's available according to the no of rooms and nights selected, the database will reset new values with the latest selection entered by users. if not, error message will be displayed to the user saying that THERE IS NO ROOM AVAILABLE ON THE DATES YOU SELECTED.

    This is almost the same scenario as the  checking availability on dates and rooms in all the hotels that have online reservation.

    Anyone?pls help.. thank you.. Sad

    -TyQa-

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Measuring programming progress by lines of code is like measuring aircraft building progress by weight.” - Bill Gates