public ArrayList<SupplierDeliveryReceipt> GetDeliveryReceiptList() throws ParseException {
ArrayList<SupplierDeliveryReceipt> DeliveryReceipt = new ArrayList<SupplierDeliveryReceipt>();
try {
DBConnectionFactory myFactory = DBConnectionFactory.getInstance();
Connection conn = myFactory.getConnection();
PreparedStatement pstmt = conn.prepareStatement("select * from supplier_delivery_receipt");
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
SupplierDeliveryReceipt temp = new SupplierDeliveryReceipt();
temp.setDrNumber(rs.getInt("drNumber"));
temp.setPoNumber(rs.getInt("poNumber"));
temp.setItemCode(rs.getInt("itemCode"));
temp.setDateReceived(rs.getDate("dateReceived"));
temp.setQty(rs.getInt("qty"));
temp.setReceivedBy(rs.getInt("receivedBy"));
temp.setApprovedBy(rs.getInt("approvedBy"));
temp.setStatus(rs.getString("status"));
DeliveryReceipt.add(temp);
}
pstmt.close();
conn.close();
return DeliveryReceipt;
} catch (SQLException ex) {
Logger.getLogger(SupplierDeliveryReceiptDAO.class.getName()).log(Level.SEVERE, null, ex);
}
return null;
}
public boolean EncodeSupplierDeliveryReceipt(SupplierDeliveryReceipt newSupplierDeliveryReceipt) {
try {
DBConnectionFactory myFactory = DBConnectionFactory.getInstance();
Connection conn = myFactory.getConnection();
String query =
"insert into supplier_delivery_receipt"
+ "(drNumber,poNumber,itemCode,dateReceived,qty,"
+ "receivedBy,approvedBy,status) "
+ "values (?,?,?,?,?,?,?,?)";
PreparedStatement pstmt = conn.prepareStatement(query);
pstmt.setInt(1, newSupplierDeliveryReceipt.getDrNumber());
pstmt.setInt(2, newSupplierDeliveryReceipt.getPoNumber());
pstmt.setInt(3, newSupplierDeliveryReceipt.getItemCode());
pstmt.setDate(4, newSupplierDeliveryReceipt.getDateReceived());
pstmt.setInt(5, newSupplierDeliveryReceipt.getQty());
pstmt.setInt(6, newSupplierDeliveryReceipt.getReceivedBy());
pstmt.setInt(7, newSupplierDeliveryReceipt.getApprovedBy());
pstmt.setString(8, newSupplierDeliveryReceipt.getStatus());
int rows = pstmt.executeUpdate();
conn.close();
return rows == 1;
} catch (SQLException ex) {
Logger.getLogger(SupplierDeliveryReceiptDAO.class.getName()).log(Level.SEVERE, null, ex);
}
return false;
}
public ArrayList<RefSupplier> MonitorRefSupplier() {
ArrayList<RefSupplier> refSupplier = new ArrayList<RefSupplier>();
try {
DBConnectionFactory myFactory = DBConnectionFactory.getInstance();
Connection conn = myFactory.getConnection();
PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM `ref_supplier`");
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
RefSupplier newRefSupplier = new RefSupplier();
newRefSupplier.setSupplierID(rs.getInt("supplierID"));
newRefSupplier.setItemCode(rs.getInt("itemCode"));
newRefSupplier.setItemName(rs.getString("itemName"));
newRefSupplier.setCompanyName(rs.getString("companyName"));
newRefSupplier.setCompanyAddress(rs.getString("companyAddress"));
newRefSupplier.setContactPerson(rs.getString("contactPerson"));
newRefSupplier.setContactNumber(rs.getInt("contactNumber"));
refSupplier.add(newRefSupplier);
System.out.println(refSupplier.get(0).getCompanyName());
}
pstmt.close();
rs.close();
conn.close();
return refSupplier;
} catch (SQLException ex) {
Logger.getLogger(RefSupplierDAO.class.getName()).log(Level.SEVERE, null, ex);
}
return null;
}
public boolean EncodeRefSupplier(RefSupplier newRefSupplier) {
try {
DBConnectionFactory myFactory = DBConnectionFactory.getInstance();
Connection conn = myFactory.getConnection();
String query =
"insert into `ref_supplier`"
+ "(supplierID,itemCode,itemName,companyName,companyAddress,contactPerson,contactNumber) "
+ "values (?,?,?,?,?,?,?)";
PreparedStatement pstmt = conn.prepareStatement(query);
pstmt.setInt(1, newRefSupplier.getSupplierID());
pstmt.setInt(2, newRefSupplier.getItemCode());
pstmt.setString(3, newRefSupplier.getItemName());
pstmt.setString(4, newRefSupplier.getCompanyName());
pstmt.setString(5, newRefSupplier.getCompanyAddress());
pstmt.setString(6, newRefSupplier.getContactPerson());
pstmt.setFloat(7, newRefSupplier.getContactNumber());
int rows = pstmt.executeUpdate();
conn.close();
return rows == 1;
} catch (SQLException ex) {
Logger.getLogger(RefSupplierDAO.class.getName()).log(Level.SEVERE, null, ex);
}
return false;
}
public ArrayList<RefSupplier> searchSupplier(String itemName) throws SQLException {
DBConnectionFactory myFactory = DBConnectionFactory.getInstance();
Connection conn = myFactory.getConnection();
String query = "SELECT * FROM `ref_supplier` WHERE itemName LIKE '%" + itemName + "%'";
PreparedStatement ps = conn.prepareStatement(query);
ArrayList<RefSupplier> RefSupplierList = new ArrayList();
ResultSet rs = ps.executeQuery();
while (rs.next()) {
RefSupplier RefSupplierN = new RefSupplier();
RefSupplierN.setSupplierID(rs.getInt("supplierID"));
RefSupplierN.setItemCode(rs.getInt("itemCode"));
RefSupplierN.setItemName(rs.getString("itemName"));
RefSupplierN.setCompanyName(rs.getString("companyName"));
RefSupplierN.setCompanyAddress(rs.getString("companyAddress"));
RefSupplierN.setContactPerson(rs.getString("contactPerson"));
RefSupplierN.setContactNumber(rs.getInt("contactNumber"));
RefSupplierList.add(RefSupplierN);
}
rs.close();
return RefSupplierList;
}