// @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;
}
}
