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.rec.job.hrmsRecJobController.java

public ModelAndView scheduleinterview(HttpServletRequest request, HttpServletResponse response) {
    Date date1;/* w ww . j  a  v  a  2  s .  c  o  m*/
    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;//from  w  ww. ja v  a 2s  . c om
    JSONObject jobj = new JSONObject();
    JSONObject jobj1 = new JSONObject();
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);

    try {
        String[] ids = request.getParameterValues("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());
    }
}

From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java

public ModelAndView editProspect(HttpServletRequest request, HttpServletResponse response) {
    Date joiningdate = null;// w w w  .  java2s. c  om
    DateFormat formatter;
    formatter = new SimpleDateFormat("MM/dd/yyyy");
    KwlReturnObject result = null;
    JSONObject jobj1 = new JSONObject();
    String appnames = "";
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);

    try {
        String[] ids = request.getParameterValues("ids");
        String[] cnames = request.getParameterValues("cnames");
        String[] positionids = request.getParameterValues("positionids");
        String applicantStatus = request.getParameter("selected");
        HashMap<String, Object> requestParams = new HashMap<String, Object>();
        HashMap<String, Object> appParams = new HashMap<String, Object>();
        for (int i = 0; i < ids.length; i++) {
            requestParams.clear();
            requestParams.put("positionid", positionids[i]);
            requestParams.put("primary", true);
            result = hrmsRecJobDAOObj.getPositionmain(requestParams);
            Positionmain position = null;
            if (StringUtil.checkResultobjList(result)) {
                position = (Positionmain) result.getEntityList().get(0);
            }

            requestParams.clear();
            requestParams.put("id", ids[i]);
            requestParams.put("primary", true);
            result = hrmsRecJobDAOObj.getPositionstatus(requestParams);
            appParams.put("id", ids[i]);
            Allapplications appl = null;
            if (StringUtil.checkResultobjList(result)) {
                appl = (Allapplications) result.getEntityList().get(0);
            }
            //                Allapplications appl = (Allapplications) session.load(Allapplications.class, ids[i]);
            //                Positionmain position = (Positionmain) session.load(Positionmain.class, positionids[i]);

            if (StringUtil.isNullOrEmpty(request.getParameter("callback")) == false) {
                appParams.put("callback", request.getParameter("callback"));
                //                    appl.setCallback((MasterData) session.load(MasterData.class, request.getParameter("callback")));
            }
            if (StringUtil.isNullOrEmpty(applicantStatus)) {
            } else {
                //                    appl.setStatus(request.getParameter("status"));
                appParams.put("status", applicantStatus);
                if (applicantStatus.equalsIgnoreCase("Rejected")) {
                    if (appl.getApplicationflag() == 1 && position.getPositionsfilled() > 0) {
                        requestParams.clear();
                        requestParams.put("positionid", positionids[i]);
                        requestParams.put("positionsfilled", position.getPositionsfilled() - 1);
                        requestParams.put("delflag", 0);
                        hrmsRecJobDAOObj.updatePositionmain(requestParams);
                        //                            position.setPositionsfilled(position.getPositionsfilled()-1);
                        //                            position.setDelflag(0);
                        //                            session.update(position);
                    }
                    appParams.put("applicationflag", 2);
                    appParams.put("rejectedbefore", 1);
                    //                        appl.setApplicationflag(2);
                    //                        appl.setRejectedbefore(1);
                } else if (applicantStatus.equalsIgnoreCase("Selected")) {
                    joiningdate = (Date) formatter.parse(request.getParameter("joiningdate"));
                    if (appl.getApplydate() != null && joiningdate != null
                            && appl.getApplydate().compareTo(joiningdate) < 0) {
                        //                        appl.setApplicationflag(1);
                        appParams.put("applicationflag", 1);
                        if (Boolean.parseBoolean(request.getParameter("changeselected"))) {
                            requestParams.clear();
                            requestParams.put("positionid", positionids[i]);
                            if (position.getNoofpos() >= position.getPositionsfilled() + 1) {
                                if (position.getNoofpos() == position.getPositionsfilled() + 1) {
                                    requestParams.put("delflag", 3);
                                    //                                    position.setDelflag(3);
                                }
                                //                                position.setPositionsfilled(position.getPositionsfilled() + 1);
                                requestParams.put("positionsfilled", position.getPositionsfilled() + 1);
                            }
                            //                            session.update(position);
                            hrmsRecJobDAOObj.updatePositionmain(requestParams);
                        }
                        if (!StringUtil.isNullOrEmpty(request.getParameter("joiningdate"))) {
                            joiningdate = (Date) formatter.parse(request.getParameter("joiningdate"));
                            //                            appl.setJoiningdate(joiningdate);
                            appParams.put("joiningdate", joiningdate);
                        }
                    }
                } else {
                    if (appl.getApplicationflag() == 1 && position.getPositionsfilled() >= 0) {
                        requestParams.clear();
                        //                            position.setPositionsfilled(position.getPositionsfilled()-1);
                        //                            position.setDelflag(0);
                        //                            session.update(position);
                        requestParams.put("positionid", positionids[i]);
                        requestParams.put("positionsfilled", position.getPositionsfilled() - 1);
                        requestParams.put("delflag", 0);
                        hrmsRecJobDAOObj.updatePositionmain(requestParams);

                    }
                    //                        appl.setApplicationflag(0);
                    appParams.put("applicationflag", 0);

                }
            }
            if (StringUtil.isNullOrEmpty(request.getParameter("rank")) == false) {
                //                    appl.setRank((MasterData) session.load(MasterData.class, request.getParameter("rank")));
                appParams.put("rank", request.getParameter("rank"));
            }
            if (!StringUtil.isNullOrEmpty(request.getParameter("statuscomment"))) {
                //                    appl.setStatuscomment(request.getParameter("statuscomment"));
                appParams.put("statuscomment", request.getParameter("statuscomment"));
            }
            String usrnm;
            if (appl.getEmployee() != null) {
                usrnm = StringUtil.getFullName(appl.getEmployee());
            } else {
                usrnm = appl.getConfigjobapplicant().getCol1() + " " + appl.getConfigjobapplicant().getCol2();
            }
            //                session.update(appl);

            if (request.getParameter("selected").equals("Selected")) {
                if (appl.getApplydate() != null && joiningdate != null
                        && appl.getApplydate().compareTo(joiningdate) < 0) {
                    hrmsRecJobDAOObj.addAllapplications(appParams);
                } else {
                    appnames += (cnames[i] + " ,");
                }
            } else {
                hrmsRecJobDAOObj.addAllapplications(appParams);
            }
            //@@ProfileHandler.insertAuditLog(session, AuditAction.PROSPECT_EDITED, "User  " + AuthHandler.getFullName(session, AuthHandler.getUserid(request)) + " has edited prospect of " + usrnm,request);
        }
        txnManager.commit(status);
        if (!appnames.equals("")) {
            appnames = appnames.substring(0, appnames.length() - 1);
        }
        jobj1.put("msg", appnames);
        jobj1.put("success", true);
        jobj1.put("valid", true);
    } catch (Exception ex) {
        ex.printStackTrace();
        txnManager.rollback(status);
    } finally {
        return new ModelAndView("jsonView", "model", jobj1.toString());
    }
}

