public void TestPerformUserAction()
        {
            Statement statement = new Statement();

            statement.query = string.Format("WHERE id = {0}", salespersonId);

            DeactivateUsers action = new DeactivateUsers();

            UpdateResult result = null;

            Assert.DoesNotThrow(delegate() {
                result = userService.performUserAction(action, statement);
            });

            Assert.NotNull(result);
            Assert.AreEqual(result.numChanges, 1);

            // Activate the user again.

            Assert.DoesNotThrow(delegate() {
                result = userService.performUserAction(new ActivateUsers(), statement);
            });

            Assert.NotNull(result);
            Assert.AreEqual(result.numChanges, 1);
        }
        public void TestPerformUserAction()
        {
            Statement statement = new Statement();
              statement.query = string.Format("WHERE id = {0}", salespersonId);

              DeactivateUsers action = new DeactivateUsers();

              UpdateResult result = null;

              Assert.DoesNotThrow(delegate() {
            result = userService.performUserAction(action, statement);
              });

              Assert.NotNull(result);
              Assert.AreEqual(result.numChanges, 1);

              // Activate the user again.

              Assert.DoesNotThrow(delegate() {
            result = userService.performUserAction(new ActivateUsers(), statement);
              });

              Assert.NotNull(result);
              Assert.AreEqual(result.numChanges, 1);
        }
