public boolean saveNewBooking(BookingRegister br, Connection con) {
        int rowsInserted = 0;
        String SQLString =
                "insert into BOOKING "
                + "values (?,?,?,?,?,?,?,?,?,?,?,?,?)";
        PreparedStatement statement = null;

        try {
            //== insert tuple
            statement = con.prepareStatement(SQLString);
            
            statement.setString(1, br.getGuestName());
            statement.setString(2, br.getGuestLastName());
            statement.setString(3, br.getGuestAddress());
            statement.setString(4, br.getGuestCountry());
            statement.setString(5, br.getGuestEmail());
            statement.setInt(6, br.getPhone());
            statement.setInt(7, br.getCheckInDate());
            statement.setInt(8, br.getCheckOutDate());
            statement.setString(9, br.getGuestAgency());
             statement.setString(10, br.getRoomPrice());
            statement.setInt(11, br.getSingleRoom());
            statement.setInt(12, br.getDoubleRoom());
            statement.setInt(13, br.getFamilyRoom());
      
            

            rowsInserted = statement.executeUpdate();
        } catch (Exception e) {
            System.out.println("Fail in BOOKING - saveNewBooking");
            System.out.println(e.getMessage());
        } finally // must close statement
        {
            try {
                statement.close();
            } catch (SQLException e) {
                System.out.println("Fail in BOOKING - saveNewBooking");
                System.out.println(e.getMessage());
            }
        }
        return rowsInserted == 1;
    }