From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java

public ModelAndView deleteJobapplicant(HttpServletRequest request, HttpServletResponse response)
        throws ServiceException, HibernateException, SessionExpiredException {
    JSONObject jobj = new JSONObject();
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);

    try {/*from   w  w  w  .  ja  va  2 s  .c o m*/
        String[] ids = request.getParameterValues("ids");
        HashMap<String, Object> requestParams = new HashMap<String, Object>();
        for (int i = 0; i < ids.length; i++) {
            requestParams.clear();
            requestParams.put("id", ids[i]);
            hrmsRecJobDAOObj.deleteConfigJobapplicant(requestParams);
        }
        jobj.put("data", "");
        jobj.put("valid", true);
        txnManager.commit(status);
    } catch (HibernateException e) {
        txnManager.rollback(status);
        throw ServiceException.FAILURE("hrmsHandler.deleteApplicants", e);
    } finally {
        return new ModelAndView("jsonView", "model", jobj.toString());
    }
}

From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java

public ModelAndView applyforjobexternal(HttpServletRequest request, HttpServletResponse response) {
    String statusstr = "Pending";
    Date date1;/*from  ww w  .j ava 2s .  c  o  m*/
    DateFormat formatter;
    String positions = "";
    ConfigRecruitmentData applicant = null;
    User user = null;
    String applicantid;
    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>();

        formatter = new SimpleDateFormat("MM/dd/yyyy");
        date1 = (Date) formatter.parse(request.getParameter("applydt"));
        Allapplications allapl = null;
        if (StringUtil.isNullOrEmpty(request.getParameter("apcntid"))) {
            applicantid = sessionHandlerImplObj.getUserid(request);
        } else {
            applicantid = request.getParameter("apcntid");
        }
        if (Integer.parseInt(request.getParameter("employeetype")) == 1) {
            user = (User) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.User", applicantid);
        } else {
            applicant = (ConfigRecruitmentData) kwlCommonTablesDAOObj
                    .getObject("com.krawler.hrms.recruitment.ConfigRecruitmentData", applicantid);
        }
        Company cmp = (Company) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.Company",
                sessionHandlerImplObj.getCompanyid(request));
        String[] ids = request.getParameterValues("posid");
        for (int i = 0; i < ids.length; i++) {
            Positionmain position = (Positionmain) kwlCommonTablesDAOObj
                    .getObject("com.krawler.hrms.recruitment.Positionmain", ids[i]);
            requestParams.put("status", statusstr);
            requestParams.put("applydate", date1);
            if (Integer.parseInt(request.getParameter("employeetype")) == 1) {
                requestParams.put("employee", user);
                requestParams.put("employeetype", 1);
            } else {
                requestParams.put("jobapplicant", applicant);
                requestParams.put("employeetype", 4); // 0 is changed to 4 for configured job application
            }
            requestParams.put("position", ids[i]);
            requestParams.put("company", cmp);
            requestParams.put("delflag", 0);
            requestParams.put("applicationflag", 0);
            requestParams.put("rejectedbefore", 0);
            positions += "" + position.getJobid() + ":" + position.getPosition().getValue() + ",";
            result = hrmsRecJobDAOObj.addAllapplications(requestParams);
            if (result.isSuccessFlag()) {
                if (Integer.parseInt(request.getParameter("employeetype")) == 1) {
                    auditTrailDAOObj.insertAuditLog(AuditAction.APPLY_FOR_JOB,
                            "User  " + profileHandlerDAOObj
                                    .getUserFullName(sessionHandlerImplObj.getUserid(request))
                                    + " has applied for job position " + position.getJobid(),
                            request, "0");
                    //@@ProfileHandler.insertAuditLog(session, AuditAction.APPLY_FOR_JOB, "User  " + AuthHandler.getFullName(session, AuthHandler.getUserid(request)) + " has applied for job position " + allapl.getPosition().getJobid(),request);
                } else {
                    if (request.getSession().getAttribute("userid") != null) {
                        //@@ProfileHandler.insertAuditLog(session, AuditAction.APPLY_FOR_JOB, "User  " + AuthHandler.getFullName(session, AuthHandler.getUserid(request)) + " has applied external applicant " + allapl.getJobapplicant().getFirstname() + " " + allapl.getJobapplicant().getLastname() + " for job position " + allapl.getPosition().getJobid(),request);
                        auditTrailDAOObj.insertAuditLog(AuditAction.APPLY_FOR_JOB,
                                "User  " + profileHandlerDAOObj
                                        .getUserFullName(sessionHandlerImplObj.getUserid(request))
                                        + " has applied external applicant " + applicant.getCol1() + " "
                                        + applicant.getCol2() + " for job position " + position.getJobid(),
                                request, "0");
                    }
                }
            }
        }
        /*if (!(Integer.parseInt(request.getParameter("employeetype")) == 1)) {
        String cmpname=cmp.getCompanyName();
        CompanyPreferences cmppref = (CompanyPreferences) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.CompanyPreferences", cmpname);
        positions = positions.replace(positions.substring(positions.length() - 1), "");
        String pmsg = String.format(HrmsMsgs.jobPlnmsg, (applicant.getFirstname() + " " + applicant.getLastname()),cmpname,cmpname);
        //                String htmlmsg = String.format(HrmsMsgs.jobHTMLmsg,allapl.getPosition().getPosition().getValue()+"["+cmp.getJobidformat()+allapl.getPosition().getJobidwthformat()+"]", cmpname, cmpname);
        String htmlmsg = String.format(HrmsMsgs.jobHTMLmsg,positions, cmpname, cmpname);
        String subject=String.format(HrmsMsgs.jobSubject,cmp.getJobidformat()+allapl.getPosition().getJobidwthformat(),allapl.getPosition().getPosition().getValue());
        try {
            SendMailHandler.postMail(new String[]{applicant.getEmail()}, subject, htmlmsg, pmsg, cmp.getEmailID());
        } catch (MessagingException e) {
            e.printStackTrace();
        }
        }*/
        jobj.put("success", true);
        jobj1.put("data", jobj.toString());
        jobj1.put("valid", true);
        txnManager.commit(status);
    } catch (Exception e) {
        e.printStackTrace();
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", jobj1.toString());
}

