public static RepNotification UPDATE_REPONSE(OVNotification ovNotification) throws SQLException {

        RepNotification rep = new RepNotification();
        Connection connexion = GET_CONNECTION();

        try {

            Statement statement = connexion.createStatement();
            int resultat = statement.executeUpdate("UPDATE reponse SET etat = " + ovNotification.getReponseEnvoye().getEtat() + " WHERE idReponse = " + ovNotification.getReponseEnvoye().getId() + ";");

            if (resultat == 0) {
                rep.erreur = true;
                rep.messageErreur = "Aucune ligne mise à jour!";
            }

                 // Ajout de la promotion //
            if (ovNotification.getReponseEnvoye().getEtat() == 1 && ovNotification.getOvPromotion() != null) {
                resultat = statement.executeUpdate("INSERT intO promotionutilisateur (idUtilisateur, idPromotion) VALUES (" + ovNotification.getIdUtilisateur() + "," + ovNotification.getOvPromotion().getId() + ");", Statement.RETURN_GENERATED_KEYS);

                if (resultat == 0) {
                    rep.erreur = true;
                    rep.messageErreur = "Aucune ligne inséré!";
                }
            }

        } catch (SQLException ex) {
            rep.erreur = true;
            rep.messageErreur = ex.getMessage();
        }

        return rep;
    }