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

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

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

Introduction

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

Prototype

public DefaultTransactionDefinition()

Source Link

Document

Create a new DefaultTransactionDefinition, with default settings.

Usage

From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java

public ModelAndView deleteBouncedTargets(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject myjobj = null;/*from   ww w .j a  v  a 2 s  .  c  o  m*/
    KwlReturnObject kmsg = null;
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);
    try {
        myjobj = new JSONObject();
        myjobj.put("success", false);
        String[] targets = request.getParameter("targets").split(",");
        kmsg = bounceHandlerImplObj.deleteBouncedTargets(targets);
        myjobj.put("success", kmsg.isSuccessFlag());
        txnManager.commit(status);
    } catch (JSONException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    } catch (Exception e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", myjobj.toString());
}

From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java

public ModelAndView sendTemplateTestMail(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject myjobj = null;//from ww w. j a  v a  2  s.  c o m
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);
    try {
        myjobj = new JSONObject();
        String bodyhtml = StringUtil.checkForNull(request.getParameter("bodyhtml"));
        String subject = StringUtil.checkForNull(request.getParameter("tsubject"));
        User user = profileHandlerDAOObj.getUserObject(sessionHandlerImpl.getUserid(request));
        String mailid = StringUtil.checkForNull(user.getEmailID());
        myjobj.put("valid", true);
        if (!StringUtil.isNullOrEmpty(mailid)) {
            try {
                String baseUrl = com.krawler.common.util.URLUtil.getRequestPageURL(request,
                        Links.UnprotectedLoginPageFull);
                bodyhtml = bodyhtml.replaceAll("src=\"[^\"]*?video.jsp", "src=\"" + baseUrl + "video.jsp");
                SendMailHandler.postMail(new String[] { mailid }, subject, bodyhtml, "",
                        storageHandlerImpl.GetNewsLetterAddress());
                myjobj.put("data", "{success: true, msg: Test mail sent to your registerd mail id}");
            } catch (Exception e) {
                myjobj.put("data", "{success: true, msg: " + e.getMessage() + "}");
            }
        } else {
            myjobj.put("data", "{success: false, errormsg: No emailid specified}");
        }
        txnManager.commit(status);
    } catch (JSONException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    } catch (Exception e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", myjobj.toString());
}

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