From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java

public ModelAndView canceljobexternal(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  ww  w  .j  a va 2 s. c o m

        String[] ids = request.getParameterValues("applicationid");
        for (int i = 0; i < ids.length; i++) {

            ArrayList<String> name = new ArrayList<String>();
            ArrayList<Object> value = new ArrayList<Object>();

            name.add("id");
            value.add(ids[i]);
            hrmsRecJobDAOObj.cancelAllapplications(name, value);
        }
        /*if (!(Integer.parseInt(request.getParameter("employeetype")) == 1)) {
        String cmpname=cmp.getCompanyName();
        CompanyPreferences cmppref = (CompanyPreferences) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.CompanyPreferences", cmpname);
        positions = positions.replace(positions.substring(positions.length() - 1), "");
        String pmsg = String.format(HrmsMsgs.jobPlnmsg, (applicant.getFirstname() + " " + applicant.getLastname()),cmpname,cmpname);
        //                String htmlmsg = String.format(HrmsMsgs.jobHTMLmsg,allapl.getPosition().getPosition().getValue()+"["+cmp.getJobidformat()+allapl.getPosition().getJobidwthformat()+"]", cmpname, cmpname);
        String htmlmsg = String.format(HrmsMsgs.jobHTMLmsg,positions, cmpname, cmpname);
        String subject=String.format(HrmsMsgs.jobSubject,cmp.getJobidformat()+allapl.getPosition().getJobidwthformat(),allapl.getPosition().getPosition().getValue());
        try {
            SendMailHandler.postMail(new String[]{applicant.getEmail()}, subject, htmlmsg, pmsg, cmp.getEmailID());
        } catch (MessagingException e) {
            e.printStackTrace();
        }
        }*/
        jobj.put("success", true);
        jobj1.put("data", jobj.toString());
        jobj1.put("valid", true);
        txnManager.commit(status);
    } catch (Exception e) {
        e.printStackTrace();
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", jobj1.toString());
}

From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java

