CONTENTS

INTRODUCTION

MySQL DATABASE
TABLE CREATION

SYSTEM
REQUIREMENTS

CODING

OUTPUT

BIBLIOGRAPHY
 INTRODUCTION
The project is on how to perform Hotel management effectively,
fast and easily. Management using pen and paper is absurd in the
modern era. These days most of the hotels have large number of
rooms and customers so the staff often find it difficult to manage
the processes manually.
The important thing is that this work is easy to understand and is
according to the public requirement. In the present time there is a
great rush in hotels as these have become necessary for middle
and upper class society. This project is developed keeping in mind
the general needs of customers when they arrives at a hotel. This
project provides various services like booking, cancellation of
booking etc. This project is created using python as the front end
and MySQL as the back end.
A virtual hotel management system eliminates all these burdens.
By using this system, all records can be generated quickly. Thus the
project aims in creating a good user-friendly hotel management
system reducing human strain to a large extent.

PYTHON
Python is an interpreted, high level, general purpose programming
language created by Guido van Rossum and first released in 1991.
It’s an object oriented language which helps programmer to write
clear, logical code for small and large scale projects. In python, we
don’t need to declare the type of variable because it is a
dynamically typed language. Python interpreters are available for
many operating systems. A global community of programmers
develops and maintains CPython, an open source reference
implementation. A non-profit organization, the Python Software
Foundation, manages and directs resources for Python and
CPython development.
FEATURES OF PYTHON

• Easy to use

• Free and open source

• Support GUI

• High level language

• Extensible features

• Portable language

MySQL

MySQL was created by a Swedish company, MySQL AB, founded

by David Axmark, Allan Larsson and Michael "Monty" Widenius.
Original development of MySQL by Widenius and Axmark began in
1994. The first version of MySQL appeared on 23 May 1995. MySQL
is an open source relational database management system
(RDBMS). Its name is combinations of ‘My’, the name of co-
founder Michael Widenius’s daughter, and ‘SQL’, the abbreviation
for Structured Query Language. A relational database organises
data into one or more data tables in which data types maybe
related to each other; these relations help structure the data. SQL
is a language programmers use to create, modify and extract data
from the relational database as well as control user access to
database. MySQL works with an operating system to implement a
relational database in a computer's storage system, manages
users, allows for network access and facilitates testing database
integrity and creation of backups. MySQL has stand-alone clients
that allow users to interact directly with a MySQL database using
SQL, but more often MySQL is used with other programs to
implement applications that need relational database capability.
MySQL is also used by many popular websites, including Facebook,
Flickr, MediaWiki,Twitter and YouTube.

FEATURES OF MySQL

• Easy to use

• It is secure

• Client/server architecture

• It is scalable

• Fast and highly flexible

• Platform independent

• Support GUI

• High performance and productivity

• Good memory efficiency

 SYSTEM REQUIREMENTS

• Processors: Intel Atom® processor or Intel® Core™ i3 processor.

• RAM: 4 GB (6 GB recommended)

• Operating systems: Windows* 7 or later, macOS, and Linux.

• Python versions: 2.7.X, 3.6.X.

• Cores: Single (Dual/Quad Core is recommended)

MYSQL DATABASE TABLE CREATION
 CODING

import mysql.connector
from mysql.connector import Error
from mysql.connector import errorcode
from datetime import datetime
from dateutil.relativedelta import relativedelta
from dateutil.parser import parse
from fpdf import FPDF
import webbrowser
def add_roomtype():
print("Enter Details of Newly Created Room Type ")
id1=int(input("Enter ROOM TYPE ID "))
type1=input("Enter Type of Room ")
cap=int(input("Enter Capacity "))
rent=int(input("Enter Rent for Type of room "))
try:

