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;
}
