Package com.centraview.common

Examples of com.centraview.common.CVDal.executeUpdate()


        dl.setSql("project.addprojectlink");
        dl.setInt(1, projectId);
        dl.setInt(2, recordTypeId);
        dl.setInt(3, pvo.getEntityID());
        dl.executeUpdate();
      }

      if (pvo.getContactID() != 0)
      {
        dl.setSqlQuery("select ModuleID from module where name='Individual'");
View Full Code Here


        dl.setSql("project.addprojectlink");
        dl.setInt(1, projectId);
        dl.setInt(2, recordTypeId);
        dl.setInt(3, pvo.getContactID());
        dl.executeUpdate();
      }

      if (pvo.getGroupID() != 0)
      {
        dl.setSqlQuery("select ModuleID from module where name='Group'");
View Full Code Here

      dl.setInt(1, activityId);
      dl.setInt(2, tvo.getProjectID());
      dl.setInt(3, tvo.getParentID());
      dl.setString(4, tvo.getIsMileStone());
      dl.setInt(5, ++taskCount);
      dl.executeUpdate();

      HashMap assigned = (HashMap)tvo.getAssignedTo();
      Iterator ite = null;
      if (assigned != null)
      {
View Full Code Here

          int assignedTo = ((Integer)ite.next()).intValue();

          dl.setSql("projecttask.addtaskassigned");
          dl.setInt(1, activityId);
          dl.setInt(2, assignedTo);
          dl.executeUpdate();
          dl.clearParameters();
        }
      }

      Collection actions = tvo.getActivityAction();
View Full Code Here

          ActivityActionVO action = (ActivityActionVO)ite.next();

          dl.setSql("projecttask.addtaskalertaction");
          dl.setString(1, action.getActionType());
          dl.setString(2, tvo.getMessage());
          dl.executeUpdate();

          int actionId = dl.getAutoGeneratedKey();
          dl.clearParameters();

          ArrayList recipients = action.getRecipient();
View Full Code Here

        dl.setSql("project.addprojectlink");
        dl.setInt(1, projectId);
        dl.setInt(2, recordTypeId);
        dl.setInt(3, pvo.getGroupID());
        dl.executeUpdate();
      }

      Vector customField = pvo.getCustomField();
      if (customField != null && customField.size() != 0)
      {
View Full Code Here

      Vector customField = pvo.getCustomField();
      if (customField != null && customField.size() != 0)
      {
        dl.setSql("project.deletecustomfieldscalar");
        dl.setInt(1, projectId);
        dl.executeUpdate();
        dl.clearParameters();

        for (int i = 0; i < customField.size(); i++)
        {
          CustomFieldVO cvo = (CustomFieldVO)customField.get(i);
View Full Code Here

            {
              dl.setSql("projecttask.addtaskalert");
              dl.setInt(1, activityId);
              dl.setInt(2, actionId);
              dl.setInt(3, ((Integer)it1.next()).intValue());
              dl.executeUpdate();
            }
          }   // end if (recipients != null)
        }   // end while (ite.hasNext())
      }   // end if (actions != null)
View Full Code Here

    CVDal cvdl = new CVDal(this.dataSource);
    if (filter != null && filter.length() > 0) {
      String str = "CREATE TABLE tasklistfilter " + filter;
      cvdl.setSqlQuery(str);
      cvdl.executeUpdate();
      cvdl.setSqlQueryToNull();
      applyFilter = true;
    }

    String query = this.buildTaskListQuery(applyFilter, individualId, cvdl, parameters);
View Full Code Here

          {
            dl.setSql("project.addcustomfieldscalar");
            dl.setInt(1, cvo.getFieldID());
            dl.setInt(2, activityId);
            dl.setString(3, cvo.getValue());
            dl.executeUpdate();
          }
        }
      }

      // TODO: we may not need to do this as tasks are activites and activites don't seem to use recordauth.
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.