def addHoliday(win):
def submitClick(cursor):
assert employee.get() != "", "No employee entered."
assert float(workHours.get()), "No work hours entered."
cursor.execute("""INSERT INTO jobs(assigneeId, date, workHours, status) VALUES(?, ?, ?, 'Holiday')""", [employee.get(), startDate.get(), workHours.get()])
win.destroy()
# Make UI.
startDate, workHours, employee = ui.form(win, ["Start date", "Work hours", "Employee"], accessDb(submitClick))
def addJob(win):
def submitClick(cursor):
assert description.get() != "", "No description entered."
assert customer.get() != "", "No customer entered."
assert boat.get() != "", "No boat entered."
assert float(workHours.get()), "No work hours entered."
assigneeId = getAssignee(cursor)
cursor.execute("""INSERT INTO jobs(description, customerId, boatId, workHours, date, status, assigneeId) VALUES(?, ?, ?, ?, DATE('now'), 'Incomplete', ?)""", [description.get(), customer.get(), boat.get(), workHours.get(), assigneeId])
win.destroy()
# Make UI.
description, customer, boat, workHours = ui.form(win, ["Description", "Customer", "Boat", "Work hours"], accessDb(submitClick))
def addHoliday(win):
def submitClick(cursor):
assert employee.get() != "", "No employee entered."
assert float(workHours.get()), "No work hours entered."
cursor.execute(
"""INSERT INTO jobs(assigneeId, date, workHours, status) VALUES(?, ?, ?, 'Holiday')""",
[employee.get(), startDate.get(),
workHours.get()])
win.destroy()
# Make UI.
startDate, workHours, employee = ui.form(
win, ["Start date", "Work hours", "Employee"], accessDb(submitClick))
def addJob(win):
def submitClick(cursor):
assert description.get() != "", "No description entered."
assert customer.get() != "", "No customer entered."
assert boat.get() != "", "No boat entered."
assert float(workHours.get()), "No work hours entered."
assigneeId = getAssignee(cursor)
cursor.execute(
"""INSERT INTO jobs(description, customerId, boatId, workHours, date, status, assigneeId) VALUES(?, ?, ?, ?, DATE('now'), 'Incomplete', ?)""",
[
description.get(),
customer.get(),
boat.get(),
workHours.get(), assigneeId
])
win.destroy()
# Make UI.
description, customer, boat, workHours = ui.form(
win, ["Description", "Customer", "Boat", "Work hours"],
accessDb(submitClick))
