Example usage for org.springframework.transaction TransactionDefinition ISOLATION_READ_UNCOMMITTED

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

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

Introduction

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

Prototype

int ISOLATION_READ_UNCOMMITTED

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

Click Source Link

Document

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

Usage

From source file:com.krawler.spring.crm.common.commentController.java

public ModelAndView addComments(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject jobj = new JSONObject();
    JSONObject myjobj = new JSONObject();
    KwlReturnObject kmsg = null;//  w ww  . j  av  a  2  s.co  m
    Object c;
    String details = "";
    String auditAction = "";
    String id = java.util.UUID.randomUUID().toString();
    String randomnumber = request.getParameter("randomnumber");
    String moduleName = request.getParameter("modulename");
    String jsondata = request.getParameter("jsondata");
    String map = "";
    String refid = "";
    //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 userid = sessionHandlerImpl.getUserid(request);
        String companyid = sessionHandlerImpl.getCompanyid(request);
        JSONArray jarr = new JSONArray("[" + jsondata + "]");
        for (int i = 0; i < jarr.length(); i++) {
            jobj = jarr.getJSONObject(i);
            map = jobj.getString("mapid");
            refid = jobj.getString("leadid");
            String commStrAudit = StringUtil.serverHTMLStripper(jobj.getString("comment"));
            commStrAudit = commStrAudit.replaceAll("&nbsp;", "");
            String cid = java.util.UUID.randomUUID().toString();
            String commentid = jobj.getString("commentid");
            jobj.put("userid", userid);
            jobj.put("companyid", companyid);
            jobj.put("cid", cid);
            jobj.put("refid", refid);
            if (StringUtil.isNullOrEmpty(commentid)) { // Add Mode
                jobj.put("id", id);
                if (moduleName.equals(Constants.Case)) {//Case                                      
                    crmCommentDAOObj.addCaseComments(jobj);
                } else {
                    kmsg = crmCommentDAOObj.addComments(jobj);
                }
            } else { // Edit Mode

                jobj.put("id", commentid.trim());
                if (moduleName.equals(Constants.Case)) {
                    kmsg = crmCommentDAOObj.editCaseComments(jobj);
                } else {
                    kmsg = crmCommentDAOObj.editComments(jobj);
                }
            }

            //@@@ - Need to restructure this code
            if (map.equals("0")) {
                c = hibernateTemplate.get("com.krawler.crm.database.tables.CrmCampaign", refid);
                details = " Campaign - ";
                details += StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "campaignname")) ? ""
                        : BeanUtils.getProperty(c, "campaignname");
                auditAction = AuditAction.CAMPAIGN_ADD_COMMENTS;
            } else if (map.equals("1")) {
                c = hibernateTemplate.get("com.krawler.crm.database.tables.CrmLead", refid);
                details = " Lead - ";
                details += StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "firstname")) ? ""
                        : BeanUtils.getProperty(c, "firstname") + " ";
                details += StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "lastname")) ? ""
                        : BeanUtils.getProperty(c, "lastname");
                auditAction = AuditAction.LEAD_ADD_COMMENTS;
            } else if (map.equals("2")) {
                c = hibernateTemplate.get("com.krawler.crm.database.tables.CrmContact", refid);
                details = " Contact - ";
                details += StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "firstname")) ? ""
                        : BeanUtils.getProperty(c, "firstname");
                details += StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "lastname")) ? ""
                        : BeanUtils.getProperty(c, "lastname");
                auditAction = AuditAction.CONTACT_ADD_COMMENTS;
            } else if (map.equals("3")) {
                c = hibernateTemplate.get("com.krawler.crm.database.tables.CrmProduct", refid);
                details = " Product - ";
                details += StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "productname")) ? ""
                        : BeanUtils.getProperty(c, "productname");
                auditAction = AuditAction.PRODUCT_ADD_COMMENTS;
            } else if (map.equals("4")) {
                c = hibernateTemplate.get("com.krawler.crm.database.tables.CrmAccount", refid);
                details = " Account - ";
                details += StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "accountname")) ? ""
                        : BeanUtils.getProperty(c, "accountname");
                auditAction = AuditAction.ACCOUNT_ADD_COMMENTS;
            } else if (map.equals("5")) {
                c = hibernateTemplate.get("com.krawler.crm.database.tables.CrmOpportunity", refid);
                details = " Opportunity - ";
                details += StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "oppname")) ? ""
                        : BeanUtils.getProperty(c, "oppname");
                auditAction = AuditAction.OPPORTUNITY_ADD_COMMENTS;
            } else if (map.equals("6")) {
                c = hibernateTemplate.get("com.krawler.crm.database.tables.CrmCase", refid);
                details = " Case - ";
                details += StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "subject")) ? ""
                        : BeanUtils.getProperty(c, "subject");
                auditAction = AuditAction.CASE_ADD_COMMENTS;
            } else if (map.equals("7")) {
                c = hibernateTemplate.get("com.krawler.crm.database.tables.CrmActivityMaster", refid);
                String subject = StringUtil.isNullOrEmpty(BeanUtils.getProperty(c, "subject")) ? ""
                        : "(" + BeanUtils.getProperty(c, "subject") + ")";
                //                      String aname = BeanUtils.getProperty(c,"crmCombodataByStatusid.aliasName");
                //                    if(!StringUtil.isNullOrEmpty(aname)){
                //                        comboStatus=aname;
                //                    }
                details = " Activity - " + BeanUtils.getProperty(c, "flag") + " " + subject;
                auditAction = AuditAction.ACTIVITY_ADD_COMMENTS;
            }
            auditTrailDAOObj.insertAuditLog(auditAction,
                    " Comment: '" + commStrAudit + "' , added for " + details, request, refid, id);
        }
        myjobj.put("ID", id);
        txnManager.commit(status);

        // add comment on other logins for same user
        try {
            JSONObject commetMap = new JSONObject();
            boolean isCommentAdded = kmsg.isSuccessFlag();
            int operationCode = CrmPublisherHandler.ADDCOMMENT;
            commetMap.put("isCommentAdded", isCommentAdded);
            commetMap.put("recid", refid);
            commetMap.put("modulename", moduleName);
            cometManagementService.publishModuleInformation(companyid, userid, randomnumber, moduleName, refid,
                    operationCode, commetMap, CometConstants.CRMUPDATES);
        } catch (Exception e) {
        }
    } catch (Exception e) {
        System.out.println(e.getMessage());
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", myjobj.toString());
}

