package GUI2;


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

import javafx.collections.FXCollections;
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() {


	}

	public void hentHold() {
		try {
			Connection minConnection;
			minConnection = DriverManager
					.getConnection("jdbc:sqlserver://LAPTOP-32KIS2JP\\DANIELSSQL;databaseName=YodaFitness2;user=sa;password=dani6602;");

			Statement stmt = minConnection.createStatement();

			String uge = txfUge.getText();
			String dag = txfDag.getText();

			ResultSet res = stmt.executeQuery("exec hentHeleHoldet2 " + uge + ", " +dag);
			while (res.next()) {

				Hold h = 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)), 0);
				tableHold.getItems().add(h);

			}

			if (res != null)
				res.close();
			if (stmt != null)
				stmt.close();
			if (minConnection != null)
				minConnection.close();
		} catch (Exception e) {
			System.out.println("fejl:  " + e.getMessage());
		}
	}

	public void tilmeldHold() {

	}

	public void frameldHold() {


	}

	public void hentTilmeldteHold() {

	}

	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;
		}
	}

}