package GUIMedlem;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javafx.collections.ListChangeListener;
import javafx.collections.ObservableList;
import javafx.geometry.Insets;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.TextField;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.scene.layout.GridPane;
import javafx.scene.text.Font;

public class TilmeldingsPane extends GridPane {

	private Button btnHent, btnHentHold;
	private Button btnTilmeld, btnFrameld;

	private final Label lblTextMedlem, lblId, lblNavn, lblAdresse, lblTelefon;
	private final Label lblTextOverSigt, lblUge, lblDag;
	private final Label lblTextTilmeldte;

	private TextField txfId, txfNavn, txfAdresse, txfTelefon;
	private TextField txfUge, txfDag;

	private TableView<Hold> tableHold = new TableView<Hold>();
	// private final ObservableList<Hold> dataHold =
	// FXCollections.observableArrayList();

	private TableView<Hold> tableTilmeldteHold = new TableView<Hold>();
	// private final ObservableList<Hold> tilmeldteHold =
	// FXCollections.observableArrayList();

	@SuppressWarnings("unchecked")
	public TilmeldingsPane() {

		setPadding(new Insets(20));
		setHgap(20);
		setVgap(10);
		setGridLinesVisible(false);

		lblTextMedlem = new Label("Indtast medlems id for log in");
		lblTextMedlem.setFont(Font.font("Verdana", 14));
		this.add(lblTextMedlem, 0, 0, 2, 1);

		lblId = new Label("Id:");
		this.add(lblId, 0, 1);

		lblNavn = new Label("Navn:");
		lblNavn.setPrefWidth(100);
		this.add(lblNavn, 0, 2);

		lblAdresse = new Label("Adresse:");
		this.add(lblAdresse, 0, 3);

		lblTelefon = new Label("Telefonnummer:");
		this.add(lblTelefon, 0, 4);

		txfId = new TextField();
		txfId.setPrefWidth(150);
		txfId.setEditable(true);
		this.add(txfId, 1, 1);

		txfNavn = new TextField();
		txfNavn.setPrefWidth(150);
		txfNavn.setEditable(true);
		this.add(txfNavn, 1, 2);

		txfAdresse = new TextField();
		txfAdresse.setPrefWidth(150);
		txfAdresse.setEditable(true);
		this.add(txfAdresse, 1, 3);

		txfTelefon = new TextField();
		txfTelefon.setPrefWidth(150);
		txfTelefon.setEditable(true);
		this.add(txfTelefon, 1, 4);

		btnHent = new Button("Hent");
		this.add(btnHent, 0, 5);
		btnHent.setOnAction(event -> hentMedlem());

		lblTextOverSigt = new Label("Holdoversigt");
		lblTextOverSigt.setFont(Font.font("Verdana", 14));
		this.add(lblTextOverSigt, 3, 0);

		lblUge = new Label("Uge:");
		this.add(lblUge, 3, 1);

		lblDag = new Label("Dag:");
		this.add(lblDag, 3, 2);

		txfUge = new TextField();
		txfUge.setPrefWidth(150);
		txfUge.setEditable(true);
		this.add(txfUge, 4, 1);

		txfDag = new TextField();
		txfDag.setPrefWidth(150);
		txfDag.setEditable(true);
		this.add(txfDag, 4, 2);

		btnHentHold = new Button("Hent");
		this.add(btnHentHold, 3, 3);
		btnHentHold.setOnAction(event -> hentHold());

		TableColumn<Hold, String> startCol = new TableColumn<Hold, String>("Starttid");
		startCol.setMinWidth(80);
		startCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("startTid"));

