-
Notifications
You must be signed in to change notification settings - Fork 0
/
SalesController.java
136 lines (126 loc) · 4.56 KB
/
SalesController.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
/*
* Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
* Click nbfs://nbhost/SystemFileSystem/Templates/javafx/FXMLController.java to edit this template
*/
package inventorysystem;
import static inventorysystem.UserController.stage2;
import java.io.IOException;
import java.net.URL;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.ResourceBundle;
import java.util.logging.Level;
import java.util.logging.Logger;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.collections.transformation.FilteredList;
import javafx.collections.transformation.SortedList;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.fxml.FXMLLoader;
import javafx.fxml.Initializable;
import javafx.scene.Parent;
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.input.MouseEvent;
import javafx.stage.Stage;
/**
* FXML Controller class
*
* @author Zahra Maryam
*/
public class SalesController implements Initializable {
@FXML
private TableView<Sales> tblSales;
@FXML
private Button btnAdd;
@FXML
private TextField txtSearch;
@FXML
private TableColumn<Sales, Integer> saleNo;
@FXML
private TableColumn<Sales, Float> profit;
@FXML
private TableColumn<Sales, Date> produstSaleDate;
public static Stage stage2;
@FXML
private Button refresh;
/**
* Initializes the controller class.
*/
@Override
public void initialize(URL url, ResourceBundle rb) {
try {
showTable();
} catch (SQLException ex) {
Logger.getLogger(SalesController.class.getName()).log(Level.SEVERE, null, ex);
}
}
private ObservableList<Sales> getList() throws SQLException{
ObservableList<Sales> oblist = FXCollections.observableArrayList();
Connection con = connection.getConnection();
String querey = "SELECT * FROM inventory.sales;";
Statement ps;
ResultSet rs;
ps = con.createStatement();
rs = ps.executeQuery(querey);
Sales mc ;
while(rs.next()){
mc = new Sales(rs.getInt("saleNo"), rs.getFloat("profit"), rs.getDate("produstSaleDate"));
oblist.add(mc);
}
return oblist;
}
private void showTable() throws SQLException{
ObservableList<Sales> oblist = getList();
saleNo.setCellValueFactory(new PropertyValueFactory<> ("saleNo"));
profit.setCellValueFactory(new PropertyValueFactory<> ("profit"));
produstSaleDate.setCellValueFactory(new PropertyValueFactory<> ("produstSaleDate"));
tblSales.setItems(oblist);
FilteredList<Sales> filterData = new FilteredList<>(oblist, b->true);
txtSearch.textProperty().addListener((observable, oldValue, newValue) ->{
filterData.setPredicate(Sales -> {
String searchWord = newValue.toLowerCase();
if(newValue.isEmpty() || newValue == null){
return true;
}
else if(Sales.getProdustSaleDate().toString().indexOf(searchWord)>-1)
return true;
else
return false;
});
});
SortedList<Sales> sorted = new SortedList<>(filterData);
sorted.comparatorProperty().bind(tblSales.comparatorProperty());
tblSales.setItems(sorted);
}
private void executeQuerey(String querey) {
Connection conn = connection.getConnection();
Statement st;
try{
st = conn.createStatement();
st.executeUpdate(querey);
}catch(Exception ex){
ex.printStackTrace();
}
}
@FXML
private void Add(MouseEvent event) throws IOException {
Parent root2 = FXMLLoader.load(getClass().getResource("AddSale.fxml"));
stage2 = new Stage();
Scene scene3 = new Scene(root2 );
stage2.setScene(scene3);
stage2.show();
}
@FXML
private void refresh(ActionEvent event) throws SQLException {
showTable();
}
}