Example usage for org.springframework.transaction TransactionDefinition ISOLATION_READ_UNCOMMITTED

List of usage examples for org.springframework.transaction TransactionDefinition ISOLATION_READ_UNCOMMITTED

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.transaction.*
  5. TransactionDefinition
  6. ISOLATION_READ_UNCOMMITTED

Introduction

In this page you can find the example usage for org.springframework.transaction TransactionDefinition ISOLATION_READ_UNCOMMITTED.

Prototype

int ISOLATION_READ_UNCOMMITTED

To view the source code for org.springframework.transaction TransactionDefinition ISOLATION_READ_UNCOMMITTED.

Click Source Link

Document

Indicates that dirty reads, non-repeatable reads and phantom reads can occur.

Usage

From source file:com.krawler.spring.hrms.common.hrmsCommonController.java

public ModelAndView assignManager(HttpServletRequest request, HttpServletResponse response) {
    KwlReturnObject result = null;/*from   w ww  . ja va2 s.  c  o 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 {/*ww w  . j ava 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 saveempprofile(HttpServletRequest request, HttpServletResponse reponse) {
    JSONObject msg = new JSONObject();
    KwlReturnObject result;/*from w  w w .  j  a v a  2 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());
}

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  . ja  va 2s. 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 .  j  ava  2 s .  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.hrmsDocumentController.java

public ModelAndView addDocuments(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject jobj = new JSONObject();
    JSONObject myjobj = new JSONObject();
    List fileItems = null;/*from w  ww  . j a va 2  s.co 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;//w  w w.  j  a  va  2 s  .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;//from ww  w.  ja  va 2s.  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   w  w w. j a  va 2 s .  c o  m
    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;/*from w  w  w. j a va  2  s .  c  om*/
    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());
    }
}