Example usage for org.springframework.transaction.support DefaultTransactionDefinition setName

List of usage examples for org.springframework.transaction.support DefaultTransactionDefinition setName

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.transaction.support.*
  5. DefaultTransactionDefinition
  6. setName

Introduction

In this page you can find the example usage for org.springframework.transaction.support DefaultTransactionDefinition setName.

Prototype

public final void setName(String name)

Source Link

Document

Set the name of this transaction.

Usage

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

public ModelAndView DeleteInternalJobs(HttpServletRequest request, HttpServletResponse response) {
    List tabledata = null;//from w  ww  .j  a  v  a2  s.com
    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 sendLetters(HttpServletRequest request, HttpServletResponse response) {
    KwlReturnObject result = null;//from  w  w  w.  ja va2 s  . c  o m
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);

    try {

        //code for history of emails to be sent
        //  String records = request.getParameter("records");
        JSONArray recordsArr = new JSONArray(request.getParameter("userlist"));
        //       HtmlTemplate ht = (HtmlTemplate)hibernateTemplate.get(HtmlTemplate.class, request.getParameter("templateid"));

        HashMap<String, Object> requestParams = new HashMap<String, Object>();
        Date curDate = new Date();
        for (int i = 0; i < recordsArr.length(); i++) {
            //           User usr = (User)hibernateTemplate.get(User.class, recordsArr.getJSONObject(i).getString("uid"));
            //              Allapplications ap = (Allapplications)hibernateTemplate.get(Allapplications.class, recordsArr.getJSONObject(i).getString("uid"));

            // if(usr==null)continue;

            //      requestParams.put("user", usr);
            requestParams.put("appid", recordsArr.getJSONObject(i).getString("uid"));
            requestParams.put("emailid", recordsArr.getJSONObject(i).getString("emailid"));
            requestParams.put("templateid", request.getParameter("templateid"));
            //          requestParams.put("templatename",ht.getName());
            requestParams.put("savedate", curDate);
            Locale locale = RequestContextUtils.getLocale(request);
            requestParams.put("locale", locale);
            result = hrmsRecJobDAOObj.saveLetterHistory(requestParams);
            requestParams.clear();

        }

        //txnManager.commit(status);//transaction commits here

        //code for sending emails start here
        requestParams.put("userid", sessionHandlerImplObj.getUserid(request));
        List usrObj = hrmsRecJobDAOObj.getUser(requestParams).getEntityList();
        String fromName = "";
        String fromEmail = "";
        if (usrObj.size() > 0) {
            User senderU = (User) usrObj.get(0);
            fromName = senderU.getFirstName() + "  " + senderU.getLastName();
            fromEmail = senderU.getEmailID();
        }

        requestParams.clear();

        requestParams.put("templateid", request.getParameter("templateid"));
        List htmltemplateObj = hrmsRecJobDAOObj.getHtmlTemplate(requestParams).getEntityList();
        HtmlTemplate ht = (HtmlTemplate) htmltemplateObj.get(0);
        String mail_subject = ht.getSubject() == null ? "" : ht.getSubject();
        String htmlLetter = ht.getText();
        if (htmlLetter == null)
            htmlLetter = "";
        String textLetter = URLDecoder.decode(htmlLetter, "utf-8");
        htmlLetter = URLDecoder.decode(htmlLetter, "utf-8");
        ArrayList<String[]> al = getPlaceHolderPairs(textLetter);

        ArrayList<String[]> phPaths = getPlaceHolderPathLookup(al);

        String cid = sessionHandlerImplObj.getCompanyid(request);
        String toEmail = null;
        ArrayList<String[]> userBasedLetterValues = null;
        for (int i = 0; i < recordsArr.length(); i++) {//user based code for iteration
            //applicant id =   recordsArr.getJSONObject(i).getString("uid");
            //code for getting user values remained

            userBasedLetterValues/*for single user*/ = getUserLetterValues(
                    recordsArr.getJSONObject(i).getString("uid"), cid, phPaths);
            StringBuffer textletter_sbf = new StringBuffer(textLetter);
            StringBuffer htmlletter_sbf = new StringBuffer(htmlLetter);

            getConvertedLetter(textletter_sbf, htmlletter_sbf, userBasedLetterValues);//converting letter

            toEmail = recordsArr.getJSONObject(i).getString("emailid");

            //String[] recipients,String subject,String htmlMsg,String plainMsg,String fromAddress,String fromName
            SendMailHandler.postMail(new String[] { toEmail }, mail_subject, htmlletter_sbf.toString(),
                    textletter_sbf.toString(), fromEmail, fromName);
            if (result.isSuccessFlag())
                auditTrailDAOObj.insertAuditLog(AuditAction.SEND_LETTERS,
                        "User  " + profileHandlerDAOObj
                                .getUserFullName(sessionHandlerImplObj.getUserid(request))
                                + " has send letter to " + recordsArr.getJSONObject(i).getString("uname"),
                        request, "0");
        }
        txnManager.commit(status);//transaction commits here
    } catch (Exception e) {
        e.printStackTrace();
        result = new KwlReturnObject(false, "{\"valid\":\"true\",\"success\":\"true\",data:{msg:\""
                + e.getMessage() + "\",value:\"failed\"}}", "", null, 0);
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", result.getMsg());
}

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

public ModelAndView applyforjobexternal(HttpServletRequest request, HttpServletResponse response) {
    String statusstr = "Pending";
    Date date1;/*from  w ww  .j av  a  2 s.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 transferappdata(HttpServletRequest request, HttpServletResponse response)
        throws ServiceException {
    KwlReturnObject result = null;//  w  w w .  j  av  a 2s .  c om
    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());
}

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;//from w w  w. j a v a  2  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 editProspect(HttpServletRequest request, HttpServletResponse response) {
    Date joiningdate = null;/*from   w ww. j  av a2  s.com*/
    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 InternalJobpositions(HttpServletRequest request, HttpServletResponse response) {
    Date date = null;//  w w w .  j a v a 2 s.  co 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 scheduleinterview(HttpServletRequest request, HttpServletResponse response) {
    Date date1;/*from   w ww .  j a v a 2s.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 createapplicantFunction(HttpServletRequest request, HttpServletResponse response) {
    JSONObject jobj = new JSONObject();
    JSONObject jobj1 = new JSONObject();
    List list = null;// w  w w.ja va  2  s .com
    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:org.broadleafcommerce.common.util.TransactionUtils.java

public static TransactionStatus createTransaction(String name, int propagationBehavior, int isolationLevel,
        PlatformTransactionManager transactionManager, boolean isReadOnly) {
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName(name);
    def.setReadOnly(isReadOnly);/* w  w  w. ja v  a2  s.  c  om*/
    def.setPropagationBehavior(propagationBehavior);
    def.setIsolationLevel(isolationLevel);
    return transactionManager.getTransaction(def);
}