def create_booking(self):
"""method to create a wedding booking and store it in the database if all validation is passed"""
if not validation.EntriesNotEmpty(self.master):
dialogs.not_completed(self.master)
elif not self.band_selected():
dialogs.not_completed(self.master, 'Band must be selected')
elif not self.guests_entered():
dialogs.not_completed(
self.master,
'Number of guests must be greater than 0 and no more than 1000'
)
elif not self.number_room_entered():
dialogs.not_completed(
self.master,
'Number of Rooms reserved must be at least 0 and no more than 1000'
)
elif not self.roomSelected:
dialogs.not_completed(self.master,
'Room must be selected for Wedding')
else:
db = da.DBAccess()
w = Wedding(noGuests=self.noGuestsEntry.get(),
nameofContact=self.nameOfContactEntry.get(),
address=self.addressEntry.get(),
contactNo=self.contactNumberEntry.get(),
eventRoomNo=self.roomNoCombo.get(),
dateOfEvent=self.dateOfEventEntry.get(),
bandName=self.bandName.get(),
bandPrice=self.bandPrice,
costPerhead=CONST.EVENT_COST_PER_HEAD.get('Wedding'),
noBedroomsReserved=self.noOfRoomsEntry.get())
db.insert_wedding(w)
dialogs.saved(self.master)
back_to_main(self.master)
def create_booking(self):
"""method to create a party booking when and store it in the database when all validation has been passed"""
if not validation.EntriesNotEmpty(self.master):
dialogs.not_completed(self.master)
elif not self.band_selected():
dialogs.not_completed(
self.master,
'Band must be selected') # extra info being passed to dialogs
elif not self.guests_entered():
dialogs.not_completed(
self.master,
'Number of guests must be greater than 0 and no more than 1000'
)
elif not self.roomSelected:
dialogs.not_completed(self.master,
'Room must be selected for Party')
else:
db = da.DBAccess()
p = Party(noGuests=self.noGuestsEntry.get(),
nameofContact=self.nameOfContactEntry.get(),
address=self.addressEntry.get(),
contactNo=self.contactNumberEntry.get(),
eventRoomNo=self.roomNoCombo.get(),
dateOfEvent=self.dateOfEventEntry.get(),
bandName=self.bandName.get(),
bandPrice=self.bandPrice,
costPerhead=CONST.EVENT_COST_PER_HEAD.get('Party'))
db.insert_party(p)
dialogs.saved(self.master)
back_to_main(self.master)
def create_booking(self):
"""method to create the conference booking and store it in the database if all validation is passed"""
if not validation.EntriesNotEmpty(self.master):
dialogs.not_completed(self.master)
elif not self.guests_entered():
dialogs.not_completed(
self.master,
'Number of guests must be greater than 0 and no more than 1000'
)
elif not self.number_days_entered():
dialogs.not_completed(
self.master,
'Number of days must be greater than 0 and no more than 50')
elif not self.roomSelected:
dialogs.not_completed(self.master,
'Room must be selected for Conference')
else:
db = da.DBAccess()
c = Conference(
noGuests=self.noGuestsEntry.get(),
nameofContact=self.nameOfContactEntry.get(),
address=self.addressEntry.get(),
contactNo=self.contactNumberEntry.get(),
eventRoomNo=self.roomNoCombo.get(),
dateOfEvent=self.dateOfEventEntry.get(),
companyName=self.companyEntry.get(),
noOfDays=self.noOfDaysEntry.get(),
projectorRequired=self.projectorRequired.get(),
dateofBooking=datetime.datetime.now().date(),
costPerhead=CONST.EVENT_COST_PER_HEAD.get('Conference'))
db.insert_conference(c)
dialogs.saved(self.master)
back_to_main(self.master)
def update_booking(self):
"""method to ensure that information entered into form is validated and if correct will save this information in
a party booking object to be update in the database """
if not validation.EntriesNotEmpty(self.master):
dialogs.not_completed(self.master)
elif not self.band_selected():
dialogs.not_completed(self.master, 'Band must be selected')
elif not self.guests_entered():
dialogs.not_completed(self.master, 'Number of guests must be greater than 0 and no more than 1000')
elif not self.roomSelected:
dialogs.not_completed(self.master, 'A Room must be Selected')
else:
p = Party(ID=self.event.id, noGuests=self.noGuestsEntry.get(), nameofContact=self.nameOfContactEntry.get(),
address=self.addressEntry.get(), contactNo=self.contactNumberEntry.get(),
eventRoomNo=self.roomNoCombo.get(), dateOfEvent=self.dateOfEventEntry.get(),
dateofBooking=self.event.dateOfBooking, bandName=self.bandNameCombobox.get(),
bandPrice=self.bandCost, costPerhead=self.event.costPerhead)
save_update(p, self.master)
self.master.destroy()
def update_booking(self):
"""method to ensure that information entered into form is validated and if correct will save this information in
a conference booking object to be update in the database """
if not validation.EntriesNotEmpty(self.master):
dialogs.not_completed(self.master)
elif not self.guests_entered():
dialogs.not_completed(self.master, 'Number of guests must be greater than 0 and no more than 1000')
elif not self.number_days_entered():
dialogs.not_completed(self.master, 'Number of days must be greater than 0 and no more than 50')
elif not self.roomSelected:
dialogs.not_completed(self.master, 'A Room must be Selected')
else:
c = Conference(ID=self.event.id, noGuests=self.noGuestsEntry.get(),
nameofContact=self.nameOfContactEntry.get(),
address=self.addressEntry.get(), contactNo=self.contactNumberEntry.get(),
eventRoomNo=self.roomNoCombo.get(), dateOfEvent=self.dateOfEventEntry.get(),
companyName=self.companyEntry.get(), noOfDays=self.noOfDaysEntry.get(),
projectorRequired=self.yesno.get(), dateofBooking=self.event.dateOfBooking,
costPerhead=self.event.costPerhead)
save_update(c, self.master)
self.master.destroy()
print('updated booking')