refactoring
add pair class
add ticketDTO
add methods to util and sqlRunner to provide transactions
add save method to ticket