import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javafx.application.Application;
import javafx.geometry.Insets;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
import javafx.scene.control.TextField;
import javafx.scene.layout.HBox;
import javafx.scene.layout.VBox;
import javafx.stage.Stage;

/**
 * 1. get rid of Egyptian folks (Mahmoud)
 * 2. Add the Driver file to the project.
 * 3.
 *
 *
 *
 */
public class Main extends Application{


    public static void main(String... args){


        launch(args);


    }


    public Connection getConnection(){

        Connection connection = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");

            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/final", "root", "");


        } catch (Exception ex) {
            Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
        }

        return connection;

    }


    public void start(Stage primary){

        VBox root = new VBox(20);
        root.setPadding(new Insets(20));


        Button add = new Button("Add");
        add.setOnAction(e->addEmployee(root));

        root.getChildren().addAll(add);
        try{

            Statement stmt = getConnection().createStatement();
            ResultSet result = stmt.executeQuery("SELECT * FROM employee");
            while(result.next()){

                int id = result.getInt("id");
                String name = result.getString("name");
                String phone = result.getString("phone");
                int sal = result.getInt("sal");

                Label lbl = new Label(id + ": " + name + ":" + phone + ":" + sal);
                Button del = new Button("Delete");

                HBox box = new HBox(lbl, del);
                del.setOnAction(e->{
                    root.getChildren().remove(box);
                    try{
                        Statement st = getConnection().createStatement();
                        st.executeUpdate("DELETE FROM employee WHERE id=" + id );
                    }catch(Exception exx){
                        System.out.println(exx);

                    }
                });


                root.getChildren().add(box);


            }

        }catch(Exception ex){
            System.out.println(ex);
        }




        primary.setScene(new Scene(root, 400, 500));
        primary.show();


    }

    public void addEmployee(VBox root2){
        Stage addWindows = new Stage();

        TextField name = new TextField();
        name.setPromptText("Name");

        TextField phone = new TextField();
        phone.setPromptText("Phone");

        TextField salary = new TextField();
        salary.setPromptText("Salary");

        Button save = new Button("Save");

        save.setOnAction(e->{
            try{


                Statement stmt = getConnection().createStatement();
                stmt.executeUpdate("INSERT INTO employee (name, phone, sal) VALUES ('" + name.getText() + "', '" + phone.getText() + "', " +salary.getText()+ ")");
                addWindows.close();

                Label lbl = new Label( name.getText() + ":" + phone.getText() + ":" + salary.getText());
                Button del = new Button("Delete");

                HBox box = new HBox(lbl, del);
                del.setOnAction(exxx->{
                    root2.getChildren().remove(box);
                    try{
                        Statement st = getConnection().createStatement();
                        st.executeUpdate("DELETE FROM employee WHERE name='" + name.getText() + "'");
                    }catch(Exception exx){
                        System.out.println(exx);

                    }
                });

                root2.getChildren().add(box);


            }catch(Exception ee){
                System.out.println(ee);
            }


        });


        VBox root = new VBox(20, name, phone, salary, save);
        root.setPadding(new Insets(20));

        addWindows.setScene(new Scene(root, 250, 200));
        addWindows.show();
        addWindows.setTitle("Add Employee");



    }


}