class 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();
		}
	}

}