def okayE(self, event):
removable = False
cursor = QF.cursor
info = []
price = self.priceI.get()
quantity = self.quantityI.get()
try:
if float(price) < 0 or int(quantity) < 0:
messagebox.showerror(
"Error", "the price or quantity cannot be less than zero.")
self.window.destroy()
type = self.typeI.get()
info.append(price)
info.append(quantity)
info.append(type)
good = tuple(info)
allgoods = QF.showGood(cursor)
for n in allgoods:
if type == n[0]:
removable = True
if removable:
QF.modifyGood(good)
self.window.destroy()
else:
messagebox.showerror("Error", "the item does not exist.")
self.window.destroy()
except:
messagebox.showerror("Error",
"Something is wrong\n Check your input.")
self.window.destroy()
def okayE(self, event):
remove = False
cursor = QF.cursor
info = []
warning = self.warningI.get()
id = self.workerI.get()
allworker = QF.showEmployee(cursor)
try:
if (int(warning) < 0):
messagebox.showerror("Error", "warning cannot be less than zero.")
self.window.destroy()
for n in allworker:
if (int(id) == int(n[0])):
remove = True
info.append(warning)
info.append(id)
warning = tuple(info)
if remove:
QF.giveWarning(warning)
self.window.destroy()
else:
messagebox.showerror("Error", "not a valid employee's id.")
self.window.destroy()
except:
messagebox.showerror("Error", "Something is wrong\n Check your input.")
self.window.destroy()
def okayE(self, event):
removable = False
cursor = QF.cursor
query = ("SELECT No, FoodName FROM Foods;")
cursor.execute(query)
info = []
no = self.noI.get()
foodname = self.foodnameI.get()
info.append(no)
info.append(foodname)
food = tuple(info)
mylist = []
for allfood in cursor:
mylist.append(allfood[0])
mylist.append(allfood[1])
if no or foodname in mylist:
removable = True
if removable == True:
QF.removeFood(food)
self.window.destroy()
else:
messagebox.showerror("Error", "Not a valid food!")
self.window.destroy()
def okayE(self, event):
info = []
drink = self.drinkI.get()
price = self.priceI.get()
try:
info.append(drink)
info.append(price)
drinkinfo = tuple(info)
QF.addDrink(drinkinfo)
self.window.destroy()
except:
messagebox.showerror("Error",
"Something is Wrong\nCheck your input!")
self.window.destroy()
def okayE(self, event):
info = []
lunch = self.lunchI.get()
price = self.priceI.get()
try:
info.append(lunch)
info.append(price)
lunch = tuple(info)
QF.addLunch(lunch)
self.window.destroy()
except:
messagebox.showerror("Error",
"Something is Wrong\nCheck your input!")
self.window.destroy()
def showEmployee3WE(self, event):
self.cnx = mysql.connector.connect(**self.config)
self.cursor = self.cnx.cursor()
self.cleanRightFrame()
self.outputT.delete(1.0, END)
employees = QF.showEmployee3E(self.cursor)
for employee in employees:
self.outputT.insert(INSERT, "ID: ")
self.outputT.insert(INSERT, employee[0])
self.outputT.insert(INSERT, "\nDOB: ")
self.outputT.insert(INSERT, employee[1])
self.outputT.insert(INSERT, "\nBASE SALARY: ")
self.outputT.insert(INSERT, employee[2])
self.outputT.insert(INSERT, "\nNAME: ")
self.outputT.insert(INSERT, employee[3])
self.outputT.insert(INSERT, "\nPOSITION: ")
self.outputT.insert(INSERT, employee[4])
self.outputT.insert(INSERT, "\nWARNING: ")
self.outputT.insert(INSERT, employee[5])
self.outputT.insert(INSERT, "\n" + "*" * 60 + '\n\n')
self.outputT.grid(column=0, row=0, rowspan=1, columnspan=1)
self.scrollbarB.grid(row=0,
column=1,
rowspan=1,
columnspan=1,
sticky=N + S)
def okayE(self, event):
info = []
id = self.idI.get()
position = self.positionI.get()
wage = self.wageI.get()
try:
info.append(wage)
info.append(position)
info.append(id)
workerinfo = tuple(info)
QF.updateWorker(workerinfo)
self.window.destroy()
except:
messagebox.showerror("Error",
"Something is Wrong\nCheck your input!")
self.window.destroy()
def okayE(self, event):
info = []
type = self.typeI.get()
price = self.priceI.get()
quantity = self.quantityI.get()
try:
info.append(type)
info.append(price)
info.append(quantity)
good = tuple(info)
QF.insertGood(good)
self.window.destroy()
except:
messagebox.showerror("Error",
"Something is Wrong\nCheck your input!")
self.window.destroy()
def showExtremeFoodE(self, event):
self.cnx = mysql.connector.connect(**self.config)
self.cursor = self.cnx.cursor()
self.cleanRightFrame()
self.outputT.delete(1.0, END)
foods = QF.showExtremeFood(self.cursor)
for food in foods:
self.outputT.insert(INSERT, "NO: ")
self.outputT.insert(INSERT, food[0])
self.outputT.insert(INSERT, "\nINGREDIENTS:\n")
for ingre in food[1]:
self.outputT.insert(INSERT, ingre)
self.outputT.insert(INSERT, "\nFOOD NAME: ")
self.outputT.insert(INSERT, food[2])
self.outputT.insert(INSERT, "\nPRICE: ")
self.outputT.insert(INSERT, food[3])
self.outputT.insert(INSERT, "\nPOPULARITY: ")
self.outputT.insert(INSERT, food[4])
self.outputT.insert(INSERT, "\n" + "*" * 60 + '\n\n')
self.outputT.grid(column=0, row=0, rowspan=1, columnspan=1)
self.scrollbarB.grid(row=0,
column=1,
rowspan=1,
columnspan=1,
sticky=N + S)
def showExpenseE(self, event):
self.cnx = mysql.connector.connect(**self.config)
self.cursor = self.cnx.cursor()
self.cleanRightFrame()
self.outputT.delete(1.0, END)
expenses = QF.showExpense(self.cursor)
for expense in expenses:
self.outputT.insert(INSERT, "DATE: ")
self.outputT.insert(INSERT, expense[0])
self.outputT.insert(INSERT, "\nELECTRICITY: ")
self.outputT.insert(INSERT, expense[1])
self.outputT.insert(INSERT, "\nGAS: ")
self.outputT.insert(INSERT, expense[2])
self.outputT.insert(INSERT, "\nWATER: ")
self.outputT.insert(INSERT, expense[3])
self.outputT.insert(INSERT, "\nSALARY: ")
self.outputT.insert(INSERT, expense[4])
self.outputT.insert(INSERT, "\nRENT: ")
self.outputT.insert(INSERT, expense[5])
self.outputT.insert(INSERT, "\nCOST OF GOODS: ")
self.outputT.insert(INSERT, expense[6])
self.outputT.insert(INSERT, "\n" + "*" * 60 + '\n\n')
self.outputT.grid(column=0, row=0, rowspan=1, columnspan=1)
self.scrollbarB.grid(row=0,
column=1,
rowspan=1,
columnspan=1,
sticky=N + S)
def okayE(self, event):
info = []
ingredients = self.ingredientsI.get()
foodname = self.foodnameI.get()
price = self.priceI.get()
popularity = self.popularityI.get()
try:
info.append(ingredients)
info.append(foodname)
info.append(price)
info.append(popularity)
food = tuple(info)
QF.addFood(food)
self.window.destroy()
except:
messagebox.showerror("Error",
"Something is Wrong\nCheck your input!")
self.window.destroy()
def okayE(self, event):
info = []
dob = self.DOBI.get()
name = self.nameI.get()
position = self.positionI.get()
baseSalary = self.baseSalaryI.get()
try:
info.append(dob)
info.append(baseSalary)
info.append(name)
info.append(position)
workerinfo = tuple(info)
QF.addWorker(workerinfo)
self.window.destroy()
except:
messagebox.showerror("Error",
"Something is Wrong\nCheck your input!")
self.window.destroy()
def okayE(self, event):
info = []
date = str(datetime.datetime.now())
cashier = self.cashierI.get()
foodordered = self.foodorderedI.get()
earning = self.earningI.get()
try:
info.append(date)
info.append(cashier)
info.append(foodordered)
info.append(earning)
trans = tuple(info)
QF.addTransaction(trans)
self.window.destroy()
except:
messagebox.showerror("Error",
"Something is Wrong\nCheck your input!")
self.window.destroy()
def okayE(self, event):
removable = False
cursor = QF.cursor
query = "SELECT ID FROM Employees"
cursor.execute(query)
info = []
id = self.workerI.get()
info.append(id)
idd = tuple(info)
mylist = []
for n in cursor:
mylist.append(str(n[0]))
if id in mylist:
removable = True
if removable == True:
QF.removeWorker(idd)
self.window.destroy()
else:
messagebox.showerror("Error", "Not a valid Employee!")
self.window.destroy()
def okayE(self, event):
removable=False
cursor = QF.cursor
query = "SELECT Name FROM LunchSpecials;"
cursor.execute(query)
info = []
lunch = self.lunchI.get()
info.append(lunch)
luncha = tuple(info)
mylist=[]
for n in cursor:
mylist.append(n[0])
if lunch in mylist:
removable=True
if removable==True:
QF.removeLunch(luncha)
self.window.destroy()
else:
messagebox.showerror("Error", "Not a valid Lunch Special!")
self.window.destroy()
def okayE(self, event):
info = []
date = self.dateI.get()
electricity = self.electricityI.get()
gas=self.gasI.get()
water=self.waterI.get()
salary=self.salaryI.get()
rent=self.rentI.get()
costofgood=self.costofgoodI.get()
try:
info.append(date)
info.append(electricity)
info.append(gas)
info.append(water)
info.append(salary)
info.append(rent)
info.append(costofgood)
expense = tuple(info)
QF.addExpense(expense)
self.window.destroy()
except:
messagebox.showerror("Error", "Something is Wrong\nExpenses must be nonnegative numbers!\nCheck your input!")
self.window.destroy()
def okayE(self, event):
removable = False
cursor = QF.cursor
query = "SELECT Drink FROM Beverages;"
cursor.execute(query)
info = []
drink = self.drinkI.get()
info.append(drink)
something = tuple(info)
mylist = []
for n in cursor:
mylist.append(n[0])
if drink in mylist:
removable = True
if removable == True:
QF.removeDrink(something)
self.window.destroy()
else:
messagebox.showerror("Error", "Not a valid Drink!")
self.window.destroy()
def okayE(self, event):
removable = False
cursor = QF.cursor
query = "SELECT Type FROM Goods;"
cursor.execute(query)
info = []
foodname = self.typeI.get()
info.append(foodname)
good = tuple(info)
mylist=[]
for n in cursor:
mylist.append(n[0])
if foodname in mylist:
removable=True
if removable==True:
QF.removeGood(good)
self.window.destroy()
else:
messagebox.showerror("Error", "Not a valid Good!")
self.window.destroy()
def showBeverageE(self, event):
self.cnx = mysql.connector.connect(**self.config)
self.cursor = self.cnx.cursor()
self.cleanRightFrame()
self.outputT.delete(1.0, END)
drinks = QF.showBeverage(self.cursor)
for drink in drinks:
self.outputT.insert(INSERT, "DRINK: ")
self.outputT.insert(INSERT, drink[0])
self.outputT.insert(INSERT, "\nPRICE: ")
self.outputT.insert(INSERT, drink[1])
self.outputT.insert(INSERT, "\n" + "*" * 60 + '\n\n')
self.outputT.grid(column=0, row=0, rowspan=1, columnspan=1)
self.scrollbarB.grid(row=0,
column=1,
rowspan=1,
columnspan=1,
sticky=N + S)
def showLunchSpecialE(self, event):
self.cnx = mysql.connector.connect(**self.config)
self.cursor = self.cnx.cursor()
self.cleanRightFrame()
self.outputT.delete(1.0, END)
foods = QF.showLunchSpecial(self.cursor)
for food in foods:
self.outputT.insert(INSERT, "NAME: ")
self.outputT.insert(INSERT, food[0])
self.outputT.insert(INSERT, "\nPRICE: ")
self.outputT.insert(INSERT, food[1])
self.outputT.insert(INSERT, "\n" + "*" * 60 + '\n\n')
self.outputT.grid(column=0, row=0, rowspan=1, columnspan=1)
self.scrollbarB.grid(row=0,
column=1,
rowspan=1,
columnspan=1,
sticky=N + S)
def showGoodRestockE(self, event):
self.cnx = mysql.connector.connect(**self.config)
self.cursor = self.cnx.cursor()
self.cleanRightFrame()
self.outputT.delete(1.0, END)
goods = QF.showGoodRestock(self.cursor)
for good in goods:
self.outputT.insert(INSERT, "TYPE: ")
self.outputT.insert(INSERT, good[0])
self.outputT.insert(INSERT, "\nPRICE: ")
self.outputT.insert(INSERT, good[1])
self.outputT.insert(INSERT, "\nQUANTITY: ")
self.outputT.insert(INSERT, good[2])
self.outputT.insert(INSERT, "\n" + "*" * 60 + '\n\n')
self.outputT.grid(column=0, row=0, rowspan=1, columnspan=1)
self.scrollbarB.grid(row=0,
column=1,
rowspan=1,
columnspan=1,
sticky=N + S)
def transactionE(self, event):
self.cleanRightFrame()
self.outputT.delete(1.0, END)
transactions = QF.showTransaction(self.cursor)
for trans in transactions:
self.outputT.insert(INSERT, "ORDER NUMBER: ")
self.outputT.insert(INSERT, trans[0])
self.outputT.insert(INSERT, "\nDATE: ")
self.outputT.insert(INSERT, trans[1])
self.outputT.insert(INSERT, "\nCASHIER: ")
self.outputT.insert(INSERT, trans[2])
self.outputT.insert(INSERT, "\nFOOD ORDERED: \n")
for food in trans[3]:
self.outputT.insert(INSERT, food)
self.outputT.insert(INSERT, "\nEARNING: ")
self.outputT.insert(INSERT, trans[4])
self.outputT.insert(INSERT, "\n" + "*" * 60 + '\n\n')
self.outputT.grid(column=0, row=0, rowspan=1, columnspan=1)
self.scrollbarB.grid(row=0,
column=1,
rowspan=1,
columnspan=1,
sticky=N + S)
