ManageUser.java

/*
* This program is part of the OpenLMIS logistics management information system platform software.
* Copyright © 2013 VillageReach
*
* This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more details.
* You should have received a copy of the GNU Affero General Public License along with this program.  If not, see http://www.gnu.org/licenses.  For additional information contact info@OpenLMIS.org. 
*/

package org.openlmis.functional;

import cucumber.api.DataTable;
import cucumber.api.java.en.And;
import cucumber.api.java.en.Then;
import cucumber.api.java.en.When;
import org.openlmis.UiUtils.TestCaseHelper;
import org.openlmis.pageobjects.*;
import org.testng.annotations.AfterMethod;
import org.testng.annotations.BeforeMethod;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;

import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import static com.thoughtworks.selenium.SeleneseTestBase.assertFalse;
import static com.thoughtworks.selenium.SeleneseTestBase.assertTrue;
import static com.thoughtworks.selenium.SeleneseTestNgHelper.assertEquals;
import static java.util.Arrays.asList;

public class ManageUser extends TestCaseHelper {

  public static final String FIELD_COORDINATOR = "Field Co-Ordinator";
  public static final String LAB_IN_CHARGE = "Lab-in-charge";
  public static final String AUTHORIZE_REQUISITION = "Authorize Requisition";
  public static final String CREATE_REQUISITION = "Create Requisition";
  public static final String APPROVE_REQUISITION = "Approve Requisition";
  public static final String geoZone = "Ngorongoro";
  public static final String facilityType = "Lvl3 Hospital";
  public static final String operatedBy = "MoH";
  public static final String facilityCodePrefix = "FCcode";
  public static final String facilityNamePrefix = "FCname";
  public static final String warehouseRole = "SHIPMENT";

  LoginPage loginPage;
  UserPage userPage;
  HomePage homePage;

  @BeforeMethod(groups = {"admin"})
  public void setUp() throws InterruptedException, SQLException, IOException {
    super.setup();
    dbWrapper.removeAllExistingRights("Admin");
    dbWrapper.assignRight("Admin", "MANAGE_USER");
    dbWrapper.assignRight("Admin", "MANAGE_FACILITY");
    loginPage = PageObjectFactory.getLoginPage(testWebDriver, baseUrlGlobal);
    userPage = PageObjectFactory.getUserPage(testWebDriver);
    homePage = PageObjectFactory.getHomePage(testWebDriver);
  }

  @And("^I create a user:$")
  public void createUser(DataTable userTable) {
    HomePage homePage = PageObjectFactory.getHomePage(testWebDriver);
    UserPage userPage = homePage.navigateToUser();
    List<Map<String, String>> data = userTable.asMaps(String.class, String.class);
    for (Map map : data)
      userPage.enterUserDetails(map.get("UserName").toString(), map.get("Email").toString(),
        map.get("FirstName").toString(), map.get("LastName").toString());
    testWebDriver.waitForAjax();
    userPage.clickViewHere();
  }

  @When("^I disable user \"([^\"]*)\" and \"([^\"]*)\"$")
  public void disableUser(String firstName, String lastName) {
    HomePage homePage = PageObjectFactory.getHomePage(testWebDriver);
    UserPage userPage = homePage.navigateToUser();
    userPage.searchUser(firstName);
    userPage.clickSearchIcon();
    userPage.clickUserName(1);
    testWebDriver.waitForAjax();
    userPage.disableUser(firstName + " " + lastName);
  }

  @Then("^I should see disable user \"([^\"]*)\" message$")
  public void verifyDisableUser(String user) {
    UserPage userPage = PageObjectFactory.getUserPage(testWebDriver);
    userPage.verifyMessage("User \"" + user + "\" has been disabled");
  }

  @Then("^I should see user not verified$")
  public void notVerifiedUser() {
    UserPage userPage = PageObjectFactory.getUserPage(testWebDriver);
    assertEquals("No", userPage.getVerifiedLabel());
  }

  @Then("^I should see user \"([^\"]*)\" verified$")
  public void VerifiedUser(String user) {
    HomePage homePage = PageObjectFactory.getHomePage(testWebDriver);
    UserPage userPage = homePage.navigateToUser();
    userPage.searchUser(user);
    userPage.clickSearchIcon();
    testWebDriver.waitForAjax();
    userPage.clickUserName(1);
    testWebDriver.waitForAjax();
    assertEquals(userPage.getVerifiedLabel(), "Yes");
  }

