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

import javafx.application.Application;
import static javafx.application.Application.launch;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
import javafx.scene.control.TextField;
import javafx.scene.layout.GridPane;
import javafx.stage.Stage;
import javafx.scene.layout.VBox;
import javafx.geometry.Pos;
import javafx.scene.layout.HBox;
import javafx.geometry.Insets;

public class JavaApplication30 extends Application
{
    @Override
    public void start(Stage stage)
    {
        GridPane okno= new GridPane();
        //panel lewy
        VBox panel_lewy=new VBox();
        panel_lewy.setSpacing(50);
        panel_lewy.setPadding(new Insets(5, 5, 5, 5));
        //
        panel_lewy.setMinWidth(200);
        panel_lewy.setAlignment(Pos.TOP_LEFT);
        panel_lewy.setStyle("-fx-stroke: green;\n" +
"    -fx-stroke-width: 5;\n" +
"    -fx-stroke-dash-array: 12 2 4 2;\n" +
"    -fx-stroke-dash-offset: 6;\n" +
"    -fx-stroke-line-cap: butt;");

        //
        okno.add(panel_lewy, 0, 0, 1, 4);

        HBox prawy= new HBox();

        prawy.setMinWidth(400);
        prawy.setAlignment(Pos.CENTER_LEFT);
        //prawy.setSpacing(50);
        prawy.setPadding(new Insets(20, 5, 5, 5));
        okno.add(prawy,1,0,1,1);

        VBox pole_spr=new VBox();
        pole_spr.setMinWidth(400);
        pole_spr.setAlignment(Pos.TOP_LEFT);
        okno.add(pole_spr,1,1,1,1);

        //przyciski
        Button testBD2 = new Button("Dane");
        testBD2.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white; -fx-background-size: 1200 900;\n" +
"-fx-background-radius: 30;\n" +
"-fx-border-radius: 30;\n" +
"-fx-border-width:5;\n" +
"-fx-border-color: #FC3D44;");


        Button testBD1= new Button("Test");
        testBD1.getStyleClass().add("testBD1");
        testBD1.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white; -fx-background-size: 1200 900;\n" +
"-fx-background-radius: 30;\n" +
"-fx-border-radius: 30;\n" +
"-fx-border-width:5;\n" +
"-fx-border-color: #FC3D44;");

        panel_lewy.getChildren().addAll(testBD2, testBD1);


        //etykiety
        Label wynik=new Label("polaczono z baza danych");
        Label wynik2=new Label("polaczono z bd z pol formularza");
        Label err1= new Label("blad poloczenia");
        Label err2=new Label("blad sterownika");

        //przycisk "Dane"

        testBD2.setOnAction(e->
        {
            pole_spr.getChildren().clear();
            prawy.getChildren().clear();


            TextField loginField = new TextField();
            loginField.setMaxWidth(200);
            TextField hasloField = new TextField();
            hasloField.setMaxWidth(200);
            TextField bdField = new TextField();
            bdField.setMaxWidth(200);

            Label login= new Label("Login");
            Label haslo= new Label("Haslo");
            haslo.setPadding(new Insets(10, 0, 0, 0));
            Label bd= new Label("Nazwa bazy danych");
            bd.setPadding(new Insets(10, 0, 0, 0));

            prawy.getChildren().clear();

            VBox etykiety = new VBox();
            etykiety.getChildren().addAll(login,haslo,bd);
            VBox pola_txt = new VBox();
            pola_txt.getChildren().addAll(loginField,hasloField,bdField);
            Button spr=new Button("Sprawdz");
            pole_spr.getChildren().add(spr);
            prawy.getChildren().addAll(etykiety,pola_txt);
            spr.setOnAction(spr1->
            {
                prawy.getChildren().clear();
                pole_spr.getChildren().clear();

                Label loginWynik=new Label();
                loginWynik.setText(loginField.getText());
                String login1=loginWynik.getText();

                Label hasloWynik=new Label();
                hasloWynik.setText(hasloField.getText());
                String haslo1=hasloWynik.getText();

                Label bdWynik=new Label();
                bdWynik.setText(bdField.getText());
                String bd1=bdWynik.getText();

                Connection con;
                    try{
                    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                    con = DriverManager.getConnection("jdbc:sqlserver://"+
                    "mssql.inf.ug.edu.pl:1401;databaseName=" +bd1+
                    ";user="+login1+";password=" + haslo1+";");
                    prawy.getChildren().add(wynik2);


                    con.close();
                    }
                    catch(SQLException error_polaczenie) {
                        prawy.getChildren().add(err1);
                    }
                    catch(ClassNotFoundException error_sterownik) {
                        prawy.getChildren().add(err2);
                    }
            });
        });


        //przycisk "testBD"
        testBD1.setOnAction(e->
                {
                    prawy.getChildren().clear();
                    pole_spr.getChildren().clear();

                    Connection con;
                    try{
                    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                    con = DriverManager.getConnection("jdbc:sqlserver://"+
                    "mssql.inf.ug.edu.pl:1401;databaseName=mdajnowicz;"+
                    "user=mdajnowicz;password=253971;");

                   prawy.getChildren().add(wynik);
                    con.close();
                    }
                    catch(SQLException error_polaczenie) {
                        okno.add(err1,1,0,1,1);
                    }
                    catch(ClassNotFoundException error_sterownik) {
                        okno.add(err2,1,1,1,1);
                    }
                }
                );

                    Scene scena = new Scene(okno, 500,150);
                    stage.setScene(scena);
                    scena.getStylesheets().add("style.css");
                    stage.show();

                }

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