public ModelAndView addRecruitersFunction(HttpServletRequest request, HttpServletResponse response) {
    //Status 0=pending,1=accepted,2=rejected,3=Not sent
    List tabledata = null;//w  w  w.  ja v  a2 s.  c  o m
    String hql = null;
    Recruiter pos = null;
    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>();
        ArrayList filter_names = new ArrayList(), filter_values = new ArrayList();

        String[] recids = null;
        String auditmsg = "";
        Company cmpid = (Company) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.Company",
                sessionHandlerImplObj.getCompanyid(request));
        User u = (User) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.User",
                sessionHandlerImplObj.getUserid(request));
        if (StringUtil.isNullOrEmpty(request.getParameter("delrec"))) {
            recids = request.getParameterValues("jobids");
            for (int i = 0; i < recids.length; i++) {

                requestParams.clear();
                filter_names.clear();
                filter_values.clear();

                filter_names.add("recruit.userID");
                filter_values.add(recids[i]);

                requestParams.put("filter_names", filter_names);
                requestParams.put("filter_values", filter_values);

                result = hrmsRecJobDAOObj.getRecruiter(requestParams);
                tabledata = result.getEntityList();
                requestParams.clear();
                if (!tabledata.isEmpty()) {
                    pos = (Recruiter) tabledata.get(0);

                    requestParams.put("Rid", pos.getRid());
                    requestParams.put("Delflag", 0);

                    auditmsg = "User  "
                            + profileHandlerDAOObj.getUserFullName(sessionHandlerImplObj.getUserid(request))
                            + " has set " + StringUtil.getFullName(pos.getRecruit()) + " as interviewer";
                } else {
                    User md = (User) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.User",
                            recids[i]);
                    requestParams.put("Delflag", 0);
                    //requestParams.put("Recruit",md);
                    requestParams.put("Recruit", recids[i]);

                    auditmsg = "User  "
                            + profileHandlerDAOObj.getUserFullName(sessionHandlerImplObj.getUserid(request))
                            + " has set " + StringUtil.getFullName(md) + " as interviewer";
                }

                result = hrmsRecJobDAOObj.setRecruiters(requestParams);
                if (result.isSuccessFlag()) {
                    auditTrailDAOObj.insertAuditLog(AuditAction.SET_AS_INTERVIEWER, auditmsg, request, "0");
                }
            }
        } else {
            String[] delrecids = request.getParameterValues("appid");
            for (int i = 0; i < delrecids.length; i++) {

                requestParams.clear();
                filter_names.clear();
                filter_values.clear();

                filter_names.add("recruit.userID");
                filter_values.add(delrecids[i]);

                requestParams.put("filter_names", filter_names);
                requestParams.put("filter_values", filter_values);

                result = hrmsRecJobDAOObj.getRecruiter(requestParams);
                tabledata = result.getEntityList();
                requestParams.clear();
                if (!tabledata.isEmpty()) {
                    pos = (Recruiter) tabledata.get(0);

                    requestParams.put("Rid", pos.getRid());
                    requestParams.put("Delflag", 3);

                    auditmsg = "User  " + StringUtil.getFullName(pos.getRecruit())
                            + " has been unassigned  as interviewer by "
                            + profileHandlerDAOObj.getUserFullName(sessionHandlerImplObj.getUserid(request));
                }

                result = hrmsRecJobDAOObj.setRecruiters(requestParams);
                if (result.isSuccessFlag()) {
                    auditTrailDAOObj.insertAuditLog(AuditAction.SET_AS_INTERVIEWER, auditmsg, request, "0");
                }
            }
        }
        if (StringUtil.isNullOrEmpty(request.getParameter("delrec"))) {
            for (int i = 0; i < recids.length; i++) {
                User r = (User) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.User", recids[i]);
                Useraccount ua = (Useraccount) kwlCommonTablesDAOObj
                        .getObject("com.krawler.common.admin.Useraccount", r.getUserID());
                String fullname = StringUtil.getFullName(r);
                String uri = URLUtil.getPageURL(request, Links.loginpagewthFull, cmpid.getSubDomain())
                        + "jspfiles/Confirmation.jsp?c=" + cmpid.getCompanyID() + "&u=" + r.getUserID()
                        + "&acpt=";
                String pmsg = String.format(HrmsMsgs.interviewerSelectionpln, fullname);
                String htmlmsg = String.format(HrmsMsgs.interviewerSelectionHTML, fullname, uri + "1",
                        uri + "0", StringUtil.getFullName(u), cmpid.getCompanyName());
                try {
                    SendMailHandler.postMail(new String[] { r.getEmailID() }, HrmsMsgs.interviewerSubject,
                            htmlmsg, pmsg, u.getEmailID());
                } catch (MessagingException e) {
                    e.printStackTrace();
                }
            }
        }
        jobj.put("success", true);
        jobj1.put("data", jobj.toString());
        jobj1.put("valid", true);
        txnManager.commit(status);
    } catch (Exception e) {
        e.printStackTrace();
        txnManager.rollback(status);
    }

    return new ModelAndView("jsonView", "model", jobj1.toString());
}

From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java