  @When("^I enable user \"([^\"]*)\"$")
  public void enableUser(String user) {
    HomePage homePage = PageObjectFactory.getHomePage(testWebDriver);
    UserPage userPage = homePage.navigateToUser();
    userPage.searchUser(user);
    userPage.clickSearchIcon();
    testWebDriver.waitForAjax();
    userPage.clickUserName(1);
    testWebDriver.waitForAjax();
    userPage.clickEnableButton();
  }

  @Then("^I should see enable user \"([^\"]*)\" message$")
  public void verifyEnabledUser(String user) {
    UserPage userPage = PageObjectFactory.getUserPage(testWebDriver);
    userPage.verifyMessage("User \"" + user + "\" has been enabled");
  }

  @When("^I verify user email \"([^\"]*)\"$")
  public void verifyUserEmail(String email) throws SQLException {
    dbWrapper.updateUser("abc123", email);
  }

  @Test(groups = {"admin"})
  public void testUserSearchSortAndPagination() throws SQLException {
    dbWrapper.assignRight("Admin", "UPLOADS");
    HomePage homePage = loginPage.loginAs("Admin123", "Admin123");
    UploadPage uploadPage = homePage.navigateUploads();
    uploadPage.uploadUsers("QA_Users21.csv");
    uploadPage.verifySuccessMessageOnUploadScreen();

    userPage = homePage.navigateToUser();
    assertEquals("Search user", userPage.getSearchUserLabel());
    assertEquals(userPage.getSearchPlaceHolder(), "Enter username, firstname, lastname or email");

    userPage.searchUser("userA");
    userPage.clickSearchIcon();
    assertEquals("No matches found for 'userA'", userPage.getNoResultMessage());

    userPage.searchUser("user2");
    userPage.clickSearchIcon();
    assertEquals("3 matches found for 'user2'", userPage.getNResultsMessage());
    assertEquals("Name", userPage.getNameHeader());
    assertEquals("User Name", userPage.getUserNameHeader());
    assertEquals("Email", userPage.getEmailHeader());
    assertEquals("Verified", userPage.getVerifiedHeader());
    assertEquals("Active", userPage.getActiveHeader());

    assertEquals("William2 Doe", userPage.getName(1));
    assertEquals("User2", userPage.getUserName(1));
    assertEquals("openlmisUser2@open.com", userPage.getEmail(1));
    assertFalse(userPage.getIsVerified(1));
    assertTrue(userPage.getIsActive(1));

    userPage.searchUser("user");
    userPage.clickSearchIcon();
    assertEquals("21 matches found for 'user'", userPage.getNResultsMessage());

    verifyNumberOFPageLinksDisplayed(21, 10);
    verifyPageNumberLinksDisplayed();
    verifyPageNumberSelected(1);
    verifyNextAndLastPageLinksEnabled();
    verifyPreviousAndFirstPageLinksDisabled();
    verifyNumberOfLineItemsVisibleOnPage(10);
    verifyUserNameOrderOnPage(new String[]{"William10 Doe", "William11 Doe", "William12 Doe", "William13 Doe", "William14 Doe",
      "William15 Doe", "William16 Doe", "William17 Doe", "William18 Doe", "William19 Doe"});

    navigateToPage(2);
    verifyPageNumberSelected(2);
    verifyNextAndLastPageLinksEnabled();
    verifyPreviousAndFirstPageLinksEnabled();
    verifyNumberOfLineItemsVisibleOnPage(10);
    verifyUserNameOrderOnPage(new String[]{"William2 Doe", "William2 IDoe", "William20 Doe", "William21 Doe", "William3 Doe",
      "William4 Doe", "William5 Doe", "William6 Doe", "William71 Doe", "William8 Doe"});

    navigateToNextPage();
    verifyPageNumberSelected(3);
    verifyNextAndLastPageLinksDisabled();
    verifyPreviousAndFirstPageLinksEnabled();
    verifyNumberOfLineItemsVisibleOnPage(1);
    verifyUserNameOrderOnPage(new String[]{"William9 Doe"});

    navigateToFirstPage();
    verifyPageNumberSelected(1);
    verifyNextAndLastPageLinksEnabled();
    verifyPreviousAndFirstPageLinksDisabled();
    verifyNumberOfLineItemsVisibleOnPage(10);
    verifyUserNameOrderOnPage(new String[]{"William10 Doe", "William11 Doe", "William12 Doe", "William13 Doe", "William14 Doe",
      "William15 Doe", "William16 Doe", "William17 Doe", "William18 Doe", "William19 Doe"});
    navigateToLastPage();
    verifyPageNumberSelected(3);
    verifyNextAndLastPageLinksDisabled();
    verifyPreviousAndFirstPageLinksEnabled();
    verifyNumberOfLineItemsVisibleOnPage(1);

    navigateToPreviousPage();
    verifyPageNumberSelected(2);
    verifyNextAndLastPageLinksEnabled();
    verifyPreviousAndFirstPageLinksEnabled();
    verifyNumberOfLineItemsVisibleOnPage(10);

    testWebDriver.sleep(500);
    userPage.clickCrossIcon();
    testWebDriver.sleep(500);
    assertFalse(userPage.isNameHeaderPresent());
  }

