@Override
public CountryCurrencyData retrieveCurrencyConfigurationDetails(Long id) {
try {
CurrencyMapper mapper = new CurrencyMapper();
String sql = "select " + mapper.schema() + " WHERE c.is_deleted='N' and c.id=?";
return this.jdbcTemplate.queryForObject(sql, mapper, new Object[] {id});
} catch (EmptyResultDataAccessException exception) {
return null;
}
}
@Override
public List<CountryCurrencyData> getTheCountryCurrencyDetaiils(String country) {
try {
CurrencyMapper mapper = new CurrencyMapper();
String sql = "select " + mapper.schema() + " WHERE country = ? and c.is_deleted='N' ";
return this.jdbcTemplate.query(sql, mapper, new Object[] {country});
} catch (EmptyResultDataAccessException accessException) {
return null;
}
}