@Override
public Collection<SavingsProductData> retrieveAllForLookup() {
final String sql =
"select "
+ this.savingsProductLookupsRowMapper.schema()
+ " where sp.deposit_type_enum = ?";
return this.jdbcTemplate.query(
sql,
this.savingsProductLookupsRowMapper,
new Object[] {DepositAccountType.SAVINGS_DEPOSIT.getValue()});
}
@Override
public SavingsProductData retrieveOne(final Long savingProductId) {
try {
this.context.authenticatedUser();
final String sql =
"select "
+ this.savingsProductRowMapper.schema()
+ " where sp.id = ? and sp.deposit_type_enum = ?";
return this.jdbcTemplate.queryForObject(
sql,
this.savingsProductRowMapper,
new Object[] {savingProductId, DepositAccountType.SAVINGS_DEPOSIT.getValue()});
} catch (final EmptyResultDataAccessException e) {
throw new SavingsProductNotFoundException(savingProductId);
}
}