  @Test(groups = {"admin"}, dataProvider = "Data-Provider-Function-Positive")
  public void testCreateUserAndVerifyOnManageDistributionScreen(String user, String program, String[] credentials, String deliveryZoneCodeFirst,
                                                                String deliveryZoneCodeSecond, String deliveryZoneNameFirst, String deliveryZoneNameSecond,
                                                                String facilityCodeFirst, String facilityCodeSecond,
                                                                String programFirst, String programSecond, String schedule, String roleName) throws SQLException {
    setupDeliveryZoneRolesAndRights(deliveryZoneCodeFirst, deliveryZoneCodeSecond, deliveryZoneNameFirst, deliveryZoneNameSecond,
      facilityCodeFirst, facilityCodeSecond, programFirst, programSecond, schedule, roleName);
    String passwordUsers = "TQskzK3iiLfbRVHeM1muvBCiiKriibfl6lh8ipo91hb74G3OvsybvkzpPI4S3KIeWTXAiiwlUU0iiSxWii4wSuS8mokS2Aieie";
    String email = "Jasmine_Doe@openlmis.com";

    HomePage homePage = loginPage.loginAs(credentials[0], credentials[1]);
    UserPage userPage = homePage.navigateToUser();
    userPage.enterUserDetails(LAB_IN_CHARGE, email, "Jasmine", "Doe");

    userPage.clickViewHere();
    dbWrapper.updateUser(passwordUsers, email);
    userPage.enterDeliveryZoneDataWithoutHomeAndSupervisoryRolesAssigned(deliveryZoneNameFirst, programFirst, FIELD_COORDINATOR);
    userPage.clickSaveButton();

    testWebDriver.waitForAjax();
    userPage.clickViewHere();
    assertEquals(deliveryZoneNameFirst, dbWrapper.getDeliveryZoneNameAssignedToUser(LAB_IN_CHARGE));
    assertEquals(FIELD_COORDINATOR, dbWrapper.getRoleNameAssignedToUser(LAB_IN_CHARGE));
  }

  @Test(groups = {"admin"}, dataProvider = "Data-Provider-Role-Function")
  public void testRestrictLogin(String[] credentials) throws SQLException {
    String passwordUsers = "TQskzK3iiLfbRVHeM1muvBCiiKriibfl6lh8ipo91hb74G3OvsybvkzpPI4S3KIeWTXAiiwlUU0iiSxWii4wSuS8mokSAieie";
    String email = "Jasmine_Doe@openlmis.com";

    HomePage homePage = loginPage.loginAs(credentials[0], credentials[1]);
    UserPage userPage = homePage.navigateToUser();

    userPage.enterUserDetails(LAB_IN_CHARGE, email, "Jasmine", "Doe");
    dbWrapper.updateUser(passwordUsers, email);
    userPage.clickViewHere();

    userPage.clickRestrictLoginYes();
    userPage.clickSaveButton();
    homePage.logout(baseUrlGlobal);

    loginPage.loginAs(LAB_IN_CHARGE, credentials[1]);
    testWebDriver.sleep(500);
    assertEquals(loginPage.getLoginErrorMessage(), "The username or password you entered is incorrect. Please try again.");

    loginPage.clearUserName();
    loginPage.loginAs(credentials[0], credentials[1]);
    homePage.navigateToUser();
    userPage.searchUser(LAB_IN_CHARGE);
    userPage.clickSearchIcon();
    userPage.clickUserName(1);
    testWebDriver.waitForAjax();

    userPage.clickRestrictLoginNo();
    userPage.clickSaveButton();
    homePage.logout(baseUrlGlobal);
    loginPage.loginAs(LAB_IN_CHARGE, credentials[1]);
    homePage.verifyLoggedInUser(LAB_IN_CHARGE);
  }

