package lab7;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.swing.JButton;
import javax.swing.JOptionPane;
import javax.swing.JTextField;

public class Controller implements ActionListener
{
	private SQLHandler handler;
	private static String database = "person";
	private static String[] fields = {"id", "nume", "varsta"};
	private Boolean editAdd;
	private Integer currentIndex;
	private Integer currentIndexID;
	private Integer currentIndexName;
	private Integer currentIndexAge;
	private JTextField current;
	private JTextField idField;
	private JTextField nameField;
	private JTextField ageField;
	private JButton next;
	private JButton previous;
	private JButton first;
	private JButton last;
	private JButton add;
	private JButton remove;
	private JButton save;
	private JButton edit;
	private JButton search;
	private JButton cancel;

	public Controller(JTextField current, JTextField idField, JTextField nameField, JTextField ageField, JButton next, JButton previous, JButton first, JButton last, JButton add, JButton remove, JButton save, JButton edit, JButton search, JButton cancel) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException
	{
		this.handler = new SQLHandler(Controller.database, fields);
		this.currentIndex = 1;
		this.currentIndexID = 0;
		this.currentIndexName = 1;
		this.currentIndexAge = 2;
		this.current = current;
		this.idField = idField;
		this.nameField = nameField;
		this.ageField = ageField;
		this.next = next;
		this.previous = previous;
		this.first = first;
		this.last = last;
		this.add = add;
		this.remove = remove;
		this.save = save;
		this.edit = edit;
		this.search = search;
		this.cancel = cancel;

	}

	public void initialise()
	{
		ArrayList<String> result = handler.selectAll();

		this.currentIndex = 1;
		this.currentIndexID = 0;
		this.currentIndexName = 1;
		this.currentIndexAge = 2;

		this.idField.setEditable(false);
		this.nameField.setEditable(false);
		this.ageField.setEditable(false);

		this.next.setEnabled(true);
		this.last.setEnabled(true);

		this.save.setEnabled(false);
		this.cancel.setEnabled(false);

		this.previous.setEnabled(false);
		this.first.setEnabled(false);

		this.current.setText(this.currentIndex + "/" + (result.size()/Controller.fields.length));

		this.idField.setText(result.get(this.currentIndexID));
		this.nameField.setText(result.get(this.currentIndexName));
		this.ageField.setText(result.get(this.currentIndexAge));
	}

	private void firstAction()
	{
		this.initialise();

		if(!this.next.isEnabled())
		{
			this.next.setEnabled(true);
			this.last.setEnabled(true);
		}

	}

	private void nextAction()
	{
		ArrayList<String> result = handler.selectAll();

		if(this.currentIndex < (result.size()/Controller.fields.length))
		{
			if(!this.previous.isEnabled())
			{
				this.previous.setEnabled(true);
				this.first.setEnabled(true);
			}

			this.currentIndex ++;
			this.currentIndexID += Controller.fields.length;
			this.currentIndexName += Controller.fields.length;
			this.currentIndexAge += Controller.fields.length;

			this.idField.setText(result.get(this.currentIndexID));
			this.nameField.setText(result.get(this.currentIndexName));
			this.ageField.setText(result.get(this.currentIndexAge));

			this.current.setText(this.currentIndex + "/" + (result.size()/Controller.fields.length));
		}

		if(this.currentIndex == (result.size()/Controller.fields.length))
		{
			this.next.setEnabled(false);
			this.last.setEnabled(false);
		}
	}

	private void previousAction()
	{
		ArrayList<String> result = handler.selectAll();

		if(this.currentIndex > 1)
		{
			if(!this.next.isEnabled())
			{
				this.next.setEnabled(true);
				this.last.setEnabled(true);
			}

			this.currentIndex --;
			this.currentIndexID -= Controller.fields.length;
			this.currentIndexName -= Controller.fields.length;
			this.currentIndexAge -= Controller.fields.length;

			this.idField.setText(result.get(this.currentIndexID));
			this.nameField.setText(result.get(this.currentIndexName));
			this.ageField.setText(result.get(this.currentIndexAge));

			this.current.setText(this.currentIndex + "/" + (result.size()/Controller.fields.length));
		}

		if(this.currentIndex == 1)
		{
			this.previous.setEnabled(false);
			this.first.setEnabled(false);
		}
	}

