Hotel booking system (room availability)

Question

0.00/5 (No votes)

See more:

I'm making a Hotel Booking System. I have 15 buttons representing each room. Once the date in has been selected, if a room has been booked, then I need the button with the room number on it to turn red and cannot be selected. However, I also need the button to be red with the time in-between the date in and date out.

So basically, I need to search the access database with the date that has been selected, which turns the button red with the same number as the room number in the database and doesn't allow a booking between the Date In and Date Out.

I have no idea where to start since I am pretty new to programming.

What I have tried:

I have tried this but this is nowhere near what I need.

Dim BookingFound As String = False
      MyConn = New OleDbConnection

      MyConn.ConnectionString = connString
      MyConn.Open()

      str1 = ("SELECT * FROM [BookingInformation] WHERE [Date In] = #" & dtpDateIn.Value.Date & "#")

      Dim cmd1 As OleDbCommand = New OleDbCommand(str1, MyConn)
      dr = cmd1.ExecuteReader

      While dr.Read()
          BookingFound = True

          strDateOut = dr("Date Out").ToString
          strDateIn = dr("Date In").ToString
          strRoomNumber = dr("Room Number").ToString

          If BookingFound = True Then

          End If


      End While
      MyConn.Close()
  End Sub

Posted 10-Sep-17 2:16am

Member 13209355

Updated 10-Sep-17 8:00am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2017-09-10T03:13:00

Solution 1

Here is an example, both VB6 and VB.NET code available: Hotel Reservation System[^]

And another one, using VB.NET and ACCESS: Simple Hotel Management System Using VB.Net | Free source code, tutorials and articles[^]

Posted 10-Sep-17 3:13am

RickZeeland

Updated 10-Sep-17 3:48am

v2

Patrice T · Answer 2 · 2017-09-10T08:00:00

Quote:
if a room has been booked, then I need the button with the room number on it to turn red and cannot be selected. However, I also need the button to be red with the time in-between the date in and date out.

Looks like your statement is missing something big.
Say that on Saturday, rooms 1 to 10 are booked, and on Sunday, rooms 10 to 15 are booked.
With your statement, you can't book a room for those 2 days because no room is available over this period.
The solution you are missing is the feature to move a booking on Sunday to another room, which free a room for those 2 days.
For more than 2 nights, you may have to move more bookings in order to free a room over the period.
----

VB

str1 = ("SELECT * FROM [BookingInformation] WHERE [Date In] = #" & dtpDateIn.Value.Date & "#")

Not a solution to your question, but another problem you have.
Never build an SQL query by concatenating strings. Sooner or later, you will do it with user inputs, and this opens door to a vulnerability named "SQL injection", it is dangerous for your database and error prone.
A single quote in a name and your program crash. If a user input a name like "Brian O'Conner" can crash your app, it is an SQL injection vulnerability, and the crash is the least of the problems, a malicious user input and it is promoted to SQL commands with all credentials.
SQL injection - Wikipedia[^]
SQL Injection[^]
SQL Injection Attacks by Example[^]
PHP: SQL Injection - Manual[^]
SQL Injection Prevention Cheat Sheet - OWASP[^]