public ModelAndView applyforjobexternal(HttpServletRequest request, HttpServletResponse response) {
    String statusstr = "Pending";
    Date date1;/*  w ww .  ja v a 2 s.c om*/
    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.crm.emailMarketing.crmEmailMarketingController.java

public RedirectView trackUrl(HttpServletRequest request, HttpServletResponse response) throws ServletException {
    String origUrl = request.getParameter("origurl");
    String trackid = request.getParameter("trackid");
    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 {//  w ww  . ja  v a2 s  .  c om
        crmEmailMarketingDAOObj.trackUrl(trackid, origUrl, new Date());
        txnManager.commit(status);
    } catch (ServiceException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    }
    return new RedirectView(origUrl);
}

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 w ww .j ava  2s. 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;//from ww w  . j a  va 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.crm.emailMarketing.crmEmailMarketingController.java

public ModelAndView updateEmailMarketingDefaults(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    String emid = request.getParameter("emailmarketingid");
    JSONObject jobj = new JSONObject();
    EmailMarketingDefault emDefault;/*from  w w  w  .  ja v a 2  s .  c  o  m*/

    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 {
        JSONArray jArr = new JSONArray(request.getParameter("defaults"));
        crmEmailMarketingDAOObj.removeEmailMarketingDefaults(emid);
        EmailMarketing em = crmEmailMarketingDAOObj.getEmailMarketing(emid);
        for (int i = 0; i < jArr.length(); i++) {
            JSONObject obj = jArr.getJSONObject(i);
            emDefault = new EmailMarketingDefault();
            emDefault.setEmailMarketing(em);
            emDefault.setVariableName(obj.getString("varname"));
            emDefault.setDefaultValue(obj.getString("varval"));
            crmEmailMarketingDAOObj.saveEmailMarketingDefault(emDefault);
        }
        txnManager.commit(status);
    } catch (JSONException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    } catch (ServiceException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", jobj.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;/*ww w. j  av  a2 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.siblinks.ws.service.impl.VideoServiceImpl.java

/**
 * {@inheritDoc}//from  w ww .j  a v a 2s  .co m
 */
@Override
@RequestMapping(value = "/insertVideo", method = RequestMethod.POST)
public ResponseEntity<Response> insertVideo(@RequestBody final RequestData request) {
    SimpleResponse response = null;
    try {
        String strDescription = request.getRequest_data().getDescription();
        String strTitle = request.getRequest_data().getTitle();
        String duration = request.getRequest_data().getRunningTime();
        String subjectId = request.getRequest_data().getSubjectId();
        if (strTitle == null || strTitle.isEmpty()) {
            response = new SimpleResponse(SibConstants.FAILURE, "videos", "insertVideo",
                    "Title can not be empty");
        } else if (duration == null || duration.isEmpty()) {
            response = new SimpleResponse(SibConstants.FAILURE, "videos", "insertVideo",
                    "Running time can not be empty");
        } else if (subjectId == null || subjectId.isEmpty() || Integer.parseInt(subjectId) == 0) {
            response = new SimpleResponse(SibConstants.FAILURE, "videos", "insertVideo", "Subject is required");
        } else if (strDescription != null && strDescription.length() > 1024) {
            response = new SimpleResponse(SibConstants.FAILURE, "videos", "insertVideo",
                    "Description can not longer than 1024 characters");
        } else {
            TransactionDefinition def = new DefaultTransactionDefinition();
            TransactionStatus status = transactionManager.getTransaction(def);
            String authorId = request.getRequest_data().getAuthorID();
            String plid = request.getRequest_data().getPlid();

            Object[] queryParams;

            String entityName = null;

            List<Object> readObject = null;
            try {

                List<Map<String, String>> allWordFilter = cachedDao.getAllWordFilter();
                strDescription = CommonUtil.filterWord(strDescription, allWordFilter);
                strTitle = CommonUtil.filterWord(strTitle, allWordFilter);

                // insert video
                entityName = SibConstants.SqlMapperBROT43.SQL_INSERT_VIDEO;
                queryParams = new Object[] { strTitle, strDescription, request.getRequest_data().getUrl(),
                        request.getRequest_data().getRunningTime(), request.getRequest_data().getImage(),
                        request.getRequest_data().getSubjectId(), authorId };
                long vid = dao.insertObject(entityName, queryParams);

                if (plid != null && plid.length() > 0) {
                    queryParams = new Object[] { plid, vid };
                    dao.insertUpdateObject(SibConstants.SqlMapperBROT126.SQL_ADD_VIDEOS_PLAYLIST, queryParams);
                }

                // get list users that subscribed mentor
                entityName = SibConstants.SqlMapperBROT43.SQL_GET_STUDENT_SUBSCRIBE;
                queryParams = new Object[] { authorId };
                readObject = dao.readObjects(entityName, queryParams);

                if (readObject != null && !readObject.isEmpty() && readObject.size() > 0) {
                    entityName = SibConstants.SqlMapperBROT43.SQL_INSERT_VIDEO_SUBCRIBE;
                    for (Object object : readObject) {
                        JsonObject json = new JsonParser().parse(object.toString()).getAsJsonObject();
                        long studentId = json.get("studentid").getAsLong();
                        queryParams = new Object[] { vid + ",", authorId, studentId };
                        dao.insertUpdateObject(entityName, queryParams);
                    }
                }
                activiLogService.insertActivityLog(new ActivityLogData(SibConstants.TYPE_VIDEO, "C",
                        "You uploaded a new video", String.valueOf(authorId), String.valueOf(vid)));
                transactionManager.commit(status);
                response = new SimpleResponse(SibConstants.SUCCESS, "videos", "insertVideo", "Success");
            } catch (Exception e) {
                response = new SimpleResponse(SibConstants.SUCCESS, "videos", "insertVideo", "Failed");
                transactionManager.rollback(status);
                logger.debug(e.getMessage());
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
        response = new SimpleResponse(SibConstants.FAILURE, request.getRequest_data_type(),
                request.getRequest_data_method(), e.getMessage());
    }
    return new ResponseEntity<Response>(response, HttpStatus.OK);
}

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  a2  s.c  o 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());
    }
}