/** 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();
}
/** Closes a specified ticket. */
public static void closeTicket(int ticketNum) {
DBHelper db = DBHelperFactory.createDBHelper();
db.updateTicketQueue(ticketNum, 2);
db.close();
}