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'] + ");")