  @Test(groups = {"admin"}, dataProvider = "Data-Provider-Role-Function")
  public void testSearchUserFunctionality(String[] credentials) throws SQLException {
    String passwordUsers = "TQskzK3iiLfbRVHeM1muvBCiiKriibfl6lh8ipo91hb74G3OvsybvkzpPI4S3KIeWTXAiiwlUU0iiSxWii4wSuS8mokSAieie";
    String email = "Jasmine_Doe@openlmis.com";

    HomePage homePage = loginPage.loginAs(credentials[0], credentials[1]);
    UserPage userPage = homePage.navigateToUser();
    userPage.enterUserDetails(LAB_IN_CHARGE, email, "Jasmine", "Doe");

    userPage.clickViewHere();
    dbWrapper.updateUser(passwordUsers, email);

    homePage.navigateToUser();
    userPage.searchUser(email);
    userPage.clickSearchIcon();
    testWebDriver.waitForAjax();
    assertEquals("1 match found for '" + email + "'", userPage.getOneResultMessage());
    assertEquals("Jasmine Doe", userPage.getName(1));

    homePage.navigateToUser();
    userPage.searchUser(LAB_IN_CHARGE);
    userPage.clickSearchIcon();
    testWebDriver.waitForAjax();
    assertEquals("1 match found for '" + LAB_IN_CHARGE + "'", userPage.getOneResultMessage());
    assertEquals("Jasmine Doe", userPage.getName(1));

    homePage.navigateToUser();
    userPage.searchUser("Doe");
    userPage.clickSearchIcon();
    testWebDriver.waitForAjax();
    assertEquals("2 matches found for 'Doe'", userPage.getNResultsMessage());
    assertEquals("Jasmine Doe", userPage.getName(1));

    homePage.navigateToUser();
    userPage.searchUser("Jasmine");
    userPage.clickSearchIcon();
    testWebDriver.waitForAjax();
    assertEquals("1 match found for 'Jasmine'", userPage.getOneResultMessage());
    assertEquals("Jasmine Doe", userPage.getName(1));
    userPage.clickUserName(1);
  }

  @Test(groups = {"admin"}, dataProvider = "Data-Provider-Role-Function")
  public void testResetPasswordLinkForDisabledUser(String[] credentials) throws SQLException {
    String email = "Jasmine_Doe@openlmis.com";

    HomePage homePage = loginPage.loginAs(credentials[0], credentials[1]);
    UserPage userPage = homePage.navigateToUser();
    userPage.enterUserDetails(LAB_IN_CHARGE, email, "Jasmine", "Doe");

    homePage.navigateToUser();
    userPage.searchUser(LAB_IN_CHARGE);
    userPage.clickSearchIcon();
    testWebDriver.waitForAjax();

    userPage.clickUserName(1);
    testWebDriver.waitForAjax();

    userPage.disableUser("Jasmine Doe");

    homePage.navigateToUser();
    userPage.searchUser(LAB_IN_CHARGE);
    userPage.clickSearchIcon();
    testWebDriver.waitForAjax();

    userPage.clickUserName(1);
    testWebDriver.waitForAjax();

    userPage.clickResetPasswordButton();
    assertEquals("User is disabled. Password cannot be reset", userPage.getSaveErrorMessage());
  }

  @Test(groups = {"admin"}, dataProvider = "Data-Provider-Role-Function")
  public void testResetPassword(String[] credentials) throws SQLException {
    String email = "Jasmine_Doe@openlmis.com";

    HomePage homePage = loginPage.loginAs(credentials[0], credentials[1]);
    UserPage userPage = homePage.navigateToUser();
    userPage.enterUserDetails(LAB_IN_CHARGE, email, "Jasmine", "Doe");

    homePage.navigateToUser();
    userPage.searchUser(LAB_IN_CHARGE);
    userPage.clickSearchIcon();
    userPage.clickUserName(1);
    testWebDriver.waitForAjax();
    userPage.resetPassword("abcd1234", "abcd1234");
    assertEquals("Password has been reset successfully", userPage.getSuccessMessage());
    homePage.logout(baseUrlGlobal);

    dbWrapper.updateFieldValue("users", "verified", true);
    loginPage.loginAs(LAB_IN_CHARGE, "abcd1234");
    homePage.verifyLoggedInUser(LAB_IN_CHARGE);
  }

  @Test(groups = {"admin"}, dataProvider = "Data-Provider-Function-Positive")
  public void testE2EManageRolesUsersAndFacility(String user, String program, String[] credentials, String deliveryZoneCodeFirst, String deliveryZoneCodeSecond,
                                                 String deliveryZoneNameFirst, String deliveryZoneNameSecond,
                                                 String facilityCodeFirst, String facilityCodeSecond,
                                                 String programFirst, String programSecond, String schedule, String roleName) throws SQLException {
    dbWrapper.insertUser(user, "Ag/myf1Whs0fxr1FFfK8cs3q/VJ1qMs3yuMLDTeEcZEGzstj/waaUsQNQTIKk1U5JRzrDbPLCzCO1/vB5YGaEQ==", "F10",
      "Jane_Doe@openlmis.com");
    dbWrapper.removeAllExistingRights("Admin");
    dbWrapper.assignRight("Admin", "MANAGE_FACILITY");

    HomePage homePage = loginPage.loginAs(credentials[0], credentials[1]);
    FacilityPage facilityPage = homePage.navigateManageFacility();
    homePage.clickCreateFacilityButton();

    String date_time = facilityPage.enterValuesInFacilityAndClickSave(facilityCodePrefix, facilityNamePrefix, program,
      geoZone, facilityType, operatedBy, "500000");
    String facility_code = facilityCodePrefix + date_time;
    String facility_name = facilityNamePrefix + date_time;

    facilityPage.verifyMessageOnFacilityScreen(facility_name, "created");
    homePage.logout();

    dbWrapper.removeAllExistingRights("Admin");
    dbWrapper.assignRight("Admin", "MANAGE_ROLE");
    dbWrapper.assignRight("Admin", "MANAGE_FACILITY");

    loginPage.loginAs(credentials[0], credentials[1]);
    List<String> userRoleList = asList(CREATE_REQUISITION, AUTHORIZE_REQUISITION, APPROVE_REQUISITION);
    createRoleAndAssignRights(userRoleList, LAB_IN_CHARGE, LAB_IN_CHARGE, "Requisition");
    createRoleAndAssignRights(asList("Manage Facilities"), "AdminRole", "", "Admin");
    createRoleAndAssignRights(asList("Manage Report"), "ReportingRole", "", "Reporting");

    RolesPage rolesPage = PageObjectFactory.getRolesPage(testWebDriver);
    rolesPage.clickRole(LAB_IN_CHARGE);
    assertTrue(rolesPage.isAdminRoleRadioEnabled());
    for (String right : userRoleList) {
      testWebDriver.sleep(500);
      assertTrue(rolesPage.isRightSelected(right));
    }
    homePage.navigateToRolePage();

    dbWrapper.insertSupervisoryNode(facility_code, "N1", "Node 1", "null");
    String passwordUsers = "TQskzK3iiLfbRVHeM1muvBCiiKriibfl6lh8ipo91hb74G3OvsybvkzpPI4S3KIeWTXAiiwlUU0iiSxWii4wSuS8mokSAieie";
    setupWarehouseRolesAndRights(facilityCodeFirst, facilityCodeSecond, programFirst, schedule, "SHIPMENT");
    String warehouseName = dbWrapper.getAttributeFromTable("facilities", "name", "code", facilityCodeFirst);
    homePage.logout();

    dbWrapper.removeAllExistingRights("Admin");
    dbWrapper.assignRight("Admin", "MANAGE_USER");
    dbWrapper.assignRight("Admin", "MANAGE_FACILITY");
    loginPage.loginAs(credentials[0], credentials[1]);

    createUserAndAssignRoles(passwordUsers, "Jasmine_Doe@openlmis.com", "Jasmine", "Doe", LAB_IN_CHARGE, facility_code, program, "Node 1", LAB_IN_CHARGE, "REQUISITION");
    userPage.assignWarehouse(warehouseName, warehouseRole);
    userPage.assignAdminRole("AdminRole");
    userPage.assignReportingRole("ReportingRole");
    userPage.clickSaveButton();

    userPage.verifyUserUpdated("Jasmine", "Doe");
    setupDeliveryZoneRolesAndRightsAfterWarehouse(deliveryZoneCodeFirst, deliveryZoneCodeSecond, deliveryZoneNameFirst,
      deliveryZoneNameSecond, facilityCodeFirst, facilityCodeSecond, programFirst, programSecond, schedule,
      roleName);

    userPage.clickViewHere();
    userPage.enterDeliveryZoneData(deliveryZoneNameFirst, programFirst, roleName);
    userPage.clickSaveButton();

    userPage.clickViewHere();
    userPage.clickDeliveryZonesAccordion();
    testWebDriver.sleep(1000);
    assertEquals(deliveryZoneNameFirst, userPage.getAddedDeliveryZoneLabel());

    userPage.clickHomeFacilityRolesAccordion();
    testWebDriver.sleep(500);
    userPage.removeRole(1, false);

    userPage.clickSupervisoryRolesAccordion();
    testWebDriver.sleep(500);
         userPage.verifyRolePresent(LAB_IN_CHARGE);
    userPage.removeRole(1, false);
    userPage.verifyRoleNotPresent(LAB_IN_CHARGE);
    userPage.clickRemoveButtonWithOk(2);

    userPage.clickWarehouseRolesAccordion();
    userPage.verifyRolePresent(warehouseRole);
    userPage.removeRole(1, false);
    userPage.verifyRoleNotPresent(warehouseRole);
    userPage.clickRemoveButtonWithOk(2);

    userPage.clickHomeFacilityRolesAccordion();
    testWebDriver.sleep(500);
    userPage.clickRemoveButtonWithOk(1);

    userPage.clickSaveButton();
    testWebDriver.waitForAjax();
    userPage.clickViewHere();
    testWebDriver.waitForAjax();

    userPage.clickHomeFacilityRolesAccordion();
    testWebDriver.sleep(500);
    userPage.verifyRoleNotPresent(LAB_IN_CHARGE);
    userPage.verifyRemoveNotPresent();
    verifyPushProgramNotAvailableForHomeFacilityRolesAndSupervisoryRoles();

    userPage.clickWarehouseRolesAccordion();
    testWebDriver.sleep(500);
    userPage.verifyRoleNotPresent(warehouseRole);
    userPage.verifyRemoveNotPresent();
    verifyWarehouseAvailableForWarehouseRoles(facilityCodeFirst, warehouseName);

    userPage.clickDeliveryZonesAccordion();
    testWebDriver.sleep(500);
    userPage.clickRemoveButtonWithOk(1);
    userPage.clickSaveButton();

    LoginPage loginPage = PageObjectFactory.getLoginPage(testWebDriver, baseUrlGlobal);
    homePage = loginPage.loginAs(LAB_IN_CHARGE, "Admin123");
    assertTrue(homePage.isHomeMenuTabDisplayed());
    assertFalse(homePage.isRequisitionsMenuTabDisplayed());
  }

