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); }
/// <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); } }