From source file:com.krawler.spring.crm.common.documentController.java

public ModelAndView addDocuments(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject jobj = new JSONObject();
    JSONObject myjobj = new JSONObject();
    List fileItems = null;/*w  w w.j  ava  2s  . c  o  m*/
    String details = "";
    KwlReturnObject kmsg = null;
    String auditAction = "";
    String id = java.util.UUID.randomUUID().toString();
    // PrintWriter out = null;
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);
    try {
        response.setContentType("text/html;charset=UTF-8");
        // out = response.getWriter();
        String userid = sessionHandlerImpl.getUserid(request);
        String companyID = sessionHandlerImpl.getCompanyid(request);
        String map = request.getParameter("mapid");
        HashMap<String, String> arrParam = new HashMap<String, String>();
        boolean fileUpload = false;
        ArrayList<FileItem> fi = new ArrayList<FileItem>();
        if (request.getParameter("fileAdd") != null) {
            DiskFileUpload fu = new DiskFileUpload();
            fileItems = fu.parseRequest(request);
            crmDocumentDAOObj.parseRequest(fileItems, arrParam, fi, fileUpload);
        }
        String docID = "";
        for (int cnt = 0; cnt < fi.size(); cnt++) {
            kmsg = crmDocumentDAOObj.uploadFile(fi.get(cnt), userid, companyID, getServletContext());
            Docs doc = (Docs) kmsg.getEntityList().get(0);
            docID = doc.getDocid();
            String refid = arrParam.get("refid");
            jobj.put("userid", userid);
            jobj.put("docid", docID);
            jobj.put("companyid", companyID);
            jobj.put("id", id);
            jobj.put("map", map);
            jobj.put("refid", refid);
            crmDocumentDAOObj.saveDocumentMapping(jobj);
            String randomid = java.util.UUID.randomUUID().toString();
            crmDocumentDAOObj.insertDocumentOwnerEntry(randomid, userid, docID);
            if (map.equals("0")) {
                CrmCampaign c = (CrmCampaign) hibernateTemplate.get(CrmCampaign.class, refid);
                details = " Campaign - ";
                details += StringUtil.isNullOrEmpty(c.getCampaignname()) ? "" : c.getCampaignname();
                auditAction = AuditAction.CAMPAIGN_DOC_UPLOAD;
            } else if (map.equals("1")) {
                CrmLead l = (CrmLead) hibernateTemplate.get(CrmLead.class, refid);
                details = " Lead - ";
                details += StringUtil.isNullOrEmpty(l.getFirstname()) ? "" : l.getFirstname() + " ";
                details += StringUtil.isNullOrEmpty(l.getLastname()) ? "" : l.getLastname();
                auditAction = AuditAction.LEAD_DOC_UPLOAD;
            } else if (map.equals("2")) {
                CrmContact c = (CrmContact) hibernateTemplate.get(CrmContact.class, refid);
                details = " Contact - ";
                details += StringUtil.isNullOrEmpty(c.getFirstname()) ? "" : c.getFirstname() + " ";
                details += StringUtil.isNullOrEmpty(c.getLastname()) ? "" : c.getLastname();
                auditAction = AuditAction.CONTACT_DOC_UPLOAD;
            } else if (map.equals("3")) {
                CrmProduct p = (CrmProduct) hibernateTemplate.get(CrmProduct.class, refid);
                details = " Product - ";
                details += StringUtil.isNullOrEmpty(p.getProductname()) ? "" : p.getProductname();
                auditAction = AuditAction.PRODUCT_DOC_UPLOAD;
            } else if (map.equals("4")) {
                CrmAccount a = (CrmAccount) hibernateTemplate.get(CrmAccount.class, refid);
                details = " Account - ";
                details += StringUtil.isNullOrEmpty(a.getAccountname()) ? "" : a.getAccountname();
                auditAction = AuditAction.ACCOUNT_DOC_UPLOAD;
            } else if (map.equals("5")) {
                CrmOpportunity o = (CrmOpportunity) hibernateTemplate.get(CrmOpportunity.class, refid);
                details = " Opportunity - ";
                details += StringUtil.isNullOrEmpty(o.getOppname()) ? "" : o.getOppname();
                auditAction = AuditAction.OPPORTUNITY_DOC_UPLOAD;
            } else if (map.equals("6")) {
                CrmCase c = (CrmCase) hibernateTemplate.get(CrmCase.class, refid);
                details = " Case - ";
                details += StringUtil.isNullOrEmpty(c.getSubject()) ? "" : c.getSubject();
                auditAction = AuditAction.CASE_DOC_UPLOAD;
            } else if (map.equals("7")) {
                CrmActivityMaster am = (CrmActivityMaster) hibernateTemplate.get(CrmActivityMaster.class,
                        refid);
                details = " Activity - ";
                details += StringUtil.isNullOrEmpty(am.getFlag()) ? "" : am.getFlag() + " ";
                details += StringUtil.isNullOrEmpty(am.getCrmCombodataByStatusid().getValue()) ? ""
                        : am.getCrmCombodataByStatusid().getValue();
                auditAction = AuditAction.ACTIVITY_DOC_UPLOAD;
            } else if (map.equals("-1")) {
                details = " My - Document ";
                auditAction = AuditAction.MY_DOC_UPLOAD;
            }
            auditTrailDAOObj.insertAuditLog(auditAction,
                    " Docment: '" + doc.getDocname() + "' , uploaded for " + details, request, refid, id);
        }
        myjobj.put("ID", docID);
        txnManager.commit(status);
    } catch (Exception e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    } finally {
        // out.close();
    }
    return new ModelAndView("jsonView", "model", myjobj.toString());
}

