Source Code

#*****************HOTEL MANAGEMENT SYSTEMS*****************

###############AURELIUS ABODE################

#SOURCE CODE

import [Link]
myConnection=””
cursor=””
userName=””
password=””
roomrent =0
restaurentbill=0
gamingbill=0
fashionbill=0
totalAmount=0
cid=""

#MODULE TO CHECK MYSQL CONNECTIVITY

def ConnectivityCheck ():

global myConnection
global userName
global password
userName = input("Enter server username: ")
password = input("Enter server pwd: ")
myConnection=[Link](host="localhost",user=userName,
passwd=password, auth_plugin=’mysql_native_password’)
if myConnection:
print("Server Connection Established!!”)

cursor=[Link]()
[Link]("CREATE DATABASE IF NOT EXISTS HMS")
[Link]("COMMIT")
[Link]()
return myConnection
else:
print("Entered username or password incorrect!")

#MODULE TO ESTABLISHED MYSQL CONNECTION

def EstConnect ():

global userName
global password
global myConnection
global cid

myConnection=[Link](host="localhost",user=userName,pa
sswd=password ,
database="HMS" , auth_plugin='mysql_native_password' )

if myConnection:
return myConnection
else:
print("An Error Occurred :( ")
[Link]()
def userEntry():
global cid
if myConnection:
cursor=[Link](
createTable ="""CREATE TABLE IF NOT EXISTS CustomerDetails(custID
VARCHAR(20), custNAME
VARCHAR(30), custADDRESS VARCHAR(30), custAGE VARCHAR(30),
custCOUNTRY VARCHAR(30), custPNO VARCHAR(30), custEMAIL
VARCHAR(30))”””
[Link](createTable)
cid = input("Enter Customer Identification Number : ")
a = input("Enter Your Name : ")
b = input("Enter Your Address : ")
c= input("Enter Your Age : ")
d = input("Enter Your Country : ")
e= input("Enter Your Contact Number : ")
f = input("Enter Your Email : ")
sql = "INSERT INTO CustomerDetails VALUES(%s, %s, %s, %s, %s, %s,
%s)"
values= (cid, a, b, c, d, e, f)
[Link](sql,values)
[Link]("COMMIT")
print("New Customer Entered In The System Successfully !")
[Link]()
else:
print("An Error Occurred :( ")
def bookingRecord():
global cid
customer=searchCustomer()
if customer:
if myConnection:
cursor=[Link]()
createTable ="CREATE TABLE IF NOT EXISTS Booking(custID
VARCHAR(20),checkin
DATE ,checkout DATE)"
[Link](createTable)
g=input(“ Enter Customer CheckIN Date [ YYYY-MM-DD ] : ")
h=input(" Enter Customer CheckOUT Date [ YYYY-MM-DD ] : ")
sql= "INSERT INTO Booking VALUES(%s,%s,%s)"
values= (cid, g, h))
[Link](sql, values)
[Link]("COMMIT")
print("Entry Made Successfully !")
[Link]()
else:
print(" An Error Occurred :( ")

def roomRent():
global cid
customer=searchCustomer()
if customer:
global roomrent
if myConnection:
cursor=[Link]()
createTable ="""CREATE TABLE IF NOT EXISTS
Rent(custID VARCHAR(20), custRoom
INT, custDuration INT, custRno INT ,custRent INT)”””
[Link](createTable)
print ("\n ##### We have The Following Rooms For You
#####")
print (" 1. Ultra Royal ----> 10000 Rs.")
print (" 2. Royal ----> 5000 Rs. ")
print (" 3. Elite ----> 3500 Rs. ")
print (" 4. Budget ----> 2500 Rs ")
roomchoice =int(input("Enter Your Option : "))
roomno=int(input("Enter Customer Room No : "))
noofdays=int(input("Enter No. Of Days : "))
if roomchoice==1:
roomrent = noofdays * 10000
print("\nUltra Royal Room Rent : ",roomrent)
elif roomchoice==2:
roomrent = noofdays * 5000
print("\nRoyal Room Rent : ",roomrent)
elif roomchoice==3:
roomrent = noofdays * 3500
print("\nElite Royal Room Rent : ",roomrent)
elif roomchoice==4:
roomrent = noofdays * 2500
print("\nBudget Room Rent : ",roomrent)
else:
print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try Again
!!! ")
return
sql= "INSERT INTO ROOM_RENT VALUES(%s,%s,%s,%s,%s)"
values= (cid,roomchoice,noofdays,roomno,roomrent,)
[Link](sql,values)
[Link]("COMMIT")
print("Thank You , Your Room Has Been Booked For : ",noofdays , "Days" )
print("Your Total Room Rent is : Rs. ",roomrent)
[Link]()
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
def Restaurent():
global cid
customer=searchCustomer()
if customer:
global restaurentbill
if myConnection:
cursor=[Link](
createTable ="""CREATE TABLE IF NOT EXISTS
RESTAURANT(CID VARCHAR(20),CUISINE
VARCHAR(30),QUANTITY VARCHAR(30),BILL VARCHAR(30))
"""
[Link](createTable)
print("1. Vegetarian Combo -----> 300 Rs.")
print("2. Non-Vegetarian Combo -----> 500 Rs.")
print("3. Vegetarian & Non-Vegetarian Combo -----> 750
Rs.")
choice_dish = int(input("Enter Your Cuisine : "))
quantity=int(input("Enter Quantity : "))
if choice_dish==1:
print("\nSO YOU HAVE ORDER: Vegetarian Combo ")
restaurentbill = quantity * 300
elif choice_dish==2:
print("\nSO YOU HAVE ORDER: Non-Vegetarian Combo ")
restaurentbill = quantity * 500
elif choice_dish==3:
print("\nSO YOU HAVE ORDER: Vegetarian & Non-Vegetarian
Combo ")
restaurentbill= quantity * 750
else:
print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try
Again !!! ")
return
sql= "INSERT INTO RESTAURENT VALUES(%s,%s,%s,%s)"
values= (cid,choice_dish,quantity,restaurentbill)
[Link](sql,values)
[Link]("COMMIT")
print("Your Total Bill Amount Is : Rs. ",restaurentbill)
print("\n\n**** WE HOPE YOU WILL ENJOY YOUR MEAL ***\n\n" )
[Link]()
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
def Gaming():
global cid
customer=searchCustomer()
if customer:
global gamingbill
if myConnection:
cursor=[Link]()
createTable ="""CREATE TABLE IF NOT EXISTS
GAMING(CID VARCHAR(20),GAMES
VARCHAR(30),HOURS VARCHAR(30),GAMING_BILL VARCHAR(30))
""" [Link](createTable)
print("""
1. Table Tennis -----> 150 Rs./HR
2. Bowling -----> 100 Rs./HR
3. Snooker -----> 250 Rs./HR
4. VR World Gaming -----> 400 Rs./HR
5. Video Games -----> 300 Rs./HR
6. Swimming Pool Games -----> 350 Rs./HR
7. Exit
""")
game=int(input("Enter What Game You Want To Play : "))
hour=int(input("Enter No Of Hours You Want To Play : "))
print("\n\n#################################################")
if game==1:
print("YOU HAVE SELECTED TO PLAY : Table Tennis")
gamingbill = hour * 150
elif game==2:
print("YOU HAVE SELECTED TO PLAY : Bowling")
gamingbill = hour * 100
elif game==3:
print("YOU HAVE SELECTED TO PLAY : Snooker")
gamingbill = hour * 250
elif game==4:
print("YOU HAVE SELECTED TO PLAY : VR World Gaming")
gamingbill = hour * 400
elif game==5:
print("YOU HAVE SELECTED TO PLAY : Video Games")
gamingbill = hour * 300
elif game ==6:
print("YOU HAVE SELECTED TO PLAY : Swimming Pool Games")
gamingbill = hour * 350
else:
print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try Again !!!
")
return
sql= "INSERT INTO GAMING VALUES(%s,%s,%s,%s)"
values= (cid,game,hour,gamingbill)
[Link](sql,values)
[Link]("COMMIT")
print("Your Total Gaming Bill Is : Rs. ",gamingbill)
print("FOR : ",hour," HOURS","\n *** WE HOPE YOU WILL ENJOY YOUR
GAME ***")
print("\n\n#################################################")
[Link]()
else:
print("ERROR ESTABLISHING MYSQL CONNECTION !")
def Fashion():
global cid
customer=searchCustomer()
if customer:
global fashionbill
if myConnection:
cursor=[Link]()
createTable ="""CREATE TABLE IF NOT EXISTS FASHION(CID
VARCHAR(20),DRESS
VARCHAR(30),AMOUNT VARCHAR(30),BILL VARCHAR(30))”””
[Link](createTable)
print("""
1. Shirts -----> 1500 Rs.
2. T-Shirts -----> 300 Rs.
3. Pants -----> 2000 Rs.
4. Jeans -----> 4000 Rs.
5. Tassel top -----> 500 Rs.
6. Gown -----> 3000 Rs.
7. Western dress -----> 3000 Rs.
8. Skirts -----> 400 Rs.
9. Trousers -----> 200 Rs.
10. InnerWear -----> 30 Rs.
""")
dress=int(input("Enter the your Choice wear: "))
quantity=int(input("How many you want to buy: "))
if dress==1:
print("\nShirts")
fashionbill = quantity * 1500
elif dress==2:
print("\nT-Shirts")
fashionbill = quantity * 300
elif dress==3:
print("\nPants")
fashionbill = quantity * 2000
elif dress==4:
print("\nJeans")
fashionbill = quantity * 4000
elif dress==5:
print("\nTassel top")
fashionbill = quantity * 500
elif dress==6:
print("\nGown")
fashionbill = quantity * 3000
elif dress==7:
print("\nWestern dress")
fashionbill = quantity * 3000
elif dress==8:
print("\nSkirts")
fashionbill = quantity * 400
elif dress==9:
print("\nTrousers")
fashionbill = quantity * 200
elif dress==10:
print("\nInnerWear")
fashionbill = quantity * 30
else:
print("Invalid Input! ")
return
sql= "INSERT INTO FASHION VALUES(%s,%s,%s,%s)"
values= (cid,dress,quantity,fashionbill)
[Link](sql,values)
[Link]("COMMIT")
print("\n\n#################################################")
print("\nYOU SELECT ITEM NO : ",dress,"\nYOUR QUANTITY IS :
",quantity," ITEMS","\nTHANK
YOU FOR SHOPPING VISIT AGAIN!!!" )
print("\nYour Total Bill Is : ",fashionbill)
print("\n\n#################################################")
[Link]()
else:
print("An Error Occurred :( ")
def totalAmount():
global cid
customer=searchCustomer()
if customer:
global grandTotal
global roomrent
global restaurentbill
global fashionbill
global gamingbill
if myConnection:
cursor=[Link]()
createTable ="""CREATE TABLE IF NOT EXISTS TOTAL(CID
VARCHAR(20),C_NAME
VARCHAR(30),ROOMRENT INT ,RESTAURENTBILL INT ,GAMINGBILL
INT,FASHIONBILL
INT,TOTALAMOUNT INT)"""
[Link](createTable)
sql= "INSERT INTO TOTAL VALUES(%s,%s,%s,%s,%s,%s,%s)"
name = input("Enter Customer Name : ")
grandTotal=roomrent + restaurentbill + fashionbill + gamingbill
values= (cid,name,roomrent,restaurentbill , gamingbill,fashionbill,grandTotal)
[Link](sql,values)
[Link]("COMMIT")
[Link]()
print("\n **** Aurelius Abode **** CUSTOMER BIILING ****")
print("\n CUSTOMER NAME : " ,name)
print("\nROOM RENT : Rs. ",roomrent)
print("\nRESTAURENT BILL : Rs. ",restaurentbill)
print("\nFASHION BILL : Rs. ",fashionbill)
print("\nGAMING BILL : Rs. ",gamingbill)
print("___________________________________________________")
print("\nTOTAL AMOUNT : Rs. ",grandTotal)
[Link]()
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
def searchOldBill():
global cid
customer=searchCustomer()
if customer:
if myConnection:
cursor=[Link]()
sql="SELECT * FROM TOTAL WHERE CID= %s"
[Link](sql,(cid,))
data=[Link]()
if data:
print(data)
else:
print("Record Not Found Try Again !")
[Link]()
else:
print("\nSomthing Went Wrong ,Please Try Again !")

def searchCustomer():
global cid
if myConnection:
cursor=[Link]()
cid=input("ENTER CUSTOMER ID : ")
sql="SELECT * FROM C_DETAILS WHERE CID= %s"
[Link](sql,(cid,))
data=[Link]()
if data:
print(data)
return True
else:
print("Record Not Found Try Again !")
return False
[Link]()

else:
print("\nSomthing Went Wrong ,Please Try Again !")
print(‘’’

******************PRABHAT SENIOR SECONDARY PUBLIC

SCHOOL*****************
***********************HOTEL MANAGEMENT
SYSTEM******************************
*********************************AURELIUS
ABODE*************************************
#***********************DESIGNED AND MAINTAINED
BY:*************************
#************Manas Singh- Class XII-A- Roll No.-
#************Devagya Shanker Tiwari- Class XII-A- Roll No.-
#************Pulkit Shukla- Class XII-A- Roll No.-

‘’’)

myConnection = ConnectivityCheck ()
if myConnection:
EstConnect ():
while True:
print("""
1--->Enter Customer Details
2--->Booking Record
3--->Calculate Room Rent
4--->Calculate Restaurant Bill
5--->Calculate Gaming Bill
6--->Calculate Fashion store Bill
7--->Display Customer Details
8--->GENERATE TOTAL BILL AMOUNT
9--->GENERATE OLD BILL
10--->EXIT """)
choice = int(input("Enter Your Choice"))
if choice == 1:
userEntry()
elif choice ==2:
bookingRecord()
elif choice ==3:
roomRent()
elif choice ==4:
Restaurant()
elif choice ==5:
Gaming()
elif choice ==6:
Fashion()
elif choice ==7:
searchCustomer()
elif choice ==8:
totalAmount()
elif choice ==9:
searchOldBill()
elif choice ==10:
break
else:
print("Invalid Input ")
else:
print("An Error Occurred :( ")

# SOURCE CODE END