public ModelAndView saveConfigRecruitment(HttpServletRequest request, HttpServletResponse response) {
    //Status 0=pending,1=accepted,2=rejected,3=Not sent
    List tabledata = null;/*from w  w w  . ja va2 s .  c o  m*/
    JSONObject msg = new JSONObject();
    String hql = null;
    Recruiter pos = null;
    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> arrParam = new HashMap<String, Object>();
        HashMap<String, Object> requestParam = new HashMap<String, Object>();
        ArrayList<FileItem> hm = new ArrayList<FileItem>();
        boolean fileUpload = false;
        HashMap<Integer, String> filemap = new HashMap<Integer, String>();
        hrmsRecJobDAOObj.parseRequest(request, arrParam, hm, fileUpload, filemap);
        String auditmsg = "";
        result = hrmsRecJobDAOObj.addConfigRecruitmentData(arrParam);
        //                    if(result.isSuccessFlag()){
        //                        auditTrailDAOObj.insertAuditLog(AuditAction.SET_AS_INTERVIEWER, "User  " + profileHandlerDAOObj.getUserFullName(sessionHandlerImplObj.getUserid(request)) + " has edited " + profileHandlerDAOObj.getUserFullName(userid) + "'s profile", request, "0");
        //                    }
        ConfigRecruitmentData ConfigRecruitmentDataobj = (ConfigRecruitmentData) result.getEntityList().get(0);
        for (int j = 0; j < filemap.size(); j++) {
            HrmsDocs doc = hrmsRecJobDAOObj.uploadFile(hm.get(j), ConfigRecruitmentDataobj, arrParam, false);
            arrParam.clear();
            arrParam.put("Docid", doc.getDocid());
            arrParam.put("Recid", ConfigRecruitmentDataobj.getId());
            result = hrmsRecJobDAOObj.addHrmsDocmap(arrParam);
            requestParam.put(filemap.get(j), doc.getDocid());
            requestParam.put("Id", ConfigRecruitmentDataobj.getId());
        }
        result = hrmsRecJobDAOObj.addConfigRecruitmentData(requestParam);
        if (result.isSuccessFlag()) {
            auditTrailDAOObj.insertAuditLog(AuditAction.PROFILE_EDITED,
                    "User " + profileHandlerDAOObj.getUserFullName(AuthHandler.getUserid(request))
                            + " has Edited " + ConfigRecruitmentDataobj.getCol1() + " "
                            + ConfigRecruitmentDataobj.getCol2() + "'s profile",
                    request, "0");
        }
        msg.put("msg", messageSource.getMessage("hrms.Messages.calMsgBoxShow122", null,
                RequestContextUtils.getLocale(request)));
        msg.put("success", true);
        txnManager.commit(status);
    } catch (Exception e) {
        e.printStackTrace();
        txnManager.rollback(status);
    }

    return new ModelAndView("jsonView", "model", msg.toString());
}

From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java

