/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package testbdd2;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;

/**
 *
 * @author cedrickaiser2
 */
public class Genre extends JFrame implements ActionListener{

    static final String ACTION_RETOUR = "Retour";
    static final String ACTION_VALIDER = "Valider";
    private String genre;
    private JLabel message;
    private JLabel lblGenre;
    private JTextField tfGenre;
    private JButton btRetour;
    private JButton btValider;
    private Connection connec;
    private Film film;


    Genre(Film f) {
        film = f;
        init();
    }

    Genre() {
        film = null;
        init();
    }

    public void init(){
        this.setTitle("Nouveau genre");
        this.setLayout(null);

        this.setLocation(100, 100);

        message = new JLabel("Entrer un nouveau genre");
        message.setBounds(10, 10, 200, 20);

        lblGenre = new JLabel("Nouveau genre");
        lblGenre.setBounds(10, 30, 100, 20);

        tfGenre = new JTextField();
        tfGenre.setBounds(150, 30, 100, 20);

        btRetour = new JButton(ACTION_RETOUR);
        btRetour.setBounds(10, 50, 100, 20);
        btRetour.addActionListener(this);

        btValider = new JButton(ACTION_VALIDER);
        btValider.setBounds(150, 50, 100, 20);
        btValider.addActionListener(this);

        this.getContentPane().add(message);
        this.getContentPane().add(lblGenre);
        this.getContentPane().add(tfGenre);
        this.getContentPane().add(btRetour);
        this.getContentPane().add(btValider);

        this.setSize(350, 200);
        this.setResizable(false);
        this.setVisible(true);
    }

    public void actionPerformed(ActionEvent e) {
        String action = e.getActionCommand();

        ConnectionBDD cbdd = ConnectionBDD.getInstance();
        connec = (Connection) cbdd.getConnexion();

        if (action.equals(ACTION_RETOUR)) {
            this.dispose();
        } else if (action.equals(ACTION_VALIDER)) {
            genre = tfGenre.getText();

            String requete = "insert into genre(nomGenre) values('" + genre + "')";

            Statement st;
            try {
                st = (Statement) connec.createStatement();
                st.executeUpdate(requete);

            } catch (SQLException ex) {
                System.out.println("Erreur d'insertion d'informations dans la Base de Données : " + ex.getMessage());
            }

            if(film != null) {
                film.afficheGenre();
            }
            
            this.dispose();
        }
    }
}