public boolean bookTicket(User user, Ticket ticket) {
   if (!isBooked(ticket)) {
     Object[] params = {
       eventAuditoriumDAO.getId(ticket.getEventAuditorium()), user.getId(), ticket.getSeat()
     };
     jdbcTemplateEmbedded.update(BOOK_TICKET, params);
     return true;
   } else {
     return false;
   }
 }
 private boolean isBooked(Ticket ticket) {
   Object[] params = {eventAuditoriumDAO.getId(ticket.getEventAuditorium()), ticket.getSeat()};
   return jdbcTemplateEmbedded.queryForObject(BOOKED_FOR_USER, params, Integer.class) > 0;
 }