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))