public void ATC4405_CRMBusinessHoursandAfterHoursphone() { #region Start Up Excel MyBook = MyApp.Workbooks.Open(DatasourceDir + @"\Clients.xlsx", 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); MySheet = (Excel.Worksheet)MyBook.Sheets[Properties.Settings.Default.ENVIRONMENT.ToString()]; MyRange = MySheet.UsedRange; //Get specific row for the data int testDataRows = MyRange.Rows.Count; int MyRow = 0; for (int i = 2; i <= testDataRows; i++) { if (MyRange.Cells[i, 1].Value.ToString() == "ClientTestData") { MyRow = i; break; } } #endregion string clientName = (MyRange.Cells[MyRow, ClientsSchema.GetColumnIndex("CLIENT_NAME")].Value.ToString()); //Login in as role User user = this.environment.GetUser(SecurityRole.GeneralStaff); new LoginDialog().Login(user.Id, user.Password); HomePage homePage = new HomePage(driver); homePage.HoverCRMRibbonTab(); homePage.ClickClientServicesRibbonButton(); homePage.HoverClientServicesRibbonTab(); homePage.ClickClientsRibbonButton(); ClientsSearchPage clientsSearchPage = new ClientsSearchPage(driver); clientsSearchPage.SetClientSearchText(clientName); Table table = new Table(clientsSearchPage.GetSearchResultTable()); StringAssert.Equals(table.GetCellValue("Full Name", clientName, "Full Name"), clientName); table.ClickCellValue("Full Name", clientName, "Full Name"); //Navigate to client phone numbers homePage.HoverClientXRibbonTab(clientName); homePage.ClickClientXPhoneNumbersRibbonButton(); //Add new phone numbers ClientPage clientPage = new ClientPage(driver); string BaseWindow = driver.CurrentWindowHandle; clientPage.ClickAddNewClientPhoneImage(); //Enter payment reference details driver = UICommon.SwitchToNewBrowserWithTitle(driver, BaseWindow, "Client Phone Number"); //Assert availability list ClientPhoneNumberPage clientPhoneNumberPage = new ClientPhoneNumberPage(driver); Assert.IsTrue(clientPhoneNumberPage.GetAvailabilityListItem("Business hours only")); Assert.IsTrue(clientPhoneNumberPage.GetAvailabilityListItem("After hours only")); Assert.IsTrue(clientPhoneNumberPage.GetAvailabilityListItem("Anytime")); //Create 3 new phone numbers //clientPhoneNumberPage.ClickTypeList(); clientPhoneNumberPage.SetTypeListValue("Fixed Line"); //clientPhoneNumberPage.ClickAreaCodeElement(); clientPhoneNumberPage.SetAreaCodeValue("07"); //clientPhoneNumberPage.ClickPhoneNumberElement(); clientPhoneNumberPage.SetPhoneNumberValue("11111111"); clientPhoneNumberPage.ClickSaveButton(); //Assert new phone number has saved string phoneNumber = clientPhoneNumberPage.GetPhoneNumber(); clientPhoneNumberPage.ClickNewButton(); clientPhoneNumberPage.ClickPageTitle(); clientPhoneNumberPage.SetClientNameList(clientName); //clientPhoneNumberPage.SetClientNameListValue("BLAIR TEST"); //clientPhoneNumberPage.ClickTypeList(); clientPhoneNumberPage.SetTypeListValue("Mobile"); //clientPhoneNumberPage.ClickPhoneNumberElement(); clientPhoneNumberPage.SetPhoneNumberValue("0422222222"); clientPhoneNumberPage.ClickSaveButton(); //Assert new phone number has saved string phoneNumber2 = clientPhoneNumberPage.GetPhoneNumber(); clientPhoneNumberPage.ClickNewButton(); clientPhoneNumberPage.ClickPageTitle(); clientPhoneNumberPage.SetClientNameList(clientName); //clientPhoneNumberPage.SetClientNameListValue("BLAIR TEST"); //clientPhoneNumberPage.ClickTypeList(); clientPhoneNumberPage.SetTypeListValue("Fax"); //clientPhoneNumberPage.ClickAreaCodeElement(); clientPhoneNumberPage.SetAreaCodeValue("07"); //clientPhoneNumberPage.ClickPhoneNumberElement(); clientPhoneNumberPage.SetPhoneNumberValue("33333333"); clientPhoneNumberPage.ClickSaveButton(); //Assert new phone number has saved string phoneNumber3 = clientPhoneNumberPage.GetPhoneNumber(); clientPhoneNumberPage.ClickSaveCloseButton(); clientPhoneNumberPage.ClickSaveCloseButton(); clientPhoneNumberPage.ClickSaveCloseButton(); driver = driver.SwitchTo().Window(BaseWindow); clientPage.SetClientSearchText(clientName); table = new Table(clientPage.GetSearchResultTable()); StringAssert.Equals(table.GetCellValue("Client", clientName, "Full Phone Number"), phoneNumber); #region Shut down Excel MyBook.Save(); MyBook.Close(); MyApp.Quit(); #endregion }