package application;

import java.awt.event.MouseEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javafx.application.Application;
import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.geometry.Insets;
import javafx.geometry.Pos;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.ChoiceBox;
import javafx.scene.control.PasswordField;
import javafx.scene.control.TextField;
import javafx.scene.layout.GridPane;
import javafx.scene.text.Text;
import javafx.stage.Stage;

public class Main extends Application {
    Stage theStage;

    @Override
    public void start(Stage stage) {
        // creating label email
        theStage = stage;
        Text text1 = new Text("user name");

        // creating label password
        Text text2 = new Text("Password");

        // Creating Text Filed for email
        TextField textField1 = new TextField();

        // Creating Text Filed for password
        PasswordField textField2 = new PasswordField();

        // Creating Buttons
        Button button1 = new Button("log in");
        Button button2 = new Button("sign up");
        Button signUpButton = new Button("sign up");
        Button back = new Button("back");

        Text logInChoice = new Text("log in as :");

        // Choice box for location
        ChoiceBox logInChoiceBox = new ChoiceBox();
        logInChoiceBox.getItems().addAll("Manager", "User");

        Text nametext = new Text("Enter your name ");
        Text pass = new Text("choose your password ");
        Text creditCard = new Text("enter credit number ");
        TextField nameField = new TextField();
        TextField passField = new TextField();
        TextField creditField = new TextField();
        Text signUpChoice = new Text("sign up as :");
        ChoiceBox signUpChoiceBox = new ChoiceBox();
        signUpChoiceBox.getItems().addAll("Manager", "User");

        // Creating a Grid Pane
        GridPane gridPane = new GridPane();
        GridPane gridPane2 = new GridPane();

        // Setting size for the pane
        gridPane.setMinSize(600, 400);
        gridPane2.setMinSize(600, 400);

        // Setting the padding
        gridPane.setPadding(new Insets(10, 10, 10, 10));
        gridPane2.setPadding(new Insets(10, 10, 10, 10));

        // Setting the vertical and horizontal gaps between the columns
        gridPane.setVgap(30);
        gridPane.setHgap(30);
        gridPane2.setVgap(30);
        gridPane2.setHgap(30);

        // Setting the Grid alignment
        gridPane.setAlignment(Pos.CENTER);
        gridPane2.setAlignment(Pos.CENTER);

        // Arranging all the nodes in the grid
        gridPane.add(text1, 0, 0);
        gridPane.add(textField1, 1, 0);
        gridPane.add(text2, 0, 1);
        gridPane.add(textField2, 1, 1);
        gridPane.add(logInChoice, 0, 2);
        gridPane.add(logInChoiceBox, 1, 2);
        gridPane.add(button1, 0, 3);
        gridPane.add(button2, 1, 3);

        gridPane2.add(nametext, 0, 0);
        gridPane2.add(nameField, 1, 0);
        gridPane2.add(pass, 0, 1);
        gridPane2.add(passField, 1, 1);
        gridPane2.add(creditCard, 0, 2);
        gridPane2.add(creditField, 1, 2);
        gridPane2.add(signUpChoice, 0, 3);
        gridPane2.add(signUpChoiceBox, 1, 3);
        gridPane2.add(signUpButton, 0, 4);
        gridPane2.add(back, 1, 4);

        // Styling nodes
        button1.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white;");
        button2.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white;");

        text1.setStyle("-fx-font: normal bold 20px 'serif' ");
        text2.setStyle("-fx-font: normal bold 20px 'serif' ");
        logInChoice.setStyle("-fx-font: normal bold 20px 'serif' ");

        // Creating a scene object
        Scene scene = new Scene(gridPane);
        Scene scene2 = new Scene(gridPane2);

        // Setting title to the Stage
        stage.setTitle("login ");

        // Adding scene to the stage
        stage.setScene(scene);

        // Displaying the contents of the stage
        stage.show();

        button2.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                theStage.setTitle("sign up");
                theStage.setScene(scene2);
                theStage.show();

            }
        });

        button1.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                System.out.println(textField1.getText());
                System.out.println(textField2.getText());
                System.out.println(logInChoiceBox.getValue());

            }
        });

        back.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                theStage.setScene(scene);
                theStage.show();

            }
        });

        signUpButton.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                String name = nameField.getText();
                String pass = passField.getText();
                String numberOfCredit = creditField.getText();
                String type = (String) signUpChoiceBox.getValue();


          /*       String databaseURL = "jdbc:mysql://localhost:3306/sample47";
                String user = "root";
                String password = "admin";
                Connection conn = null;
                try {
                    Class.forName("com.mysql.jdbc.Driver");
                    conn = DriverManager.getConnection(databaseURL, user, password);
                    if (conn != null) {
                        System.out.println("Connected to the database");
                    }
                } catch (ClassNotFoundException ex) {
                    System.out.println("Could not find database driver class");
                    ex.printStackTrace();
                } catch (SQLException ex) {
                    System.out.println("An error occurred. Maybe user/password is invalid");
                    ex.printStackTrace();
                } finally {
                    if (conn != null) {
                        try {
                            conn.close();
                        } catch (SQLException ex) {
                            ex.printStackTrace();
                        }
                    }
                }*/

                try {
                    Class.forName("com.mysql.jdbc.Driver") ;
                } catch (ClassNotFoundException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                Connection conn = null;
                try {
                    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sample47?useSSL=false", "root", "admin");
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                PreparedStatement stmt = null;
                try {
                    String query = "select TITLE from book where Book_ID=1" ;
                    stmt = conn.prepareStatement(query);
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                try {
                    ResultSet rs = stmt.executeQuery() ;
                    while(rs.next()) {
                        System.out.println(rs.getString("TITLE"));
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }



            }

        });

    }

    public static void main(String args[]) {
        launch(args);
    }
}