Main class

import javafx.application.Application;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.geometry.Insets;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.TextField;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.scene.layout.GridPane;
import javafx.scene.text.Text;
import javafx.stage.Stage;

import java.sql.PreparedStatement;
import java.sql.SQLException;


public class uiMain extends Application {

    ObservableList<Interjers> data = FXCollections.observableArrayList();
    TextField kodsT, nosaukumsT, inventarsT, uzskaitesT, iegadesT;
    TableView<Interjers> tableView, tableViewM;
    private PersonDataAccessor dataAccessor ;
    PreparedStatement pst = null;

    public static void main(String[] args) {
        launch(args);
    }
    public void start(Stage stage) throws Exception{

        dataAccessor = new PersonDataAccessor("com.mysql.cj.jdbc.Driver",
                "jdbc:mysql://sql11.freesqldatabase.com/sql11197391?autoReconnect=true&useSSL=false",
                "sql11197391", "Wq5u7D8s5N");


        TableColumn<Interjers, String> kodsCol = new TableColumn<>("Kods");
        kodsCol.setCellValueFactory(new PropertyValueFactory<Interjers, String>("kods"));
        TableColumn<Interjers, String> nosaukCol = new TableColumn<>("Nosaukums");
        nosaukCol.setCellValueFactory(new PropertyValueFactory<Interjers, String>("nosaukums"));
        TableColumn<Interjers, String> inventCol = new TableColumn<>("Inventāra Nr.");
        inventCol.setCellValueFactory(new PropertyValueFactory<Interjers, String>("inventaraNr"));
        TableColumn<Interjers, String> uzskaitesCol = new TableColumn<>("Uzskaites Ver.");
        uzskaitesCol.setCellValueFactory(new PropertyValueFactory<Interjers, String>("uzskaitesVer"));
        TableColumn<Interjers, String> iegadesCol = new TableColumn<>("Iegādes Ver.");
        iegadesCol.setCellValueFactory(new PropertyValueFactory<Interjers, String>("iegadesVer"));

        TableColumn<Interjers, String> kodsColM = new TableColumn<>("Kods");
        kodsColM.setCellValueFactory(new PropertyValueFactory<Interjers, String>("kods"));
        TableColumn<Interjers, String> nosaukColM = new TableColumn<>("Nosaukums");
        nosaukColM.setCellValueFactory(new PropertyValueFactory<Interjers, String>("nosaukums"));
        TableColumn<Interjers, String> inventColM = new TableColumn<>("Inventāra Nr.");
        inventColM.setCellValueFactory(new PropertyValueFactory<Interjers, String>("inventaraNr"));
        TableColumn<Interjers, String> uzskaitesColM = new TableColumn<>("Uzskaites Ver.");
        uzskaitesColM.setCellValueFactory(new PropertyValueFactory<Interjers, String>("uzskaitesVer"));
        TableColumn<Interjers, String> iegadesColM = new TableColumn<>("Iegādes Ver.");
        iegadesColM.setCellValueFactory(new PropertyValueFactory<Interjers, String>("iegadesVer"));


        GridPane gridPane = new GridPane();
        gridPane.setPadding(new Insets(10, 10, 10, 10));
        gridPane.setHgap(10);
        gridPane.setVgap(10);
        gridPane.setPrefSize(1100, 400  );

        Text kods = new Text("Kods");
        kodsT = new TextField();
        Text nosaukums = new Text("Nosaukums");
        nosaukumsT = new TextField();
        Text invent = new Text("Invent. Nr.");
        inventarsT = new TextField();
        Text uzskaite = new Text("Uzskait. Ver.");
        uzskaitesT = new TextField();
        Text iegade = new Text("Iegades Ver.");
        iegadesT = new TextField();
        Button pievienot = new Button("Pievienot atmiņā");
        Button izdzet = new Button("Izdzēst no atmiņas");
        Button pievDB = new Button("Pievienot DB");
        Button pieDBVisu = new Button("Pievienot DB visu");

        pievienot.setOnAction(event -> {
                pievButtonClicked();
        });

        izdzet.setOnAction(event -> {
            izdzButtonClicked();
        });

        pievDB.setOnAction(event -> {
            try {
                pievienotDBClicked();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        });


        tableView = new TableView();
        tableView.getColumns().addAll(kodsCol, nosaukCol, inventCol, uzskaitesCol, iegadesCol);
        tableView.getItems().addAll(dataAccessor.getInterijersList());

        tableViewM = new TableView();
        tableViewM.getColumns().addAll(kodsColM, nosaukColM, inventColM, uzskaitesColM, iegadesColM);
        tableViewM.setItems(data);

        gridPane.add(kods, 0, 0);
        gridPane.add(kodsT, 1, 0);
        gridPane.add(nosaukums, 0, 1);
        gridPane.add(nosaukumsT, 1, 1);
        gridPane.add(invent, 0, 2);
        gridPane.add(inventarsT, 1, 2);
        gridPane.add(uzskaite, 0, 3);
        gridPane.add(uzskaitesT, 1, 3);
        gridPane.add(iegade, 0, 4);
        gridPane.add(iegadesT, 1, 4);
        gridPane.add(pievienot, 0, 5);
        gridPane.add(izdzet, 1, 5);
        gridPane.add(pievDB, 0, 8);
        gridPane.add(pieDBVisu, 1, 8);
        gridPane.add(tableView, 6, 0, 4, 8);
        gridPane.add(tableViewM, 2, 0, 4, 8);

        Scene scene = new Scene(gridPane);
        stage.setScene(scene);
        stage.show();
    }

    public void pievButtonClicked() {
        int kods = Integer.parseInt(kodsT.getText());
        String nosaukums = nosaukumsT.getText();
        int inventars = Integer.parseInt(iegadesT.getText());
        double uzskaite = Double.parseDouble(uzskaitesT.getText());
        double iegade = Double.parseDouble(iegadesT.getText());
        data.addAll(new Interjers(kods, nosaukums, inventars, uzskaite, iegade));

    }

    public void izdzButtonClicked() {
        Interjers selectedItem = tableViewM.getSelectionModel().getSelectedItem();
        tableViewM.getItems().remove(selectedItem);
    }

    public void pievienotDBClicked() throws SQLException{
        String query = "INSERT INTO interjers (kods, nosaukums, inventaraNr, uzskaitesVer, iegadesVer) " +
                "VALUES (?, ?, ?, ?, ?)";

        pst = dataAccessor.connection.prepareStatement(query);

        for (int i =0; i<data.size(); i++){
            pst.setString(1, String.valueOf(data.get(i).getKods()));
            pst.setString(2, String.valueOf(data.get(i).getNosaukums()));
            pst.setString(3, String.valueOf(data.get(i).getInventaraNr()));
            pst.setString(4, String.valueOf(data.get(i).getUzskaitesVer()));
            pst.setString(5, String.valueOf(data.get(i).getIegadesVer()));

            pst.execute();

            tableView.getItems().clear();
            tableView.getItems().addAll(dataAccessor.getInterijersList());
        }
    }


}