List of usage examples for org.springframework.transaction TransactionDefinition PROPAGATION_REQUIRED
int PROPAGATION_REQUIRED
To view the source code for org.springframework.transaction TransactionDefinition PROPAGATION_REQUIRED.
Click Source Link
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.hrms.common.hrmsCommonController.java
public ModelAndView saveSearch(HttpServletRequest request, HttpServletResponse response) { HashMap<String, Object> requestParams = new HashMap<String, Object>(); KwlReturnObject result = null;//from w ww.ja 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 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 .ja v a2 s . co 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.hrmsDocumentController.java
public ModelAndView addDocuments(HttpServletRequest request, HttpServletResponse response) throws ServletException { JSONObject jobj = new JSONObject(); JSONObject myjobj = new JSONObject(); List fileItems = null;// ww w .j a va 2s. c o m KwlReturnObject kmsg = null; String auditAction = ""; boolean applicant = false; String id = java.util.UUID.randomUUID().toString(); PrintWriter out = 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 { response.setContentType("text/html;charset=UTF-8"); out = response.getWriter(); String userid = sessionHandlerImplObj.getUserid(request); String map = request.getParameter("mapid"); HashMap<String, String> arrParam = new HashMap<String, String>(); boolean fileUpload = false; String docdesc; ArrayList<FileItem> fi = new ArrayList<FileItem>(); if (request.getParameter("fileAdd") != null) { DiskFileUpload fu = new DiskFileUpload(); fileItems = fu.parseRequest(request); documentDAOObj.parseRequest(fileItems, arrParam, fi, fileUpload); arrParam.put("IsIE", request.getParameter("IsIE")); if (arrParam.get("applicantid").equalsIgnoreCase("applicant")) { applicant = true; userid = arrParam.get("refid"); } if (StringUtil.isNullOrEmpty((String) arrParam.get("docdesc")) == false) { docdesc = (String) arrParam.get("docdesc"); } } for (int cnt = 0; cnt < fi.size(); cnt++) { String docID; if (applicant) { kmsg = hrmsExtApplDocsDAOObj.uploadFile(fi.get(cnt), userid, arrParam, profileHandlerDAOObj.getUserFullName(sessionHandlerImplObj.getUserid(request))); HrmsDocs doc = (HrmsDocs) kmsg.getEntityList().get(0); docID = doc.getDocid(); } else { kmsg = documentDAOObj.uploadFile(fi.get(cnt), userid, arrParam); Docs doc = (Docs) kmsg.getEntityList().get(0); docID = doc.getDocid(); } String companyID = sessionHandlerImplObj.getCompanyid(request); String userID = sessionHandlerImplObj.getUserid(request); String refid = arrParam.get("refid"); jobj.put("userid", userID); jobj.put("docid", docID); jobj.put("companyid", companyID); jobj.put("id", id); jobj.put("map", map); jobj.put("refid", refid); if (arrParam.get("applicantid").equalsIgnoreCase("applicant")) { hrmsExtApplDocsDAOObj.saveDocumentMapping(jobj); } else { documentDAOObj.saveDocumentMapping(jobj); } } myjobj.put("ID", id); txnManager.commit(status); } catch (Exception e) { System.out.println(e.getMessage()); txnManager.rollback(status); } finally { out.close(); } return new ModelAndView("jsonView", "model", myjobj.toString()); }
From source file:com.krawler.spring.hrms.common.hrmsDocumentController.java
public ModelAndView deleteDocuments(HttpServletRequest request, HttpServletResponse response) { KwlReturnObject result;/*from w w w. jav a2s . c o 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 { HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("ids", request.getParameterValues("ids")); String applicant = request.getParameter("applicant"); applicant = StringUtil.checkForNull(applicant); if (applicant.equalsIgnoreCase("applicant")) { result = hrmsExtApplDocsDAOObj.deleteDocuments(requestParams); } else { result = documentDAOObj.deleteDocuments(requestParams); } if (result.isSuccessFlag()) { jobj.put("success", true); } else { jobj.put("success", false); } jobj1.put("data", jobj.toString()); jobj1.put("valid", true); txnManager.commit(status); } catch (Exception e) { System.out.println(e.getMessage()); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }
From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java
public ModelAndView InternalJobpositions(HttpServletRequest request, HttpServletResponse response) { Date date = null;/* w w w . j ava2 s . c o m*/ SimpleDateFormat fmt = new SimpleDateFormat("MM/dd/yyyy"); boolean checkflag = true; JSONObject jobj = new JSONObject(); JSONObject jobj1 = new JSONObject(); KwlReturnObject result = 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 { HashMap<String, Object> requestParams = new HashMap<String, Object>(); String companyid = sessionHandlerImplObj.getCompanyid(request); Company company = (Company) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.Company", companyid); if (StringUtil.isNullOrEmpty(request.getParameter("posid"))) { ArrayList<String> name = new ArrayList<String>(); ArrayList<Object> value = new ArrayList<Object>(); name.add("position.id"); value.add(request.getParameter("position")); name.add("department.id"); value.add(request.getParameter("department")); name.add("jobtype"); value.add(request.getParameter("jobtype")); name.add("!delflag"); value.add(1); requestParams.clear(); requestParams.put("filter_names", name); requestParams.put("filter_values", value); result = hrmsRecJobDAOObj.getPositionmain(requestParams); if (!result.getEntityList().isEmpty()) checkflag = false; if (checkflag) { requestParams = new HashMap<String, Object>(); requestParams.put("masterid", request.getParameter("position")); requestParams.put("companyid", sessionHandlerImplObj.getCompanyid(request)); result = hrmsCommonDAOObj.getMasterData(requestParams); MasterData md = null; if (result.getEntityList() != null && result.getEntityList().size() > 0) md = (MasterData) result.getEntityList().get(0); requestParams = new HashMap<String, Object>(); requestParams.put("masterid", request.getParameter("department")); requestParams.put("companyid", sessionHandlerImplObj.getCompanyid(request)); result = hrmsCommonDAOObj.getMasterData(requestParams); MasterData dept = null; if (result.getEntityList() != null && result.getEntityList().size() > 0) dept = (MasterData) result.getEntityList().get(0); requestParams = new HashMap<String, Object>(); requestParams.put("empid", request.getParameter("manager")); result = hrmsCommonDAOObj.getUserDetailsbyUserid(requestParams); User man = null; if (result.getEntityList() != null && result.getEntityList().size() > 0) man = (User) result.getEntityList().get(0); date = (Date) fmt.parse(request.getParameter("startdate")); requestParams = new HashMap<String, Object>(); requestParams.put("empid", sessionHandlerImplObj.getUserid(request)); result = hrmsCommonDAOObj.getUserDetailsbyUserid(requestParams); User createdby = null; if (result.getEntityList() != null && result.getEntityList().size() > 0) createdby = (User) result.getEntityList().get(0); requestParams = new HashMap<String, Object>(); requestParams.put("startdate", request.getParameter("startdate")); requestParams.put("enddate", request.getParameter("enddate")); requestParams.put("position", md); requestParams.put("details", request.getParameter("details")); requestParams.put("jobtype", request.getParameter("jobtype")); requestParams.put("jobidwthformat", Integer.parseInt(request.getParameter("jobid"))); HashMap<String, Object> requestParams1 = new HashMap<String, Object>(); requestParams1.put("companyid", sessionHandlerImplObj.getCompanyid(request)); requestParams1.put("jobid", request.getParameter("jobid")); requestParams1.put("jobidformat", request.getParameter("jobidformat")); requestParams.put("jobid", profileHandlerDAOObj.getJobIdFormatEdit(requestParams1)); requestParams.put("delflag", 0); requestParams.put("company", company); requestParams.put("manager", man); requestParams.put("departmentid", dept); requestParams.put("noofpos", Integer.parseInt(request.getParameter("nopos"))); requestParams.put("createdby", createdby); requestParams.put("positionsfilled", 0); hrmsRecJobDAOObj.setPositionmain(requestParams); jobj.put("message", messageSource.getMessage("hrms.recruitment.Jobpositionaddedsuccessfully", null, "Job position added successfully.", RequestContextUtils.getLocale(request))); } else { jobj.put("message", messageSource.getMessage("hrms.recruitment.Jobpositionalreadypresent", null, "Job position already present.", RequestContextUtils.getLocale(request))); } } else { //Positionmain posmain = (Positionmain) session.load(Positionmain.class, request.getParameter("posid")); requestParams = new HashMap<String, Object>(); requestParams.put("empid", request.getParameter("manager")); result = hrmsCommonDAOObj.getUserDetailsbyUserid(requestParams); User man = null; if (result.getEntityList() != null && result.getEntityList().size() > 0) man = (User) result.getEntityList().get(0); // requestParams = new HashMap<String, Object>(); // requestParams.put("positionid",request.getParameter("posid")); ArrayList<String> name = new ArrayList<String>(); ArrayList<Object> value = new ArrayList<Object>(); name.add("positionid"); value.add(request.getParameter("posid")); requestParams.clear(); requestParams.put("filter_names", name); requestParams.put("filter_values", value); result = hrmsRecJobDAOObj.getPositionmain(requestParams); Positionmain posmain = null; requestParams = new HashMap<String, Object>(); requestParams.put("positionid", request.getParameter("posid")); if (result.getEntityList() != null && result.getEntityList().size() > 0) posmain = (Positionmain) result.getEntityList().get(0); if (request.getParameter("details") != null) { requestParams.put("details", request.getParameter("details")); } if (!StringUtil.isNullOrEmpty(request.getParameter("manager"))) { requestParams.put("manager", man); } if (!StringUtil.isNullOrEmpty(request.getParameter("department"))) { requestParams.put("departmentid", request.getParameter("department")); } if (!StringUtil.isNullOrEmpty(request.getParameter("startdate"))) { //date = (Date) fmt.parse(request.getParameter("startdate")); requestParams.put("startdate", request.getParameter("startdate")); } if (!StringUtil.isNullOrEmpty(request.getParameter("enddate"))) { date = (Date) fmt.parse(request.getParameter("enddate")); if (new Date(fmt.format(new Date())).after(date)) { requestParams.put("delflag", 2); } else { requestParams.put("delflag", 0); } requestParams.put("enddate", request.getParameter("enddate")); } if (!StringUtil.isNullOrEmpty(request.getParameter("nopos"))) { if (posmain.getPositionsfilled() == Integer.parseInt(request.getParameter("nopos"))) { requestParams.put("delflag", 3); } requestParams.put("noofpos", Integer.parseInt(request.getParameter("nopos"))); } if (!StringUtil.isNullOrEmpty(request.getParameter("jobshift"))) { requestParams.put("jobshift", request.getParameter("jobshift")); } if (!StringUtil.isNullOrEmpty(request.getParameter("location"))) { requestParams.put("location", request.getParameter("location")); } if (!StringUtil.isNullOrEmpty(request.getParameter("relocation"))) { requestParams.put("relocation", request.getParameter("relocation")); } if (!StringUtil.isNullOrEmpty(request.getParameter("expmonth"))) { requestParams.put("experiencemonth", Integer.parseInt(request.getParameter("expmonth"))); } if (!StringUtil.isNullOrEmpty(request.getParameter("expyear"))) { requestParams.put("experienceyear", Integer.parseInt(request.getParameter("expyear"))); } if (!StringUtil.isNullOrEmpty(request.getParameter("travel"))) { requestParams.put("travel", request.getParameter("travel")); } result = hrmsRecJobDAOObj.updatePositionmain(requestParams); jobj.put("message", messageSource.getMessage("hrms.recruitment.Jobpositionupdatedsuccessfully", null, "Job position updated successfully.", RequestContextUtils.getLocale(request))); } // ProfileHandler.insertAuditLog(session, // ("Internal".equals(request.getParameter("jobtype")) ? AuditAction.INTERNAL_JOB_ADDED : AuditAction.EXTERNAL_JOB_ADDED), // "User " + AuthHandler.getFullName(session, AuthHandler.getUserid(request)) + " has added " + request.getParameter("jobtype") + " job", request); jobj1.put("valid", true); jobj1.put("data", jobj.toString()); txnManager.commit(status); } catch (ParseException ex) { ex.printStackTrace(); txnManager.rollback(status); } catch (SessionExpiredException ex) { ex.printStackTrace(); txnManager.rollback(status); } catch (JSONException ex) { ex.printStackTrace(); txnManager.rollback(status); } catch (Exception e) { e.printStackTrace(); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }
From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java
public ModelAndView DeleteInternalJobs(HttpServletRequest request, HttpServletResponse response) { List tabledata = null;//from ww w. ja v a2s . c om JSONObject jobj = new JSONObject(); JSONObject jobj1 = new JSONObject(); String hql = null; boolean flag = true; ArrayList<String> name = new ArrayList<String>(); ArrayList<Object> value = new ArrayList<Object>(); KwlReturnObject result = 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); String title = "Success"; try { String delids[] = request.getParameterValues("delid"); for (int i = 0; i < delids.length; i++) { name.clear(); value.clear(); // hql = "from Allapplications where position.positionid=? and company.companyID=? and delflag=0"; // tabledata = HibernateUtil.executeQuery(session, hql, new Object[]{delids[i], AuthHandler.getCompanyid(request)}); name.add("position.positionid"); value.add(delids[i]); name.add("company.companyID"); value.add(sessionHandlerImplObj.getCompanyid(request)); name.add("delflag"); value.add(0); result = hrmsRecJobDAOObj.getPositionstatus(name, value); tabledata = result.getEntityList(); if (tabledata.isEmpty()) { HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("filter_names", Arrays.asList("applypos")); requestParams.put("filter_values", Arrays.asList((Positionmain) kwlCommonTablesDAOObj .getObject("com.krawler.hrms.recruitment.Positionmain", delids[i]))); result = hrmsRecAgencyDAOObj.getApplyagency(requestParams); if (result.getEntityList().isEmpty()) { name.clear(); value.clear(); name.add("positionid"); value.add(delids[i]); // hql = "from Positionmain where positionid=?"; // tabledata = HibernateUtil.executeQuery(session, hql, delids[i]); requestParams.clear(); requestParams.put("filter_names", name); requestParams.put("filter_values", value); result = hrmsRecJobDAOObj.getPositionmain(requestParams); tabledata = result.getEntityList(); if (!tabledata.isEmpty()) { requestParams = new HashMap<String, Object>(); requestParams.put("delflag", 1); requestParams.put("positionid", delids[i]); result = hrmsRecJobDAOObj.updatePositionmain(requestParams); // Positionmain log = (Positionmain) tabledata.get(0); // log.setDelflag(1); // session.update(log); } } else { flag = false; } } else { flag = false; } } if (flag) { jobj.put("message", messageSource.getMessage("hrms.recruitment.SelectedJobPositionsuccessfullydeleted", null, "Selected Job Position(s) successfully deleted.", RequestContextUtils.getLocale(request))); } else { jobj.put("message", messageSource.getMessage("hrms.recruitment.SomejobscannotbedeletedBeacause", null, "Some jobs have assigned applicants or are assigned to agencies and hence cannot be deleted.", RequestContextUtils.getLocale(request))); } jobj1.put("valid", true); jobj.put("title", title); 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.rec.job.hrmsRecJobController.java
public ModelAndView addjobprofile(HttpServletRequest request, HttpServletResponse response) { String id = ""; KwlReturnObject result = null;/*ww w. j a v a 2 s. co m*/ 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 jsondata1 = request.getParameter("jsondataresp"); String jsondata2 = request.getParameter("jsondataskill"); String jsondata3 = request.getParameter("jsondataqual"); ArrayList name = new ArrayList(); ArrayList value = new ArrayList(); name.add("positionid"); value.add(request.getParameter("position")); HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("filter_names", name); requestParams.put("filter_values", value); result = hrmsRecJobDAOObj.getPositionmain(requestParams); Positionmain pos = null; if (result.getEntityList() != null && result.getEntityList().size() > 0) pos = (Positionmain) result.getEntityList().get(0); requestParams = new HashMap<String, Object>(); JSONArray jarr = new JSONArray("[" + jsondata1 + "]"); for (int i = 0; i < jarr.length(); i++) { JSONObject jobj = jarr.getJSONObject(i); if (!StringUtil.isNullOrEmpty(jobj.getString("id"))) { id = jobj.getString("id"); requestParams.put("id", id); } requestParams.put("responsibility", jobj.getString("responsibility")); requestParams.put("position", pos); requestParams.put("type", jobj.getString("type")); hrmsRecJobDAOObj.addJobProfile(requestParams); requestParams.clear(); } requestParams.clear(); jarr = new JSONArray("[" + jsondata2 + "]"); for (int j = 0; j < jarr.length(); j++) { JSONObject jobj = jarr.getJSONObject(j); if (!StringUtil.isNullOrEmpty(jobj.getString("id"))) { id = jobj.getString("id"); requestParams.put("id", id); } requestParams.put("skill", jobj.getString("skill")); requestParams.put("skilldesc", jobj.getString("skilldesc")); requestParams.put("type", jobj.getString("type")); requestParams.put("position", pos); hrmsRecJobDAOObj.addJobProfile(requestParams); requestParams.clear(); } requestParams.clear(); jarr = new JSONArray("[" + jsondata3 + "]"); for (int j = 0; j < jarr.length(); j++) { JSONObject jobj = jarr.getJSONObject(j); if (!StringUtil.isNullOrEmpty(jobj.getString("id"))) { id = jobj.getString("id"); requestParams.put("id", id); } requestParams.put("qualification", jobj.getString("qualification")); requestParams.put("qualificationdesc", jobj.getString("qualificationdesc")); requestParams.put("type", jobj.getString("type")); requestParams.put("position", pos); hrmsRecJobDAOObj.addJobProfile(requestParams); requestParams.clear(); } jobj1.put("valid", true); jobj1.put("data", "success"); 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.rec.job.hrmsRecJobController.java
public ModelAndView scheduleinterview(HttpServletRequest request, HttpServletResponse response) { Date date1;//from ww w. ja va 2s .c om DateFormat formatter; JSONObject jobj = new JSONObject(); String interviewdate = ""; //boolean reflag=false; String htmlmsg = ""; String pmsg = ""; String interviewsub = ""; KwlReturnObject result = null, recruitresult = 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 { HashMap<String, Object> requestParams = new HashMap<String, Object>(); String interviewtime = request.getParameter("interviewtime"); String location = request.getParameter("interviewplace"); formatter = new SimpleDateFormat("MM/dd/yyyy"); // Company cmp=(Company) session.get(Company.class,AuthHandler.getCompanyid(request)); requestParams.put("companyid", sessionHandlerImplObj.getCompanyid(request)); result = profileHandlerDAOObj.getCompanyid(requestParams); Company cmp = null; if (StringUtil.checkResultobjList(result)) { cmp = (Company) result.getEntityList().get(0); } date1 = (Date) formatter.parse(request.getParameter("interviewdt")); //interviewdate=(AuthHandler.getUserDateFormatter(request,session).format(date1)); requestParams.clear(); requestParams.put("request", request); interviewdate = request.getParameter("interviewdt"); Allapplications allapl = null; String[] ids = request.getParameterValues("ids"); String[] emailids = new String[ids.length]; String[] Resumeids = new String[ids.length]; String[] jobs = new String[ids.length]; String[] applicant = new String[ids.length]; Boolean[] reflag = new Boolean[ids.length]; for (int i = 0; i < ids.length; i++) { requestParams.clear(); requestParams.put("id", ids[i]); requestParams.put("primary", true); result = hrmsRecJobDAOObj.getPositionstatus(requestParams); allapl = (Allapplications) result.getEntityList().get(0); if (allapl.getStatus().equalsIgnoreCase("In Process")) { reflag[i] = true; } else { reflag[i] = false; } requestParams.clear(); requestParams.put("id", ids[i]); requestParams.put("status", "In Process"); requestParams.put("interviewdate", date1); requestParams.put("interviewtime", interviewtime); requestParams.put("interviewplace", location); requestParams.put("contactperson", request.getParameter("contactperson")); requestParams.put("interviewcomment", request.getParameter("interviewcomment")); //set rid to recruiter table and remove recruiter column from allapp requestParams.put("recruiter", request.getParameter("rid")); result = hrmsRecJobDAOObj.addAllapplications(requestParams); if (StringUtil.checkResultobjList(result)) { allapl = (Allapplications) result.getEntityList().get(0); requestParams.clear(); String[] Recruiterids = request.getParameter("rid").split(","); requestParams.put("Allapplication", allapl.getId()); boolean success = hrmsRecJobDAOObj.deleteRecruiters(requestParams); requestParams.put("Delflag", 0); for (int j = 0; j < Recruiterids.length && success; j++) { requestParams.put("Recruit", Recruiterids[j]); recruitresult = hrmsRecJobDAOObj.setRecruiters(requestParams); } } jobs[i] = (allapl.getPosition().getPosition().getValue() + " [" + allapl.getPosition().getJobid() + "] "); if (Integer.parseInt(request.getParameter("employeetype")) == 1) { emailids[i] = allapl.getEmployee().getEmailID(); applicant[i] = (allapl.getEmployee().getFirstName() + " " + allapl.getEmployee().getLastName()); } else { emailids[i] = allapl.getConfigjobapplicant().getCol3(); applicant[i] = (allapl.getConfigjobapplicant().getCol1() + " " + allapl.getConfigjobapplicant().getCol2()); Resumeids[i] = allapl.getConfigjobapplicant().getCol5(); } String usrnm; if (allapl.getEmployee() != null) { usrnm = StringUtil.getFullName(allapl.getEmployee()); } else { usrnm = allapl.getConfigjobapplicant().getCol1() + " " + allapl.getConfigjobapplicant().getCol2(); } //@@ProfileHandler.insertAuditLog(session, AuditAction.INTERVIEW_SCHEDULED, "User " + AuthHandler.getFullName(session, AuthHandler.getUserid(request)) + " has scheduled interview for " + usrnm + " on "+ interviewdate + " at " + allapl.getInterviewplace(),request); } // User usr=(User) session.get(User.class,AuthHandler.getUserid(request)); Useraccount ua = (Useraccount) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.Useraccount", sessionHandlerImplObj.getUserid(request)); User usr = ua.getUser(); if (!StringUtil.isNullOrEmpty(request.getParameter("mail"))) { for (int j = 0; j < emailids.length; j++) { if (reflag[j]) { pmsg = String.format(HrmsMsgs.rescheduleinterviewPlnmsg, applicant[j], jobs[j], cmp.getCompanyName(), interviewdate, interviewtime, location, usr.getContactNumber(), usr.getEmailID(), usr.getFirstName() + " " + usr.getLastName(), ua.getDesignationid() != null ? ua.getDesignationid().getValue() : " ", cmp.getCompanyName()); htmlmsg = String.format(HrmsMsgs.rescheduleinterviewHTMLmsg, applicant[j], jobs[j], cmp.getCompanyName(), interviewdate, interviewtime, location, usr.getContactNumber(), usr.getEmailID(), usr.getFirstName() + " " + usr.getLastName(), ua.getDesignationid() != null ? ua.getDesignationid().getValue() : " ", cmp.getCompanyName()); interviewsub = String.format(HrmsMsgs.rescheduleinterviewSubject, allapl.getPosition().getJobid(), allapl.getPosition().getPosition().getValue(), cmp.getCompanyName()); try { SendMailHandler.postMail(new String[] { emailids[j] }, interviewsub, htmlmsg, pmsg, usr.getEmailID()); } catch (MessagingException e) { e.printStackTrace(); } } else { pmsg = String.format(HrmsMsgs.interviewPlnmsg, jobs[j], interviewdate, interviewtime, location); htmlmsg = String.format(HrmsMsgs.interviewHTMLmsg, applicant[j], jobs[j], cmp.getCompanyName(), interviewdate, interviewtime, location, usr.getContactNumber(), usr.getEmailID(), usr.getFirstName() + " " + usr.getLastName(), ua.getDesignationid() != null ? ua.getDesignationid().getValue() : " ", cmp.getCompanyName()); interviewsub = String.format(HrmsMsgs.interviewSubject, allapl.getPosition().getJobid(), allapl.getPosition().getPosition().getValue(), cmp.getCompanyName()); try { SendMailHandler.postMail(new String[] { emailids[j] }, interviewsub, htmlmsg, pmsg, usr.getEmailID()); } catch (MessagingException e) { e.printStackTrace(); } } ArrayList params = new ArrayList(); params.add(allapl.getId()); ArrayList filter_names = new ArrayList(); filter_names.add("allapplication.id"); requestParams.clear(); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", params); recruitresult = hrmsRecJobDAOObj.getRecruiters(requestParams); if (StringUtil.checkResultobjList(recruitresult)) { List recruiterlist = recruitresult.getEntityList(); for (int k = 0; k < recruiterlist.size(); k++) { Recruiter r = (Recruiter) recruiterlist.get(k); String interviewer = r.getRecruit().getFirstName() + " " + r.getRecruit().getLastName(); String intpmsg = String.format(HrmsMsgs.interviewinvitePlnmsg, interviewer, jobs[j], interviewdate, interviewtime, location); String inthtmlmsg = String.format(HrmsMsgs.interviewinviteHTMLmsg, interviewer, jobs[j], interviewdate, interviewtime, location, usr.getFirstName() + " " + usr.getLastName(), ua.getDesignationid() != null ? ua.getDesignationid().getValue() : " ", cmp.getCompanyName()); String interviewinvitesub = String.format(HrmsMsgs.interviewinviteSubject, allapl.getPosition().getJobid(), allapl.getPosition().getPosition().getValue(), cmp.getCompanyName()); if (StringUtil.isNullOrEmpty(Resumeids[j])) { try { SendMailHandler.postMail(new String[] { r.getRecruit().getEmailID() }, interviewinvitesub, inthtmlmsg, intpmsg, usr.getEmailID()); } catch (MessagingException e) { e.printStackTrace(); } } else { hrmsDocumentController hdc = new hrmsDocumentController(); KwlReturnObject kmsg = hrmsExtApplDocsDAOObj.downloadDocument(Resumeids[j]); HashMap ht = hdc.getDocInfo(kmsg, storageHandlerImplObj); try { if (ht != null && ht.containsKey("filename")) { SendMailHandler.postMail(new String[] { r.getRecruit().getEmailID() }, interviewinvitesub, inthtmlmsg, intpmsg, usr.getEmailID(), new String[] { (String) ht.get("attachment"), (String) ht.get("filename") }); } else { SendMailHandler.postMail(new String[] { r.getRecruit().getEmailID() }, interviewinvitesub, inthtmlmsg, intpmsg, usr.getEmailID()); } } catch (MessagingException e) { e.printStackTrace(); } } } } } } if (result.isSuccessFlag()) { String interviewersname = ""; String delimiter = ","; String[] temp = request.getParameter("rid").split(delimiter); for (int i = 0; i < temp.length; i++) { interviewersname += profileHandlerDAOObj.getUserFullName(temp[i]); if (temp.length > i + 1) interviewersname += ", "; } for (int i = 0; i < ids.length; i++) auditTrailDAOObj.insertAuditLog(AuditAction.INTERVIEW_SCHEDULED, "User " + profileHandlerDAOObj.getUserFullName(sessionHandlerImplObj.getUserid(request)) + " has scheduled interview for applicant " + request.getParameterValues("cname")[i] + ". Interviewers are " + interviewersname, request, "0"); } jobj.put("success", "true"); txnManager.commit(status); } catch (Exception ex) { ex.printStackTrace(); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", ""); } }
From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java
public ModelAndView deleteAllappliations(HttpServletRequest request, HttpServletResponse response) { List tabledata = null;// www .j av a 2 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[] ids = request.getParameterValues("ids"); for (int i = 0; i < ids.length; i++) { HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("id", ids[i]); hrmsRecJobDAOObj.deleteAllapplications(requestParams); } jobj.put("success", "true"); jobj1.put("data", jobj.toString()); jobj1.put("valid", true); txnManager.commit(status); } catch (Exception ex) { txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }