import javax.swing.JFrame;
import java.awt.Color;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.util.ArrayList;
import java.util.List;

import javax.swing.JButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;

import com.db4o.Db4oEmbedded;
import com.db4o.ObjectContainer;
import com.db4o.query.Predicate;
import javax.swing.JLabel;

public class Modify {
	private static JTextField text2;
	private static JTextField text3;
	private static JTextField text4;
	private static JTextField text1;
	private static JTextField text5;
	private static JTextField text6;

    public static void main(String[] args){


        JFrame frame = new JFrame();
        frame.setResizable(false);
        JTable table = new JTable();


        Object[] columns = {"Nom","Prenom","Age","Pays","Ville","Adresse"};
        DefaultTableModel model = new DefaultTableModel();
        model.setColumnIdentifiers(columns);


        table.setModel(model);


        table.setBackground(Color.LIGHT_GRAY);
        table.setForeground(Color.black);
        Font font = new Font("",1,22);
        table.setFont(font);
        table.setRowHeight(30);


        JButton btnAfficher = new JButton("Afficher");
        JButton btnDelete = new JButton("Delete");
        JButton btnUpdate = new JButton("Update");

        btnAfficher.setBounds(52, 357, 100, 25);
        btnUpdate.setBounds(349, 357, 100, 25);
        btnDelete.setBounds(672, 357, 100, 25);


        JScrollPane pane = new JScrollPane(table);
        pane.setBounds(0, 0, 880, 325);

        frame.getContentPane().setLayout(null);

        frame.getContentPane().add(pane);


        frame.getContentPane().add(btnAfficher);
        frame.getContentPane().add(btnDelete);
        frame.getContentPane().add(btnUpdate);

        text2 = new JTextField();
        text2.setBounds(108, 435, 86, 20);
        frame.getContentPane().add(text2);
        text2.setColumns(10);

        text3 = new JTextField();
        text3.setBounds(208, 435, 86, 20);
        frame.getContentPane().add(text3);
        text3.setColumns(10);

        text4 = new JTextField();
        text4.setBounds(322, 435, 86, 20);
        frame.getContentPane().add(text4);
        text4.setColumns(10);

        text1 = new JTextField();
        text1.setColumns(10);
        text1.setBounds(10, 435, 86, 20);
        frame.getContentPane().add(text1);

        text5 = new JTextField();
        text5.setColumns(10);
        text5.setBounds(432, 435, 86, 20);
        frame.getContentPane().add(text5);

        text6 = new JTextField();
        text6.setColumns(10);
        text6.setBounds(557, 435, 86, 20);
        frame.getContentPane().add(text6);
     //  text1.setVisible(false);
    //  text2.setVisible(false);
        //    text3.setVisible(false);
        //     text4.setVisible(false);
        //   text5.setVisible(false);
        //    text6.setVisible(false);


        Object[] row = new Object[6];


        btnAfficher.addActionListener(new ActionListener(){

            @Override
            public void actionPerformed(ActionEvent e) {
            	 ObjectContainer db = Db4oEmbedded.openFile("databaseFile1.db4o");
            	 model.setRowCount(0);
            	try{

            		List<Personne> l = db.queryByExample(Personne.class);

            		 for (Personne personne : l) {
            			 ArrayList<Emplacement> are = new ArrayList<Emplacement>();

            			 are=personne.getEmp();


            			 if(are!=null){
            			for(Emplacement emplacement : are){
            				row[3] = emplacement.getPays();
            				row[4]=emplacement.getVille();
            				row[5]=emplacement.getAdresse();


            			}
            			 }
            			 row[0] = personne.getNom();
            		     row[1] = personne.getPrenom();
            		     row[2] = personne.getAge();

            		                // add row to the model
            		      model.addRow(row);

            		      row[0] = "";
             		     row[1] ="";
             		     row[2] = "";
             		    row[3] = "";
        				row[4]="";
        				row[5]="";
            			}
            		 }

            		finally{
            			db.close();
            		}

            }
        });


        btnDelete.addActionListener(new ActionListener(){

            @Override
            public void actionPerformed(ActionEvent e) {
            	 int i = table.getSelectedRow();
            	 String valsup=   (String) table.getValueAt(i,0);
            	 System.out.println(valsup);
		////////////////////////BDO
            ObjectContainer db = Db4oEmbedded.openFile("databaseFile1.db4o");
             try {

            	    List<Personne> al = db.query(new Predicate<Personne>(){

            	        @Override
            	        public boolean match(Personne p) {
            	            // TODO Auto-generated method stub
            	            return p.getNom().equals(valsup);
            	        }


            	    }) ;

            	    Personne pe = al.get(0);
            	    db.delete(pe);

            	    }
            	    finally {
            	    db.close();
            	    }

             ///////////////////VISUEL
             // i = the index of the selected row

             if(i >= 0){

                 // remove a row from jtable
                 model.removeRow(i);
             }
             else{
                 System.out.println("Delete Error");
             }

            }
        });

        // get selected row data From table to textfields
        table.addMouseListener(new MouseAdapter(){

        @Override
        public void mouseClicked(MouseEvent e){

            // i = the index of the selected row
            int i = table.getSelectedRow();
            try
            {
            	text1.setText("");
   	         text2.setText("");
   	         text3.setText("");
   	         text4.setText("");
   	         text5.setText("");
   	       text6.setText("");

	         text1.setText(model.getValueAt(i, 0).toString());
	         text2.setText(model.getValueAt(i, 1).toString());
	         text3.setText(model.getValueAt(i, 2).toString());
	         text4.setText(model.getValueAt(i, 3).toString());
	         text5.setText(model.getValueAt(i, 4).toString());
	       text6.setText(model.getValueAt(i, 5).toString());
            }
            catch(Exception e1)
            {
            	System.out.println("");
            }
        }
        });

        // button update row
        btnUpdate.addActionListener(new ActionListener(){

            @Override
            public void actionPerformed(ActionEvent e) {

                // i = the index of the selected row
                int i = table.getSelectedRow();
                //////////////////////////////BDO
                String nombeforeupdate=   (String) table.getValueAt(i,0);
                String paysupdate=   (String) table.getValueAt(i,3);
                String villeupdate=   (String) table.getValueAt(i,4);
                String adresseupdate=   (String) table.getValueAt(i,5);








                ///////////////////////VISUEL
                if(i >= 0)
                {
                /*     model.setValueAt(text1.getText(), i, 0);
                	  model.setValueAt(text2.getText(), i, 1);
                   model.setValueAt(text3.getText(), i, 2);
                    model.setValueAt(text4.getText(), i, 3);
                    model.setValueAt(text5.getText(), i, 4);
                    model.setValueAt(text6.getText(), i, 5);*/


                }
                else{
                    System.out.println("Update Error");
                }



            }
        });

        frame.setSize(900,519);
        frame.setLocationRelativeTo(null);
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.setVisible(true);

    }
}