List of usage examples for org.springframework.transaction.support DefaultTransactionDefinition DefaultTransactionDefinition
public DefaultTransactionDefinition()
From source file:com.krawler.spring.crm.leadModule.crmLeadCommonController.java
public ModelAndView acceptweblead(HttpServletRequest request, HttpServletResponse response) throws ServletException { String result = "Problem while handling your request."; //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try {/*w w w . j a va 2s . c om*/ String userid = request.getParameter("userid"); String leadid = request.getParameter("leadid"); boolean isAlreadyAssigned = crmLeadDAOObj.checkWebLeadAssignedOwner(leadid); String replaceStr = "<p id='unsubContent'><p>Lead has been successfully allocated to you and can be viewed in your lead list.</p>"; String headerContent = "<head><meta http-equiv='Content-Type' content='text/html; charset=utf-8'>" + "<title>New Web Lead</title>" + "<style type='text/css'>" + "body {font-family: 'trebuchet MS', tahoma, verdana, arial, helvetica, sans-serif;" + "background-color: #eee;margin: 0;} " + "#content {width: 100%;position:absolute;padding:20px;top:5%;}" + ".content {width: 600px;margin:auto;padding:20px;border:10px solid #ccc;background-color: white;}" + ".alert {font-size:20px;line-height:200%;font-family:Arial;font-weight:bold;}" + "p, label, .formText {line-height:150%;font-family:Arial;font-size: 14px;color: #333333;}" + "</style>" + "</head>"; if (isAlreadyAssigned) { replaceStr = "<p id='unsubContent'><p>Sorry, lead cannot be allocated as it has been already allocated to a different team member.</p>"; } else { String oldOwnerId = crmLeadDAOObj.confirmWebLeadOwner(leadid, userid); if (!StringUtil.isNullOrEmpty(oldOwnerId) && !oldOwnerId.equals(userid)) { User oldOwner = (User) kwlCommonTablesDAOObj.getClassObject("com.krawler.common.admin.User", oldOwnerId); User newOwner = (User) kwlCommonTablesDAOObj.getClassObject("com.krawler.common.admin.User", userid); CrmLead lead = (CrmLead) kwlCommonTablesDAOObj .getClassObject("com.krawler.crm.database.tables.CrmLead", leadid); String recipients = oldOwner.getEmailID(); String subject = oldOwner.getCompany().getCompanyName() + " CRM - Web lead has been allocated to " + StringUtil.getFullName(newOwner); String mailbodyContent = "Hi %s,<p>Following web lead has been allocated to %s</p><p>Lead Name: %s</p><p>Phone Number: %s</p>" + "<p>Email Address: %s</p><p>Please Note that lead will not be displayed in your list.</p>" + "<p></p><p>- Thanks,</p><p>Administrator</p>"; String mailbody = String.format(mailbodyContent, StringUtil.getFullName(oldOwner), StringUtil.getFullName(newOwner), (lead.getFirstname() + " " + lead.getLastname()).trim(), lead.getPhone(), lead.getEmail()); String htmlmsg = "<html><head><link rel='shortcut icon' href='../../images/deskera/deskera.png'/><title>New Web Lead</title></head><style type='text/css'>" + "a:link, a:visited, a:active {\n" + " color: #03C;" + "}\n" + "body {\n" + " font-family: Arial, Helvetica, sans-serif;" + " color: #000;" + " font-size: 13px;" + "}\n" + "</style><body>" + " <div>" + mailbody + " </div></body></html>"; String pmsg = htmlmsg; String fromAddress = newOwner.getCompany().getCreator().getEmailID(); SendMailHandler.postMail(new String[] { recipients }, subject, htmlmsg, pmsg, fromAddress, ""); } } String bodyContent = "<body>" + "<div id='content'><div id=unsubThankYouPage class='content'>" + "<div class='alert' id='unsubTitle'>New Web Lead</div>" + replaceStr + "</p></div></div>" + "</div>" + "</body>"; result = "<html><link rel='shortcut icon' href='../../images/deskera/deskera.png'/>" + headerContent + bodyContent + "</html>"; txnManager.commit(status); } catch (Exception e) { txnManager.rollback(status); logger.warn(e.getMessage(), e); e.printStackTrace(); } return new ModelAndView("chartView", "model", result); }
From source file:com.siblinks.ws.service.impl.VideoServiceImpl.java
/** * {@inheritDoc}//from w w w. j a v a2 s . c om */ @Override @RequestMapping(value = "/updateVideo", method = RequestMethod.POST) public @ResponseBody ResponseEntity<Response> updateVideo(@RequestBody final RequestData request) { SimpleResponse response = null; TransactionStatus statusDao = null; try { if (!AuthenticationFilter.isAuthed(context)) { response = new SimpleResponse(SibConstants.FAILURE, "Authentication required."); return new ResponseEntity<Response>(response, HttpStatus.FORBIDDEN); } TransactionDefinition def = new DefaultTransactionDefinition(); statusDao = transactionManager.getTransaction(def); boolean status = true; String message = ""; String description = request.getRequest_data().getDescription(); String strTitle = request.getRequest_data().getTitle(); if (description != null && description.length() > 1024) { response = new SimpleResponse(SibConstants.SUCCESS, request.getRequest_data_type(), request.getRequest_data_method(), "Description cannot longer than 1024 characters"); } else { List<Map<String, String>> allWordFilter = cachedDao.getAllWordFilter(); description = CommonUtil.filterWord(description, allWordFilter); strTitle = CommonUtil.filterWord(strTitle, allWordFilter); String vid = request.getRequest_data().getVid(); Object[] queryParams = new Object[] { strTitle, description, request.getRequest_data().getSubjectId(), vid }; status = dao.insertUpdateObject(SibConstants.SqlMapper.SQL_UPDATE_VIDEO, queryParams); if (status) { String plid = request.getRequest_data().getPlid(); if (plid != null && plid.length() > 0) { // remove old playlist queryParams = new Object[] { vid }; status = dao.insertUpdateObject(SibConstants.SqlMapperBROT43.SQL_DELETE_VIDEO_PLAYLIST, queryParams); // insert new playlist queryParams = new Object[] { plid, vid }; status = dao.insertUpdateObject(SibConstants.SqlMapperBROT126.SQL_ADD_VIDEOS_PLAYLIST, queryParams); } else { // remove playlist if exists queryParams = new Object[] { vid }; dao.insertUpdateObject(SibConstants.SqlMapperBROT43.SQL_DELETE_VIDEO_PLAYLIST, queryParams); } } if (status) { activiLogService.insertActivityLog(new ActivityLogData(SibConstants.TYPE_VIDEO, "U", "You updateded a video", request.getRequest_data().getAuthorID(), String.valueOf(vid))); transactionManager.commit(statusDao); Map<String, String> dataChange = new HashMap<String, String>(); dataChange.put("title", strTitle); dataChange.put("description", description); response = new SimpleResponse(SibConstants.SUCCESS, request.getRequest_data_type(), request.getRequest_data_method(), dataChange); } else { transactionManager.rollback(statusDao); response = new SimpleResponse(SibConstants.FAILURE, request.getRequest_data_type(), request.getRequest_data_method(), message); } } } catch (Exception e) { if (statusDao != null) { transactionManager.rollback(statusDao); } e.printStackTrace(); response = new SimpleResponse(SibConstants.FAILURE, request.getRequest_data_type(), request.getRequest_data_method(), e.getMessage()); } return new ResponseEntity<Response>(response, HttpStatus.OK); }
From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java
public ModelAndView editProspect(HttpServletRequest request, HttpServletResponse response) { Date joiningdate = null;// w w w . j a v a2 s. c o m DateFormat formatter; formatter = new SimpleDateFormat("MM/dd/yyyy"); KwlReturnObject result = null; JSONObject jobj1 = new JSONObject(); String appnames = ""; //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try { String[] ids = request.getParameterValues("ids"); String[] cnames = request.getParameterValues("cnames"); String[] positionids = request.getParameterValues("positionids"); String applicantStatus = request.getParameter("selected"); HashMap<String, Object> requestParams = new HashMap<String, Object>(); HashMap<String, Object> appParams = new HashMap<String, Object>(); for (int i = 0; i < ids.length; i++) { requestParams.clear(); requestParams.put("positionid", positionids[i]); requestParams.put("primary", true); result = hrmsRecJobDAOObj.getPositionmain(requestParams); Positionmain position = null; if (StringUtil.checkResultobjList(result)) { position = (Positionmain) result.getEntityList().get(0); } requestParams.clear(); requestParams.put("id", ids[i]); requestParams.put("primary", true); result = hrmsRecJobDAOObj.getPositionstatus(requestParams); appParams.put("id", ids[i]); Allapplications appl = null; if (StringUtil.checkResultobjList(result)) { appl = (Allapplications) result.getEntityList().get(0); } // Allapplications appl = (Allapplications) session.load(Allapplications.class, ids[i]); // Positionmain position = (Positionmain) session.load(Positionmain.class, positionids[i]); if (StringUtil.isNullOrEmpty(request.getParameter("callback")) == false) { appParams.put("callback", request.getParameter("callback")); // appl.setCallback((MasterData) session.load(MasterData.class, request.getParameter("callback"))); } if (StringUtil.isNullOrEmpty(applicantStatus)) { } else { // appl.setStatus(request.getParameter("status")); appParams.put("status", applicantStatus); if (applicantStatus.equalsIgnoreCase("Rejected")) { if (appl.getApplicationflag() == 1 && position.getPositionsfilled() > 0) { requestParams.clear(); requestParams.put("positionid", positionids[i]); requestParams.put("positionsfilled", position.getPositionsfilled() - 1); requestParams.put("delflag", 0); hrmsRecJobDAOObj.updatePositionmain(requestParams); // position.setPositionsfilled(position.getPositionsfilled()-1); // position.setDelflag(0); // session.update(position); } appParams.put("applicationflag", 2); appParams.put("rejectedbefore", 1); // appl.setApplicationflag(2); // appl.setRejectedbefore(1); } else if (applicantStatus.equalsIgnoreCase("Selected")) { joiningdate = (Date) formatter.parse(request.getParameter("joiningdate")); if (appl.getApplydate() != null && joiningdate != null && appl.getApplydate().compareTo(joiningdate) < 0) { // appl.setApplicationflag(1); appParams.put("applicationflag", 1); if (Boolean.parseBoolean(request.getParameter("changeselected"))) { requestParams.clear(); requestParams.put("positionid", positionids[i]); if (position.getNoofpos() >= position.getPositionsfilled() + 1) { if (position.getNoofpos() == position.getPositionsfilled() + 1) { requestParams.put("delflag", 3); // position.setDelflag(3); } // position.setPositionsfilled(position.getPositionsfilled() + 1); requestParams.put("positionsfilled", position.getPositionsfilled() + 1); } // session.update(position); hrmsRecJobDAOObj.updatePositionmain(requestParams); } if (!StringUtil.isNullOrEmpty(request.getParameter("joiningdate"))) { joiningdate = (Date) formatter.parse(request.getParameter("joiningdate")); // appl.setJoiningdate(joiningdate); appParams.put("joiningdate", joiningdate); } } } else { if (appl.getApplicationflag() == 1 && position.getPositionsfilled() >= 0) { requestParams.clear(); // position.setPositionsfilled(position.getPositionsfilled()-1); // position.setDelflag(0); // session.update(position); requestParams.put("positionid", positionids[i]); requestParams.put("positionsfilled", position.getPositionsfilled() - 1); requestParams.put("delflag", 0); hrmsRecJobDAOObj.updatePositionmain(requestParams); } // appl.setApplicationflag(0); appParams.put("applicationflag", 0); } } if (StringUtil.isNullOrEmpty(request.getParameter("rank")) == false) { // appl.setRank((MasterData) session.load(MasterData.class, request.getParameter("rank"))); appParams.put("rank", request.getParameter("rank")); } if (!StringUtil.isNullOrEmpty(request.getParameter("statuscomment"))) { // appl.setStatuscomment(request.getParameter("statuscomment")); appParams.put("statuscomment", request.getParameter("statuscomment")); } String usrnm; if (appl.getEmployee() != null) { usrnm = StringUtil.getFullName(appl.getEmployee()); } else { usrnm = appl.getConfigjobapplicant().getCol1() + " " + appl.getConfigjobapplicant().getCol2(); } // session.update(appl); if (request.getParameter("selected").equals("Selected")) { if (appl.getApplydate() != null && joiningdate != null && appl.getApplydate().compareTo(joiningdate) < 0) { hrmsRecJobDAOObj.addAllapplications(appParams); } else { appnames += (cnames[i] + " ,"); } } else { hrmsRecJobDAOObj.addAllapplications(appParams); } //@@ProfileHandler.insertAuditLog(session, AuditAction.PROSPECT_EDITED, "User " + AuthHandler.getFullName(session, AuthHandler.getUserid(request)) + " has edited prospect of " + usrnm,request); } txnManager.commit(status); if (!appnames.equals("")) { appnames = appnames.substring(0, appnames.length() - 1); } jobj1.put("msg", appnames); jobj1.put("success", true); jobj1.put("valid", true); } catch (Exception ex) { ex.printStackTrace(); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView importTargetList(HttpServletRequest request, HttpServletResponse response) throws ServletException { JSONObject jobj = new JSONObject(); //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try {//from w ww .ja v a 2 s .c om HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("importtl", request.getParameter("importtl")); requestParams.put("listid", request.getParameter("listid")); requestParams.put("userid", sessionHandlerImpl.getUserid(request)); KwlReturnObject kmsg = crmEmailMarketingDAOObj.importTargetList(requestParams); TargetList tl = (TargetList) kmsg.getEntityList().get(0); jobj.put("success", true); jobj.put("TLID", tl.getId()); txnManager.commit(status); } catch (ServiceException e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); } catch (Exception e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); } return new ModelAndView("jsonView", "model", jobj.toString()); }
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView deleteTargets(HttpServletRequest request, HttpServletResponse response) throws ServletException { String retMsg = ""; //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try {/* w w w. j av a 2 s . c om*/ HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("relatedid", request.getParameter("relatedid")); requestParams.put("listid", request.getParameter("listid")); if (!StringUtil.isNullOrEmpty(request.getParameter("targetid"))) { requestParams.put("targetid", request.getParameter("targetid")); } KwlReturnObject kmsg = crmEmailMarketingDAOObj.deleteTargets(requestParams); retMsg = kmsg.getEntityList().get(0).toString(); txnManager.commit(status); } catch (ServiceException e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); } catch (Exception e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); } return new ModelAndView("jsonView", "model", retMsg); }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView saveempprofile(HttpServletRequest request, HttpServletResponse reponse) { JSONObject msg = new JSONObject(); KwlReturnObject result;/*ww w. ja v a 2s. co m*/ //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try { SimpleDateFormat fmt1 = new SimpleDateFormat("yyyy-MM-dd"); String currentuser = sessionHandlerImplObj.getUserid(request); String userid = request.getParameter("userid"); String jsondata = request.getParameter("jsondatawk"); String jsondata1 = request.getParameter("jsondatacad"); msg.put("msg", "Error in updating profile."); msg.put("success", false); HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("userid", userid); if (!StringUtil.isNullOrEmpty(request.getParameter("formname")) && request.getParameter("formname").equals("Personal")) { requestParams.put("middlename", request.getParameter("mname")); requestParams.put("bankbranch", request.getParameter("bankbranch")); requestParams.put("bankname", request.getParameter("bankname")); requestParams.put("bloodgrp", request.getParameter("bloodgrp")); if (!StringUtil.isNullOrEmpty(request.getParameter("childDoB1"))) { requestParams.put("child1dob", request.getParameter("childDoB1")); } requestParams.put("child1name", request.getParameter("child1name")); if (!StringUtil.isNullOrEmpty(request.getParameter("childDoB2"))) { requestParams.put("child2dob", request.getParameter("childDoB2")); } requestParams.put("child2name", request.getParameter("child2name")); if (!StringUtil.isNullOrEmpty(request.getParameter("DoB"))) { requestParams.put("dob", request.getParameter("DoB")); } requestParams.put("drvlicense", request.getParameter("drvlicense")); if (!StringUtil.isNullOrEmpty(request.getParameter("exppassport"))) { requestParams.put("exppassport", request.getParameter("exppassport")); } if (!StringUtil.isNullOrEmpty(request.getParameter("fatherDoB"))) { requestParams.put("fatherdob", request.getParameter("fatherDoB")); } requestParams.put("fathername", request.getParameter("fathername")); requestParams.put("gender", request.getParameter("gender")); requestParams.put("marriage", request.getParameter("marital")); if (!StringUtil.isNullOrEmpty(request.getParameter("motherDoB"))) { requestParams.put("motherdob", request.getParameter("motherDoB")); } requestParams.put("mothername", request.getParameter("mothername")); requestParams.put("panno", request.getParameter("panno")); requestParams.put("passportno", request.getParameter("passportno")); requestParams.put("pfno", request.getParameter("pfno")); if (!StringUtil.isNullOrEmpty(request.getParameter("spouseDoB"))) { requestParams.put("spousedob", request.getParameter("spouseDoB")); } requestParams.put("spousename", request.getParameter("spousename")); requestParams.put("keyskills", request.getParameter("keyskills")); requestParams.put("updated_by", currentuser); requestParams.put("updated_on", fmt1.format(new Date())); if (StringUtil.equal(userid, currentuser)) { requestParams.put("status", "Pending"); } else { requestParams.put("status", "Approved"); } result = hrmsCommonDAOObj.addEmpprofile(requestParams); if (result.isSuccessFlag()) { requestParams.clear(); requestParams.put("UserID", userid); requestParams.put("FirstName", request.getParameter("fname")); requestParams.put("LastName", request.getParameter("lname")); result = hrmsCommonDAOObj.adduser(requestParams); if (result.isSuccessFlag()) { requestParams.clear(); requestParams.put("UserID", userid); requestParams.put("Salary", request.getParameter("salarypermonth")); requestParams.put("Accno", request.getParameter("bankacc")); result = hrmsCommonDAOObj.addUseraccount(requestParams); requestParams.put("Useraccount", (Object) result.getEntityList().get(0)); if (result.getRecordTotalCount() > 0) hrmsCommonDAOObj.insertConfigData(request, "Personal", userid, sessionHandlerImplObj.getCompanyid(request), requestParams); else hrmsCommonDAOObj.insertConfigData(request, "Personal", userid, sessionHandlerImplObj.getCompanyid(request)); auditTrailDAOObj.insertAuditLog(AuditAction.PROFILE_EDITED, "User " + profileHandlerDAOObj .getUserFullName(sessionHandlerImplObj.getUserid(request)) + " has edited " + profileHandlerDAOObj.getUserFullName(userid) + "'s profile", request, "0"); msg.put("msg", "Profile updated successfully."); msg.put("success", true); } } } else if (!StringUtil.isNullOrEmpty(request.getParameter("formname")) && request.getParameter("formname").equals("Contact")) { requestParams.put("emgaddr", request.getParameter("emgaddr")); requestParams.put("emghome", request.getParameter("emghome")); requestParams.put("emgmob", request.getParameter("emgmob")); requestParams.put("emgname", request.getParameter("emgname")); requestParams.put("emgreln", request.getParameter("emgreln")); requestParams.put("emgwork", request.getParameter("emgwork")); requestParams.put("landno", request.getParameter("landno")); requestParams.put("mailaddr", request.getParameter("mailaddr")); requestParams.put("mobno", request.getParameter("mobno")); requestParams.put("permaddr", request.getParameter("permaddr")); requestParams.put("permcity", request.getParameter("permcity")); if (!StringUtil.isNullOrEmpty(request.getParameter("permcountry"))) { requestParams.put("permcountry", request.getParameter("permcountry")); } requestParams.put("permstate", request.getParameter("permstate")); requestParams.put("presentaddr", request.getParameter("presentaddr")); requestParams.put("presentcity", request.getParameter("presentcity")); if (!StringUtil.isNullOrEmpty(request.getParameter("presentcountry"))) { requestParams.put("presentcountry", request.getParameter("presentcountry")); } requestParams.put("presentstate", request.getParameter("presentstate")); requestParams.put("workno", request.getParameter("workno")); requestParams.put("workmail", request.getParameter("workmail")); requestParams.put("othermail", request.getParameter("othermail")); requestParams.put("weekoff", request.getParameter("weekoff")); requestParams.put("wkstarttime", request.getParameter("starttime")); requestParams.put("wkendtime", request.getParameter("endtime")); result = hrmsCommonDAOObj.addEmpprofile(requestParams); if (result.isSuccessFlag()) { requestParams.put("filter_names", Arrays.asList("userID")); requestParams.put("filter_values", Arrays.asList(userid)); result = hrmsCommonDAOObj.getUseraccount(requestParams); requestParams.put("Useraccount", (Object) result.getEntityList().get(0)); if (result.getRecordTotalCount() > 0) hrmsCommonDAOObj.insertConfigData(request, "Contact", userid, sessionHandlerImplObj.getCompanyid(request), requestParams); msg.put("msg", "Profile updated successfully."); msg.put("success", true); } } else if (!StringUtil.isNullOrEmpty(request.getParameter("formname")) && request.getParameter("formname").equals("Organizational")) { if (!StringUtil.isNullOrEmpty(request.getParameter("reportto"))) { requestParams.put("reportto", request.getParameter("reportto")); } requestParams.put("emptype", request.getParameter("emptype")); requestParams.put("commid", request.getParameter("commid")); requestParams.put("branchcode", request.getParameter("branchcode")); requestParams.put("branchaddr", request.getParameter("branchaddr")); requestParams.put("branchcity", request.getParameter("branchcity")); if (!StringUtil.isNullOrEmpty(request.getParameter("relievedate"))) { requestParams.put("relievedate", request.getParameter("relievedate")); } if (!StringUtil.isNullOrEmpty(request.getParameter("branchcountry"))) { requestParams.put("branchcountry", request.getParameter("branchcountry")); } if (!StringUtil.isNullOrEmpty(request.getParameter("probationmon")) && !StringUtil.isNullOrEmpty(request.getParameter("probationyr"))) { requestParams.put("probperiod", request.getParameter("probationmon") + "," + request.getParameter("probationyr")); } if (!StringUtil.isNullOrEmpty(request.getParameter("trainingmon")) && !StringUtil.isNullOrEmpty(request.getParameter("trainingyr"))) { requestParams.put("trainperiod", request.getParameter("trainingmon") + "," + request.getParameter("trainingyr")); } if (!StringUtil.isNullOrEmpty(request.getParameter("noticemon")) && !StringUtil.isNullOrEmpty(request.getParameter("noticeyr"))) { requestParams.put("noticeperiod", request.getParameter("noticemon") + "," + request.getParameter("noticeyr")); } if (!StringUtil.isNullOrEmpty(request.getParameter("confirmdate"))) { requestParams.put("confirmdate", request.getParameter("confirmdate")); } if (!StringUtil.isNullOrEmpty(request.getParameter("joindate"))) { requestParams.put("joindate", request.getParameter("joindate")); } result = hrmsCommonDAOObj.addEmpprofile(requestParams); Useraccount ua = (Useraccount) kwlCommonTablesDAOObj .getObject("com.krawler.common.admin.Useraccount", userid); int histsave = 0; Date saveDate = new Date(); SimpleDateFormat fmt = new SimpleDateFormat("yyyy/MM/dd"); saveDate = new Date(fmt.format(saveDate)); Emphistory ehst = new Emphistory(); String updatedby = sessionHandlerImplObj.getUserid(request); String histdept = ""; String histdesig = ""; requestParams.clear(); requestParams.put("UserID", userid); if (!StringUtil.isNullOrEmpty(request.getParameter("designationid"))) { if ((MasterData) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.master.MasterData", (String) request.getParameter("designationid")) != ua.getDesignationid() && ua.getDesignationid() != null) { histdesig = ua.getDesignationid().getId(); histsave = 1; } requestParams.put("Designationid", request.getParameter("designationid")); } if (!StringUtil.isNullOrEmpty(request.getParameter("department"))) { if ((MasterData) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.master.MasterData", (String) request.getParameter("department")) != ua.getDepartment() && ua.getDepartment() != null) { histdept = ua.getDepartment().getId(); if (histsave == 0) { histdesig = ua.getDesignationid().getId(); } histsave = 2; } requestParams.put("Department", request.getParameter("department")); } if (!StringUtil.isNullOrEmpty(request.getParameter("costcenter"))) { requestParams.put("CostCenter", request.getParameter("costcenter")); } String employeeIdFormat = ""; if (!StringUtil.isNullOrEmpty(request.getParameter("empid"))) { String[] codeid = (request.getParameter("empid")).split("-"); Integer codeid2 = null; for (int x = 0; x < codeid.length; x++) { if (codeid[x].matches("[0-9]*") == true) { codeid2 = Integer.parseInt(codeid[x]); } else { employeeIdFormat += (codeid[x] + "-"); } } if (employeeIdFormat.length() > 0) { employeeIdFormat = employeeIdFormat.substring(0, employeeIdFormat.length() - 1); } if (StringUtil.isNullOrEmpty(employeeIdFormat)) employeeIdFormat = null; HashMap<String, Object> requestParams1 = new HashMap<String, Object>(); ArrayList filter_names = new ArrayList(), filter_values = new ArrayList(); requestParams1.put("employeeIdFormat", employeeIdFormat); requestParams1.put("userID", userid); requestParams1.put("employeeid", codeid2); requestParams1.put("request", request); boolean isStadardEmpFormatWithIdAvilable = isStadardEmpFormatWithIdAvilable(requestParams1); String standardEmpId = getStadardEmpFormat(requestParams1); if (standardEmpId != null && employeeIdFormat != null && standardEmpId.equals(employeeIdFormat)) { employeeIdFormat = null; } requestParams1.clear(); filter_names.add("employeeid"); filter_values.add(codeid2); if (employeeIdFormat == null) { filter_names.add("IS employeeIdFormat"); } else { filter_names.add("employeeIdFormat"); filter_values.add(employeeIdFormat); } filter_names.add("!userID"); filter_values.add(userid); filter_names.add("user.company.companyID"); filter_values.add(sessionHandlerImplObj.getCompanyid(request)); requestParams1.put("filter_names", filter_names); requestParams1.put("filter_values", filter_values); result = hrmsCommonDAOObj.getUseraccount(requestParams1); if (!result.getEntityList().isEmpty() || isStadardEmpFormatWithIdAvilable) { msg.put("msg", "Employee ID is already assigned to another employee."); msg.put("success", false); txnManager.commit(status); return new ModelAndView(successView, "model", msg.toString()); } else { requestParams.put("Employeeid", codeid2); requestParams.put("EmployeeIdFormat", employeeIdFormat); } if (histsave == 1) { histdept = ua.getDepartment().getId(); } requestParams1.clear(); if (histsave == 1 || histsave == 2) { requestParams1.put("Department", histdept); requestParams1.put("Designation", histdesig); requestParams1.put("Userid", userid); requestParams1.put("Empid", ua.getEmployeeid()); requestParams1.put("Updatedon", saveDate); requestParams1.put("Updatedby", updatedby); requestParams1.put("Category", Emphistory.Emp_Desg_change); result = hrmsCommonDAOObj.addEmphistory(requestParams1); } result = hrmsCommonDAOObj.addUseraccount(requestParams); requestParams.put("Useraccount", (Object) result.getEntityList().get(0)); } if (result.getRecordTotalCount() > 0 && requestParams.get("Useraccount") != null) hrmsCommonDAOObj.insertConfigData(request, "Organizational", userid, sessionHandlerImplObj.getCompanyid(request), requestParams); else hrmsCommonDAOObj.insertConfigData(request, "Organizational", userid, sessionHandlerImplObj.getCompanyid(request)); msg.put("msg", "Profile updated successfully."); msg.put("success", true); } else { if (jsondata.length() > 0) { JSONArray jarr = new JSONArray("[" + jsondata + "]"); for (int i = 0; i < jarr.length(); i++) { Empexperience empexp = new Empexperience(); JSONObject jobj = jarr.getJSONObject(i); requestParams.clear(); if (!StringUtil.isNullOrEmpty(jobj.getString("id"))) { empexp.setId(jobj.getString("id")); } empexp.setUserid((UserLogin) kwlCommonTablesDAOObj .getObject("com.krawler.common.admin.UserLogin", userid)); empexp.setType(jobj.getString("type")); empexp.setOrganization(jobj.getString("organisation")); empexp.setPosition(jobj.getString("position")); empexp.setBeginyear(jobj.getString("beginyear")); empexp.setEndyear(jobj.getString("endyear")); empexp.setComment(jobj.getString("comment")); hrmsCommonDAOObj.addEmpExperience(empexp); } } if (jsondata1.length() > 0) { JSONArray jarr1 = new JSONArray("[" + jsondata1 + "]"); for (int j = 0; j < jarr1.length(); j++) { Empexperience empexp = new Empexperience(); JSONObject jobj = jarr1.getJSONObject(j); requestParams.clear(); if (!StringUtil.isNullOrEmpty(jobj.getString("id"))) { empexp.setId(jobj.getString("id")); } empexp.setUserid((UserLogin) kwlCommonTablesDAOObj .getObject("com.krawler.common.admin.UserLogin", userid)); empexp.setType(jobj.getString("type")); empexp.setQualification(jobj.getString("qualification")); empexp.setInstitution(jobj.getString("institution")); empexp.setYearofgrad(jobj.getString("gradyear")); empexp.setMarks(jobj.getString("marks")); empexp.setFrmyear(jobj.getString("yeargrdfrm")); empexp.setQaulin(jobj.getString("qualificationin")); hrmsCommonDAOObj.addEmpExperience(empexp); } } JSONObject jobj1 = new JSONObject(); jobj1.put("msg", "Profile updated successfully."); jobj1.put("success", true); msg.put("valid", true); msg.put("data", jobj1.toString()); } txnManager.commit(status); } catch (Exception e) { e.printStackTrace(); txnManager.rollback(status); } return new ModelAndView(successView, "model", msg.toString()); }
From source file:com.krawler.spring.importFunctionality.ImportUtil.java
/** * @param filename//from w w w .j ava2 s.c o m * @param sheetNo * @param startindex * @param importDao * @return * @throws ServiceException */ public static void dumpXLSXFileData(String filename, int sheetNo, int startindex, ImportDAO importDao, HibernateTransactionManager txnManager) throws ServiceException { boolean commitedEx = false; DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("import_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); TransactionStatus status = txnManager.getTransaction(def); Session session = txnManager.getSessionFactory().getCurrentSession(); try { String destinationDirectory = storageHandlerImpl.GetDocStorePath() + "xlsfiles"; FileInputStream fs = new FileInputStream(destinationDirectory + "/" + filename); XSSFWorkbook wb = new XSSFWorkbook(fs); XSSFSheet sheet = wb.getSheetAt(sheetNo); //DateFormat sdf = new SimpleDateFormat(df_full); int maxRow = sheet.getLastRowNum(); int maxCol = 0; String tableName = importDao.getTableName(filename); int flushCounter = 0; for (int i = startindex; i <= maxRow; i++) { XSSFRow row = sheet.getRow(i); if (row == null) { continue; } if (i == startindex) { maxCol = row.getLastCellNum(); //Column Count } ArrayList<String> dataArray = new ArrayList<String>(); JSONObject dataObj = new JSONObject(); for (int j = 0; j < maxCol; j++) { XSSFCell cell = row.getCell(j); String val = null; if (cell == null) { dataArray.add(val); continue; } String colHeader = new CellReference(i, j).getCellRefParts()[2]; switch (cell.getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: if (DateUtil.isCellDateFormatted(cell)) { val = Long.toString(cell.getDateCellValue().getTime()); } else { val = dfmt.format(cell.getNumericCellValue()); } break; case XSSFCell.CELL_TYPE_STRING: val = ImportUtil.cleanHTML(cell.getRichStringCellValue().getString()); break; } dataObj.put(colHeader, val); dataArray.add(val); //Collect row data } //Insert Query if (dataObj.length() > 0) { // Empty row check (if lenght==0 then all columns are empty) importDao.dumpFileRow(tableName, dataArray.toArray()); if (flushCounter % 30 == 0) { session.flush(); session.clear(); } flushCounter++; } } try { txnManager.commit(status); } catch (Exception ex) { commitedEx = true; throw ex; } } catch (IOException ex) { throw ServiceException.FAILURE("dumpXLSXFileData: " + ex.getMessage(), ex); } catch (Exception ex) { if (!commitedEx) { //if exception occurs during commit then dont call rollback txnManager.rollback(status); } throw ServiceException.FAILURE("dumpXLSXFileData: " + ex.getMessage(), ex); } }
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView saveEmailTemplateFiles(HttpServletRequest request, HttpServletResponse response) throws ServletException { JSONObject result = new JSONObject(); DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try {/*w w w. j a v a 2s. c om*/ result.put("success", false); int file_type = 1; String fType = request.getParameter("type"); if (fType != null && fType.compareTo("img") == 0) { file_type = 0; } String companyid = sessionHandlerImpl.getCompanyid(request); String filename = ""; ServletFileUpload fu = new ServletFileUpload( new DiskFileItemFactory(DiskFileItemFactory.DEFAULT_SIZE_THRESHOLD, new File("/tmp"))); if (fu.isMultipartContent(request)) { List<FileItem> fileItems = fu.parseRequest(request); for (FileItem field : fileItems) { if (!field.isFormField()) { String fname = new String(field.getName().getBytes(), "UTF8"); String file_id = java.util.UUID.randomUUID().toString(); String file_extn = fname.substring(fname.lastIndexOf(".")); filename = file_id.concat(file_extn); boolean isUploaded = false; fname = fname.substring(fname.lastIndexOf("\\") + 1); if (field.getSize() != 0) { String basePath = StorageHandler.GetDocStorePath() + companyid + "/" + fType; File destDir = new File(basePath); if (!destDir.exists()) { destDir.mkdirs(); } File uploadFile = new File(basePath + "/" + filename); field.write(uploadFile); isUploaded = true; String id = request.getParameter("fileid"); if (StringUtil.isNullOrEmpty(id)) { id = file_id; } crmEmailMarketingDAOObj.saveEmailTemplateFile(id, fname, file_extn, new Date(), file_type, sessionHandlerImplObj.getUserid()); } } } } txnManager.commit(status); result.put("success", true); } catch (ServiceException e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); try { result.put("msg", e.getMessage()); } catch (Exception je) { } } catch (UnsupportedEncodingException ex) { logger.warn(ex.getMessage(), ex); txnManager.rollback(status); try { result.put("msg", ex.getMessage()); } catch (Exception je) { } } catch (Exception e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); try { result.put("msg", e.getMessage()); } catch (Exception je) { } } return new ModelAndView("jsonView", "model", result.toString()); }
From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java
public ModelAndView deleteJobapplicant(HttpServletRequest request, HttpServletResponse response) throws ServiceException, HibernateException, SessionExpiredException { JSONObject jobj = new JSONObject(); //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try {//from w ww . j av a2 s . co m String[] ids = request.getParameterValues("ids"); HashMap<String, Object> requestParams = new HashMap<String, Object>(); for (int i = 0; i < ids.length; i++) { requestParams.clear(); requestParams.put("id", ids[i]); hrmsRecJobDAOObj.deleteConfigJobapplicant(requestParams); } jobj.put("data", ""); jobj.put("valid", true); txnManager.commit(status); } catch (HibernateException e) { txnManager.rollback(status); throw ServiceException.FAILURE("hrmsHandler.deleteApplicants", e); } finally { return new ModelAndView("jsonView", "model", jobj.toString()); } }
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView checkBounceStatus(HttpServletRequest request, HttpServletResponse response) throws ServletException { JSONObject myjobj = new JSONObject(); KwlReturnObject kmsg = null;// ww w .j av a 2s . co m //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try { myjobj.put("success", false); kmsg = bounceHandlerImplObj.checkBounceStatus(); myjobj.put("success", kmsg.isSuccessFlag()); txnManager.commit(status); } catch (Exception e) { logger.warn(e.getMessage(), e); txnManager.rollback(status); } return new ModelAndView("jsonView", "model", myjobj.toString()); }