  private void createUserAndAssignRoles(String passwordUsers, String userEmail, String userFirstName, String userLastName,
                                        String userUserName, String facility, String program, String supervisoryNode, String role,
                                        String roleType) throws SQLException {
    UserPage userPage = homePage.navigateToUser();
    userPage.enterUserDetails(userUserName, userEmail, userFirstName, userLastName);
    String expectedMessage = String.format("User \"%s %s\" has been successfully created," +
      " password link has been sent on registered Email address.  View Here", userFirstName, userLastName);
    assertEquals(expectedMessage, userPage.getSuccessMessage());
    userPage.clickViewHere();
    dbWrapper.updateUser(passwordUsers, userEmail);

    userPage.ExpandAll();
    assertTrue(userPage.isProgramsToSuperviseDisplayed());
    assertTrue(userPage.isProgramToDeliverDisplayed());

    userPage.collapseAll();
    testWebDriver.sleep(500);
    assertFalse(userPage.isProgramsToSuperviseDisplayed());
    assertFalse(userPage.isProgramToDeliverDisplayed());
    assertFalse(userPage.isWarehouseToSelectDisplayed());

    dbWrapper.updateFieldValue("facilities", "enabled", "false", "code", "F10");
    dbWrapper.updateFieldValue("facilities", "virtualFacility", "true", "code", "F11");
    assertFalse(userPage.isHomeFacilityAccordionDisplayed());
    userPage.clickHomeFacilityField();
    userPage.searchFacility("F1");
    assertEquals(userPage.getOneFacilityResultMessage(), "1 match found for 'F1'");
    assertEquals(userPage.getFacilityResult(1), "F10 - Village Dispensary");
    userPage.selectFacility(1);
    userPage.clearFacility();

    dbWrapper.updateFieldValue("facilities", "enabled", "true", "code", "F10");
    dbWrapper.updateFieldValue("facilities", "virtualFacility", "false", "code", "F11");

    userPage.enterMyFacilityAndMySupervisedFacilityData(facility, program, supervisoryNode, role, roleType);
  }

