/**
* Method called by the Form panel to delete existing data.
*
* @param persistentObject value object to delete
* @return an ErrorResponse value object in case of errors, VOResponse if the operation is
* successfully completed
*/
public Response deleteRecord(ValueObject persistentObject) throws Exception {
PreparedStatement stmt = null;
try {
EmpVO vo = (EmpVO) persistentObject;
// delete from WORKING_DAYS...
stmt = conn.prepareStatement("delete from WORKING_DAYS where EMP_CODE=?");
stmt.setString(1, vo.getEmpCode());
stmt.execute();
stmt.close();
// delete from EMP...
stmt = conn.prepareStatement("delete from EMP where EMP_CODE=?");
stmt.setString(1, vo.getEmpCode());
stmt.execute();
gridFrame.reloadData();
frame.getGrid().clearData();
return new VOResponse(vo);
} catch (SQLException ex) {
ex.printStackTrace();
return new ErrorResponse(ex.getMessage());
} finally {
try {
stmt.close();
conn.commit();
} catch (SQLException ex1) {
}
}
}
/**
* Callback method called when the data loading is completed.
*
* @param error <code>true</code> if an error occours during data loading, <code>false</code> if
* data loading is successfully completed
*/
public void loadDataCompleted(boolean error) {
frame.getControlCurrency().setCurrencySymbol("$");
frame.getControlCurrency().setDecimals(2);
frame.getControlCurrency().setDecimalSymbol('.');
frame.getControlCurrency().setGroupingSymbol(',');
EmpVO vo = (EmpVO) frame.getMainPanel().getVOModel().getValueObject();
frame.getGrid().getOtherGridParams().put("empCode", vo.getEmpCode());
frame.getGrid().reloadData();
}