public ModelAndView createapplicantFunction(HttpServletRequest request, HttpServletResponse response) {
    JSONObject jobj = new JSONObject();
    JSONObject jobj1 = new JSONObject();
    List list = null;/*from w  w  w .j  a v  a 2 s  .  co m*/
    SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd");
    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>();
        ArrayList filter_names = new ArrayList(), filter_values = new ArrayList();

        String pwd = request.getParameter("p");
        String username = request.getParameter("u");
        String fname = request.getParameter("fname");
        String lname = request.getParameter("lname");
        String cmpid = sessionHandlerImplObj.getCompanyid(request);
        if (StringUtil.isNullOrEmpty(request.getParameter("update"))) {

            filter_names.add("Col3");
            filter_values.add(request.getParameter("e"));
            filter_names.add("deleted");
            filter_values.add(false);
            filter_names.add("company.companyID");
            filter_values.add(cmpid);

            requestParams.put("filter_names", filter_names);
            requestParams.put("filter_values", filter_values);

            result = hrmsRecJobDAOObj.getConfigJobApplicant(requestParams);

            list = result.getEntityList();

            if (list.size() == 0) {
                Company cmp = (Company) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.Company",
                        cmpid);
                requestParams.clear();
                requestParams.put("Col1", fname);
                requestParams.put("Col2", lname);
                requestParams.put("Col3", request.getParameter("e"));
                //requestParams.put("Address1", request.getParameter("addr"));
                requestParams.put("Col4", request.getParameter("contact"));
                //                    requestParams.put("Username", username);
                //                    requestParams.put("Password", authHandler.getSHA1(pwd));
                //                    requestParams.put("Status", 0);
                requestParams.put("Company", cmpid);
                result = hrmsRecJobDAOObj.addConfigRecruitmentData(requestParams);
                if (result.isSuccessFlag()) {
                    /*String uri = URLUtil.getPageURL(request, Links.loginpagewthFull,cmp.getSubDomain())+"applicantLogin.html";
                    String pmsg = String.format(KWLErrorMsgs.msgMailInvite, fname, "Demo", username, pwd, uri, "Demo");
                    String htmlmsg = String.format(HrmsMsgs.msgMailInviteUsernamePassword, fname, profileHandlerDAOObj.getUserFullName( sessionHandlerImplObj.getUserid(request)), sessionHandlerImplObj.getCompanyName(request), username,
                        pwd, uri, uri, "");
                    try {
                    SendMailHandler.postMail(new String[]{request.getParameter("e")}, "["+messageSource.getMessage("hrms.common.deskera", null, RequestContextUtils.getLocale(request))+"] "+messageSource.getMessage("hrms.common.welcome.deskera.hrms", null, RequestContextUtils.getLocale(request)), htmlmsg, pmsg, "admin.hrms@mailinator.com");
                    } catch (MessagingException e) {
                    e.printStackTrace();
                    }*/
                    jobj.put("msg", messageSource.getMessage("hrms.common.Applicantcreatedsuccessfully", null,
                            RequestContextUtils.getLocale(request)));
                    jobj.put("type", messageSource.getMessage("hrms.common.success", null,
                            RequestContextUtils.getLocale(request)));
                    //@@ProfileHandler.insertAuditLog(session, AuditAction.CREATE_APPLICANT, "User  " + AuthHandler.getFullName(session, AuthHandler.getUserid(request)) + " has created new applicant " + jobapp.getFirstname() + " " + jobapp.getLastname(),request);
                    auditTrailDAOObj.insertAuditLog(AuditAction.CREATE_APPLICANT,
                            "User  " + profileHandlerDAOObj
                                    .getUserFullName(sessionHandlerImplObj.getUserid(request))
                                    + " has created new applicant " + fname + " " + lname,
                            request, "0");
                } else {
                    jobj.put("msg",
                            messageSource.getMessage("hrms.recruitment.error.occurred.creating.applicant", null,
                                    RequestContextUtils.getLocale(request)));
                    jobj.put("type", messageSource.getMessage("hrms.common.error", null,
                            RequestContextUtils.getLocale(request)));
                }
            } else {
                jobj.put("msg", messageSource.getMessage("hrms.common.email.already.exists", null,
                        RequestContextUtils.getLocale(request)));
                jobj.put("type", messageSource.getMessage("hrms.common.warning", null,
                        RequestContextUtils.getLocale(request)));
            }
        } else {
            requestParams.put("primary", true);
            requestParams.put("applicantid", request.getParameter("profileid"));

            result = hrmsRecJobDAOObj.getConfigJobApplicant(requestParams);
            list = result.getEntityList();
            if (!list.isEmpty()) {
                String jsondata1 = request.getParameter("jsondata1");
                String jsondata2 = request.getParameter("jsondata2");
                String jsondata3 = request.getParameter("jsondata3");
                String jsondata4 = request.getParameter("jsondata4");
                String jsondata5 = request.getParameter("jsondata5");

                requestParams.clear();

                requestParams.put("Applicantid", request.getParameter("profileid"));
                if (jsondata1.length() > 0) {
                    jobj = new JSONObject(jsondata1);
                    requestParams.put("Title", jobj.getString("title"));
                    requestParams.put("Firstname", jobj.getString("firstname"));
                    requestParams.put("Lastname", jobj.getString("lastname"));
                    requestParams.put("Email", jobj.getString("email"));
                    requestParams.put("Otheremail", jobj.getString("otheremail"));
                    requestParams.put("Birthdate", (Date) fmt.parse(jobj.getString("birthdate")));
                }
                if (jsondata2.length() > 0) {
                    jobj = new JSONObject(jsondata2);
                    requestParams.put("Contactno", jobj.getString("contactno"));
                    requestParams.put("Mobileno", jobj.getString("mobileno"));
                    requestParams.put("City", jobj.getString("city"));
                    requestParams.put("State", jobj.getString("state"));
                    requestParams.put("Countryid", jobj.getString("country"));
                    requestParams.put("Address1", jobj.getString("address1"));
                    requestParams.put("Address2", jobj.getString("address2"));

                }
                if (jsondata3.length() > 0) {
                    jobj = new JSONObject(jsondata3);
                    if (StringUtil.isNullOrEmpty(jobj.getString("graddegree")) == false) {
                        requestParams.put("Graddegree", jobj.getString("graddegree"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("gradspecilization")) == false) {
                        requestParams.put("Gradspecialization", jobj.getString("gradspecilization"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("gradcollege")) == false) {
                        requestParams.put("Gradcollege", jobj.getString("gradcollege"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("graduniversity")) == false) {
                        requestParams.put("Graduniversity", jobj.getString("graduniversity"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("gradepercent")) == false) {
                        requestParams.put("Gradpercent", jobj.getString("gradepercent"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("gradpassdate")) == false) {
                        requestParams.put("Gradpassdate", (Date) fmt.parse(jobj.getString("gradpassdate")));
                    }

                    if (StringUtil.isNullOrEmpty(jobj.getString("pgqualification")) == false) {
                        requestParams.put("Pgqualification", jobj.getString("pgqualification"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("pgspecialization")) == false) {
                        requestParams.put("Pgspecialization", jobj.getString("pgspecialization"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("pgcollege")) == false) {
                        requestParams.put("Pgcollege", jobj.getString("pgcollege"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("pguniversity")) == false) {
                        requestParams.put("Pguniversity", jobj.getString("pguniversity"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("pgpercent")) == false) {
                        requestParams.put("Pgpercent", jobj.getString("pgpercent"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("pgpassdate")) == false) {
                        requestParams.put("Pgpassdate", (Date) fmt.parse(jobj.getString("pgpassdate")));
                    }

                    if (StringUtil.isNullOrEmpty(jobj.getString("othername")) == false) {
                        requestParams.put("Othername", jobj.getString("othername"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("otherqualification")) == false) {
                        requestParams.put("Otherqualification", jobj.getString("otherqualification"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("otherpercent")) == false) {
                        requestParams.put("Otherpercent", jobj.getString("otherpercent"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("otherdetails")) == false) {
                        requestParams.put("Otherdetails", jobj.getString("otherdetails"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("otherpassdate")) == false) {
                        requestParams.put("Otherpassdate", (Date) fmt.parse(jobj.getString("otherpassdate")));
                    }
                }
                if (jsondata4.length() > 0) {
                    jobj = new JSONObject(jsondata4);
                    if (jobj.getString("experiencemonth").equals("")) {
                        requestParams.put("Experiencemonth", 0);
                    } else {
                        requestParams.put("Experiencemonth",
                                Integer.parseInt(jobj.getString("experiencemonth")));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("experienceyear")) == false) {
                        requestParams.put("Experienceyear", Integer.parseInt(jobj.getString("experienceyear")));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("functionalexpertise")) == false) {
                        requestParams.put("Functionalexpertise", jobj.getString("functionalexpertise"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("currentindustry")) == false) {
                        requestParams.put("Currentindustry", jobj.getString("currentindustry"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("currentorganization")) == false) {
                        requestParams.put("Currentorganization", jobj.getString("currentorganization"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("currentdesignation")) == false) {
                        requestParams.put("Currentdesignation", jobj.getString("currentdesignation"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("grosssalary")) == false) {
                        requestParams.put("Grosssalary", Integer.parseInt(jobj.getString("grosssalary")));
                    }
                    requestParams.put("Expectedsalary", Integer.parseInt(jobj.getString("expectedsalary")));
                }
                if (jsondata5.length() > 0) {
                    jobj = new JSONObject(jsondata5);
                    requestParams.put("Keyskills", jobj.getString("keyskills"));
                    if (StringUtil.isNullOrEmpty(jobj.getString("category")) == false) {
                        requestParams.put("Category", jobj.getString("category"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("filepath")) == false) {
                        requestParams.put("Filepath", jobj.getString("filepath"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("companyrelative")) == false) {
                        requestParams.put("Companyrelative", jobj.getString("companyrelative"));
                    }
                    if (StringUtil.isNullOrEmpty(jobj.getString("appearedbefore")) == false) {
                        requestParams.put("Appearedbefore", jobj.getString("appearedbefore"));
                        if (jobj.getString("appearedbefore").equalsIgnoreCase("yes")) {
                            if (StringUtil.isNullOrEmpty(jobj.getString("interviewplace")) == false) {
                                requestParams.put("Interviewplace", jobj.getString("interviewplace"));
                            }
                            if (StringUtil.isNullOrEmpty(jobj.getString("interviewdate")) == false) {
                                requestParams.put("Interviewdate",
                                        (Date) fmt.parse(jobj.getString("interviewdate")));
                            }
                            if (StringUtil.isNullOrEmpty(jobj.getString("interviewposition")) == false) {
                                requestParams.put("Interviewposition", jobj.getString("interviewposition"));
                            }
                        }
                    }
                    requestParams.put("Interviewlocation", jobj.getString("interviewlocation"));
                    result = hrmsRecJobDAOObj.setJobApplicant(requestParams);
                }
                // insertConfigData(request, "Recruitment", request.getParameter("profileid"),sessionHandlerImplObj.getCompanyid(request));
                hrmsCommonDAOObj.insertConfigData(request, "Recruitment", request.getParameter("profileid"),
                        sessionHandlerImplObj.getCompanyid(request));
            }
            if (result.isSuccessFlag()) {
                jobj.put("msg", messageSource.getMessage("hrms.recruitment.applicant.updated.successfully",
                        null, RequestContextUtils.getLocale(request)));
                jobj.put("type", messageSource.getMessage("hrms.common.success", null,
                        RequestContextUtils.getLocale(request)));
            } else {
                jobj.put("msg", messageSource.getMessage("hrms.recruitment.error.occurred.updating.applicant",
                        null, RequestContextUtils.getLocale(request)));
                jobj.put("type", messageSource.getMessage("hrms.common.error", null,
                        RequestContextUtils.getLocale(request)));
            }
        }
        jobj1.put("data", jobj.toString());
        jobj1.put("valid", true);
        txnManager.commit(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 transferappdata(HttpServletRequest request, HttpServletResponse response)
        throws ServiceException {
    KwlReturnObject result = null;//from  w w  w.j  av  a 2 s  . com
    JSONObject jobj = new JSONObject();
    JSONObject jobj1 = new JSONObject();
    int dt = 0;
    HashMap<String, Object> requestParams = new HashMap<String, Object>();
    HashMap<String, Integer> datatransfer = new HashMap<String, Integer>();
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);
    datatransfer.put("count", dt);
    try {
        String appid = request.getParameter("applicantid");
        String mappedHeaders = request.getParameter("mappedheader");

        requestParams.put("employeetype", request.getParameter("employeetype"));
        requestParams.put("employeeid", request.getParameter("employeeid"));
        requestParams.put("appusername", request.getParameter("appusername"));
        requestParams.put("applicantid", appid);
        requestParams.put("designationid", request.getParameter("designationid"));
        requestParams.put("empjoindate", request.getParameter("empjoindate"));
        requestParams.put("departmentid", request.getParameter("departmentid"));
        requestParams.put("employeerectype", request.getParameter("employeerectype"));

        if (request.getParameter("employeerectype").toString().equalsIgnoreCase("0")) {
            com.krawler.utils.json.base.JSONObject headers = new com.krawler.utils.json.base.JSONObject(
                    mappedHeaders);
            requestParams.put("middlename", fetchField(headers, "Middle Name", appid, false, datatransfer));
            requestParams.put("dob", fetchField(headers, "Date Of Birth", appid, true, datatransfer));
            requestParams.put("gender", fetchField(headers, "Gender", appid, false, datatransfer));
            requestParams.put("maritalstatus",
                    fetchField(headers, "Marital Status", appid, false, datatransfer));
            requestParams.put("bloodgroup", fetchField(headers, "Blood Group", appid, false, datatransfer));
            requestParams.put("fathername", fetchField(headers, "Father's Name", appid, false, datatransfer));
            requestParams.put("fatherdob", fetchField(headers, "Father's DOB", appid, true, datatransfer));
            requestParams.put("mothername", fetchField(headers, "Mother's Name", appid, false, datatransfer));
            requestParams.put("motherdob", fetchField(headers, "Mother's DOB", appid, true, datatransfer));
            requestParams.put("keyskill", fetchField(headers, "Key Skills", appid, false, datatransfer));
            requestParams.put("panno", fetchField(headers, "PAN No", appid, false, datatransfer));
            requestParams.put("epfno", fetchField(headers, "EPF No", appid, false, datatransfer));
            requestParams.put("drivingno",
                    fetchField(headers, "Driving License No", appid, false, datatransfer));
            requestParams.put("passportno", fetchField(headers, "Passport No", appid, false, datatransfer));
            requestParams.put("exdateofpassport",
                    fetchField(headers, "Expiry Date of Passport", appid, true, datatransfer));
            requestParams.put("mobileno", fetchField(headers, "Mobile no", appid, false, datatransfer));
            requestParams.put("landlineno", fetchField(headers, "Landline No", appid, false, datatransfer));
            requestParams.put("otheremail", fetchField(headers, "Other Email", appid, false, datatransfer));
            requestParams.put("permanentaddress",
                    fetchField(headers, "Permanent Address", appid, false, datatransfer));
            requestParams.put("presentaddress",
                    fetchField(headers, "Present Address", appid, false, datatransfer));
            requestParams.put("presentcity", fetchField(headers, "Present City", appid, false, datatransfer));
            requestParams.put("presentstate", fetchField(headers, "Present State", appid, false, datatransfer));
            requestParams.put("presentcountry",
                    fetchField(headers, "Present Country", appid, false, datatransfer));
            requestParams.put("Permanentcity",
                    fetchField(headers, "Permanent City", appid, false, datatransfer));
            requestParams.put("Permanentstate",
                    fetchField(headers, "Permanent State", appid, false, datatransfer));
            requestParams.put("Permanentcountry",
                    fetchField(headers, "Permanent Country", appid, false, datatransfer));
        }

        requestParams.put("companyid", sessionHandlerImplObj.getCompanyid(request));
        requestParams.put("userid", sessionHandlerImplObj.getUserid(request));
        result = hrmsRecJobDAOObj.transferappdata(requestParams);
        User relatedTo = ((ArrayList<User>) result.getEntityList()).get(0);

        if (request.getParameter("employeerectype").toString().equalsIgnoreCase("0")) {//For External Applicant Only(Uploaded Documents transfer to Employee data.)
            KwlReturnObject kwlReturnObject1 = null;
            KwlReturnObject kwlReturnObject2 = null;
            KwlReturnObject kwlReturnObject3 = null;
            String userid = request.getParameter("applicantid");
            ArrayList<String> filter_names = new ArrayList<String>();
            ArrayList<Object> filter_values = new ArrayList<Object>();
            filter_names.add("recid");
            filter_values.add(userid);
            filter_names.add("docid.deleted");
            filter_values.add(false);
            filter_names.add("docid.referenceid");
            filter_values.add(userid);
            requestParams.put("filter_names", filter_names);
            requestParams.put("filter_values", filter_values);
            kwlReturnObject1 = hrmsExtApplDocsDAOObj.getDocs(requestParams);
            ArrayList<HrmsDocmap> hrmsDocmaps = (ArrayList<HrmsDocmap>) kwlReturnObject1.getEntityList();
            kwlReturnObject2 = hrmsRecJobDAOObj.transferExternalAppDocs(hrmsDocmaps, relatedTo);
            kwlReturnObject3 = hrmsRecJobDAOObj.transferExternalAppDocMaps(hrmsDocmaps,
                    (ArrayList<Docs>) kwlReturnObject2.getEntityList(), relatedTo);
        }

        jobj.put("success", result.isSuccessFlag());
        if (result.isSuccessFlag())
            auditTrailDAOObj.insertAuditLog(AuditAction.TRANSFER_APPLICANT,
                    "User  " + profileHandlerDAOObj.getUserFullName(sessionHandlerImplObj.getUserid(request))
                            + " has transfered " + request.getParameter("appusername") + "'s applicants data",
                    request, "0");

        if (datatransfer.get("count") > 0 && result.getMsg().equals("Applicant data trasfered successfully.")) {
            jobj.put("msg", messageSource.getMessage("hrms.recruitment.data.not.transfer.incorrect.mapping",
                    null, RequestContextUtils.getLocale(request)));
        } else {
            jobj.put("msg", result.getMsg());
        }
        jobj1.put("data", jobj);
        jobj1.put("valid", true);
        if (result.isSuccessFlag()) {
            txnManager.commit(status);
        } else {
            txnManager.rollback(status);
        }
    } catch (Exception ex) {
        txnManager.rollback(status);
        ex.printStackTrace();
    }
    return new ModelAndView(successView, "model", jobj1.toString());
}