@Test public void testCreateReissue() { int[] value = new int[] { 2, 6 }; when(jdbcTemplate.batchUpdate(any(String.class), any(List.class))).thenReturn(value); marriageCertRepository.createReissue(getReissueCertRequest()); }
public void createReissue(ReissueCertRequest reissueAppRequest) { ReissueCertAppl reissueApp=reissueAppRequest.getReissueApplication(); try { jdbcTemplate.update(Reissue_Cert_Insert_Query,new PreparedStatementSetter(){ @Override public void setValues(PreparedStatement ps) throws SQLException { ps.setString(1,reissueApp.getId()); ps.setString(2,reissueApp.getRegnNo()); ps.setString(3,reissueApp.getApplicantInfo().getName()); ps.setString(4,reissueApp.getApplicantInfo().getAddress()); ps.setString(5,reissueApp.getApplicantInfo().getMobileNo()); ps.setBigDecimal(6,reissueApp.getApplicantInfo().getFee()); ps.setString(7,reissueApp.getApplicantInfo().getAadhaar()); ps.setString(8,reissueApp.getApplicationNumber()); ps.setString(9,reissueApp.getReissueApplStatus().toString()); ps.setString(10,reissueApp.getStateId()); ps.setLong (11,reissueApp.getApprovalDetails().getDepartment()); ps.setLong (12,reissueApp.getApprovalDetails().getDesignation()); ps.setLong (13,reissueApp.getApprovalDetails().getAssignee()); ps.setString(14,reissueApp.getApprovalDetails().getAction()); ps.setString(15,reissueApp.getApprovalDetails().getStatus()); ps.setString(16,reissueApp.getApprovalDetails().getComments()); ps.setLong (17,reissueApp.getDemands().get(0)); ps.setString(18,reissueApp.getRejectionReason()); ps.setString(19,reissueApp.getRemarks()); ps.setBoolean(20,reissueApp.getIsActive()); ps.setString(21,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (22,new Date().getTime()); ps.setString(23,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (24,new Date().getTime()); ps.setString(25,reissueApp.getTenantId()); } }); } catch (DataAccessException e) { e.printStackTrace(); } }
MarriageCertRepository { public void createReissue(ReissueCertRequest reissueAppRequest) { ReissueCertAppl reissueApp=reissueAppRequest.getReissueApplication(); try { jdbcTemplate.update(Reissue_Cert_Insert_Query,new PreparedStatementSetter(){ @Override public void setValues(PreparedStatement ps) throws SQLException { ps.setString(1,reissueApp.getId()); ps.setString(2,reissueApp.getRegnNo()); ps.setString(3,reissueApp.getApplicantInfo().getName()); ps.setString(4,reissueApp.getApplicantInfo().getAddress()); ps.setString(5,reissueApp.getApplicantInfo().getMobileNo()); ps.setBigDecimal(6,reissueApp.getApplicantInfo().getFee()); ps.setString(7,reissueApp.getApplicantInfo().getAadhaar()); ps.setString(8,reissueApp.getApplicationNumber()); ps.setString(9,reissueApp.getReissueApplStatus().toString()); ps.setString(10,reissueApp.getStateId()); ps.setLong (11,reissueApp.getApprovalDetails().getDepartment()); ps.setLong (12,reissueApp.getApprovalDetails().getDesignation()); ps.setLong (13,reissueApp.getApprovalDetails().getAssignee()); ps.setString(14,reissueApp.getApprovalDetails().getAction()); ps.setString(15,reissueApp.getApprovalDetails().getStatus()); ps.setString(16,reissueApp.getApprovalDetails().getComments()); ps.setLong (17,reissueApp.getDemands().get(0)); ps.setString(18,reissueApp.getRejectionReason()); ps.setString(19,reissueApp.getRemarks()); ps.setBoolean(20,reissueApp.getIsActive()); ps.setString(21,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (22,new Date().getTime()); ps.setString(23,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (24,new Date().getTime()); ps.setString(25,reissueApp.getTenantId()); } }); } catch (DataAccessException e) { e.printStackTrace(); } } }
MarriageCertRepository { public void createReissue(ReissueCertRequest reissueAppRequest) { ReissueCertAppl reissueApp=reissueAppRequest.getReissueApplication(); try { jdbcTemplate.update(Reissue_Cert_Insert_Query,new PreparedStatementSetter(){ @Override public void setValues(PreparedStatement ps) throws SQLException { ps.setString(1,reissueApp.getId()); ps.setString(2,reissueApp.getRegnNo()); ps.setString(3,reissueApp.getApplicantInfo().getName()); ps.setString(4,reissueApp.getApplicantInfo().getAddress()); ps.setString(5,reissueApp.getApplicantInfo().getMobileNo()); ps.setBigDecimal(6,reissueApp.getApplicantInfo().getFee()); ps.setString(7,reissueApp.getApplicantInfo().getAadhaar()); ps.setString(8,reissueApp.getApplicationNumber()); ps.setString(9,reissueApp.getReissueApplStatus().toString()); ps.setString(10,reissueApp.getStateId()); ps.setLong (11,reissueApp.getApprovalDetails().getDepartment()); ps.setLong (12,reissueApp.getApprovalDetails().getDesignation()); ps.setLong (13,reissueApp.getApprovalDetails().getAssignee()); ps.setString(14,reissueApp.getApprovalDetails().getAction()); ps.setString(15,reissueApp.getApprovalDetails().getStatus()); ps.setString(16,reissueApp.getApprovalDetails().getComments()); ps.setLong (17,reissueApp.getDemands().get(0)); ps.setString(18,reissueApp.getRejectionReason()); ps.setString(19,reissueApp.getRemarks()); ps.setBoolean(20,reissueApp.getIsActive()); ps.setString(21,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (22,new Date().getTime()); ps.setString(23,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (24,new Date().getTime()); ps.setString(25,reissueApp.getTenantId()); } }); } catch (DataAccessException e) { e.printStackTrace(); } }  }
MarriageCertRepository { public void createReissue(ReissueCertRequest reissueAppRequest) { ReissueCertAppl reissueApp=reissueAppRequest.getReissueApplication(); try { jdbcTemplate.update(Reissue_Cert_Insert_Query,new PreparedStatementSetter(){ @Override public void setValues(PreparedStatement ps) throws SQLException { ps.setString(1,reissueApp.getId()); ps.setString(2,reissueApp.getRegnNo()); ps.setString(3,reissueApp.getApplicantInfo().getName()); ps.setString(4,reissueApp.getApplicantInfo().getAddress()); ps.setString(5,reissueApp.getApplicantInfo().getMobileNo()); ps.setBigDecimal(6,reissueApp.getApplicantInfo().getFee()); ps.setString(7,reissueApp.getApplicantInfo().getAadhaar()); ps.setString(8,reissueApp.getApplicationNumber()); ps.setString(9,reissueApp.getReissueApplStatus().toString()); ps.setString(10,reissueApp.getStateId()); ps.setLong (11,reissueApp.getApprovalDetails().getDepartment()); ps.setLong (12,reissueApp.getApprovalDetails().getDesignation()); ps.setLong (13,reissueApp.getApprovalDetails().getAssignee()); ps.setString(14,reissueApp.getApprovalDetails().getAction()); ps.setString(15,reissueApp.getApprovalDetails().getStatus()); ps.setString(16,reissueApp.getApprovalDetails().getComments()); ps.setLong (17,reissueApp.getDemands().get(0)); ps.setString(18,reissueApp.getRejectionReason()); ps.setString(19,reissueApp.getRemarks()); ps.setBoolean(20,reissueApp.getIsActive()); ps.setString(21,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (22,new Date().getTime()); ps.setString(23,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (24,new Date().getTime()); ps.setString(25,reissueApp.getTenantId()); } }); } catch (DataAccessException e) { e.printStackTrace(); } }  void insert(MarriageRegn marriageRegn); List<ReissueCertAppl> findForCriteria(MarriageCertCriteria marriageCertCriteria); void createDoc(ReissueCertRequest reissueAppRequest); void updateDoc(ReissueCertRequest reissueAppRequest); void createReissue(ReissueCertRequest reissueAppRequest); void updateReissue(ReissueCertRequest reissueAppRequest); void createCert(ReissueCertAppl reissueApp); }
MarriageCertRepository { public void createReissue(ReissueCertRequest reissueAppRequest) { ReissueCertAppl reissueApp=reissueAppRequest.getReissueApplication(); try { jdbcTemplate.update(Reissue_Cert_Insert_Query,new PreparedStatementSetter(){ @Override public void setValues(PreparedStatement ps) throws SQLException { ps.setString(1,reissueApp.getId()); ps.setString(2,reissueApp.getRegnNo()); ps.setString(3,reissueApp.getApplicantInfo().getName()); ps.setString(4,reissueApp.getApplicantInfo().getAddress()); ps.setString(5,reissueApp.getApplicantInfo().getMobileNo()); ps.setBigDecimal(6,reissueApp.getApplicantInfo().getFee()); ps.setString(7,reissueApp.getApplicantInfo().getAadhaar()); ps.setString(8,reissueApp.getApplicationNumber()); ps.setString(9,reissueApp.getReissueApplStatus().toString()); ps.setString(10,reissueApp.getStateId()); ps.setLong (11,reissueApp.getApprovalDetails().getDepartment()); ps.setLong (12,reissueApp.getApprovalDetails().getDesignation()); ps.setLong (13,reissueApp.getApprovalDetails().getAssignee()); ps.setString(14,reissueApp.getApprovalDetails().getAction()); ps.setString(15,reissueApp.getApprovalDetails().getStatus()); ps.setString(16,reissueApp.getApprovalDetails().getComments()); ps.setLong (17,reissueApp.getDemands().get(0)); ps.setString(18,reissueApp.getRejectionReason()); ps.setString(19,reissueApp.getRemarks()); ps.setBoolean(20,reissueApp.getIsActive()); ps.setString(21,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (22,new Date().getTime()); ps.setString(23,reissueAppRequest.getRequestInfo().getDid()); ps.setLong (24,new Date().getTime()); ps.setString(25,reissueApp.getTenantId()); } }); } catch (DataAccessException e) { e.printStackTrace(); } }  void insert(MarriageRegn marriageRegn); List<ReissueCertAppl> findForCriteria(MarriageCertCriteria marriageCertCriteria); void createDoc(ReissueCertRequest reissueAppRequest); void updateDoc(ReissueCertRequest reissueAppRequest); void createReissue(ReissueCertRequest reissueAppRequest); void updateReissue(ReissueCertRequest reissueAppRequest); void createCert(ReissueCertAppl reissueApp); static final String CERTIFICATE_INSERT_QUERY; final String GET_APPLICATION_NO_QUERY; final String create_Certificate_Query; }