Reservation Algorithm

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jimmy
    #1

    Reservation Algorithm

    Hi all,

    I am currently developing a reservation management program however i am
    having trouble finding a way in which i can check whether a table is
    free at a specific time or not. When the program is setup i will get
    the manager to enter how many tables there are. There will then be a
    screen where customers can enter a reservation time and for how many
    people. I need a way of checking against a list of already stored
    reservations. How would you recommend going about this?

    Thanks in advance

    James

    Tags: None
    • Spam Catcher
      #2
      Re: Reservation Algorithm

      "jimmy" <james.herringt on@tiscali.co.u kwrote in
      news:1165713628 .119567.34730@n 67g2000cwd.goog legroups.com:
      There will then be a
      screen where customers can enter a reservation time and for how many
      people. I need a way of checking against a list of already stored
      reservations. How would you recommend going about this?
      Store the table list in the database. Check against the database before you
      reserve the table.

      You should wrap the SQL call in a transaction to prevent any concurrency
      issues (i.e. 2 users reserving the same table).

        Comment

        Previous template Next
        Working...