/** Assigns a worker by name to a ticket by ID. */ public static void assignWorker(int ticketNum, String workername) { DBHelper db = DBHelperFactory.createDBHelper(); Account temp = db.retrieveAccount(workername); db.updateTicketWorker(ticketNum, temp.get_id()); db.updateTicketQueue(ticketNum, 1); db.close(); }