예제 #1
0
  private void addProject(
      HttpServletRequest request, HttpServletResponse response, boolean updateFlag)
      throws ServletException, IOException {
    // First order of business is to capture the form parameters into the project bean
    setProjectBean(request);
    // execute the insert
    String id = request.getParameter("id");
    try {
      if (updateFlag) parameterDAO.deleteProject(id);
      project = pb.insert();
    } catch (Exception e) {
      msg.append("A B O R T.  The following database error has occured:<br />");
      msg.append(
          "<strong><span style=\"background-color: #FFFF00\">" + e + "</span></strong><br />");
    } finally {
      if (project > 0) {
        // success
        msg.append(
            "Project <strong><span style=\"background-color: #FFFF00\">" + pb.getProjectname());
        if (updateFlag) {
          msg.append("</span></strong> was U P D A T E D <br />");
        } else {
          msg.append("</span></strong> was I N S E R T E D<br />");
        }

      } else {
        msg.append(
            "F A I L E D to Insert/Update Project "
                + pb.getProjectname()
                + " into database!!!!!!!!!!!<br />");
      }
    }
  }
예제 #2
0
  private String getProjectsListHTML(String column, String order) {
    // System.out.println("AddProjectServlet.getPrjectsHTML filter = " + filter.toString());
    String html = parameterDAO.getProjectsListHTML(column, order, baseurl, filter);

    System.out.println("Filter FINISHED as = " + filter.toFilterString());
    // System.out.println("Filter Training FINISHED as, ParameterDAO.(Training) = " +
    // ParameterDAO.parse(filter.getTraining()));
    // System.out.println("Filter Capability Area(s) FINISHED as = " + filter.getCapabilityAreas());

    // filter=new ProjectBean();
    return html;
  }
예제 #3
0
  protected void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {

    System.out.println("AddProjectServlet.doPost Entered...");

    init(response);
    PrintWriter out = response.getWriter();
    dataSource = (DataSource) request.getSession().getServletContext().getAttribute("DBCPool");
    baseurl = config.getServletContext().getInitParameter("baseurl"); // filesystem web-root
    parameterDAO.setDataSource(dataSource);
    pb.setParameterDAO(parameterDAO);
    filter.setParameterDAO(parameterDAO);

    System.out.println("AddProjectServlet.doPost done inits pb.set, filter.set...");

    if (ParameterDAO.parse(request.getParameter("clearmsgs"))) {
      msg = new StringBuffer();
    }

    String[] deleted = request.getParameterValues("delete");
    String addnew = request.getParameter("addnew");
    String updated = request.getParameter("updated");
    String undelete = request.getParameter("undelete");
    String searchbyx = request.getParameter("searchbyx");

    filter.setSearchString(StringUtils.trimToEmpty(request.getParameter("search")));
    String sortby = StringUtils.trimToEmpty(request.getParameter("sortby"));

    String order = "DESC";
    if (!ParameterDAO.parse(request.getParameter("order"))) order = "ASC";

    // if coming from addContacts, success or failure...
    if (ParameterDAO.parse(request.getAttribute("addcontacts"))
        || ParameterDAO.parse(request.getAttribute("addagencies"))
        || ParameterDAO.parse(request.getAttribute("uploadedfile"))) {
      msg.append(StringUtils.trimToEmpty((String) request.getAttribute("msg")));
    } else if (StringUtils.isNotBlank(filter.getSearchString())) {
      // triggers the simple search exclusive of any other action (safe from delete, by preceding in
      // if-then )
      // do absolutely nothing the search field will be populated just fine as expected.  Later, may
      // be add X number of projects
    } else if (deleted == null) {
      // System.out.println("AddProjectServlet.doPost Entered else if deleted == null");

      // coming from index.jsp
      if (ParameterDAO.parse(updated)) {
        addProject(request, response, true);
      } else if (ParameterDAO.parse(undelete)) {
        parameterDAO.unDeleteAllProjects();
      } else if (ParameterDAO.parse(addnew)) {
        addProject(request, response, false);
      } else if (ParameterDAO.parse(searchbyx)) {
        // we are just setting filter
        setProjectBean(request);
        filter = pb;
        System.out.println("Filter STARTS LIFE as = " + filter.toFilterString());
        // System.out.println("Filter Training INIT parsed as = " +
        // ParameterDAO.parse(filter.getTraining()));
        // System.out.println("Filter Capability Area(s) INIT as = " + filter.getCapabilityAreas());

        msg.append("Advanced Search Parameters = ");
        msg.append(
            "<div style=\"font-family: 'trebuchet ms', sans-serif;  font-size: 9px; font-style: italic; text-transform: lowercase; display: inline; \">");
        msg.append(filter.toFilterString());
        msg.append("</div><br />");
      }
    } else if (deleted.length == 0) {
      // came from projects list but nothing to do...later when table cells are editable, we may @TO
      // DO capture all edits/updates here
    } else {
      parameterDAO.deleteProject(deleted);
      int count = 0;
      for (int i = 0; i < deleted.length; i++) {
        count++;

        if (count == 1) {
          msg.append("Project(s) <strong><span style=\"background-color: #FFFF00\">");
        } else {
          msg.append(",&nbsp;<strong><span style=\"background-color: #FFFF00\">");
        }
        msg.append(
            StringEscapeUtils.escapeHtml(
                parameterDAO.getJustOneProject(deleted[i]).getProjectname()));
        msg.append("</span></strong>");
      }
      if (count > 0) msg.append(" D E L E T E D<BR />");
    }

    /////////////////////////////////////////////
    //  Draw the projects list table
    //
    out.println(getHeader());
    out.println(getMessageTable(msg));
    // System.out.println("AddProjectServlet.doPost drawing projects table " + filter.toString());

    if (StringUtils.isBlank(sortby)) {
      out.println(getProjectsListHTML());
    } else if (StringUtils.equalsIgnoreCase(sortby, "code")) {
      out.println(getProjectsListHTML("code", order));
    } else if (StringUtils.equalsIgnoreCase(sortby, "name")) {
      out.println(getProjectsListHTML("nametitle", order));
    } else if (StringUtils.equalsIgnoreCase(sortby, "description")) {
      out.println(getProjectsListHTML("description", order));
    } else if (StringUtils.equalsIgnoreCase(sortby, "status")) {
      out.println(getProjectsListHTML("status", order));
    } else {
      out.println(getProjectsListHTML());
    }

    out.println(getFooter());
    filter = new ProjectBean();
    // System.out.println("AddProjectServlet.doPost DONE");

  }