connection=mysql.connector.connect(host='localhost',database='hotel',user='r
oot',password='')
sql_insert_query = (""" INSERT INTO roomtype(id,type,capacity,rentpd)
VALUES(%d,%s,%d,%d)"""%(id1,"'"+type1+"'",cap,rent))
cursor = connection.cursor()
result = cursor.execute(sql_insert_query)
connection.commit()
print ("Record inserted successfully into python_users table")
 except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def modify_roomtype_type():
id1=int(input("Enter ROOM TYPE ID for Modify "))
print("Re Enter Details of Newly Created Room Type ")
type1=input("Enter Type of Room ")
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE ROOMTYPE SET TYPE=%s where
id=%d"""%("'"+type1+"'",id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def modify_roomtype_capacity():
id1=int(input("Enter ROOM TYPE ID for Modify "))
print("Re Enter Details of Newly Created Room Type ")
cap=int(input("Enter Capacity of Room "))
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE ROOMTYPE SET CAPACITY=%d where
id=%d"""%(cap,id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
 print("MySQL connection is closed")
def modify_roomtype_rent():
id1=int(input("Enter ROOM TYPE ID for Modify "))
print("Re Enter Details of Newly Created Room Type ")
cap=int(input("Enter Rent of Room per day "))
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE ROOMTYPE SET RENTPD=%d where
id=%d"""%(cap,id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def add_guest():
print("Enter Details of Newly Created Room Type ")
id1=int(input("Enter GUEST ID "))
 firstname=input("Enter First Name of Guest ")
lastname=input("Enter Last Name of Guest ")
mdate=input("Enter Date of membership of Guest ")
address=input("Enter Address of Guest ")
city=input("Enter City of Guest ")
def modify_guest_firstname():
id1=int(input("Enter GUEST ID for Modify "))
print("Re Enter Details of Guest ")
firstname=input("Enter First Name of Guest ")
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE GUEST SET FIRSTNAME=%s where
id=%d"""%("'"+firstname+"'",id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
 print("MySQL connection is closed")
def modify_guest_lastname():
id1=int(input("Enter GUEST ID for Modify "))
print("Re Enter Details of Guest ")
lastname=input("Enter Last Name of Guest ")
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE GUEST SET LASTNAME=%s where
id=%d"""%("'"+lastname+"'",id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def modify_guest_mdate() :
id1=int(input("Enter GUEST ID for Modify "))
print("Re Enter Details of Guest ")
 mdate=input("Enter Date of Membership of Guest ")
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
lossql_update = (""" UPDATE GUEST SET MDATE=%s where
id=%d"""%("'"+mdate+"'",id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def modify_guest_address():
id1=int(input("Enter GUEST ID for Modify "))
print("Re Enter Details of Guest ")
address=input("Enter Address of Guest ")
try:
 connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE GUEST SET ADDRESS=%s where
id=%d"""%("'"+address+"'",id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def modify_guest_city():
id1=int(input("Enter GUEST ID for Modify "))
print("Re Enter Details of Guest ")
city=input("Enter City of Guest ")
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE GUEST SET CITY=%s where
id=%d"""%("'"+city+"'",id1))
 cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def modify_guest_pincode():
id1=int(input("Enter GUEST ID for Modify "))
print("Re Enter Details of Guest ")
pin=input("Enter Pincode of Guest ")
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE GUEST SET PIN=%s where
id=%d"""%("'"+pin+"'",id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
 except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def modify_guest_mobileno():
id1=int(input("Enter GUEST ID for Modify "))
print("Re Enter Details of Guest ")
mobileno=input("Enter Mobile No of Guest ")
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE GUEST SET MOBILENO=%s where
id=%d"""%("'"+mobileno+"'",id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def add_room():
print("Enter Details of Newly Created Room ")
id1=int(input("Enter ROOM ID "))
roomno=int(input("Enter Newly Created Room No "))
status=int(input("Enter Status 1 for working and 0 for not Working "))
roomtypeid=int(input("Enter Room Type id which was created in room type
"))
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_insert_query = (""" INSERT INTO room
(id,roomno,func_status,room_type_id)
VALUES(%d,%d,%d,%d)"""%(id1,roomno,status,roomtypeid))
print(sql_insert_query)
cursor = connection.cursor()
result = cursor.execute(sql_insert_query)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
 finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def modify_room_roomno():
id1=int(input("Enter ROOM ID for Modify "))
print("Re Enter Details of ROOM ")
roomno=int(input("Enter Room No of Room "))
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE ROOM SET ROOMNO=%d where
id=%d"""%(roomno,id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
 connection.close()
print("MySQL connection is closed")
def modify_room_status():
id1=int(input("Enter ROOM ID for Modify "))
print("Re Enter Details of ROOM ")
status=int(input("Enter Status of Room 1 for WORKING AND 0 FOR NOT
WORKING "))
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE ROOM SET func_status=%d where
id=%d"""%(status,id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def new_booking():
 print("Enter Details of New Booking ")
id1=int(input("Enter New Booking ID "))
cindate2=input("Enter Check In Date ")
cindate=parse(cindate2)
noofdaysstay=int(input("Enter No of Days Stay "))
roomtypeid=int(input("Enter Room Type id for booking "))
noofrooms=int(input("Enter No of Rooms "))
guestid=int(input("Enter Guest id "))
madeby=input("Enter Made By ")
cindate1=datetime.date(cindate)
reservationdate=datetime.date(datetime.now())
reservationdate1=reservationdate.strftime('%Y-%m-%d')
coutdate=cindate1+relativedelta(days=noofdaysstay)
coutdate2=coutdate.strftime('%Y-%m-%d')
print(cindate2)
print(coutdate2)
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_insert_query = (""" INSERT INTO
reservation(id,noofrooms,cindate,coutdate,madeby,guestid,reservationdate,n
o_of_days_stay,roomtypeid)VALUES
(%d,%d,%s,%s,%s,%d,%s,%d,%d)"""%(id1,noofrooms,"'"+cindate2+"'","'"+cout
date2+"'","'"+madeby
+"'",guestid,"'"+reservationdate1+"'",noofdaysstay,roomtypeid))
print(sql_insert_query)
 cursor = connection.cursor()
result = cursor.execute(sql_insert_query)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
try:
for i in range(0,noofrooms):
id2=int(input("Enter Room ID "))
roomno2=int(input("Enter Room No "))
roomtypeid1=roomtypeid
reservationid1=id1
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_insert_query = (""" INSERT INTO reservedroom
(id,roomno,roomtypeid,reservationid)
VALUES (%d,%d,%d,%d)"""%(id2,roomno2,roomtypeid1,reservationid1))
print(sql_insert_query)
cursor = connection.cursor()
 result = cursor.execute(sql_insert_query)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured\
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def cancel_booking():
id1=int(input("Enter Reservation ID for Cancel Booking "))
val=1
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE RESERVATION SET cancelled=%d where
id=%d"""%(val,id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
 print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
cancelleddate=datetime.date(datetime.now())
cancelleddate1=cancelleddate.strftime('%Y-%m-%d')
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE RESERVATION SET cancelleddate=%s where
id=%d"""%("'"+cancelleddate1+"'",id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
 connection.close()
print("MySQL connection is closed")
val1=0
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE RESERVEDROOM SET STATUS=%d where
RESERVATIONid=%d"""%(val1,id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def guest_arrived():
print("Enter Details of Guest at Check In Time ")
id1=int(input("Enter OCCUPIED ID "))
cindate=input("Enter Check In Date ")
 cintime=input("Enter Check In Time ")
roomid=int(input("Enter Room ID "))
reservationid=int(input("Enter Reservation ID "))
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_insert_query = (""" INSERT INTO OCCUPIEDROOM
(id,cindate,cintime,roomid,reservationid)
VALUES
(%d,%s,%s,%d,%d)"""%(id1,"'"+cindate+"'","'"+cintime+"'",roomid,reservationi
d))
print(sql_insert_query)
cursor = connection.cursor()
result = cursor.execute(sql_insert_query)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
print("Enter Details of HOSTED at Check In Time ")
 id11=int(input("Enter HOSTED ID "))
guestid=int(input("Enter Guest ID "))
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_insert_query = (""" INSERT INTO hostedat (id,guestid,occupiedroomid)
VALUES
(%d,%d,%d)"""%(id11,guestid,id1))
print(sql_insert_query)
cursor = connection.cursor()
result = cursor.execute(sql_insert_query)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def guest_checkout():
id1=int(input("Enter Reservation ID for Check Out "))
coutdate=input("Enter Check Out Date ")
couttime=input("Enter Check Out Time ")
 val=0
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE occupiedroom SET coutdate=%s where
reservationid=%d"""%("'"+coutdate+"'",id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE occupiedroom SET couttime=%s where
reservationid=%d"""%("'"+couttime+"'",id1))
cursor = connection.cursor()
 result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_update = (""" UPDATE reservation SET cancelled=%s where
id=%d"""%(val,id1))
cursor = connection.cursor()
result = cursor.execute(sql_update)
connection.commit()
print ("Record inserted successfully into python_users table")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
 if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def billing():
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
#sql_select = ("SELECT * FROM RESERVEDROOM")
#sql_select = ("SELECT id, GUESTID FROM RESERVEDROOM where
cancelled=True and billpaid is null")
#SELECT ID, GUESTID FROM RESERVATION WHERE CANCELLED=1 AND
BILLPAID IS NULL
sql_select = ("SELECT ID, GUESTID FROM RESERVATION WHERE
CANCELLED=0 AND BILLPAID =0")
cursor = connection.cursor()
cursor.execute(sql_select)
result = cursor.fetchall()
print("Bill going to generate ")
print("Customer Id Reservation Id ")
for x in result:
print(x[0]," ",x[1])
#for x in result:
# print(x[0],x[1],x[2],x[3])
#generate_pdf()
except mysql.connector.Error as error :
 connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
def billpay():
print("Do you wnat to Make Paymnet Y(1)")
reservationid=int(input("Enter Reservation Id :"))
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
sql_select = ("""SELECT
G.FIRSTNAME,G.LASTNAME,RT.RENTPD,R.NO_OF_DAYS_STAY,
R.CINDATE,R.COUTDATE FROM ROOMTYPE RT,RESERVEDROOM
RR,RESERVATION R , GUEST G
WHERE R.ID=%d AND R.ID=RR.RESERVATIONID AND RR.ROOMTYPEID=RT.ID
AND
G.ID=R.GUESTID"""%(reservationid))
cursor = connection.cursor()
cursor.execute(sql_select)
result = cursor.fetchall()
for x in result:
fname=x[0]
sname=x[1]
 rent=x[2]
nod=x[3]
cindate=x[4]
coutdate=x[5]
amtpayable=rent*nod
gst=amtpayable*18/100
netamt=amtpayable+gst
print("Mr / Mrs / Ms ",fname," ",sname)
print("Total Bill Payable : ",amtpayable)
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
def generate_bill():
try:

connection=mysql.connector.connect(host='localhost',database='hotel',user='r
oot',password='')
#sql_select=('SELECT* FROM RESERVEDROOM')
#sql_select("SELECT id, GUESTID FROM RESERVEDROOM where cancelled
= True and billpid is null")
#select id,guest id from reservationwhere cancelled=1 and billpaid is null
 sql_select = ("SELECT ID, GUESTID FROM RESERVATION WHERE
CANCELLED=0 AND BILLPAID =1")
cursor = connection.cursor()
cursor.execute(sql_select)
result = cursor.fetchall()
print("Bill going to generate ")
print("Customer Id Reservation Id ")
for x in result:
print(x[0]," ",x[1])
#for x in result:
# print(x[0],x[1],x[2],x[3])
#generate_pdf()
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()

print("Do you wnat to Make Paymnet Y(1)")

reservationid=int(input("Enter Reservation Id :"))
try:
connection
=mysql.connector.connect(host='localhost',database='hotel',user='root',passw
ord='')
 sql_select = ("""SELECT
G.FIRSTNAME,G.LASTNAME,RT.RENTPD,R.NO_OF_DAYS_STAY,
R.CINDATE,R.COUTDATE FROM ROOMTYPE RT,RESERVEDROOM
RR,RESERVATION R , GUEST G
WHERE R.ID=%d AND R.ID=RR.RESERVATIONID AND RR.ROOMTYPEID=RT.ID
AND
G.ID=R.GUESTID"""%(reservationid))
cursor = connection.cursor()
cursor.execute(sql_select)
result = cursor.fetchall()
for x in result:
fname=x[0]
sname=x[1]
rent=x[2]
nod=x[3]
cindate=x[4]
coutdate=x[5]
amtpayable=rent*nod
gst=amtpayable*18/100
netamt=amtpayable+gst
print("Mr / Mrs / Ms ",fname," ",sname)
print("Total Bill Payable : ",amtpayable)
#generate_pdf()

pdf = FPDF()
pdf.add_page()
pdf.set_font("Arial", size=12)
 pdf.cell(0,5,"Hotel BHOPAL !", ln=0, align="L")
pdf.cell(0,5,"Receipt No. "+str(reservationid), ln=1, align="R")
pdf.cell(0,5,"Station Road !", ln=0, align="l")
pdf.cell(0,5,"Date . "+str(coutdate), ln=1, align="R")
pdf.cell(0,5,"BHOPAL M.P. !", ln=1, align="L")
pdf.cell(0, 10,'Invoice', 0, 1, align='C')
pdf.cell(0,0,"-------------------------------------------------------------------------------
---------------------------------------------------------",ln=1,align="L")
pdf.cell(160,10,"Guest Name",ln=0,align="L")
pdf.cell(160,10,fname+" "+sname,ln=1,align="L")
pdf.cell(0,0,"-------------------------------------------------------------------------------
---------------------------------------------------------",ln=1,align="L")
pdf.cell(160,10," Check In Date ",ln=0,align="L")
pdf.cell(160,10,str(cindate),ln=1,align="L")
pdf.cell(160,10," Check Out Date ",ln=0,align="L")
pdf.cell(160,10,str(coutdate),ln=1,align="L")
pdf.cell(160,10," Total Days ",ln=0,align="L")
pdf.cell(160,10,str(nod),ln=1,align="L")
pdf.cell(160,10," Rent Per day ",ln=0,align="L")
pdf.cell(160,10,str(rent),ln=1,align="L")
pdf.cell(160,10," Rented Amount without Tax ",ln=0,align="L")
pdf.cell(160,10,str(amtpayable),ln=1,align="L")
pdf.cell(160,10," SGST 9% & CGST 9% ",ln=0,align="L")
pdf.cell(160,10,str(gst),ln=1,align="L")
pdf.cell(160,10," Total Amount Payable ",ln=0,align="L")
pdf.cell(160,10,str(netamt),ln=1,align="L")
 pdf.cell(0,0,"-------------------------------------------------------------------------------
---------------------------------------------------------",ln=1,align="L")
pdf.cell(0,100,"Signature ",ln=1,align="R")
pdf.output("simple_demo.pdf")
url='file:///G:/PERSONAL/SCHOOL/IN-SERVICE-COURSE/SPELL-2-BPL-
NO-2/simple_demo.pdf'

#chrome_path = 'C:/Program Files

(x86)/Google/Chrome/Application/chrome.exe %s'
webbrowser.open(url)
pdf.cell(0,0,"----------------------------------------------------------------------------------
------------------------------------------------------",ln=1,align="L")
pdf.cell(0,100,"Signature ",ln=1,align="R")
except mysql.connector.Error as error :
connection.rollback() #rollback if any exception occured
print("Failed inserting record into python_users table {}".format(error))
finally:
#closing database connection.
if(connection.is_connected()):
cursor.close()
connection.close()

while(True):
while(True):
print()
print("***********************************************************
************************* Main
Menu***********************************************************
************")
print()
print("1. Room Type Details ")
print("2. Reservation ")
print("3. Guest Details ")
print("4. Room Details ")
print("5. Guest Arrival Check In ")
print("6. Guest Departure Check Out ")
print("7. Billing ")
print("8. Generate Old Bill ")
print("8. Exit ")
ch=int(input("Enter Choice from above "))
if (ch>=1 or ch <= 9):
break
if (ch==9):
break
if (ch==1):
while(True):
while(True):
print()
print("***********************************************************
*************Room Type Details
Menu***********************************************************
***************")
print()
print("1. Add Room Type ")
print("2. Modify Room Type ")
print("3. Modify Room Capacity ")
print("4. Modify Room Rent per Day ")
print("5. Exit ")
ch1=int(input("Enter Choice from above "))
if (ch1>=1 or ch1 <= 5):
break;
if (ch1==5):
break
if (ch1==1):
add_roomtype()
if (ch1==2):
modify_roomtype_type()
if (ch1==3):
modify_roomtype_capacity()
if (ch1==4):
modify_roomtype_rent()
if (ch==3):
while(True):
while(True):
print()
print("***********************************************************
*************Guest Details
Menu***********************************************************
***************")
print()
print("1. Add New Guest ")
print("2. Modify Guest First Name ")
print("3. Modify Guest Last Name ")
print("4. Modify Guest Membership Date ")
print("5. Modify Guest Address ")
print("6. Modify Guest City ")
print("7. Modify Guest Pin code ")
print("8. Modify Guest Mobile No ")
print("9. Exit ")
ch_guest=int(input("Enter Choice from above "))
if (ch_guest>=1 or ch_guest <= 9):
break
if (ch_guest==9):
break
if (ch_guest==1):
add_guest()
if (ch_guest==2):
modify_guest_firstname()
if (ch_guest==3):
modify_guest_lastname()
if (ch_guest==4):
modify_guest_mdate()
if (ch_guest==5):
modify_guest_address()
if (ch_guest==6):
modify_guest_city()
if (ch_guest==7):
 modify_guest_pincode()
if (ch_guest==8):
modify_guest_mobileno()
if (ch==4):
while(True):
while(True):
print()
print("***********************************************************
*************Room Details
Menu***********************************************************
***************")
print()
print("1. Add New Room ")
print("2. Modify Room No ")
print("3. Modify Room Status ")
print("4. Exit ")
ch_room=int(input("Enter Choice from above "))
if (ch_room>=1 or ch_room <= 4):
break
if (ch_room==4):
break
if (ch_room==1):
add_room()
if (ch_room==2):
modify_room_roomno()
if (ch_room==3):
modify_room_status()
if (ch==2):
while(True):
while(True):
print()
print("***********************************************************
*************Reservation
Menu***********************************************************
***************")
print()
print("1. New Booking ")
print("2. Modify Booking Date ")
print("3. Cancel Booking ")
print("4. Exit ")
ch_res=int(input("Enter Choice from above "))
if (ch_res>=1 or ch_res <= 4):
break
if (ch_res==4):
break
if (ch_res==1):
new_booking()
if (ch_res==2):
cancel_booking()
new_booking()
if (ch_res==3):
cancel_booking()
if (ch==5):
guest_arrived()
if (ch==6):
guest_checkout()
if (ch==7):
billing()
billpay()
if (ch==8):
generate_bill()
 OUTPUT
***************************************Main Menu*********************************************

****************************************************************************************

1. Room Type Details

2. Reservation

3. Guest Details

4. Room Details

5. Guest Arrival Check In

6. Guest Departure Check Out

7. Billing

8. Generate Old Bill

9. Exit

Enter choice from above 9

****************************Room type details********************************

1. Add Room Type

2. Modify Room Type

3. Modify Room Capacity

4. Modify Room Rate per Day

5. Exit

Enter Choices from above 5

***************************************************************************
Main Menu
******************************************************************

1. Room Type Details

2. Reservation

3. Guest Details

4. Room Details

5. Guest Arrival Check In

6. Guest Departure Check Out

7. Billing

8. Generate Old Bill

9. Exit

Enter Choice from above 9

***************************************************************************
Reservation Menu
******************************************************************

1. New Booking

2. Modify Booking Date

3. Cancel Booking

4. Exit

Enter Choices from above 4

***************************************************************************
Main Menu
****************************************************************

1. Room Type Details

2. Reservation

3. Guest Details

4. Room Details

5. Guest Arrival Check In

6. Guest Departure Check Out

7. Billing

8. Generate Old Bill

9. Exit

Enter Choice from above 9

***************************************************************************
Guest Details Menu
******************************************************************

1. Add New Guest

2. Modify Guest First Name

3. Modify Guest Last Name

4. Modify Guest Membership Date

5. Modify Guest Address

6. Modify Guest City

7. Modify Guest Pin code

8. Modify Guest Mobile. No

9. Exit

Enter Choices from above 9

**************************************************************************
Main Menu
****************************************************************

1. Room Type Details

2. Reservation

3. Guest Details

4. Room Details

5. Guest Arrival Check In

6. Guest Departure Check Out

7. Billing

8. Generate Old Bill

9. Exit

Enter Choice from above 9

***************************************************************************
Room Details Menu
*****************************************************************

1. Add New Room

2. Modify Room No

3. Modify Room Status

4. Exit

Enter Choices from above 4

***************************************************************************
Main Menu
****************************************************************

1. Room Type Details

2. Reservation

3. Guest Details

4. Room Details

5. Guest Arrival Check In

6. Guest Departure Check Out

7. Billing

8. Generate Old Bill

9. Exit

Enter Choice from above 9

 BIBLIOGRAPHY

Computer Science in python by Sumita Aurora

www.wikipedia.org

www.slideshare.com

www.scribd.com