/** 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();
 }