package application;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.scene.layout.BorderPane;
import javafx.stage.Stage;

public class GUIConsulter
{
	TableView<InfoVehicule> table;
	Statement statement = null;
	
	public GUIConsulter(BorderPane root, Stage primaryStage) throws SQLException
	{
		TableColumn<InfoVehicule, String> colonneMarque = new TableColumn<>("Marque");
		colonneMarque.setCellValueFactory(new PropertyValueFactory<>("marque"));
        
        TableColumn<InfoVehicule, String> colonneModele = new TableColumn<>("Modèle");
        colonneModele.setCellValueFactory(new PropertyValueFactory<>("modele"));
        
        TableColumn<InfoVehicule, String> colonneImmatriculation = new TableColumn<>("Immatriculation");
        colonneImmatriculation.setCellValueFactory(new PropertyValueFactory<>("immatriculation"));
        
        TableColumn colonneBoutonDetails = new TableColumn("");
        colonneBoutonDetails.setCellValueFactory(new PropertyValueFactory<InfoVehicule, String>("boutonDetails"));
        
        table = new TableView<>();
        table.setItems(getVehicule());
		table.getColumns().addAll(colonneMarque, colonneModele, colonneImmatriculation, colonneBoutonDetails);
        
        root.setCenter(table);
	}
	
	public ObservableList<InfoVehicule> getVehicule() throws SQLException
    {
		table.setTranslateY(10);
		
		ObservableList<InfoVehicule> vehicules = FXCollections.observableArrayList();
    	
    	ConnectionBddSQLite connection = new ConnectionBddSQLite("C:\\Users\\quentin\\Documents\\Eclipse\\gestionParc\\bddVehicules.db");
        Connection conn = connection.connect();
        ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM vehicules");
        
		while (rs.next()) 
		{
			vehicules.add(new InfoVehicule(rs.getString("marque").toUpperCase(), rs.getString("modele").toUpperCase(),
					rs.getString("immatriculation").toUpperCase().toUpperCase(), 
					"Détails " + rs.getString("immatriculation").toUpperCase()));
			
			System.err.println("Marque          : " + rs.getString("marque"));
			System.err.println("Modele          : " + rs.getString("modele"));
			System.err.println("Immatriculation : " + rs.getString("immatriculation"));
			System.err.println("**************************************************************");
		}
    	
		connection.disconnect();
		conn.close();
    	
    	return vehicules;
    }
}