@Override public Collection<PaymentToWhomData> retrieveAllPaymentToWhom() { this.context.authenticatedUser(); final PaymentToWhomMapper ptm = new PaymentToWhomMapper(); final String sql = "select " + ptm.schema() + "order by position"; return this.jdbcTemplate.query(sql, ptm, new Object[] {}); }
@Override public PaymentToWhomData retrieveOne(Long paymentToWhomId) { this.context.authenticatedUser(); final PaymentToWhomMapper ptm = new PaymentToWhomMapper(); final String sql = "select " + ptm.schema() + "where pm.id = ?"; return this.jdbcTemplate.queryForObject(sql, ptm, new Object[] {paymentToWhomId}); }