2 Replies - 1689 Views - Last Post: 16 March 2015 - 10:00 AM Rate Topic: -----

#1 dornan1993   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 16-March 15

Need help with my asp.net hotel booking system.

Posted 16 March 2015 - 08:26 AM

Im trying to develop a hotel booking system .net using vb and sql. I have the following database tables:

Customer(CustomerID, title, Firstname, Surname,Address, Town, County, Postcode, Country, Email, Tel, Password, ConfirmPassword)

Rooms(RoomID, RoomType, Description)

Reservation(ReservationID, CustomerID, ArrivalDate, DepartureDate, Number of Occupants, TotalPrice)

Rooms_Booked (ReservationID, RoomID)

I dont know if my tables are correct?? if you think they are can you let me know.

The scenario is that a user selects two dates (Arrival and departure) from the ajax calendars and then clicks the check availability button to search for available rooms. On the next page I want all the rooms to appear, with dates that they are available on, and dates they are not available on. Can this be done?? I have no rooms booked at the moment so all rooms should be available on any date.

Is This A Good Question/Topic? 0
  • +

Replies To: Need help with my asp.net hotel booking system.

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15433
  • View blog
  • Posts: 61,843
  • Joined: 12-June 08

Re: Need help with my asp.net hotel booking system.

Posted 16 March 2015 - 09:08 AM

Looks good.

Yes, you certainly should be able to show any room availability in a calendar.

(though that would be odd since an average hotel can have hundreds of rooms)
Was This Post Helpful? 0
  • +
  • -

#3 dornan1993   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 16-March 15

Re: Need help with my asp.net hotel booking system.

Posted 16 March 2015 - 10:00 AM

View Postmodi123_1, on 16 March 2015 - 09:08 AM, said:

Looks good.

Yes, you certainly should be able to show any room availability in a calendar.

(though that would be odd since an average hotel can have hundreds of rooms)


Hi modi123, How can query my database though to find available rooms? for example if the standard room was booked for 17/03/2015 to 18/03/2015, I dont want the user to be able to book on these dates.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1