/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package nl.hva.hboict.fys;

import java.sql.*;
import java.util.Stack;

import javafx.application.Application;
import static javafx.application.Application.launch;

import javafx.beans.property.ReadOnlyStringWrapper;
import javafx.beans.value.ChangeListener;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.geometry.HPos;
import javafx.geometry.Insets;
import javafx.geometry.Pos;
import javafx.geometry.VPos;
import javafx.scene.Scene;
import javafx.scene.control.*;
import javafx.scene.layout.*;
import javafx.stage.Stage;
import javafx.scene.text.Font;
import javafx.scene.text.Text;
import nl.hva.hboict.sql.DataRow;
import nl.hva.hboict.sql.DataTable;

/**
 *
 * @author Boris Kalshoven
 */
public class EventHandlers extends Application {

    Scene scene1, scene2;
    Stage thestage;
    Button btVbrv;

    private static TableView<DataRow> createJavaFXReadOnlyDataTableView(DataTable dt) {
        TableView<DataRow> tv = new TableView<>();
        tv.setPrefWidth(5000);

        // define a JavaFX TableColumn for every column in the DataTable
        for (int c = 0; c < dt.getNColumns(); c++) {
            TableColumn<DataRow, String> tc = new TableColumn(dt.getColumnName(c));
            tc.setStyle("-fx-alignment: CENTER;");
            tc.setResizable(true);
            final int colIndex = c;

            // configure the Cell Value generator
            tc.setCellValueFactory(data -> {
                DataRow dr = data.getValue();
                String cellValue;
                cellValue = dr.getString(colIndex);
                return new ReadOnlyStringWrapper(cellValue);
            });
            tv.getColumns().add(tc);
        }

        // Add all Data Table data to the TableView
        for (int i = 0; i < dt.size(); i++) {
            tv.getItems().add(dt.get(i));
        }

        // align the view with the boundaries of the container
        tv.setColumnResizePolicy(TableView.CONSTRAINED_RESIZE_POLICY);
        //tv.setColumnResizePolicy((param) -> true);

        return tv;
    }

    private static Region pagina2(Button btVbrv){
        VBox inrichting = new VBox();
        inrichting.setAlignment(Pos.TOP_RIGHT);

        //hbox bovenin de grid
        HBox bar = new HBox();
        bar.setAlignment(Pos.TOP_RIGHT);
        bar.setSpacing(15);
        bar.setPadding(new Insets(5, 10, 10, 10));

        //hbox text "Corendon"
        HBox textCorendon = new HBox();
        textCorendon.setAlignment(Pos.TOP_LEFT);
        textCorendon.setSpacing(15);
        textCorendon.setPadding(new Insets(15, 10, 10, 15));

        //hbox drop down menu
        HBox invoer = new HBox();
        invoer.setAlignment(Pos.TOP_RIGHT);
        invoer.setPadding(new Insets(10, 10, 10, 10));
        invoer.setSpacing(15);

        //hbox voor button voeg toe
        HBox add = new HBox();
        add.setAlignment(Pos.TOP_RIGHT);
        add.setPadding(new Insets(10, 10, 0, 0));
        add.setSpacing(30);

        //hbox voor ingevoerde gegevens
        HBox kenmerken = new HBox();
        kenmerken.setAlignment(Pos.TOP_RIGHT);
        kenmerken.setPadding(new Insets(10, 10, 10, 10));
        kenmerken.setSpacing(15);

        HBox toevoegen = new HBox();
        toevoegen.setAlignment(Pos.TOP_RIGHT);
        toevoegen.setSpacing(15);
        toevoegen.setPadding(new Insets(5, 10, 10, 10));

        //button1
        Button btn = new Button();
        btn.setText("Vermiste bagage registreren/verwijderen");
        btn.setMaxSize(140, 60);
        btn.setWrapText(true);
        return inrichting;
    }


    /*
    Pas dit aan!!
    */