Example #3
0
        /// <summary>
        /// Run the code example.
        /// </summary>
        public void Run(DfpUser user)
        {
            using (UserService userService = (UserService)user.GetService(
                       DfpService.v201708.UserService)) {
                // Set the ID of the user to deactivate
                long userId = long.Parse(_T("INSERT_USER_ID_HERE"));

                // Create statement text to select user by id.
                StatementBuilder statementBuilder = new StatementBuilder()
                                                    .Where("id = :userId")
                                                    .OrderBy("id ASC")
                                                    .Limit(1)
                                                    .AddValue("userId", userId);

                // Sets default for page.
                UserPage      page    = new UserPage();
                List <string> userIds = new List <string>();

                try {
                    do
                    {
                        // Get users by statement.
                        page = userService.getUsersByStatement(statementBuilder.ToStatement());

                        if (page.results != null)
                        {
                            int i = page.startIndex;
                            foreach (User userResult in page.results)
                            {
                                Console.WriteLine("{0}) User with ID = '{1}', email = '{2}', and status = '{3}'" +
                                                  " will be deactivated.", i, userResult.id, userResult.email,
                                                  userResult.isActive ? "ACTIVE" : "INACTIVE");
                                userIds.Add(userResult.id.ToString());
                                i++;
                            }
                        }

                        statementBuilder.IncreaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT);
                    } while (statementBuilder.GetOffset() < page.totalResultSetSize);

                    Console.WriteLine("Number of users to be deactivated: {0}", page.totalResultSetSize);

                    if (userIds.Count > 0)
                    {
                        // Modify statement for action.
                        statementBuilder.RemoveLimitAndOffset();

                        // Create action.
                        DeactivateUsers action = new DeactivateUsers();

                        // Perform action.
                        UpdateResult result = userService.performUserAction(action,
                                                                            statementBuilder.ToStatement());

                        // Display results.
                        if (result != null && result.numChanges > 0)
                        {
                            Console.WriteLine("Number of users deactivated: {0}" + result.numChanges);
                        }
                        else
                        {
                            Console.WriteLine("No users were deactivated.");
                        }
                    }
                } catch (Exception e) {
                    Console.WriteLine("Failed to deactivate users. Exception says \"{0}\"",
                                      e.Message);
                }
            }
        }
    /// <summary>
    /// Run the code example.
    /// </summary>
    /// <param name="user">The DFP user object running the code example.</param>
    public override void Run(DfpUser user) {
      // Get the UserService.
      UserService userService = (UserService) user.GetService(DfpService.v201211.UserService);

      // Set the ID of the user to deactivate
      long userId = long.Parse(_T("INSERT_USER_ID_HERE"));

      // Create Statement text to select user by id.
      string statementText = "WHERE id = :userId LIMIT 500";
      Statement statement = new StatementBuilder("").AddValue("userId", userId).ToStatement();

      // Sets defaults for page and offset.
      UserPage page = new UserPage();
      int offset = 0;
      List<string> userIds = new List<string>();

      try {
        do {
          // Create a Statement to page through users.
          statement.query = string.Format("{0} OFFSET {1}", statementText, offset);

          // Get users by Statement.
          page = userService.getUsersByStatement(statement);

          if (page.results != null && page.results.Length > 0) {
            int i = page.startIndex;
            foreach (User userResult in page.results) {
              Console.WriteLine("{0}) User with ID = '{1}', email = '{2}', and status = '{3}'" +
                 " will be deactivated.", i, userResult.id, userResult.email,
                 userResult.isActive ? "ACTIVE" : "INACTIVE");
              userIds.Add(userResult.id.ToString());
              i++;
            }
          }

          offset += 500;
        } while (offset < page.totalResultSetSize);

        Console.WriteLine("Number of users to be deactivated: {0}", page.totalResultSetSize);

        if (userIds.Count > 0) {
          // Create action Statement.
          statement = new StatementBuilder(
              string.Format("WHERE id IN ({0})", string.Join(",", userIds.ToArray()))).
              ToStatement();

          // Create action.
          DeactivateUsers action = new DeactivateUsers();

          // Perform action.
          UpdateResult result = userService.performUserAction(action, statement);

          // Display results.
          if (result != null && result.numChanges > 0) {
            Console.WriteLine("Number of users deactivated: {0}" + result.numChanges);
          } else {
            Console.WriteLine("No users were deactivated.");
          }
        }
      } catch (Exception ex) {
        Console.WriteLine("Failed to deactivate users. Exception says \"{0}\"",
            ex.Message);
      }
    }
    /// <summary>
    /// Run the code example.
    /// </summary>
    /// <param name="user">The DFP user object running the code example.</param>
    public override void Run(DfpUser user) {
      // Get the UserService.
      UserService userService = (UserService) user.GetService(DfpService.v201508.UserService);

      // Set the ID of the user to deactivate
      long userId = long.Parse(_T("INSERT_USER_ID_HERE"));

      // Create statement text to select user by id.
      StatementBuilder statementBuilder = new StatementBuilder()
          .Where("id = :userId")
          .OrderBy("id ASC")
          .Limit(1)
          .AddValue("userId", userId);

      // Sets default for page.
      UserPage page = new UserPage();
      List<string> userIds = new List<string>();

      try {
        do {
          // Get users by statement.
          page = userService.getUsersByStatement(statementBuilder.ToStatement());

          if (page.results != null && page.results.Length > 0) {
            int i = page.startIndex;
            foreach (User userResult in page.results) {
              Console.WriteLine("{0}) User with ID = '{1}', email = '{2}', and status = '{3}'" +
                 " will be deactivated.", i, userResult.id, userResult.email,
                 userResult.isActive ? "ACTIVE" : "INACTIVE");
              userIds.Add(userResult.id.ToString());
              i++;
            }
          }

          statementBuilder.IncreaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT);
        } while (statementBuilder.GetOffset() < page.totalResultSetSize);

        Console.WriteLine("Number of users to be deactivated: {0}", page.totalResultSetSize);

        if (userIds.Count > 0) {
          // Modify statement for action.
          statementBuilder.RemoveLimitAndOffset();

          // Create action.
          DeactivateUsers action = new DeactivateUsers();

          // Perform action.
          UpdateResult result = userService.performUserAction(action,
              statementBuilder.ToStatement());

          // Display results.
          if (result != null && result.numChanges > 0) {
            Console.WriteLine("Number of users deactivated: {0}" + result.numChanges);
          } else {
            Console.WriteLine("No users were deactivated.");
          }
        }
      } catch (Exception e) {
        Console.WriteLine("Failed to deactivate users. Exception says \"{0}\"",
            e.Message);
      }
    }
        /// <summary>
        /// Run the code example.
        /// </summary>
        /// <param name="user">The DFP user object running the code example.</param>
        public override void Run(DfpUser user)
        {
            // Get the UserService.
            UserService userService = (UserService)user.GetService(DfpService.v201311.UserService);

            // Set the ID of the user to deactivate
            long userId = long.Parse(_T("INSERT_USER_ID_HERE"));

            // Create Statement text to select user by id.
            string    statementText = "WHERE id = :userId LIMIT 500";
            Statement statement     = new StatementBuilder("").AddValue("userId", userId).ToStatement();

            // Sets defaults for page and offset.
            UserPage      page    = new UserPage();
            int           offset  = 0;
            List <string> userIds = new List <string>();

            try {
                do
                {
                    // Create a Statement to page through users.
                    statement.query = string.Format("{0} OFFSET {1}", statementText, offset);

                    // Get users by Statement.
                    page = userService.getUsersByStatement(statement);

                    if (page.results != null && page.results.Length > 0)
                    {
                        int i = page.startIndex;
                        foreach (User userResult in page.results)
                        {
                            Console.WriteLine("{0}) User with ID = '{1}', email = '{2}', and status = '{3}'" +
                                              " will be deactivated.", i, userResult.id, userResult.email,
                                              userResult.isActive ? "ACTIVE" : "INACTIVE");
                            userIds.Add(userResult.id.ToString());
                            i++;
                        }
                    }

                    offset += 500;
                } while (offset < page.totalResultSetSize);

                Console.WriteLine("Number of users to be deactivated: {0}", page.totalResultSetSize);

                if (userIds.Count > 0)
                {
                    // Create action Statement.
                    statement = new StatementBuilder(
                        string.Format("WHERE id IN ({0})", string.Join(",", userIds.ToArray()))).
                                ToStatement();

                    // Create action.
                    DeactivateUsers action = new DeactivateUsers();

                    // Perform action.
                    UpdateResult result = userService.performUserAction(action, statement);

                    // Display results.
                    if (result != null && result.numChanges > 0)
                    {
                        Console.WriteLine("Number of users deactivated: {0}" + result.numChanges);
                    }
                    else
                    {
                        Console.WriteLine("No users were deactivated.");
                    }
                }
            } catch (Exception ex) {
                Console.WriteLine("Failed to deactivate users. Exception says \"{0}\"",
                                  ex.Message);
            }
        }