home

package application;

import javafx.scene.Scene;

import javafx.stage.Stage;
import javafx.scene.text.Font;
import javafx.scene.text.Text;
import javafx.scene.control.Alert;
import javafx.scene.control.Button;
import javafx.scene.control.ButtonType;
import javafx.scene.control.ChoiceBox;
import javafx.scene.control.TextField;
import javafx.scene.image.Image;
import javafx.scene.image.ImageView;
import javafx.scene.control.Alert.AlertType;
import javafx.scene.Group;
import javafx.scene.Node;
import javafx.scene.layout.GridPane;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;

import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.geometry.Insets;
import javafx.geometry.Pos;


public class HomePage extends Stage{
    public HomePage() {
        Stage current = this;
        Connection con;



        Button addPatient = new Button("Add Patient");
        addPatient.setMinSize(100, 50);
        Button search = new Button("Search");
        search.setMinSize(100, 50);
        Button missing = new Button("Missing Reports");
        missing.setMinSize(100, 50);
        Button upComing = new Button("Up Coming Sessions");
        upComing.setMinSize(100, 50);
        Button provider = new Button("Provider");
        provider.setMinSize(100, 50);



        //Styling nodes
        addPatient.setStyle("-fx-background-color: pink; -fx-text-fill: black;");
        search.setStyle("-fx-background-color: pink; -fx-text-fill: black;");
        missing.setStyle("-fx-background-color: pink; -fx-text-fill: black;");
        upComing.setStyle("-fx-background-color: pink; -fx-text-fill: black;");
        provider.setStyle("-fx-background-color: pink; -fx-text-fill: black;");




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

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

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

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

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

        //Arranging all the nodes in the grid
        gridPane.add(search,1,1);
        gridPane.add(upComing, 2, 1);
        gridPane.add(addPatient, 3,1 );
        gridPane.add(missing,5 ,1 );
        gridPane.add(provider,4 ,1 );
        gridPane.setStyle("-fx-background-image: url(\"33682672_1485248468245623_4434124833390854144_n.jpg\"); -fx-background-color:white;");







        upComing.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                LocalDate date = LocalDate.now();
                Sessions sessions = new Sessions(current, date);
                sessions.show();
                current.close();

            }
        });

        addPatient.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                Connection conn = null;
                try {
                    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/company?useSSL=false","root", "ahmed666");
                    String select="select * from help";
                    PreparedStatement selectStmt = conn.prepareStatement(select);
                    ResultSet res=selectStmt.executeQuery();
                    String ID = null;
                    while(res.next()) {
                        ID=res.getString("ID");
                    }
                    if(ID!=null) {
                    String delete="delete from help where ID = ?";
                    PreparedStatement deleteStmt = conn.prepareStatement(delete);
                    deleteStmt.setString(1, ID);
                    deleteStmt.executeUpdate();
                    }

                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }


                Add add = new Add(current);
                add.show();
                current.close();

            }
        });

        search.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                Search searchPage = new Search(current,null,null);
                searchPage.show();
                current.close();

            }
        });

        missing.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                MissingReports missingPage = new MissingReports(current);
                missingPage.show();
                current.close();

            }
        });

        provider.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                Provider provider = new Provider(current);
                provider.show();
                current.close();

            }
        });







        Scene scene = new Scene(gridPane);

        //scene.getStylesheets().add(getClass().getResource("application.css").toExternalForm());
        setScene(scene);
        setTitle(" رؤية");
    }

}