	private void lastAction()
	{
		ArrayList<String> result = handler.selectAll();

		this.currentIndex = (result.size()/Controller.fields.length);
		this.currentIndexID = result.size() - Controller.fields.length;
		this.currentIndexName = result.size()- (Controller.fields.length - 1);
		this.currentIndexAge = result.size() - (Controller.fields.length - 2);

		this.current.setText(this.currentIndex + "/" + (result.size()/Controller.fields.length));

		this.idField.setText(result.get(this.currentIndexID));
		this.nameField.setText(result.get(this.currentIndexName));
		this.ageField.setText(result.get(this.currentIndexAge));

		this.next.setEnabled(false);
		this.last.setEnabled(false);

		if(!this.previous.isEnabled())
		{
			this.previous.setEnabled(true);
			this.first.setEnabled(true);
		}
	}

	private void searchAction()
	{
		String name = JOptionPane.showInputDialog("Numele pe care il cautati");

		ArrayList<String> result = handler.searchName(name);

		if(!result.isEmpty())
		{
			this.initialise();
			while(!nameField.getText().equals(result.get(1)))
				nextAction();
		}
		else
			JOptionPane.showMessageDialog(null, "Nu a fost gasit/a " + name + "!");

	}

	private void removeAction()
	{
		int dialogResult = JOptionPane.showConfirmDialog (null, "Sigur vrei sa stergi datele acestea?","Warning",JOptionPane.YES_NO_OPTION);

		if(dialogResult == JOptionPane.YES_OPTION)
		{
				handler.delete(Integer.parseInt(idField.getText()));
		}

		this.initialise();
	}

	private void editAddAction(String action)
	{
		this.first.setEnabled(false);
		this.previous.setEnabled(false);
		this.next.setEnabled(false);
		this.last.setEnabled(false);
		this.add.setEnabled(false);
		this.edit.setEnabled(false);
		this.remove.setEnabled(false);
		this.search.setEnabled(false);
		this.save.setEnabled(true);
		this.cancel.setEnabled(true);

		this.nameField.setEditable(true);
		this.ageField.setEditable(true);

		switch(action)
		{
			case "add":
				this.idField.setEditable(true);
				this.idField.setText("");
				this.nameField.setText("");
				this.ageField.setText("");
				this.current.setText("Noua inregistrare");
				this.editAdd = false;
				break;
			case "edit":
				this.current.setText("Modul editare");
				this.editAdd = true;
				break;
		}
	}

	private void saveAction()
	{
		if(!this.editAdd)
		{
			this.handler.insert(new String[] {idField.getText(), nameField.getText(), ageField.getText()});
		}
		else
		{
			this.handler.update(new String[] {idField.getText(), nameField.getText(), ageField.getText()});
		}

		this.first.setEnabled(true);
		this.previous.setEnabled(true);
		this.next.setEnabled(true);
		this.last.setEnabled(true);
		this.add.setEnabled(true);
		this.edit.setEnabled(true);
		this.remove.setEnabled(true);
		this.search.setEnabled(true);
		this.nameField.setEditable(false);
		this.ageField.setEditable(false);
		this.idField.setEditable(false);

		this.initialise();
	}

	private void cancelAction()
	{
		this.first.setEnabled(true);
		this.previous.setEnabled(true);
		this.next.setEnabled(true);
		this.last.setEnabled(true);
		this.add.setEnabled(true);
		this.edit.setEnabled(true);
		this.remove.setEnabled(true);
		this.search.setEnabled(true);
		this.nameField.setEditable(false);
		this.ageField.setEditable(false);
		this.idField.setEditable(false);

		this.initialise();
	}

	@Override
	public void actionPerformed(ActionEvent e)
	{
		JButton trigger = (JButton)e.getSource();

		switch(trigger.getName())
		{
			case "first":
				this.firstAction();
				break;
			case "next":
				this.nextAction();
				break;
			case "previous":
				this.previousAction();
				break;
			case "last":
				lastAction();
				break;
			case "search":
				searchAction();
				break;
			case "remove":
				removeAction();
				break;
			case "edit":
				editAddAction("edit");
				break;
			case "add":
				editAddAction("add");
				break;
			case "save":
				saveAction();
				break;
			case "cancel":
				cancelAction();
				break;
			default:
				break;
		}

	}

}