List of usage examples for org.springframework.transaction.support DefaultTransactionDefinition setIsolationLevel
public final void setIsolationLevel(int isolationLevel)
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView deleteemailMarketing(HttpServletRequest request, HttpServletResponse response) throws ServletException { JSONObject myjobj = null;//from w ww . j a v a 2 s. co m KwlReturnObject kmsg = null; KwlReturnObject kmsg1 = null; //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 = new JSONObject(); JSONArray deletejarr = new JSONArray(); JSONArray failDeletejarr = new JSONArray(); myjobj.put(Constants.success, false); if (StringUtil.bNull(request.getParameter(Constants.jsondata))) { String jsondata = request.getParameter(Constants.jsondata); JSONArray jarr = new JSONArray("[" + jsondata + "]"); for (int i = 0; i < jarr.length(); i++) { JSONObject jobj = new JSONObject(); String templateid = jarr.getJSONObject(i).getString(Constants.templateid); List<EmailMarketing> ll = crmEmailMarketingHandler .getCampEmailMarketList(crmEmailMarketingDAOObj, templateid); JSONObject jobjmsg = new JSONObject(); if (ll.isEmpty()) { if (StringUtil.equal(templateid, Constants.DEFAULT_BASIC_TEMPLATEID) || StringUtil.equal(templateid, Constants.DEFAULT_LEFTCOLUMN_TEMPLATEID) || StringUtil.equal(templateid, Constants.DEFAULT_POSTCARD_TEMPLATEID) || StringUtil.equal(templateid, Constants.DEFAULT_RICHTEXT_TEMPLATEID) || StringUtil.equal(templateid, Constants.DEFAULT_RIGHTCOLUMN_TEMPLATEID)) { HashMap requestParams = new HashMap(); ArrayList filter_names = new ArrayList(); ArrayList filter_params = new ArrayList(); filter_names.add("c.templateid"); filter_params.add(templateid); requestParams.put("filter_names", filter_names); requestParams.put("filter_params", filter_params); kmsg1 = crmEmailMarketingDAOObj.getDefaultEmailTemplate(requestParams); DefaultTemplates obj = (DefaultTemplates) kmsg1.getEntityList().get(0); jobjmsg.put(Constants.name, obj.getName()); jobjmsg.put(Constants.moduleName, "Default Template"); failDeletejarr.put(jobjmsg); } else { jobj.put(Constants.modifiedon, new Date().getTime()); jobj.put(Constants.tid, templateid); jobj.put(Constants.deleted, 1); kmsg = crmEmailMarketingDAOObj.editEmailTemplate(jobj); if (kmsg.isSuccessFlag()) { EmailTemplate obj = (EmailTemplate) kmsg.getEntityList().get(0); jobjmsg.put(Constants.name, obj.getName()); jobjmsg.put(Constants.moduleName, Constants.MODULE_EmailTemplate); deletejarr.put(jobjmsg); } } } else { EmailTemplate obj = ll.get(0).getTemplateid(); String emarkt = ""; for (EmailMarketing em : ll) { emarkt += em.getName() + ", "; } emarkt = emarkt.substring(0, emarkt.length() - 2); jobjmsg.put(Constants.name, obj.getName()); jobjmsg.put(Constants.moduleName, emarkt); failDeletejarr.put(jobjmsg); } } myjobj.put(Constants.success, true); if (failDeletejarr.length() > 0) { myjobj.put(Constants.successDeleteArr, deletejarr); myjobj.put(Constants.failDelete, failDeletejarr); } } txnManager.commit(status); } catch (JSONException 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", myjobj.toString()); }
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView saveCampEmailMarketConfig(HttpServletRequest request, HttpServletResponse response) throws ServletException { String retMsg = "{success:false}"; //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 2s.c o m*/ String emailMarketingID = null; HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("userid", sessionHandlerImpl.getUserid(request)); requestParams.put("templateid", request.getParameter("templateid")); KwlReturnObject copyMsg = crmEmailMarketingDAOObj.copyDefaultTemplates(requestParams); String templateid = request.getParameter("templateid"); if (copyMsg.isSuccessFlag()) { List template = copyMsg.getEntityList(); templateid = template.get(0).toString(); } requestParams = new HashMap<String, Object>(); requestParams.put("mode", request.getParameter("mode")); requestParams.put("emailmarkid", request.getParameter("emailmarkid")); requestParams.put("userid", sessionHandlerImpl.getUserid(request)); requestParams.put("name", request.getParameter("name")); requestParams.put("fromname", request.getParameter("fromname")); requestParams.put("fromaddress", request.getParameter("fromaddress")); requestParams.put("replyaddress", request.getParameter("replyaddress")); requestParams.put("inboundemail", request.getParameter("inboundemail")); requestParams.put("htmlcont", request.getParameter("htmlcont")); requestParams.put("plaincont", request.getParameter("plaincont")); requestParams.put("unsub", request.getParameter("unsub")); requestParams.put("marketingsubject", request.getParameter("marketingsubject")); requestParams.put("fwdfriend", request.getParameter("fwdfriend")); requestParams.put("archive", request.getParameter("archive")); requestParams.put("updatelink", request.getParameter("updatelink")); requestParams.put("templateid", templateid); requestParams.put("campid", request.getParameter("campid")); requestParams.put("captureLead", Boolean.parseBoolean(request.getParameter("captureLead"))); requestParams.put("colortheme", request.getParameter("colortheme")); requestParams.put("targetlist", request.getParameter("targetlist")); requestParams.put("csaccept", Boolean.parseBoolean(request.getParameter("csaccept"))); KwlReturnObject kmsg = crmEmailMarketingDAOObj.saveCampEmailMarketConfig(requestParams); Iterator ite = kmsg.getEntityList().iterator(); while (ite.hasNext()) { EmailMarketing emobj = (EmailMarketing) ite.next(); HashMap<String, Object> requestParams1 = new HashMap<String, Object>(); emailMarketingID = emobj.getId(); requestParams1.put("emailmarkid", emailMarketingID); KwlReturnObject kmsg1 = crmEmailMarketingDAOObj.deleteEmailmarketingTargetList(requestParams1); requestParams1.put("targetlist", request.getParameter("targetlist")); KwlReturnObject kmsg2 = crmEmailMarketingDAOObj.mapEmailmarketingTargetList(requestParams1); retMsg = kmsg2.getEntityList().get(0).toString(); } HashMap<String, Object> requestParams2 = new HashMap<String, Object>(); requestParams2.put("campaignid", request.getParameter("campid")); crmEmailMarketingDAOObj.deleteCampaignTarget(requestParams2); requestParams2.put("targetlist", request.getParameter("targetlist")); requestParams2.put("userid", sessionHandlerImpl.getUserid(request)); KwlReturnObject kmsg4 = crmEmailMarketingDAOObj.saveCampaignTargetList(requestParams2); // To Get Default Values of Email Marketing Template if (emailMarketingID != null) { JSONArray jArr = new JSONArray(request.getParameter("defaulttemplatestore")); crmEmailMarketingDAOObj.removeEmailMarketingDefaults(emailMarketingID); EmailMarketing em = crmEmailMarketingDAOObj.getEmailMarketing(emailMarketingID); EmailMarketingDefault emDefault; for (int i = 0; i < jArr.length(); i++) { JSONObject obj = jArr.getJSONObject(i); emDefault = new EmailMarketingDefault(); emDefault.setEmailMarketing(em); emDefault.setVariableName(obj.getString("varname")); emDefault.setDefaultValue(obj.getString("varval")); crmEmailMarketingDAOObj.saveEmailMarketingDefault(emDefault); } } 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 deleteSavedSearch(HttpServletRequest request, HttpServletResponse response) { JSONObject jobj = new JSONObject(); JSONObject jobj1 = 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 w w .j a v a2s . c o m String searchid = request.getParameter("searchid"); boolean success = false; if (!StringUtil.isNullOrEmpty(searchid)) { success = hrmsCommonDAOObj.deleteSavedSearch(searchid); } jobj.put("success", success); jobj1.put("valid", true); jobj1.put("data", jobj.toString()); txnManager.commit(status); } catch (Exception ex) { ex.printStackTrace(); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView approveprofile(HttpServletRequest request, HttpServletResponse response) { HashMap<String, Object> requestParams = new HashMap<String, Object>(); KwlReturnObject result = null;//w w w. j a v a2 s . c om JSONObject jobj = new JSONObject(); JSONObject jobj1 = 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 { String[] ids = request.getParameterValues("emp_ids"); for (int i = 0; i < ids.length; i++) { requestParams.put("userid", ids[i]); requestParams.put("status", "Approved"); requestParams.put("updated_by", sessionHandlerImplObj.getUserid(request)); requestParams.put("updated_on", new Date()); result = hrmsCommonDAOObj.addEmpprofile(requestParams); jobj.put("success", "true"); jobj1.put("valid", true); jobj1.put("data", jobj.toString()); } txnManager.commit(status); } catch (Exception ex) { ex.printStackTrace(); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView saveSearch(HttpServletRequest request, HttpServletResponse response) { HashMap<String, Object> requestParams = new HashMap<String, Object>(); KwlReturnObject result = null;//from w w w. j a va2 s . co m JSONObject jobj = new JSONObject(); JSONObject jobj1 = 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 { String saveJson = request.getParameter("saveJson"); String searchName = request.getParameter("saveSearchName"); String userid = sessionHandlerImplObj.getUserid(request); int searchFlag = Integer.parseInt(request.getParameter("searchFlag")); String msg = ""; boolean isDuplicate = false; if (!StringUtil.isNullOrEmpty(searchName) && !StringUtil.isNullOrEmpty(saveJson)) { boolean checkforExistingSearchName = hrmsCommonDAOObj.checkForSearchName(searchName, userid); if (!checkforExistingSearchName) { result = hrmsCommonDAOObj.saveSearch(searchName, searchFlag, saveJson, userid); msg = result.getMsg(); } else { isDuplicate = true; } } jobj.put("msg", msg); jobj.put("isduplicate", isDuplicate); jobj.put("success", "true"); jobj1.put("valid", true); jobj1.put("data", jobj.toString()); txnManager.commit(status); } catch (Exception ex) { ex.printStackTrace(); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView assignManager(HttpServletRequest request, HttpServletResponse response) { KwlReturnObject result = null;/*from w w w . j a v a 2 s . co m*/ List tabledata = null; String[] userids = request.getParameterValues("userid"); String[] reviewerids = request.getParameterValues("reviewerid"); String[] managerids = request.getParameterValues("managerid"); String[] availmanagerid = request.getParameterValues("availmanagerid"); 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 { HashMap<String, Object> requestParams = new HashMap<String, Object>(); if (Boolean.parseBoolean(request.getParameter("isManager"))) { for (int i = 0; i < userids.length; i++) { requestParams.put("filter_names", Arrays.asList("assignemp.userID", "managerstatus")); requestParams.put("filter_values", Arrays.asList(userids[i], 1)); result = hrmsCommonDAOObj.getAssignmanager(requestParams); tabledata = result.getEntityList(); Iterator ite = tabledata.iterator(); while (ite.hasNext()) { Assignmanager log = (Assignmanager) ite.next(); requestParams.clear(); requestParams.put("Id", log.getId()); requestParams.put("Managerstatus", 0); hrmsCommonDAOObj.addAssignmanager(requestParams); } } for (int i = 0; i < userids.length; i++) { for (int j = 0; j < managerids.length; j++) { requestParams.clear(); requestParams.put("Assignemp", userids[i]); requestParams.put("Assignman", managerids[j]); requestParams.put("Managerstatus", 1); hrmsCommonDAOObj.addAssignmanager(requestParams); } } } else if (Boolean.parseBoolean(request.getParameter("salaryManagerF"))) { hrmsCommonDAOObj.addAssignSalaryManager(managerids, availmanagerid); } else { for (int i = 0; i < userids.length; i++) { requestParams.clear(); requestParams.put("filter_names", Arrays.asList("employee.userID", "reviewerstatus")); requestParams.put("filter_values", Arrays.asList(userids[i], 1)); result = hrmsCommonDAOObj.getAssignreviewer(requestParams); tabledata = result.getEntityList(); Iterator ite = tabledata.iterator(); while (ite.hasNext()) { Assignreviewer log = (Assignreviewer) ite.next(); requestParams.clear(); requestParams.put("Id", log.getId()); requestParams.put("Reviewerstatus", 0); hrmsCommonDAOObj.addAssignreviewer(requestParams); } } for (int i = 0; i < userids.length; i++) { for (int j = 0; j < managerids.length; j++) { requestParams.clear(); requestParams.put("Employee", userids[i]); requestParams.put("Reviewer", managerids[j]); requestParams.put("Reviewerstatus", 1); hrmsCommonDAOObj.addAssignreviewer(requestParams); } } } jobj.put("valid", true); jobj.put("data", ""); txnManager.commit(status); } catch (Exception ex) { ex.printStackTrace(); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj.toString()); } }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView rehireEmp(HttpServletRequest request, HttpServletResponse response) { SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd"); SimpleDateFormat sdf = new SimpleDateFormat("dd-mm-yyyy"); JSONObject msg = 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 www . j av a 2s . c o m Empprofile e = null; String ids[] = request.getParameterValues("ids"); String deptid = request.getParameter("dept"); String desgid = request.getParameter("desg"); String salary = (request.getParameter("salary")); String reldate = request.getParameter("joindate"); String tempid = request.getParameter("templateid"); Date rvdate = fmt.parse(reldate); Date now = new Date(); for (int i = 0; i < ids.length; i++) { e = (Empprofile) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.ess.Empprofile", ids[i]); if (e != null) { if (e.getRelievedate() != null) { if (e.getRelievedate().after(rvdate)) { msg.put("msg", "invalidjoindate"); msg.put("success", true); txnManager.commit(status); return new ModelAndView("jsonView", "model", msg.toString()); } } } HashMap<String, Object> requestParams = new HashMap<String, Object>(); if (rvdate.before(now) || rvdate.equals(now)) { requestParams.put("termnd", false); } requestParams.put("userid", ids[i]); requestParams.put("joindate", request.getParameter("joindate")); requestParams.put("confirmdate", null); requestParams.put("relievedate", null); hrmsCommonDAOObj.addEmpprofile(requestParams); requestParams.clear(); requestParams.put("UserID", ids[i]); requestParams.put("Department", deptid); requestParams.put("Designationid", desgid); requestParams.put("Salary", salary); requestParams.put("Templateid", tempid); hrmsCommonDAOObj.addUseraccount(requestParams); if (rvdate.before(now) || rvdate.equals(now)) { requestParams.clear(); requestParams.put("UserID", ids[i]); requestParams.put("Deleteflag", 0); hrmsCommonDAOObj.adduser(requestParams); } // User u=(User)session.get(User.class,ids[i]); // Empprofile emp=(Empprofile)session.get(Empprofile.class,ids[i]); // Useraccount ua = (Useraccount) session.get(Useraccount.class, u.getUserID()); // ua.setDepartment((dept)); // ua.setDesignationid(desg); // ua.setSalary(salary); // u.setDeleteflag(0); // if (StringUtil.isNullOrEmpty(tempid) == false) { // ua.setTemplateid(tempid); // } // emp.setJoindate(rvdate); // emp.setTermnd(false); // emp.setRelievedate(null); // session.saveOrUpdate(emp); // session.saveOrUpdate(u); // session.saveOrUpdate(ua); //@@ProfileHandler.insertAuditLog(session, AuditAction.REHIRE_EMPLOYEE, "User " + AuthHandler.getFullName(session, AuthHandler.getUserid(request)) + " has rehired employee " + AuthHandler.getFullName(u) ,request); } msg.put("success", true); txnManager.commit(status); } catch (Exception e) { e.printStackTrace(); txnManager.rollback(status); } finally { //return new ModelAndView("jsonView","model","{\"success\":\"true\"}"); return new ModelAndView("jsonView", "model", msg.toString()); } }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView terminateEmp(HttpServletRequest request, HttpServletResponse response) { String hql = ""; SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd"); SimpleDateFormat sdf = new SimpleDateFormat("dd-mm-yyyy"); JSONObject msg = 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 w w. ja v a2 s . co m*/ boolean isCompanySuperAdmin = false; Empprofile e = null; String ids[] = request.getParameterValues("ids"); String masterid = request.getParameter("tercause"); String desc = ((StringUtil.isNullOrEmpty(request.getParameter("terdesc"))) ? "" : request.getParameter("terdesc")); String reldate = request.getParameter("relievedate"); Date rvdate = fmt.parse(reldate); Empprofile emp = null; UserLogin usl = null; User usr = null; Date now = new Date(); // User updatedby=(User)session.get(User.class,sessionHandlerImplObj.getUserid(request)); // User updatedby=(User)kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.User", sessionHandlerImplObj.getUserid(request)); String updatedby = sessionHandlerImplObj.getUserid(request); String companyid = sessionHandlerImplObj.getCompanyid(request); for (int i = 0; i < ids.length; i++) { if (hrmsCommonDAOObj.isCompanySuperAdmin(ids[i], companyid)) { isCompanySuperAdmin = true; break; } } if (isCompanySuperAdmin) { msg.put("msg", "adminerror"); msg.put("success", true); txnManager.commit(status); return new ModelAndView("jsonView", "model", msg.toString()); } for (int i = 0; i < ids.length; i++) { e = (Empprofile) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.ess.Empprofile", ids[i]); if (e != null) { if (e.getJoindate() != null) { if (e.getJoindate().after(rvdate)) { msg.put("msg", "invalidterminatedate"); msg.put("success", true); txnManager.commit(status); return new ModelAndView("jsonView", "model", msg.toString()); } } } // hql = "from Empprofile where userLogin.userID=?"; // List lst = HibernateUtil.executeQuery(session, hql, new Object[]{ids[i]}); //// usl=(UserLogin)session.get(UserLogin.class,ids[i]); // usl=(UserLogin)HibernateUtil.getPrimary("com.krawler.common.admin.UserLogin", "userID"); //// usr=(User)session.get(User.class,ids[i]); // usr=(User)HibernateUtil.getPrimary("com.krawler.common.admin.User", "userID"); // if(lst.isEmpty()){ // emp=new Empprofile(); // emp.setUserLogin(usl); // }else{ // emp=(Empprofile)session.get(Empprofile.class,ids[i]); // } // Emphistory ehst=new Emphistory(); // ehst.setUserid(usr); // ehst.setDepartment(usr.getDepartment()); // ehst.setDesignation(usr.getDesignationid()); // ehst.setSalary(usr.getSalary()); // ehst.setEmpid(usr.getEmployeeid()); // ehst.setUpdatedon(rvdate); // ehst.setJoindate(emp.getJoindate()); // ehst.setEnddate(rvdate); // ehst.setUpdatedby(updatedby); // ehst.setCategory(Emphistory.Emp_Desg_change); // emp.setTerminatedby(updatedby); // emp.setTercause((MasterData)session.get(MasterData.class,masterid)); // emp.setRelievedate(rvdate); // emp.setTerReason(desc); // emp.setTermnd(true); // usr.setDeleted(true); // session.saveOrUpdate(ehst); // session.saveOrUpdate(emp); // session.saveOrUpdate(usr); // //@@ProfileHandler.insertAuditLog(session, AuditAction.EMPLOYEE_TERMINATED, "Employee " + sessionHandlerImplObj.getFullName(usr) + " terminated by " + sessionHandlerImplObj.getFullName(session, sessionHandlerImplObj.getUserid(request)),request); HashMap<String, Object> requestParams = new HashMap<String, Object>(); if (rvdate.before(now) || rvdate.equals(now)) { requestParams.put("termnd", true); } requestParams.put("userid", ids[i]); requestParams.put("terminatedby", updatedby); requestParams.put("tercause", masterid); requestParams.put("terReason", desc); requestParams.put("relievedate", reldate); KwlReturnObject result = hrmsCommonDAOObj.addEmpprofile(requestParams); HashMap<String, Object> deleteJobj = organizationService.deleteNode(ids[i]); if (rvdate.before(now) || rvdate.equals(now)) { requestParams.clear(); requestParams.put("UserID", ids[i]); requestParams.put("Deleteflag", 1); hrmsCommonDAOObj.adduser(requestParams); } } msg.put("success", true); txnManager.commit(status); } catch (Exception e) { e.printStackTrace(); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", msg.toString()); } }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView saveUser(HttpServletRequest request, HttpServletResponse response) { JSONObject jobj = new JSONObject(); Integer codeid2 = null;// w w w . j av a 2 s. c o m KwlReturnObject result = null; String msg = ""; int roleflag = 0; String employeeIdFormat = ""; boolean isStadardEmpFormatWithIdAvilable = false; //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 { HashMap<String, Object> requestParams = new HashMap<String, Object>(); ArrayList filter_names = new ArrayList(), filter_values = new ArrayList(); HashMap newhm = new FileUploadHandler().getItems(request); HashMap<String, String> hm = new HashMap<String, String>(); for (Object key : newhm.keySet()) { hm.put(key.toString(), new String(newhm.get(key.toString()).toString().getBytes("iso-8859-1"), "UTF-8")); } String id = (String) hm.get("userid"); //String lastname = (String) hm.get("lastname"); //lastname = new String (lastname.getBytes ("iso-8859-1"), "UTF-8"); if (!StringUtil.isNullOrEmpty((String) hm.get("employeeid"))) { String[] codeid = ((String) hm.get("employeeid")).split("-"); 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; String companyid = sessionHandlerImplObj.getCompanyid(request); String pwd = null; if (!StringUtil.isNullOrEmpty(id)) { requestParams.clear(); // filter_names.add("employeeid"); // filter_values.add(codeid2); // // filter_names.add("userID"); // filter_values.add(id); // // filter_names.add("company.companyID"); // filter_values.add(companyid); // // requestParams.put("filter_names", filter_names); // requestParams.put("filter_values", filter_values); // // result = hrmsCommonDAOObj.getUsers(requestParams); // if (result.getEntityList().isEmpty()) { requestParams.put("employeeIdFormat", employeeIdFormat); requestParams.put("userID", id); requestParams.put("employeeid", codeid2); requestParams.put("request", request); isStadardEmpFormatWithIdAvilable = isStadardEmpFormatWithIdAvilable(requestParams); String standardEmpId = getStadardEmpFormat(requestParams); if (standardEmpId != null && employeeIdFormat != null && standardEmpId.equals(employeeIdFormat)) { employeeIdFormat = null; } requestParams.clear(); filter_names.clear(); filter_values.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(id); filter_names.add("user.company.companyID"); filter_values.add(companyid); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); result = hrmsCommonDAOObj.getUseraccount(requestParams); if (!result.getEntityList().isEmpty() || isStadardEmpFormatWithIdAvilable) { throw new Exception("Employee ID already present."); } // } requestParams.clear(); requestParams.put("id", id); if (((String) hm.get("formname")).equals("user")) { if (!StringUtil.isNullOrEmpty((String) hm.get("templateid"))) { requestParams.put("templateid", (String) hm.get("templateid")); } else { requestParams.put("templateid", " "); } } } else { requestParams.clear(); filter_names.clear(); filter_values.clear(); filter_names.add("userLogin.userName"); filter_values.add(hm.get("username")); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); result = hrmsCommonDAOObj.getUsers(requestParams); if (!result.getEntityList().isEmpty()) { throw new Exception("User name not available."); } requestParams.clear(); filter_names.clear(); filter_values.clear(); filter_names.add("employeeid"); filter_values.add(codeid2); filter_names.add("company.companyID"); filter_values.add(companyid); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); result = hrmsCommonDAOObj.getUsers(requestParams); if (!result.getEntityList().isEmpty()) { throw new Exception("Employee ID already present."); } requestParams.clear(); requestParams.put("username", hm.get("username")); pwd = AuthHandler.generateNewPassword(); requestParams.put("pwd", AuthHandler.getSHA1(pwd)); requestParams.put("companyid", companyid); } requestParams.put("fname", hm.get("firstname")); requestParams.put("lname", hm.get("lastname")); requestParams.put("emailid", hm.get("emailid")); requestParams.put("address", hm.get("address")); requestParams.put("contactno", hm.get("contactnumber")); requestParams.put("empid", codeid2); requestParams.put("employeeIdFormat", employeeIdFormat); requestParams.put("companyid", companyid); int histsave = 0; String histdept = ""; String histdesig = ""; String histsal = ""; Date saveDate = new Date(); SimpleDateFormat fmt = new SimpleDateFormat("yyyy/MM/dd"); saveDate = new Date(fmt.format(saveDate)); String updatedby = sessionHandlerImplObj.getUserid(request); Useraccount ua = (Useraccount) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.Useraccount", id); if (!StringUtil.isNullOrEmpty((String) hm.get("roleid")) && !hm.get("roleid").equals(ua.getRole().getID())) { if (ua.getRole().getID().equals("1") && hrmsCommonDAOObj.isCompanySuperAdmin(id, companyid)) {//Can't Edit role for super admin roleflag = 1; } else { String newRoleId = hm.get("roleid").toString(); if (StringUtil.equal(newRoleId, Role.COMPANY_USER)) { // Check whether new Role is Company User/ Company Employee List<Empprofile> childList = organizationChartDAOObj.getChildNode(id); // Check for child list before changing its role to Employee. if (childList.size() > 0) { roleflag = 2; } else { requestParams.put("roleid", newRoleId); } } else { requestParams.put("roleid", newRoleId); } } } if (!StringUtil.isNullOrEmpty((String) hm.get("designationid"))) { if ((MasterData) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.master.MasterData", (String) hm.get("designationid")) != ua.getDesignationid()) { histdesig = (ua.getDesignationid() == null) ? "" : ua.getDesignationid().getId(); histsave = 1; } requestParams.put("designationid", hm.get("designationid")); } if (!StringUtil.isNullOrEmpty((String) hm.get("department"))) { if ((MasterData) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.master.MasterData", (String) hm.get("department")) != ua.getDepartment()) { histdept = (ua.getDepartment() == null) ? "" : ua.getDepartment().getId(); if (histsave == 0) { histdesig = (ua.getDesignationid() == null) ? "" : ua.getDesignationid().getId(); } histsave = 2; } requestParams.put("department", hm.get("department")); } if (!StringUtil.isNullOrEmpty((String) hm.get("salary"))) { String tempsal = "0"; if (((String) hm.get("salary")).length() > 0) { tempsal = hm.get("salary").toString(); } if (!tempsal.equals(ua.getSalary())) { if (ua.getSalary() != null) { histsal = ua.getSalary(); } } requestParams.put("salary", tempsal); } if (!StringUtil.isNullOrEmpty((String) hm.get("accno"))) { if (((String) hm.get("accno")).length() > 0) { requestParams.put("accno", hm.get("accno")); } else { requestParams.put("accno", "0"); } } if (!StringUtil.isNullOrEmpty((String) hm.get("formatid"))) { requestParams.put("formatid", hm.get("formatid")); } String diff = null; if (!StringUtil.isNullOrEmpty((String) hm.get("tzid"))) { KWLTimeZone timeZone = (KWLTimeZone) kwlCommonTablesDAOObj .getObject("com.krawler.common.admin.KWLTimeZone", (String) hm.get("tzid")); diff = timeZone.getDifference(); requestParams.put("tzid", hm.get("tzid")); } if (!StringUtil.isNullOrEmpty((String) hm.get("aboutuser"))) { requestParams.put("aboutuser", hm.get("aboutuser")); } String imageName = ""; if (newhm.get("userimage") != null) { imageName = ((FileItem) (newhm.get("userimage"))).getName(); if (!StringUtil.isNullOrEmpty(imageName)) { requestParams.put("userimage", hm.get("userimage")); } } result = hrmsCommonDAOObj.saveUser(requestParams, RequestContextUtils.getLocale(request)); if (!StringUtil.isNullOrEmpty(imageName)) { User user = (User) result.getEntityList().get(0); String fileName = user.getImage().substring(user.getImage().lastIndexOf("/") + 1, user.getImage().length()); new FileUploadHandler().uploadImage((FileItem) (newhm.get("userimage")), fileName, StorageHandler.GetProfileImgStorePath(), 100, 100, false, false); } msg = result.getMsg(); requestParams.clear(); if (histsave == 1) { histdept = ua.getDepartment().getId(); } if (histsave == 1 || histsave == 2) { String latestUpdate = ""; HashMap<String, Object> requestParams2 = new HashMap<String, Object>(); requestParams2.put("id", id); requestParams2.put("cat", Emphistory.Emp_Desg_change); result = hrmsCommonDAOObj.getLastUpdatedHistory(requestParams2); latestUpdate = result.getEntityList().get(0).toString(); if (!latestUpdate.equals("")) { latestUpdate = latestUpdate.replace("-", "/"); requestParams.put("Joindate", fmt.parse(latestUpdate)); } requestParams.put("Department", histdept); requestParams.put("Designation", histdesig); requestParams.put("Userid", id); requestParams.put("Empid", ua.getEmployeeid()); requestParams.put("Updatedon", saveDate); requestParams.put("Updatedby", updatedby); requestParams.put("Category", Emphistory.Emp_Desg_change); result = hrmsCommonDAOObj.addEmphistory(requestParams); } if (!histsal.equals("")) { requestParams.clear(); requestParams.put("Userid", id); requestParams.put("Salary", histsal); requestParams.put("Updatedon", saveDate); requestParams.put("Updatedby", updatedby); requestParams.put("Category", Emphistory.Emp_Salary); result = hrmsCommonDAOObj.addEmphistory(requestParams); } sessionHandlerImplObj.updatePreferences(request, null, (StringUtil.isNullOrEmpty((String) hm.get("formatid")) ? null : (String) hm.get("formatid")), (StringUtil.isNullOrEmpty((String) hm.get("tzid")) ? null : (String) hm.get("tzid")), diff); if (roleflag == 1) { msg = msg + " " + messageSource.getMessage("hrms.common.Rolecannotbechangedforsuperadministrator", null, "Role cannot be changed for Super Administrator.", RequestContextUtils.getLocale(request)); jobj.put("roleflag", roleflag); } if (roleflag == 2) { msg = msg + " <br><br><br>" + messageSource.getMessage( "hrms.common.rolecannotbechangedtocompanyemployee", null, "Note : Role cannot be changed to Company Employee. Please re-assign or remove its child node in Organization Chart before changing its role to Company Employee.", RequestContextUtils.getLocale(request)); jobj.put("roleflag", roleflag); } jobj.put("msg", msg); jobj.put("success", true); txnManager.commit(status); } catch (Exception e) { try { if (e.getMessage().equals("Employee ID already present.")) { jobj.put("msg", e.getMessage()); } } catch (Exception ex) { e.printStackTrace(); } e.printStackTrace(); txnManager.rollback(status); } return new ModelAndView("jsonView", "model", jobj.toString()); }
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 .j a v a2 s. c om //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()); }