// @Override // public List<ClientData> getClientList(int partyId, int buId,String clientValueSearch,boolean // IsAutoPlan,int nodeId) { // jdbcTemplate.setDataSource(dataSourceProvider.getDataSource(buId)); // return jdbcTemplate.query("{call usp_cp_getClientList(?,?,?,?)}", new Object[] { // partyId,clientValueSearch,IsAutoPlan,nodeId }, // new BeanPropertyRowMapper<ClientData>(ClientData.class)); // } @SuppressWarnings("finally") @Override public Response getClientList( int partyId, int buId, String clientValueSearch, boolean IsAutoPlan, int nodeId, int pageNo, int pageSize, String orderBy, String sord) { jdbcTemplate.setDataSource(dataSourceProvider.getDataSource(buId)); try { List<ClientData> list; BaseResponse<GridData> br = new BaseResponse<GridData>(); GridData gridData = new GridData(); list = jdbcTemplate.query( "{call usp_cp_getClientList(?,?,?,?,?,?,?,?)}", new Object[] { partyId, clientValueSearch, IsAutoPlan, nodeId, pageNo, pageSize, orderBy, sord }, new BeanPropertyRowMapper<ClientData>(ClientData.class)); gridData.setRows(list); CommonStoredProcedure myStoredProcedure = new CommonStoredProcedure(jdbcTemplate, "usp_cp_getClientListCount"); SqlParameter partyIdParam = new SqlParameter("partyId", Types.INTEGER); SqlParameter nodeIdParam = new SqlParameter("nodeId", Types.INTEGER); SqlParameter clientVlaueParam = new SqlParameter("clientValueSearch", Types.VARCHAR); SqlParameter IsAutoPlanParam = new SqlParameter("IsAutoPlan", Types.BOOLEAN); SqlOutParameter recordsCountParam = new SqlOutParameter("recordsCount", Types.INTEGER); SqlParameter[] paramArray = { partyIdParam, clientVlaueParam, IsAutoPlanParam, nodeIdParam, recordsCountParam }; myStoredProcedure.setParameters(paramArray); myStoredProcedure.compile(); Map<String, Object> paranValues = new HashMap<String, Object>(); paranValues.put("partyId", partyId); paranValues.put("clientValueSearch", clientValueSearch); paranValues.put("IsAutoPlan", IsAutoPlan); paranValues.put("nodeId", nodeId); logger.info("paranValues:--------------" + paranValues); logger.info("-----------Before Calling SP In APP(getClientList)-----------"); Map<String, Object> storedProcResult = myStoredProcedure.execute(paranValues); logger.info("-----------After Calling SP In APP(getClientList)-----------"); int recordCount = (int) storedProcResult.get("recordsCount"); gridData.setRecords(recordCount); gridData.setPage(pageNo); gridData.setTotal( recordCount % pageSize == 0 ? recordCount / pageSize : (recordCount / pageSize) + 1); br.setResponseObject(gridData); response = FiinfraResponseBuilder.getSuccessResponse(br, null); } catch (DataAccessException e) { response = FiinfraResponseBuilder.getErrorResponse(e.getMessage().toString()); } finally { return response; } }