From source file:com.krawler.spring.crm.common.documentController.java

public ModelAndView addTag(HttpServletRequest request, HttpServletResponse response) throws ServletException {
    JSONObject jobj = new JSONObject();
    KwlReturnObject kmsg = null;//  w w w .  j  a  v a2s  .  c  om
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);
    try {
        String tag = request.getParameter("tag");
        String newTag = request.getParameter("newTag");
        HashMap<String, Object> requestParams = new HashMap<String, Object>();
        requestParams.put("tag", StringUtil.checkForNull(tag));

        kmsg = crmDocumentDAOObj.addTag(requestParams);
        Docs d = (Docs) kmsg.getEntityList().get(0);
        auditTrailDAOObj.insertAuditLog(com.krawler.common.admin.AuditAction.DOC_TAG_ADDED,
                " Document - '" + newTag + "' tag added for " + d.getDocname(), request, d.getDocid());
        txnManager.commit(status);
    } catch (Exception e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", jobj.toString());
}

From source file:com.krawler.spring.crm.common.documentController.java

public ModelAndView deletedocument(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject jobj = new JSONObject();
    KwlReturnObject kmsg = null;//  ww w  .j a  v a2 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);
    String docid = "";
    if (request.getParameter("docid") != null)
        docid = request.getParameter("docid");
    try {
        crmDocumentDAOObj.deletedocument(docid);
        //            auditTrailDAOObj.insertAuditLog(AuditAction.DOC_TAG_ADDED,
        //                    " Document - '" + newTag + "' tag added for "+d.getDocname(),
        //                    request, d.getDocid());
        txnManager.commit(status);
    } catch (Exception e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", jobj.toString());
}

From source file:com.krawler.spring.crm.common.documentController.java

public ModelAndView saveDocOwners(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject myjobj = new JSONObject();
    KwlReturnObject kmsg = null;//from   w w  w.j a  va  2s  . c  om
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);
    try {
        String docid = request.getParameter("leadid");
        String owners = request.getParameter("owners");
        String mainowner = request.getParameter("mainOwner");
        HashMap<String, Object> requestParams = new HashMap<String, Object>();
        requestParams.put("docid", docid);
        requestParams.put("owners", owners);
        requestParams.put("mainOwner", mainowner);
        kmsg = crmDocumentDAOObj.saveDocOwners(requestParams);

        myjobj.put("success", kmsg.isSuccessFlag());
        txnManager.commit(status);
    } catch (SessionExpiredException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    } catch (JSONException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    } catch (ServiceException 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.common.documentController.java

public ModelAndView deleteDocumentFromModule(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject jobj = new JSONObject();
    KwlReturnObject kmsg = null;//from w w  w . ja v  a  2 s.  co m
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);
    String docid = "";
    String details = "";
    String auditAction = "";
    if (request.getParameter("docid") != null)
        docid = request.getParameter("docid");
    String map = request.getParameter("mapid");
    String refId = request.getParameter("recid");
    String docName = request.getParameter("docName");
    try {
        crmDocumentDAOObj.deleteDocumentFromModule(docid);
        if (map.equals("0")) {
            CrmCampaign c = (CrmCampaign) hibernateTemplate.get(CrmCampaign.class, refId);
            details = " Campaign - ";
            details += StringUtil.isNullOrEmpty(c.getCampaignname()) ? "" : c.getCampaignname();
            auditAction = AuditAction.CAMPAIGN_DOC_DELETED;
        } else if (map.equals("1")) {
            CrmLead l = (CrmLead) hibernateTemplate.get(CrmLead.class, refId);
            details = " Lead - ";
            details += StringUtil.isNullOrEmpty(l.getFirstname()) ? "" : l.getFirstname() + " ";
            details += StringUtil.isNullOrEmpty(l.getLastname()) ? "" : l.getLastname();
            auditAction = AuditAction.LEAD_DOC_DELETED;
        } else if (map.equals("2")) {
            CrmContact c = (CrmContact) hibernateTemplate.get(CrmContact.class, refId);
            details = " Contact - ";
            details += StringUtil.isNullOrEmpty(c.getFirstname()) ? "" : c.getFirstname() + " ";
            details += StringUtil.isNullOrEmpty(c.getLastname()) ? "" : c.getLastname();
            auditAction = AuditAction.CONTACT_DOC_DELETED;
        } else if (map.equals("3")) {
            CrmProduct p = (CrmProduct) hibernateTemplate.get(CrmProduct.class, refId);
            details = " Product - ";
            details += StringUtil.isNullOrEmpty(p.getProductname()) ? "" : p.getProductname();
            auditAction = AuditAction.PRODUCT_DOC_DELETED;
        } else if (map.equals("4")) {
            CrmAccount a = (CrmAccount) hibernateTemplate.get(CrmAccount.class, refId);
            details = " Account - ";
            details += StringUtil.isNullOrEmpty(a.getAccountname()) ? "" : a.getAccountname();
            auditAction = AuditAction.ACCOUNT_DOC_DELETED;
        } else if (map.equals("5")) {
            CrmOpportunity o = (CrmOpportunity) hibernateTemplate.get(CrmOpportunity.class, refId);
            details = " Opportunity - ";
            details += StringUtil.isNullOrEmpty(o.getOppname()) ? "" : o.getOppname();
            auditAction = AuditAction.OPPORTUNITY_DOC_DELETED;
        } else if (map.equals("6")) {
            CrmCase c = (CrmCase) hibernateTemplate.get(CrmCase.class, refId);
            details = " Case - ";
            details += StringUtil.isNullOrEmpty(c.getSubject()) ? "" : c.getSubject();
            auditAction = AuditAction.CASE_DOC_DELETED;
        } else if (map.equals("7")) {
            CrmActivityMaster am = (CrmActivityMaster) hibernateTemplate.get(CrmActivityMaster.class, refId);
            details = " Activity - ";
            details += StringUtil.isNullOrEmpty(am.getFlag()) ? "" : am.getFlag() + " ";
            details += StringUtil.isNullOrEmpty(am.getCrmCombodataByStatusid().getValue()) ? ""
                    : am.getCrmCombodataByStatusid().getValue();
            auditAction = AuditAction.ACTIVITY_DOC_DELETED;
        } else if (map.equals("-1")) {
            details = " My - Document ";
            auditAction = AuditAction.MY_DOC_DELETED;
        }
        auditTrailDAOObj.insertAuditLog(auditAction, " Docment: '" + docName + "' , deleted for " + details,
                request, refId, docid);

        //    auditTrailDAOObj.insertAuditLog(AuditAction.DOC_TAG_ADDED,
        //            " Document - '" + newTag + "' tag added for "+d.getDocname(),
        //            request, d.getDocid());
        txnManager.commit(status);
    } catch (Exception e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", jobj.toString());
}

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

public ModelAndView saveEmailTemplate(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject myjobj = new JSONObject();
    KwlReturnObject kmsg = null;/*  w  w  w  .j av a2 s  . co m*/
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);
    try {
        myjobj.put("success", false);
        int mode = Integer.parseInt(request.getParameter("mode"));
        String templateClass = request.getParameter("templateclass");
        JSONObject jobj = new JSONObject();
        String companyid = sessionHandlerImpl.getCompanyid(request);
        String templatename = request.getParameter("tname");
        templatename = templatename.replaceAll("\\s+", " ").trim();
        jobj.put("userid", sessionHandlerImpl.getUserid(request));
        jobj.put("tbody", request.getParameter("tbody"));
        jobj.put("description", request.getParameter("tdesc"));
        jobj.put("subject", request.getParameter("tsub"));
        jobj.put("name", templatename);

        ArrayList filter_names = new ArrayList();
        ArrayList filter_params = new ArrayList();
        filter_names.add("c.name");
        filter_params.add(templatename);
        filter_names.add("c.creator.company.companyID");
        filter_params.add(companyid);
        filter_names.add("c.deleted");
        filter_params.add(0);

        HashMap<String, Object> requestParams = new HashMap<String, Object>();
        requestParams.put("filter_names", filter_names);
        requestParams.put("filter_params", filter_params);

        KwlReturnObject kmsg1 = crmEmailMarketingDAOObj.getTemplateContent(requestParams);
        if (kmsg1.getRecordTotalCount() > 0 && (mode == 0 || templateClass.equals("DefaultTemplates"))) {
            myjobj.put("msg", "Email template with ' " + templatename
                    + " ' name already exists. Please change the name and save it again.");
        } else {
            if (mode == 0) {
                jobj.put("modifiedon", new Date().getTime());
                jobj.put("createdon", new Date().getTime());
                kmsg = crmEmailMarketingDAOObj.addEmailTemplate(jobj);
            } else {
                jobj.put("modifiedon", new Date().getTime());
                jobj.put("deleted", "0");
                if (templateClass.equals("DefaultTemplates")) {
                    HashMap<String, Object> params = new HashMap<String, Object>();
                    params.put("userid", sessionHandlerImpl.getUserid(request));
                    params.put("templateid", request.getParameter("tid"));
                    KwlReturnObject copyMsg = crmEmailMarketingDAOObj.copyDefaultTemplates(params);
                    List templateid = copyMsg.getEntityList();
                    jobj.put("tid", templateid.get(0));
                } else {
                    jobj.put("tid", request.getParameter("tid"));
                }
                kmsg = crmEmailMarketingDAOObj.editEmailTemplate(jobj);
            }
        }
        myjobj.put("success", true);
        txnManager.commit(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 saveEmailType(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject myjobj = new JSONObject();
    KwlReturnObject kmsg = null;/*from   ww  w.ja v a  2  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 {
        myjobj.put("success", false);
        JSONObject jobj = new JSONObject();
        String companyid = sessionHandlerImpl.getCompanyid(request);
        String templatename = request.getParameter("tname");
        templatename = templatename.replaceAll("\\s+", " ").trim();
        jobj.put("userid", sessionHandlerImpl.getUserid(request));
        jobj.put("tbody", request.getParameter("tbody"));
        jobj.put("description", request.getParameter("tdesc"));
        jobj.put("subject", request.getParameter("tsub"));
        jobj.put("name", templatename);
        jobj.put("plaintext", request.getParameter("plaintext"));
        jobj.put("companyid", companyid);

        ArrayList filter_names = new ArrayList();
        ArrayList filter_params = new ArrayList();
        filter_names.add("c.name");
        filter_params.add(templatename);
        filter_names.add("c.company.companyID");
        filter_params.add(companyid);

        HashMap<String, Object> requestParams = new HashMap<String, Object>();
        requestParams.put("filter_names", filter_names);
        requestParams.put("filter_params", filter_params);
        KwlReturnObject kmsg1 = crmEmailMarketingDAOObj.getEmailTypeContent(requestParams);
        if (kmsg1.getRecordTotalCount() > 0) {
            List<EnumEmailType> enumEmailList = kmsg1.getEntityList();
            for (EnumEmailType eet : enumEmailList) {
                jobj.put("modifiedon", new Date().getTime());
                jobj.put("tid", eet.getTypeid());
            }
            kmsg = crmEmailMarketingDAOObj.editEmailType(jobj);
        } else {
            jobj.put("modifiedon", new Date().getTime());
            jobj.put("createdon", new Date().getTime());
            kmsg = crmEmailMarketingDAOObj.addEmailType(jobj);
        }

        myjobj.put("success", true);
        txnManager.commit(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 deleteemailMarketing(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject myjobj = null;//from   www.  java2 s.  c  om
    KwlReturnObject kmsg = null;
    KwlReturnObject kmsg1 = 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();
        JSONArray deletejarr = new JSONArray();
        JSONArray failDeletejarr = new JSONArray();
        myjobj.put(Constants.success, false);
        if (StringUtil.bNull(request.getParameter(Constants.jsondata))) {
            String jsondata = request.getParameter(Constants.jsondata);
            JSONArray jarr = new JSONArray("[" + jsondata + "]");
            for (int i = 0; i < jarr.length(); i++) {
                JSONObject jobj = new JSONObject();
                String templateid = jarr.getJSONObject(i).getString(Constants.templateid);
                List<EmailMarketing> ll = crmEmailMarketingHandler
                        .getCampEmailMarketList(crmEmailMarketingDAOObj, templateid);
                JSONObject jobjmsg = new JSONObject();

                if (ll.isEmpty()) {
                    if (StringUtil.equal(templateid, Constants.DEFAULT_BASIC_TEMPLATEID)
                            || StringUtil.equal(templateid, Constants.DEFAULT_LEFTCOLUMN_TEMPLATEID)
                            || StringUtil.equal(templateid, Constants.DEFAULT_POSTCARD_TEMPLATEID)
                            || StringUtil.equal(templateid, Constants.DEFAULT_RICHTEXT_TEMPLATEID)
                            || StringUtil.equal(templateid, Constants.DEFAULT_RIGHTCOLUMN_TEMPLATEID)) {
                        HashMap requestParams = new HashMap();
                        ArrayList filter_names = new ArrayList();
                        ArrayList filter_params = new ArrayList();
                        filter_names.add("c.templateid");
                        filter_params.add(templateid);
                        requestParams.put("filter_names", filter_names);
                        requestParams.put("filter_params", filter_params);
                        kmsg1 = crmEmailMarketingDAOObj.getDefaultEmailTemplate(requestParams);
                        DefaultTemplates obj = (DefaultTemplates) kmsg1.getEntityList().get(0);
                        jobjmsg.put(Constants.name, obj.getName());
                        jobjmsg.put(Constants.moduleName, "Default Template");
                        failDeletejarr.put(jobjmsg);
                    } else {
                        jobj.put(Constants.modifiedon, new Date().getTime());
                        jobj.put(Constants.tid, templateid);
                        jobj.put(Constants.deleted, 1);
                        kmsg = crmEmailMarketingDAOObj.editEmailTemplate(jobj);
                        if (kmsg.isSuccessFlag()) {
                            EmailTemplate obj = (EmailTemplate) kmsg.getEntityList().get(0);
                            jobjmsg.put(Constants.name, obj.getName());
                            jobjmsg.put(Constants.moduleName, Constants.MODULE_EmailTemplate);
                            deletejarr.put(jobjmsg);
                        }
                    }

                } else {
                    EmailTemplate obj = ll.get(0).getTemplateid();
                    String emarkt = "";
                    for (EmailMarketing em : ll) {
                        emarkt += em.getName() + ", ";
                    }
                    emarkt = emarkt.substring(0, emarkt.length() - 2);
                    jobjmsg.put(Constants.name, obj.getName());
                    jobjmsg.put(Constants.moduleName, emarkt);
                    failDeletejarr.put(jobjmsg);
                }
            }
            myjobj.put(Constants.success, true);
            if (failDeletejarr.length() > 0) {
                myjobj.put(Constants.successDeleteArr, deletejarr);
                myjobj.put(Constants.failDelete, failDeletejarr);
            }
        }
        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 sendEmailMarketMail(HttpServletRequest request, HttpServletResponse response)
        throws ServletException {
    JSONObject jobj = new JSONObject();
    //Create transaction
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setName("JE_Tx");
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED);
    TransactionStatus status = txnManager.getTransaction(def);
    String msg = "";
    try {/*from   w ww  .j a  va2 s. c  o m*/
        jobj.put("success", false);
        HashMap<String, Object> requestParams = new HashMap<String, Object>();
        requestParams.put("userid", sessionHandlerImpl.getUserid(request));
        requestParams.put("companyid", sessionHandlerImpl.getCompanyid(request));
        requestParams.put("campaignid", request.getParameter("campid"));
        requestParams.put("emailmarkid", request.getParameter("emailmarkid"));
        requestParams.put("resume", Boolean.parseBoolean(request.getParameter("resume")));
        requestParams.put("baseurl", URLUtil.getRequestPageURL(request, Links.UnprotectedLoginPageFull));
        KwlReturnObject kmsg = crmEmailMarketingDAOObj.sendEmailMarketMail(requestParams);
        jobj.put("success", kmsg.isSuccessFlag());
        msg = kmsg.getEntityList().get(0).toString();
        jobj.put("msgs", msg);
        txnManager.commit(status);
    } catch (SessionExpiredException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    } catch (ServiceException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    } catch (JSONException e) {
        logger.warn(e.getMessage(), e);
        txnManager.rollback(status);
    }
    return new ModelAndView("jsonView", "model", jobj.toString());
}