    @Override
    public void start(Stage primaryStage) {

        thestage = primaryStage;

        //Login Pagina
        Button btnL = new Button("Login");
        TextField txtL = new TextField("Username");
        PasswordField passL = new PasswordField();
        HBox buttonBar = new HBox(btnL, txtL, passL);
//eerste pagina
        StackPane mainArea =  new StackPane();

        GridPane pane = new GridPane();
        pane.add(buttonBar, 0, 0);
        pane.setPrefHeight(400);
        pane.setPrefWidth(600);
        pane.setPadding(new Insets(10, 10, 10, 250));
        pane.setHgap(10);
        pane.setVgap(10);
        pane.add(mainArea, 0, 1);

        //text and labels
        Label label1 = new Label("koffers");
        label1.setPrefWidth(130);
        TextField text = new TextField();

        GridPane.setConstraints(label1, 0, 1);
        GridPane.setConstraints(text, 1, 1);

        Label label2 = new Label("kleur");
        TextField text2 = new TextField();

        GridPane.setConstraints(label2, 0, 2);
        GridPane.setConstraints(text2, 1, 2);

        Label label3 = new Label("formaat");
        TextField text3 = new TextField();
        GridPane.setConstraints(label3, 0, 3);
        GridPane.setConstraints(text3, 1, 3);

        Label label4 = new Label("gewicht");
        TextField text4 = new TextField();
        GridPane.setConstraints(label4, 0, 4);
        GridPane.setConstraints(text4, 1, 4);

        Label label5 = new Label("merk");
        TextField text5 = new TextField();
        GridPane.setConstraints(label5, 0, 5);
        GridPane.setConstraints(text5, 1, 5);

        //zoek button
        Button btZoeken = new Button("Zoeken");
        GridPane.setConstraints(btZoeken, 1, 7, 1, 1, HPos.CENTER, VPos.BASELINE);

        //repatrieer button
        Button btRepatrieer = new Button("Repatrieer");
        GridPane.setConstraints(btRepatrieer, 1, 7, 1, 1, HPos.CENTER, VPos.BASELINE);

        btVbrv = new Button("Vermiste koffers registreren");
        btVbrv.setPadding(new Insets(0));

        //Gevonden checkbox
        CheckBox cb1 = new CheckBox("Gevonden");
        GridPane.setConstraints(cb1, 0, 6);
        //Vermiste checkbox
        CheckBox cb2 = new CheckBox("Vermist");
        GridPane.setConstraints(cb2, 1, 6);

        //action voor button registreerKoffer

        /*
        pas dit aan!!
        */
        btVbrv.setOnAction(e -> ButtonClicked(e));


        /*

        Tweede pagina is jouw code!!
        */
//tweede pagina
        VBox inrichting = new VBox();
        inrichting.setAlignment(Pos.TOP_RIGHT);

        //hbox bovenin de grid
        HBox bar = new HBox();
        bar.setAlignment(Pos.TOP_RIGHT);
        bar.setSpacing(15);
        bar.setPadding(new Insets(5, 10, 10, 10));

        //hbox text "Corendon"
        HBox textCorendon = new HBox();
        textCorendon.setAlignment(Pos.TOP_LEFT);
        textCorendon.setSpacing(15);
        textCorendon.setPadding(new Insets(15, 10, 10, 15));

        //hbox drop down menu
        HBox invoer = new HBox();
        invoer.setAlignment(Pos.TOP_RIGHT);
        invoer.setPadding(new Insets(10, 10, 10, 10));
        invoer.setSpacing(15);

        //hbox voor button voeg toe
        HBox add = new HBox();
        add.setAlignment(Pos.TOP_RIGHT);
        add.setPadding(new Insets(10, 10, 0, 0));
        add.setSpacing(30);

        //hbox voor ingevoerde gegevens
        HBox kenmerken = new HBox();
        kenmerken.setAlignment(Pos.TOP_RIGHT);
        kenmerken.setPadding(new Insets(10, 10, 10, 10));
        kenmerken.setSpacing(15);

        HBox toevoegen = new HBox();
        toevoegen.setAlignment(Pos.TOP_RIGHT);
        toevoegen.setSpacing(15);
        toevoegen.setPadding(new Insets(5, 10, 10, 10));

        //button1
        Button btn = new Button();
        btn.setText("Vermiste bagage registreren/verwijderen");
        btn.setMaxSize(140, 60);
        btn.setWrapText(true);

        //button acties
        /*

        Pas dit aan!!

        */

        btn.setOnAction(e -> ButtonClicked(e));

        //button 2
        Button btn2 = new Button();
        btn2.setText("Gevonden bagage registreren/verwijderen");
        btn2.setMaxSize(140, 60);
        btn2.setWrapText(true);

        //button2 acties
        btn2.setOnAction(new EventHandler<ActionEvent>() {

            @Override
            public void handle(ActionEvent event) {
                System.out.println("");
            }
        });

        //button3
        Button btn3 = new Button();
        btn3.setText("Voeg toe");
        btn3.setMaxSize(2500, 60);

        //button 4
        Button btn4 = new Button();
        btn4.setText("Toevoegen");
        btn4.setMaxSize(140, 60);

        //button 5
        Button btn5 = new Button();
        btn5.setText("Verwijderen");
        btn5.setMaxSize(140, 60);

        //text "Corendon"
        Text t = new Text("Corendon");
        t.setFont(new Font(20));

        //menu
        ChoiceBox cb = new ChoiceBox(FXCollections.observableArrayList(
                "Kleur",
                "Gewicht",
                "Lengte",
                "Breedte",
                "Label Nr.",
                "Locatie")
        );
        /*
        cb.setPrefWidth(140);
        cb.setMaxWidth(140);
         */
        Label label = new Label();
        //TextField y = new TextField();

        final String[] keuze = new String[]{"Kleur", "Gewicht", "Lengte", "Breedte", "Label Nr.", "Locatie"};

        cb.getSelectionModel().selectedIndexProperty().addListener(new ChangeListener<Number>() {
            public void changed(ObservableValue ov, Number value, Number new_value) {
                label.setText(keuze[new_value.intValue()]);
                //y.setText(keuze[new_value.intValue()]);

            }
        }
        );

        //invoer van tekst
        TextField textField = new TextField();
        textField.setMaxWidth(140);

        //display van tekst
        TextArea j = new TextArea();
        j.setPrefSize(240, 120);
        j.setEditable(false);

        /*
        label.textProperty().bind(test);
         */
        btn3.setOnAction(new EventHandler<ActionEvent>() {

            @Override
            public void handle(ActionEvent event) {
                if (textField.getText().trim().isEmpty() == false && label.getText().trim().isEmpty() == false) {
                    String test = " ";
                    test = j.getText();
                    j.setText(test + label.getText() + " - " + textField.getText() + " \n");
                    textField.clear();
                }
            }
        });

        //root
        StackPane root = new StackPane();
        root.getChildren().addAll(text, inrichting);
        inrichting.getChildren().addAll(bar, invoer, add, kenmerken, toevoegen);

        //bar
        bar.getChildren().addAll(btn, btn2);

        //text
        textCorendon.getChildren().add(t);

        //invoer
        invoer.getChildren().addAll(cb, textField);

        //add
        add.getChildren().addAll(btn3);

        //kenmerken
        kenmerken.getChildren().add(j);

        //toevoegen
        toevoegen.getChildren().addAll(btn4, btn5);

        //scene 1 en 2
        pane.getChildren().addAll(label1, text, label2, text2, label3, text3,
                label4, text4, label5, text5, btZoeken, cb1, cb2, btVbrv);
        pane.setGridLinesVisible(false);
        scene1 = new Scene(pane);
        scene2 = new Scene(root, 600, 400);
        primaryStage.setTitle("EventHandlers");
        primaryStage.setScene(scene1);
        primaryStage.show();

    }

