public static Reservation getUserReservation(int userid, int eventid) {
        try {
            Connection con = DB.getConnection();
            PreparedStatement ps = con.prepareStatement(GETUSERRESERVATION);
            ps.setInt(1, userid);
            ps.setInt(2, eventid);
            ResultSet result = ps.executeQuery();
            if (result.first()) {
                Reservation res = extractReservation(result);
                return res;
            }
        } catch (Exception e) {
        }
        return null;
    }