		TableColumn<Hold, String> navnCol = new TableColumn<Hold, String>("Navn");
		navnCol.setMinWidth(90);
		navnCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("navn"));

		TableColumn<Hold, String> varighedCol = new TableColumn<Hold, String>("Varighed");
		varighedCol.setMinWidth(80);
		varighedCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("varighed"));

		TableColumn<Hold, String> salCol = new TableColumn<Hold, String>("Sal");
		salCol.setMinWidth(80);
		salCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("sal"));

		TableColumn<Hold, String> instruktorCol = new TableColumn<Hold, String>("Instruktor");
		instruktorCol.setMinWidth(110);
		instruktorCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("instruktor"));

		TableColumn<Hold, String> maxAntalCol = new TableColumn<Hold, String>("Maks. Antal");
		maxAntalCol.setMinWidth(80);
		maxAntalCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("maxAntal"));

		TableColumn<Hold, String> aktuelleAntalCol = new TableColumn<Hold, String>("Tilmeldte");
		aktuelleAntalCol.setMinWidth(80);
		aktuelleAntalCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("aktuelleAntal"));

		this.add(tableHold, 3, 4, 3, 6);
		tableHold.getColumns().addAll(startCol, navnCol, varighedCol, salCol, instruktorCol, maxAntalCol,
				aktuelleAntalCol);

		tableHold.getSelectionModel().setCellSelectionEnabled(true);
		ObservableList selectedCells = tableHold.getSelectionModel().getSelectedCells();

		selectedCells.addListener(new ListChangeListener() {
			@Override
			public void onChanged(Change c) {

				if (tableHold.getSelectionModel().getSelectedItem() != null) {
					Hold hold = tableHold.getSelectionModel().getSelectedItem();
					System.out.println(hold.getId());
				}

			}
		});

		btnTilmeld = new Button("Tilmeld");
		this.add(btnTilmeld, 3, 11);
		btnTilmeld.setOnAction(event -> tilmeldHold());

		lblTextTilmeldte = new Label("Tilmeldte Hold");
		lblTextTilmeldte.setFont(Font.font("Verdana", 14));
		this.add(lblTextTilmeldte, 7, 0);

		TableColumn<Hold, String> ugeCol = new TableColumn<Hold, String>("Uge");
		ugeCol.setMinWidth(70);
		ugeCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("uge"));

		TableColumn<Hold, String> dagCol = new TableColumn<Hold, String>("Dag");
		dagCol.setMinWidth(90);
		dagCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("dag"));

		TableColumn<Hold, String> startTilCol = new TableColumn<Hold, String>("Starttid");
		startTilCol.setMinWidth(80);
		startTilCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("startTid"));

		TableColumn<Hold, String> navnTilCol = new TableColumn<Hold, String>("Navn");
		navnTilCol.setMinWidth(90);
		navnTilCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("navn"));

		TableColumn<Hold, String> varighedTilCol = new TableColumn<Hold, String>("Varighed");
		varighedTilCol.setMinWidth(80);
		varighedTilCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("varighed"));

		TableColumn<Hold, String> salTilCol = new TableColumn<Hold, String>("Sal");
		salTilCol.setMinWidth(80);
		salTilCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("sal"));

		TableColumn<Hold, String> instruktorTilCol = new TableColumn<Hold, String>("Instruktor");
		instruktorTilCol.setMinWidth(110);
		instruktorTilCol.setCellValueFactory(new PropertyValueFactory<Hold, String>("instruktor"));

		this.add(tableTilmeldteHold, 7, 4, 1, 6);
		tableTilmeldteHold.getColumns().addAll(ugeCol, dagCol, startTilCol, navnTilCol, varighedTilCol, salTilCol,
				instruktorTilCol);
		tableTilmeldteHold.getSelectionModel().setCellSelectionEnabled(true);
		ObservableList selectedCellsTilmelding = tableTilmeldteHold.getSelectionModel().getSelectedCells();

		selectedCellsTilmelding.addListener(new ListChangeListener() {
			@Override
			public void onChanged(Change c) {

				if (tableTilmeldteHold.getSelectionModel().getSelectedItem() != null) {
					Hold hold = tableTilmeldteHold.getSelectionModel().getSelectedItem();
				}

			}
		});
		btnFrameld = new Button("Frameld");
		this.add(btnFrameld, 7, 11);
		btnFrameld.setOnAction(event -> frameldHold());

	}

	public void updateControls() {

	}

	public void hentMedlem() {
		try {
			tableTilmeldteHold.getItems().clear();
			Connection minConnection;
			minConnection = DriverManager
					.getConnection(
							"jdbc:sqlserver://DESKTOP-C5KJ46E\\DAOS;databaseName=Yodafit;user=sa;password=123123;");

			Statement stmt = minConnection.createStatement();

			String id = txfId.getText();
			ResultSet res = stmt.executeQuery("exec hentMedlem " + id);

			while (res.next()) {
				txfNavn.setText(res.getString(1));
				txfAdresse.setText(res.getString(2));
				txfTelefon.setText(res.getString(3));
			}
			hentTilmeldteHold();
		} catch (SQLException e) {
			System.out.println(e.getMessage());
		}
	}

	public void hentHold() {
		try {
			tableHold.getItems().clear();
			Connection min;

			min = DriverManager
					.getConnection(
							"jdbc:sqlserver://DESKTOP-C5KJ46E\\DAOS;databaseName=Yodafit;user=sa;password=123123;");
			Statement stmt = min.createStatement();
			String uge = txfUge.getText();
			String dag = txfDag.getText();

			ResultSet res = stmt.executeQuery("exec hentHoldMedlem " + uge + ", " + dag);

			while (res.next()) {
				Hold hold = new Hold(res.getString(1), res.getString(2), res.getString(3), res.getString(4),
						res.getString(5), res.getString(6), res.getString(7), res.getString(8),
						Integer.parseInt(res.getString(9)), Integer.parseInt(res.getString(10)));
				tableHold.getItems().add(hold);
			}

		} catch (SQLException e) {
			System.out.println(e.getMessage());
		}

	}

	public void tilmeldHold() {

	}

	public void frameldHold() {

	}

	public void hentTilmeldteHold() {
		try {
			Connection min;

			min = DriverManager
					.getConnection(
							"jdbc:sqlserver://DESKTOP-C5KJ46E\\DAOS;databaseName=Yodafit;user=sa;password=123123;");
			Statement stmt = min.createStatement();
			String id = txfId.getText();

			ResultSet res = stmt.executeQuery("exec hentMedlemsHold " + id);

			while (res.next()) {
				Hold hold = new Hold(res.getString(1), res.getString(2), res.getString(3), res.getString(4),
						res.getString(5), res.getString(6), res.getString(7), res.getString(8),
						Integer.parseInt(res.getString(9)), Integer.parseInt(res.getString(10)));
				tableTilmeldteHold.getItems().add(hold);
			}

		} catch (Exception e) {
			// TODO: handle exception
		}
	}

	public static class Hold {

		private String id;
		private String navn;
		private String dag;
		private String uge;
		private String startTid;
		private String varighed;
		private String sal;
		private String instruktor;
		private int maxAntal;
		private int aktuelleAntal;

		public Hold(String id, String navn, String dag, String uge, String startTid, String varighed, String sal,
				String instruktor, int maxAntal, int aktuelleAntal) {
			this.id = id;
			this.navn = navn;
			this.dag = dag;
			this.uge = uge;
			this.startTid = startTid;
			this.varighed = varighed;
			this.sal = sal;
			this.instruktor = instruktor;
			this.maxAntal = maxAntal;
			this.aktuelleAntal = aktuelleAntal;
		}

		public String getId() {
			return id;
		}

		public String getDag() {
			return dag;
		}

		public String getUge() {
			return uge;
		}

		public String getStartTid() {
			return startTid;
		}

		public String getVarighed() {
			return varighed;
		}

		public String getNavn() {
			return navn;
		}

		public String getSal() {
			return sal;
		}

		public String getInstruktor() {
			return instruktor;
		}

		public int getMaxAntal() {
			return maxAntal;
		}

		public int getAktuelleAntal() {
			return aktuelleAntal;
		}
	}

}