    /*

    pas dit aan!!

    */
    public void ButtonClicked(ActionEvent e) {
        if (e.getSource() == btVbrv) {
            thestage.setScene(scene2);
        } else {
            thestage.setScene(scene1);
        }
    }


 /*
Button btnE, btnC, btnS, btnL;
StackPane mainArea = new StackPane();
    Label txtL,passL;

    btnL.setOnAction(new EventHandler<ActionEvent>() {
                             @Override
                             public void handle(ActionEvent event) {
                                 String user = txtL.getText();
                                 String pass = passL.getText();
                                 try {
                                     Class<?> aClass = Class.forName("com.mysql.jdbc.Driver");
                                     Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/myairline", "root", "handig123");
                                     Statement stmt = con.createStatement();
                                     String sql = "Select * from user WHERE username ='" + user + "' and password ='" + pass + "'";
                                     ResultSet rs = stmt.executeQuery(sql);
                                     while (rs.next()) {
                                         if (user.equals(rs.getString("username"))) {
                                             if (pass.equals(rs.getString("password"))) {
                                                 mainArea.getChildren().clear();
                                                 mainArea.getChildren().add(createJavaFXReadOnlyDataTableView(airportData));
                                                 btnE.setVisible(true);
                                                 btnC.setVisible(false);
                                                 btnS.setVisible(false);
                                                 buttonList.setVisible(true);
                                                 txtL.setVisible(false);
                                                 passL.setVisible(false);

                                             } else {
                                                 alert.showAndWait();
                                             }
                                         } else {
                                             alert.showAndWait();
                                         }
                                         stmt.close();
                                         con.close();
                                     }


                                 } catch (ClassNotFoundException e) {
                                     e.printStackTrace();
                                 } catch (SQLException e) {
                                     e.printStackTrace();
                                 }
                             }
                         });

*/
   /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        launch(args);
    }
}