package hotel.management.system;

import java.net.URL;
import java.util.ResourceBundle;
import javafx.fxml.Initializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javafx.collections.FXCollections;
import javafx.fxml.FXML;
import javafx.scene.Node;
import javafx.scene.control.Pagination;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;
import javax.swing.JOptionPane;
/**
 * FXML Controller class
 *
 * @author PHILSERVER
 */
public class AliennavigationController implements Initializable {

    int itemPerPage = 5;
    int from = 0, to = 0;

    @FXML
    private Pagination pagination;

    @FXML
    private TableView<TableSetterGetter1> paginationTableview;


    @FXML
    private TableColumn<TableSetterGetter1, String> nameofhotel, surname, othernames, nationality, telephone, profession, maritalstatus, nameofspouse, numberofchildren, modeoftravel, purposeofvisit, countryofresidence, numberofnight, rate, discount, total, dateofarrival, dateofdepature, issuedat, no, arrivedherefrom, fullname, purposeofvisitt, durationofstay, destination, hostaddress, emailaddress, dateofdepaturee, sex;





    @Override
    public void initialize(URL url, ResourceBundle rb) {

     int count = 0;
         try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            JOptionPane.showMessageDialog(null, "Unable to register class " + e.getMessage());
        }

        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost/level2", "root", "addison");
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("select count(*) from foreignersinformation");
            rs.first();
            count = rs.getInt(1);
            rs.close();
            stmt.close();

            con.close();
        } catch (Exception e) {
            e.printStackTrace();

        }

       nameofhotel.setCellValueFactory(new PropertyValueFactory<>("nameofhotel"));
       surname.setCellValueFactory(new PropertyValueFactory<>("surname"));
       othernames.setCellValueFactory(new PropertyValueFactory<>("othernames"));
       nationality.setCellValueFactory(new PropertyValueFactory<>("nationality"));
       telephone.setCellValueFactory(new PropertyValueFactory<>("telephone"));
       profession.setCellValueFactory(new PropertyValueFactory<>("profession"));
       maritalstatus.setCellValueFactory(new PropertyValueFactory<>("maritalStatus"));
       nameofspouse.setCellValueFactory(new PropertyValueFactory<>("nameofspouse"));
       numberofchildren.setCellValueFactory(new PropertyValueFactory<>("numberofchildren"));
       modeoftravel.setCellValueFactory(new PropertyValueFactory<>("modeoftravel"));
       purposeofvisit.setCellValueFactory(new PropertyValueFactory<>("purposeofvisit"));
       countryofresidence.setCellValueFactory(new PropertyValueFactory<>("countryofresidence"));
       numberofnight.setCellValueFactory(new PropertyValueFactory<>("numberofnight"));
       rate.setCellValueFactory(new PropertyValueFactory<>("rate"));
       discount.setCellValueFactory(new PropertyValueFactory<>("discount"));
       total.setCellValueFactory(new PropertyValueFactory<>("total"));
       dateofarrival.setCellValueFactory(new PropertyValueFactory<>("dateofarrival"));
       dateofdepature.setCellValueFactory(new PropertyValueFactory<>("dateofdepature"));
       issuedat.setCellValueFactory(new PropertyValueFactory<>("issuedat"));
       no.setCellValueFactory(new PropertyValueFactory<>("no"));
       arrivedherefrom.setCellValueFactory(new PropertyValueFactory<>("arrivedherefrom"));
       fullname.setCellValueFactory(new PropertyValueFactory<>("fullname"));
       purposeofvisitt.setCellValueFactory(new PropertyValueFactory<>("purposeofvisitt"));
       durationofstay.setCellValueFactory(new PropertyValueFactory<>("durationofstay"));
       destination.setCellValueFactory(new PropertyValueFactory<>("deatination"));
       hostaddress.setCellValueFactory(new PropertyValueFactory<>("hostaddress"));
       emailaddress.setCellValueFactory(new PropertyValueFactory<>("emailaddress"));
       dateofdepaturee.setCellValueFactory(new PropertyValueFactory<>("dateofdepaturee"));
       sex.setCellValueFactory(new PropertyValueFactory<>("sex"));

        int pageCount = (count / itemPerPage) + 1;
        pagination.setPageCount(pageCount);

        pagination.setPageFactory(this::createPage);
    }

    public List<TableSetterGetter1> getTableData() {

        List<TableSetterGetter1> data = new ArrayList<>();
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            JOptionPane.showMessageDialog(null, "Unable to register class " + e.getMessage());
        }

        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost/level2", "root", "addison");
            Statement stmt = con.createStatement();

            ResultSet rs = stmt.executeQuery("select * from foreignersinformation limit " + from + "," + to);

            while (rs.next()) {
                data.add(new TableSetterGetter1("" + rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(12), rs.getString(13), rs.getString(14), rs.getString(15), rs.getString(16), rs.getString(17), rs.getString(18), rs.getString(19), rs.getString(20), rs.getString(21), rs.getString(22), rs.getString(23), rs.getString(24), rs.getString(25), rs.getString(26), rs.getString(27), rs.getString(28), rs.getString(29)));
            }

            con.close();
        } catch (Exception e) {
            e.printStackTrace();

        }

        return data;

    }

    private Node createPage(int pageIndex) {
        from = pageIndex * itemPerPage;
        to = itemPerPage;
        paginationTableview.setItems(FXCollections.observableArrayList(getTableData()));
        return paginationTableview;


    }

}