/** * Description of the Method * * @param context Description of the Parameter * @return Description of the Return Value */ public String executeCommandInsert(ActionContext context) { if (!(hasPermission(context, "sales-leads-action-plans-add"))) { return ("PermissionError"); } Connection db = null; User assigned = null; User manager = null; Contact assignedContact = null; Contact managerContact = null; Contact ContactDetails = null; ActionPlanWork planWork = (ActionPlanWork) context.getFormBean(); String actionPlanIdString = context.getRequest().getParameter("actionPlan"); if (actionPlanIdString != null && !"".equals(actionPlanIdString.trim()) && !"null".equals(actionPlanIdString.trim())) { planWork.setActionPlanId(actionPlanIdString); } try { db = this.getConnection(context); String contactId = context.getRequest().getParameter("contactId"); ContactDetails = new Contact(db, Integer.parseInt(contactId)); if (!isRecordAccessPermitted(context, ContactDetails)) { return ("PermissionError"); } context.getRequest().setAttribute("orgDetails", ContactDetails); boolean isValid = this.validateObject(context, db, planWork); boolean recordStatus = false; if (isValid) { ActionPlan actionPlan = new ActionPlan(); actionPlan.setBuildPhases(true); actionPlan.setBuildSteps(true); actionPlan.setLinkObjectId(ActionPlan.getMapIdGivenConstantId(db, ActionPlan.LEADS)); actionPlan.queryRecord(db, planWork.getActionPlanId()); planWork.setLinkModuleId(ActionPlan.getMapIdGivenConstantId(db, ActionPlan.LEADS)); planWork.setLinkItemId(ContactDetails.getId()); planWork.setEnteredBy(this.getUserId(context)); planWork.setModifiedBy(this.getUserId(context)); planWork.insert(db, actionPlan); this.processInsertHook(context, planWork); context.getRequest().setAttribute("actionPlanId", String.valueOf(planWork.getId())); assigned = this.getUser(context, planWork.getAssignedTo()); assignedContact = new Contact(db, assigned.getContactId()); manager = this.getUser(context, planWork.getManagerId()); managerContact = new Contact(db, manager.getContactId()); } } catch (Exception e) { context.getRequest().setAttribute("Error", e); e.printStackTrace(System.out); return ("SystemError"); } finally { this.freeConnection(context, db); } // Process Emails if (planWork.getId() > -1) { try { String templateFile = getDbNamePath(context) + "templates_" + getUserLanguage(context) + ".xml"; if (!FileUtils.fileExists(templateFile)) { templateFile = getDbNamePath(context) + "templates_en_US.xml"; } // Send an email to the Action Plan "owner" & Action Plan "manager" planWork.sendEmail( context, assignedContact, managerContact, ContactDetails.getNameLast(), templateFile); } catch (Exception e) { context.getRequest().setAttribute("Error", e); return ("SystemError"); } } else { return executeCommandAdd(context); } return (executeCommandDetails(context)); }