@SuppressWarnings("unchecked") @Override public List<AccountStateEntity> findAllAccountStateEntities() { HashMap<String, Object> queryParameters = new HashMap<String, Object>(); queryParameters.put("prdTypeId", AccountTypes.LOAN_ACCOUNT.getValue()); List<AccountStateEntity> queryResult = (List<AccountStateEntity>) this.genericDao.executeNamedQuery( NamedQueryConstants.RETRIEVEALLACCOUNTSTATES, queryParameters); initializeAccountStates(queryResult); List<AccountStateEntity> allStateEntities = new ArrayList<AccountStateEntity>(queryResult); queryParameters = new HashMap<String, Object>(); queryParameters.put("prdTypeId", AccountTypes.SAVINGS_ACCOUNT.getValue()); queryResult = (List<AccountStateEntity>) this.genericDao.executeNamedQuery( NamedQueryConstants.RETRIEVEALLACCOUNTSTATES, queryParameters); initializeAccountStates(queryResult); allStateEntities.addAll(queryResult); return allStateEntities; }
public List<AccountBO> findApprovedLoansForClientWithPhoneNumber(String phoneNumber) throws PersistenceException { Map<String, Object> queryParameters = new HashMap<String, Object>(); queryParameters.put("phoneNumberStripped", MifosStringUtils.removeNondigits(phoneNumber)); queryParameters.put("loanAccountTypeId", AccountTypes.LOAN_ACCOUNT.getValue()); return executeNamedQuery( NamedQueryConstants.FIND_APPROVED_LOANS_FOR_CLIENT_WITH_PHONE_NUMBER, queryParameters); }
public AccountBO findLoanByClientPhoneNumberAndProductShortName( String phoneNumber, String productShortName) throws PersistenceException { Map<String, Object> queryParameters = new HashMap<String, Object>(); queryParameters.put("phoneNumberStripped", MifosStringUtils.removeNondigits(phoneNumber)); queryParameters.put("loanAccountTypeId", AccountTypes.LOAN_ACCOUNT.getValue()); queryParameters.put("productShortName", productShortName); Object queryResult = execUniqueResultNamedQuery( NamedQueryConstants.FIND_LOAN_ACCOUNT_BY_CLIENT_PHONE_NUMBER_AND_PRODUCT_SHORT_NAME, queryParameters); return queryResult == null ? null : (AccountBO) queryResult; }
public AccountBO findLoanByClientGovernmentIdAndProductShortName( String clientGovernmentId, String productShortName) throws PersistenceException { Map<String, Object> queryParameters = new HashMap<String, Object>(); queryParameters.put("clientGovernmentId", clientGovernmentId); queryParameters.put("loanAccountTypeId", AccountTypes.LOAN_ACCOUNT.getValue()); queryParameters.put("productShortName", productShortName); Object queryResult = execUniqueResultNamedQuery( NamedQueryConstants.FIND_LOAN_ACCOUNT_BY_CLIENT_GOVERNMENT_ID_AND_PRODUCT_SHORT_NAME, queryParameters); return queryResult == null ? null : (AccountBO) queryResult; }