def addBooking(jsonParams):
query = "select * from project1.bookRoom("
query += jsonParams['roomId'] + ","
query += jsonParams['guestId'] + ",'"
query += jsonParams['startDate'] + "','"
query += jsonParams['endDate'] + "','"
query += jsonParams['extras'] + "');"
return executeQuery(query)
def changeBooking(jsonParams):
query = "select * from project1.changeBooking("
query += jsonParams['bookingId'] + ","
query += jsonParams['roomId'] + ","
query += "null," if jsonParams[
'startDate'] == "null" else "'" + jsonParams['startDate'] + "',"
query += "null," if jsonParams[
'endDate'] == "null" else "'" + jsonParams['endDate'] + "',"
query += "null," if jsonParams[
'extras'] == "null" else "'" + jsonParams['extras'] + "',"
query += jsonParams['userId'] + ");"
return executeQuery(query)
def registerGuest(jsonParams):
try:
query = "select * from project1.register('"
query += jsonParams['firstName'] + "','"
query += jsonParams['surname'] + "','"
query += jsonParams['creditCard'] + "',"
query += jsonParams['handicap'] + ",'"
query += jsonParams['email'] + "','"
query += jsonParams['phoneNumber'] + "');"
except:
with open("log.txt", "a") as myfile:
myfile.write(query + "\n")
return executeQuery(query)
def getGetCountOfActiveBookingsWithExtras(jsonParams):
return executeQuery(
"select * from project1.countOfActiveBookingWithExtras(" +
jsonParams['extrasId'] + ");")
def checkOutBooking(jsonParams):
return executeQuery("select * from project1.checkOutBooking(" +
jsonParams['bookingId'] + "," + jsonParams['userId'] +
");")
def showActualBookingsForCapacity(jsonParams):
return executeQuery("select * from project1.roomCapacityActualBookings(" +
jsonParams['capacity'] + ");")
def getBookingsForRoom(jsonParams):
return executeQuery("select * from project1.roomBookings(" +
jsonParams['roomId'] + ");")
def canGuestEnterCanteen(jsonParams):
return executeQuery("select * from project1.canGuestEnterCanteen(" + jsonParams['guestId'] + ");")
def getBookingInfo(jsonParams):
return executeQuery("select * from project1.bookingInfo;")
def getExtrasForBooking(jsonParams):
return executeQuery(
"select * from project1.extras_booking where bookingId =" +
jsonParams['bookingId'] + ";")
def getExtras(jsonParams):
return executeQuery("select * from project1.extras;");
def getRoomCategories(jsonParams):
return executeQuery("select * from project1.roomCategory;")
def roomInfo(jsonParams):
return executeQuery("select * from project1.roomInfo;")
def getGuestInfo(jsonParams):
return executeQuery("select * from project1.guest;")
def getTotalCostOfBooking(jsonParams):
return executeQuery("select * from project1.getTotalCostOfBooking(" +
jsonParams['bookingId'] + ");")
def showActualBookingsForCategory(jsonParams):
return executeQuery("select * from project1.roomCategoryActualBookings('" +
jsonParams['categoryName'] + "');")
def getBookingsForRoomInDateRange(jsonParams):
return executeQuery("select * from project1.roomBookingsDateRange(" +
jsonParams['roomId'] + ",'" + jsonParams['startDate'] +
"','" + jsonParams['endDate'] + "');")
def showActualBookingsForComfort(jsonParams):
return executeQuery("select * from project1.roomComfortActualBookings(" +
jsonParams['comfort'] + ");")
def getBookingInfoWithId(jsonParams):
return executeQuery("select * from project1.booking where bookingId = " +
jsonParams['bookingId'] + ";")
def showGuestBookings(jsonParams):
return executeQuery("select * from project1.getAllBookingsForGuest(" + jsonParams['guestId'] + ");")