  private void createRoleAndAssignRights(List<String> userRoleList, String roleName, String roleDescription, String roleType) {
    RolesPage rolesPage = homePage.navigateToRolePage();
    rolesPage.createRole(roleName, roleDescription, userRoleList, roleType);
    assertEquals(rolesPage.getSuccessMessage(), "\"" + roleName + "\" created successfully");
  }

  private void verifyPushProgramNotAvailableForHomeFacilityRolesAndSupervisoryRoles() throws SQLException {
    assertFalse(userPage.getAllProgramsHomeFacility().contains("VACCINES"));
    userPage.clickSupervisoryRolesAccordion();
    assertFalse(userPage.getAllProgramsToSupervise().contains("VACCINES"));
  }

  private void verifyWarehouseAvailableForWarehouseRoles(String FacilityCode, String warehouseName) throws SQLException {
    assertTrue(userPage.getAllWarehouseToSelect().contains(warehouseName));
    assertFalse(userPage.getAllWarehouseToSelect().contains(facilityNamePrefix));
    dbWrapper.updateFieldValue("facilities", "enabled", "false", "name", warehouseName);
    userPage.clickSaveButton();

    userPage.clickViewHere();
    userPage.clickWarehouseRolesAccordion();
    assertFalse(userPage.getAllWarehouseToSelect().contains(warehouseName));
    dbWrapper.updateFieldValue("facilities", "enabled", "true", "name", warehouseName);
    dbWrapper.updateFieldValue("facilities", "active", "true", "code", FacilityCode);
    userPage.clickSaveButton();

    userPage.clickViewHere();
    userPage.clickWarehouseRolesAccordion();
    assertTrue(userPage.getAllWarehouseToSelect().contains(warehouseName));
  }

  private void verifyUserNameOrderOnPage(String[] nodeNames) {
    for (int i = 1; i < nodeNames.length; i++) {
      assertEquals(nodeNames[i - 1], userPage.getName(i));
    }
  }

  private void verifyNumberOfLineItemsVisibleOnPage(int numberOfLineItems) {
    assertEquals(numberOfLineItems, testWebDriver.getElementsSizeByXpath("//table[@id='userSearchResultTable']/tbody/tr"));
  }

  @AfterMethod(groups = {"admin"})
  public void tearDown() throws SQLException {
    testWebDriver.sleep(500);
    dbWrapper.removeAllExistingRights("Admin");
    dbWrapper.insertAllAdminRightsAsSeedData();
    if (!testWebDriver.getElementById("username").isDisplayed()) {
      HomePage homePage = PageObjectFactory.getHomePage(testWebDriver);
      homePage.logout(baseUrlGlobal);
      dbWrapper.deleteData();
      dbWrapper.closeConnection();
    }
  }

  @DataProvider(name = "Data-Provider-Role-Function")
  public Object[][] parameterIntRoleTestProvider() {
    return new Object[][]{
      {new String[]{"Admin123", "Admin123"}}
    };
  }

  @DataProvider(name = "Data-Provider-Function-Positive")
  public Object[][] parameterIntTestProviderPositive() {
    return new Object[][]{
      {"User123", "HIV", new String[]{"Admin123", "Admin123"}, "DZ1", "DZ2", "Delivery Zone First", "Delivery Zone Second",
        "F10", "F11", "VACCINES", "TB", "M", "Field Co-Ordinator"}
    };
  }
}