Пример #1
0
 def test_728(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ActivityHubPage()
     page.open()
     page.add_location_button.click()
     page = AddStartingLocationPage()
     select = Select(page.location_Country)
     select.select_by_visible_text('United States')
     select = Select(page.location_state)
     time.sleep(3)
     select.select_by_visible_text('Florida')
     page.location_zipcode.send_keys('54321')
     State = select.first_selected_option.text
     Zip = page.location_zipcode.get_attribute('value')
     select = Select(page.location_Country)
     select.select_by_visible_text('Canada')
     time.sleep(3)
     select = Select(page.location_state)
     assert select.first_selected_option.text == State
     assert page.location_zipcode.get_attribute('value') == Zip
     select = Select(page.location_Country)
     select.select_by_visible_text('Mexico')
     time.sleep(3)
     assert page.location_zipcode.get_attribute('value') == Zip
     select = Select(page.location_Country)
     select.select_by_visible_text('United States')
     time.sleep(3)
     select = Select(page.location_state)
     assert select.first_selected_option.text == State
     assert page.location_zipcode.get_attribute('value') == Zip
Пример #2
0
 def test_113(self):  #DELETE BRANCH
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = BranchPage()
     page.open()
     for i in range(0, len(page.branch_names)):
         if page.branch_names[i].get_attribute(
                 'textContent') == BranchEditedNameList[0]:
             page.delete_buttons[i - 1].click()
         else:
             continue
         break
     time.sleep(3)
     branch_list = []
     for i in range(0, len(page.branch_names)):
         branch_list.append(
             page.branch_names[i].get_attribute('textContent'))
     assert BranchEditedNameList[0] not in branch_list
     page = CustomerBranchPage()
     page.open()
     customer_branch_list = []
     for i in range(0, len(page.branch_tickets)):
         customer_branch_list.append(
             page.branch_tickets[i].get_attribute('textContent'))
     assert BranchEditedNameList[0] not in customer_branch_list
 def test_923(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = EditCompanyPage()
     page.open()
     time.sleep(5)
     if page.viator_checkbox.is_selected() == False:
         page.viator_checkbox.click()
         page.save_button.click()
         page.open()
     else:
         pass
     assert page.viator_checkbox.is_selected() == True
     SupplierID = page.viator_supplierID.get_attribute('value')
     SupplierIDlist.append(SupplierID)
     page.viator_checkbox.click()
     assert page.viator_checkbox.is_selected() == False
     assert page.is_element_present('viator_supplierID') == False
     page.save_button.click()
     cnxn = pyodbc.connect(
         'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server +
         ';DATABASE=' + database + ';UID=' + username + ';PWD=' +
         password)  # STEP 14
     cursor = cnxn.cursor()
     cursor.execute(
         "SELECT company_viator_useAPI FROM company WHERE company_id = 68")
     row = cursor.fetchone()
     assert row[0] == 0
 def test_731(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     time.sleep(5)
     page = EmployeePage()
     page.open()
     time.sleep(5)
     page.search_field.send_keys(user_name)
     time.sleep(2)
     page.edit_user_button.click()
     time.sleep(2)
     select = Select(page.state_list)
     State = select.first_selected_option.text
     Zip = page.user_zip.get_attribute('value')
     select = Select(page.country_list)
     select.select_by_visible_text('Canada')
     time.sleep(3)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State
     assert page.user_zip.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('Mexico')
     time.sleep(3)
     assert page.user_zip.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('United States')
     time.sleep(3)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State
     assert page.user_zip.get_attribute('value') == Zip
 def test_723(self):  #ADD BRANCH
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = EditCompanyPage()
     page.open()
     select = Select(page.state_list)
     State = select.first_selected_option.text
     Zip = page.zip_field.get_attribute('value')
     select = Select(page.country_list)
     select.select_by_visible_text('Canada')
     time.sleep(3)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State
     assert page.zip_field.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('Mexico')
     time.sleep(3)
     select = Select(page.state_list)
     assert page.zip_field.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('United States')
     time.sleep(3)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State
     assert page.zip_field.get_attribute('value') == Zip
Пример #6
0
 def test_16(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = GuidePayrollPage()
     page.open()
     select = Select(page.guide_list)
     select.select_by_visible_text(GuideName)
     time.sleep(6)
     for i in range(0, len(page.check)):
         if page.check[i].is_displayed():
             page.check[i].click()
         else:
             continue
         break
     time.sleep(2)
     for i in range(0, len(page.check_number)):
         if page.check_number[i].is_displayed():
             page.check_number[i].send_keys(CheckNumber)
         else:
             continue
         break
     time.sleep(6)
     for i in range(0, len(page.pay_button)):
         if page.pay_button[i].is_displayed():
             page.pay_button[i].click()
         else:
             continue
         break
     time.sleep(6)
     alert = get_driver().switch_to_alert()
     assert (guide_flat_due+' to '+''.join(GuideName)) in alert.text
     alert.accept()
     time_and_date = datetime.now(AT).strftime('%#m/%#d/%Y %#I:%M')
     print(time_and_date)
     time.sleep(2)
     page.OK_button.click()
     time.sleep(15)
     select = Select(page.show_entries)
     select.select_by_visible_text('100')
     time.sleep(5)
     # try:
     #     page.next_button.click()
     # except WebDriverException:
     #     print("Less than 100 Entries")
     # time.sleep(4)
     L=[]
     # for i in range(0, len(page.payment_entry)):
     #     L.append(page.payment_entry[i].get_attribute('textContent'))
     for i in range(0, len(page.payment_entry)): #until fixing 2904 Incorrect sorting of Recent Payments by date on guide_payroll.aspx
         if time_and_date in page.payment_entry[i].get_attribute('textContent'):
             L.append(page.payment_entry[i].get_attribute('textContent'))
             assert GuideName and guide_flat_due in page.payment_entry[i].get_attribute('textContent')
         else:
             continue
         break
     assert len(L) ==1  #until fixing 2904 Incorrect sorting of Recent Payments by date on guide_payroll.aspx
 def test_363(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ActivityHubPage()
     page.open()
     InactiveActivity = 'Sometimes inactive activity'
     page.search_activity_field.send_keys(InactiveActivity)
     page.show_inactive.click()
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(10)
     select = Select(page.activity_status)
     NewActivityStatus = "Inactive"
     select.select_by_visible_text(NewActivityStatus )
     page.save_button.click()
     page = NavigationBar()
     time.sleep(8)
     page.main_actions_drop_down.click()
     page.add_a_booking.click()
     time.sleep(8)
     page = AdminBookingPage()
     page.activity_list.click()
     L=[]
     for i in range(0, len(page.activities_in_list)):
         L.append(page.activities_in_list[i].get_attribute("textContent"))
     assert InactiveActivity not in L
 def test_124(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ActivityHubPage()
     page.open()
     page.add_location_button.click()
     page = AddStartingLocationPage()
     OldLocationNamePart = "AutoTestLoc"
     page.search_location.send_keys(OldLocationNamePart)
     page = LocationLink()
     for i in range(0, len(page.location_links)):
         if OldLocationNamePart in page.location_links[i].get_attribute(
                 "textContent"):
             if page.location_links[i].is_displayed():
                 page.location_links[i].click()
     page = AddStartingLocationPage()
     ExistedLocationName = page.location_name.get_attribute('value')
     get_driver().back()
     page.location_name.send_keys(ExistedLocationName)
     time.sleep(4)
     assert page.is_element_present('alert_message') == True
     assert page.save_button.is_enabled() == False
 def test_402(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     time.sleep(5)
     page = EmployeePage()
     page.open()
     page.add_new_user.click()
     NewUserName = ("autotest402_" +
                    ''.join(choice(digits) for i in range(4)))
     page.username_field.send_keys(NewUserName)
     NewUserPassword = ('' + ''.join(choice(digits)
                                     for i in range(8)) + 'qwer')
     page.password_field.send_keys(NewUserPassword)
     first_names = ('Ivan', 'Peter', 'John', 'Bill', 'Michael', 'Sidor',
                    'Alex', 'James')
     NewFirstName = random.choice(first_names)
     page.first_name_field.send_keys(NewFirstName)
     last_names = ('Smith', 'Baker', 'Petroff', 'Smirnoff', 'Black',
                   'White', 'Broun', 'Ivanoff')
     NewLastName = random.choice(last_names)
     page.last_name_field.send_keys(NewLastName)
     NewPhone1 = ('' + ''.join(choice(digits) for i in range(10)))
     page.phone1_field.send_keys(NewPhone1)
     NewEmail = ('' + ''.join(choice(digits)
                              for i in range(10)) + '@mailinator.com')
     page.email_field.send_keys(NewEmail)
     select = Select(page.role_list)
     NewRole = "Office Staff"
     select.select_by_visible_text(NewRole)
     select = Select(page.payroll_type_list)
     NewPayrollType = "weekly"
     select.select_by_visible_text(NewPayrollType)
     NewSalaryAmount = '100'
     page.amount_field.send_keys(NewSalaryAmount)
     page.status_checkbox.click()
     page.save_button.click()
     time.sleep(6)
     page.search_field.clear()
     page.search_field.send_keys(NewEmail)
     time.sleep(6)
     page.edit_user_button.click()
     time.sleep(2)
     assert page.username_readonly_field.get_attribute(
         'value') == NewUserName
     assert page.first_name_field.get_attribute('value') == NewFirstName
     assert page.last_name_field.get_attribute('value') == NewLastName
     assert page.phone1_field.get_attribute('value') == NewPhone1
     assert page.email_field.get_attribute('value') == NewEmail
     select = Select(page.role_list)
     assert select.first_selected_option.text == NewRole
     select = Select(page.payroll_type_list)
     assert select.first_selected_option.text == NewPayrollType
     assert page.amount_field.get_attribute('value') == NewSalaryAmount
     assert page.status_checkbox.get_attribute('checked') == 'true'
 def test_118(self):
     get_driver().maximize_window()
     page = GuidePage()
     page.profile_dropdown.click()
     wait = WebDriverWait(get_driver(), 15)
     wait.until(lambda driver: page.is_element_present('logout_button'))
     page.logout_button.click()
     page = loginpage()
     assert page.url == get_driver().current_url
 def test_780(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.button.click()
     time.sleep(5)
     assert get_driver().current_url == page.url
     assert page.error_login.is_displayed()
     assert page.error_login.get_attribute(
         'textContent') == "ERROR: Your login was incorrect"
 def test_117(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(guide1_login)
     page.password_field.send_keys(guide1_password)
     page.button.click()
     time.sleep(5)
     page = GuidePage()
     assert page.url == get_driver().current_url
Пример #13
0
 def test_116(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ActivityHubPage()
     page.open()
     activity_partnames = ('AutoTest', 'test1', '3110', '25102017',
                           'TESTEDIT', 'REGRESSION', 'Regr')
     activity_partname = random.choice(activity_partnames)
     page.search_activity_field.send_keys(activity_partname)
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     ActivityName = page.activity_name.get_attribute('value')
     page.ticket_maximum.clear()
     page.ticket_maximum.send_keys('50')
     page.ticket_minimum.clear()
     page.ticket_minimum.send_keys('51')
     page.ticket_maximum.click()
     assert page.ticket_maximum.get_attribute('value') == '50'
     assert page.ticket_minimum.get_attribute('value') == '51'
     time.sleep(5)
     assert page.is_element_present('ticket_maximum_alert') == True
     assert page.ticket_maximum_alert.is_displayed()
     page.save_button.click()
     time.sleep(5)
     assert page.ticket_maximum_alert.is_displayed()
     page.ticket_maximum.clear()
     page.ticket_maximum.send_keys('10')
     page.ticket_minimum.clear()
     page.ticket_minimum.send_keys('9')
     assert page.ticket_maximum.get_attribute('value') == '10'
     assert page.ticket_minimum.get_attribute('value') == '9'
     time.sleep(5)
     assert page.is_element_present('ticket_maximum_alert') == False
     page.save_button.click()
     page.save_button.click()
     time.sleep(5)
     page = ActivityHubPage()
     get_driver().refresh()
     page.search_activity_field.send_keys(ActivityName)
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     assert page.ticket_maximum.get_attribute('value') == '10'
     assert page.ticket_minimum.get_attribute('value') == '9'
     assert page.is_element_present('ticket_maximum_alert') == False
Пример #14
0
 def test_314(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page=ActivityHubPage()
     page.open()
     activity_partnames = ('test1', '3110', '25102017', 'TESTEDIT', 'REGRESSION', 'Regr')
     activity_partname = random.choice(activity_partnames)
     page.search_activity_field.send_keys(activity_partname)
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     ActivityName = page.activity_name.get_attribute('value')
     page.first_ticket_price.clear()
     page.first_ticket_price.send_keys('-100')
     assert page.first_ticket_price.get_attribute('value')=='100'
     page.first_ticket_price.clear()
     page.first_ticket_price.send_keys('abc')
     assert page.first_ticket_price.get_attribute('value')==''
     page.first_ticket_price.clear()
     page.first_ticket_price.send_keys('0.01')
     assert page.first_ticket_price.get_attribute('value')=='0.01'
     page.save_button.click()
     time.sleep(5)
     page = ActivityHubPage()
     get_driver().refresh()
     page.search_activity_field.send_keys(ActivityName)
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     assert page.first_ticket_price.get_attribute('value') == '0.01'
     page.first_ticket_price.clear()
     page.first_ticket_price.send_keys('0.9')
     assert page.first_ticket_price.get_attribute('value') == '0.9'
     page.save_button.click()
     time.sleep(5)
     page = ActivityHubPage()
     get_driver().refresh()
     page.search_activity_field.send_keys(ActivityName)
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     assert page.first_ticket_price.get_attribute('value') == '0.9'
Пример #15
0
 def test_121(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ActivityHubPage()
     page.open()
     page.show_inactive.click()
     page.search_activity_field.send_keys('TestEdit')
     ExistedActivityName = page.activity_title.get_attribute("textContent")
     page.add_activity_button.click()
     time.sleep(10)
     page = AddEditActivityPage()
     page.activity_name.send_keys(ExistedActivityName)
     page.activity_url.click()
     time.sleep(5)
     assert page.is_element_present('alert_message') == True
     select = Select(page.activity_status)
     NewActivityStatus = "Active"
     select.select_by_visible_text(NewActivityStatus)
     select = Select(page.branch)
     NewActivityBranch = "First branch"
     select.select_by_visible_text(NewActivityBranch)
     select = Select(page.starting_location)
     NewActivityLocation = "Hotel California"
     select.select_by_visible_text(NewActivityLocation)
     select = Select(page.time_zone)
     NewActivityTimezone = "Central"
     select.select_by_visible_text(NewActivityTimezone)
     NewActivityCancellationPolicy = 'We can cancel an event any time we want.'
     page.cancellation_policy.send_keys(NewActivityCancellationPolicy)
     NewActivityDurationDays = '0'
     page.activity_duration_days.send_keys(NewActivityDurationDays)
     NewActivityDurationHours = '2'
     page.activity_duration_hours.send_keys(NewActivityDurationHours)
     NewActivityDurationMinutes = '15'
     page.activity_duration_minutes.send_keys(NewActivityDurationMinutes)
     page.stop_booking_sold.click()
     select = Select(page.stop_booking_sold)
     NewActivityStopbookingSold = "1h 30 m"
     select.select_by_visible_text(NewActivityStopbookingSold)
     NewActivityFirstTicketType = "Adult"
     page.first_ticket_type.send_keys(NewActivityFirstTicketType)
     NewActivityFirstTicketPrice = '9.99'
     page.first_ticket_price.send_keys(NewActivityFirstTicketPrice)
     page.save_button.click()
     time.sleep(5)
     assert page.is_element_present(
         'alert_message') == True  #failed - bug 2432
     assert get_driver().current_url == page.url  #failed - bug 2432
 def test_778(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     invalid_pwd = (''.join(choice(digits) for i in range(7)))
     page.password_field.send_keys(invalid_pwd)
     page.button.click()
     time.sleep(5)
     assert get_driver().current_url == page.url
     assert page.error_login.is_displayed()
     assert page.error_login.get_attribute(
         'textContent') == "ERROR: Your login was incorrect"
Пример #17
0
 def test_3(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = logoutpage()
     page.profile_dropdown.click()
     wait = WebDriverWait(get_driver(), 15)
     wait.until(lambda driver: page.is_element_present('logout_button'))
     page.logout_button.click()
     assert get_driver().current_url == 'https://dev.godo.io/login.aspx'
     get_driver().quit()
Пример #18
0
 def test_123(self):  #2 BRANCHES WITH THE SAME NAME
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = BranchPage()
     page.open()
     branch_list = []
     for i in range(0, len(page.branch_names)):
         branch_list.append(
             page.branch_names[i].get_attribute('textContent'))
     time.sleep(3)
     page.add_branch_button.click()
     BranchName = branch_list[-1]
     page.branch_name_field.send_keys(BranchName)
     BranchNewNameList.append(BranchName)
     select = Select(page.timezone_list)
     NewBranchTimeZone = "Atlantic"
     select.select_by_visible_text(NewBranchTimeZone)
     NewBranchAddress1 = "test012"
     page.branch_address1.send_keys(NewBranchAddress1)
     NewBranchAddress2 = "test012"
     page.branch_address2.send_keys(NewBranchAddress2)
     select = Select(page.country_list)
     NewBranchCountry = "United States"
     select.select_by_visible_text(NewBranchCountry)
     time.sleep(6)
     select = Select(page.state_list)
     NewBranchState = "Washington"
     select.select_by_visible_text(NewBranchState)
     NewBranchCity = "Seattle"
     page.branch_city.send_keys(NewBranchCity)
     NewBranchZip = "12341"
     page.branch_zip.send_keys(NewBranchZip)
     NewBranchEmail = "*****@*****.**"
     page.branch_email.send_keys(NewBranchEmail)
     NewBranchPhone1 = "(206)624-3287"
     page.branch_phone1.send_keys(NewBranchPhone1)
     NewBranchPhone2 = "(206)624-3287"
     page.branch_phone2.send_keys(NewBranchPhone2)
     page.save_button.click()
     time.sleep(3)
     assert page.is_element_present('alert_message') == True
     branch_list1 = []
     for i in range(0, len(page.branch_names)):
         branch_list1.append(
             page.branch_names[i].get_attribute('textContent'))
     assert len(branch_list1) == len(branch_list)
Пример #19
0
 def test_4(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_hourly_login)
     page.password_field.send_keys(admin_hourly_password)
     page.button.click()
     page = NavigationBar()
     time.sleep(6)
     page.time_tracker.click()
     time.sleep(tracked_time_seconds)
     page.time_tracker_checked.click()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = EmployeePayrollPage()
     page.open()
     time.sleep(3)
     page.employee_payment_due_hourly.click()
     L = []
     for i in range(0, len(page.hourly_payment_due_enties)):
         if admin_hourly_name in page.hourly_payment_due_enties[
                 i].get_attribute("textContent"):
             L.append(
                 page.hourly_employee_payment_due_amounts[i].get_attribute(
                     "textContent"))
         else:
             continue
         break
     time.sleep(3)
     assert len(L) == 1
     payment_due_amount_number = float("{0:.1f}".format(
         float(re.sub("[^\d\.]", "", L[0]))))
     assert payment_due_amount_number == amount_tracked
Пример #20
0
 def test_510(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ActivityHubPage()
     page.open()
     page.search_activity_field.send_keys(Activity1)
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     if page.is_element_present('remove_fourth_linked_activity') == True:
         page.remove_fourth_linked_activity.click()
     if page.is_element_present('remove_third_linked_activity') == True:
         page.remove_third_linked_activity.click()
     if page.is_element_present('remove_second_linked_activity') == True:
         page.remove_second_linked_activity.click()
     if page.is_element_present('remove_first_linked_activity') == True:
         page.remove_first_linked_activity.click()
     time.sleep(7)
     select = Select(page.first_linked_activity)
     time.sleep(5)
     select.select_by_visible_text(Activity2)
     page.save_button.click()
     page = ActivityHubPage()
     page.search_activity_field.send_keys(Activity1)
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     select = Select(page.first_linked_activity)
     assert select.first_selected_option.text == Activity2
     page.cancel_button.click()
     page = ActivityHubPage()
     page.search_activity_field.send_keys(Activity2)
     time.sleep(5)
     text = page.activity_title.get_attribute("textContent")
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     select = Select(page.first_linked_activity)
     assert select.first_selected_option.text == Activity1
Пример #21
0
 def test_781(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ChannelPage()
     page.open()
     time.sleep(5)
     page.search_field.send_keys(ChannelName)
     time.sleep(2)
     page.table_channel_editbutton.click()
     select = Select(page.comission_type_list)
     if select.first_selected_option.text == 'Percentage':
         pass
     else:
         select.select_by_visible_text('Percentage')
     if page.comission_amount.get_attribute('value') == Amount:
         pass
     else:
         page.comission_amount.clear()
         page.comission_amount.send_keys(Amount)
     page.save_button.click()
     time.sleep(5)
     page.search_field.send_keys(ChannelName)
     time.sleep(2)
     page.table_channel_editbutton.click()
     select = Select(page.comission_type_list)
     NewComissionType = 'Dollar Amount'
     select.select_by_visible_text(NewComissionType)
     page.save_button.click()
     time.sleep(5)
     page.search_field.send_keys(ChannelName)
     time.sleep(2)
     assert page.table_channel_comission.get_attribute(
         'textContent') == '$' + ''.join(Amount)
     page.table_channel_editbutton.click()
     time.sleep(2)
     select = Select(page.comission_type_list)
     assert select.first_selected_option.text == 'Dollar Amount'
     select.select_by_visible_text('Percentage')
     page.save_button.click()
     time.sleep(5)
     page.search_field.send_keys(ChannelName)
     time.sleep(2)
     assert page.table_channel_comission.get_attribute(
         'textContent') == Amount + '%'
 def test_877(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = CustomerListPage()
     page.open()
     page.add_customer_button.click()
     first_names = ('Ivan', 'Peter', 'John', 'Bill', 'Michael', 'Sidor',
                    'Alex', 'James', 'Bob', 'Ivan', 'Tim', 'Chris', 'Jim',
                    'Pahom', 'Vlad', 'Paul')
     NewFirstName = random.choice(first_names)
     page.first_name_field.send_keys(NewFirstName)
     last_names = ('Smith', 'Baker', 'Petroff', 'Smirnoff', 'Black',
                   'White', 'Broun', 'Ivanoff', 'Green', 'Clinton',
                   'Jameson', 'Last', 'Sergeff', 'Madison')
     NewLastName = random.choice(last_names)
     NewFullName = NewFirstName + ' ' + ''.join(NewLastName)
     page.last_name_field.send_keys(NewLastName)
     NewEmail = (''.join(choice(digits)
                         for i in range(15)) + '@mailinator.com')
     page.email_field.send_keys(NewEmail)
     page.save_button.click()
     time.sleep(5)
     page.search_field.send_keys(NewFullName)
     page.search_button.click()
     time.sleep(5)
     assert page.customer_name_in_list.get_attribute(
         'textContent') == NewFullName
     assert page.email_in_list.get_attribute('textContent') == NewEmail
     page.edit_button.click()
     assert page.customer_name_info.get_attribute(
         'textContent') == NewFullName + "'s"
     assert page.email_info.get_attribute('innerText') == NewEmail
     cnxn = pyodbc.connect(
         'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server +
         ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password)
     cursor = cnxn.cursor()
     cursor.execute(
         "SELECT TOP 1 * FROM customer ORDER BY customer_id DESC")
     row = cursor.fetchone()
     assert row[1] == 68  #company ID
     assert row[2] == NewFirstName
     assert row[3] == NewLastName
     assert row[12] == NewEmail
     assert row[17] == NewEmail  #CustomerKey
Пример #23
0
 def test_790(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ChannelPage()
     page.open()
     time.sleep(2)
     page.search_field.send_keys(ChannelName)
     time.sleep(2)
     page.table_channel_editbutton.click()
     time.sleep(5)
     select = Select(page.country_list)
     if select.first_selected_option.text == 'United States':
         pass
     else:
         select.select_by_visible_text('United States')
     select = Select(page.state_list)
     if select.first_selected_option.text == 'California':
         pass
     else:
         select.select_by_visible_text('California')
     if page.zip_code.get_attribute('value') == '45355':
         pass
     else:
         page.zip_code.clear()
         page.zip_code.send_keys('45355')
     State = select.first_selected_option.text
     Zip = page.zip_code.get_attribute('value')
     select = Select(page.country_list)
     select.select_by_visible_text('Canada')
     time.sleep(3)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State  #Bug2952
     assert page.zip_code.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('Mexico')
     time.sleep(3)
     assert page.zip_code.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('United States')
     time.sleep(3)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State
     assert page.zip_code.get_attribute('value') == Zip
 def test_595(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = WaiverAddPage()
     page.open()
     page.add_waiver_button.click()
     page.ok_confirm_button.click()
     time.sleep(7)
     page.logo_checkbox.click()
     NewWaiverName = ("AutoTest_" +
                      ''.join(choice(digits) for i in range(4)))
     page.waiver_title.send_keys(NewWaiverName)
     NewWaiverHeader = "TestHeader"
     page.text_fields[0].send_keys(NewWaiverHeader)
     page.next_button.click()
     # select = Select(page.field_add)
     # NewFieldAdd = "Date of Signing"
     # select.select_by_visible_text(NewFieldAdd)
     # page.insert_button.click()
     time.sleep(8)
     page.text_fields[1].send_keys(
         'By signing this waiver agreement, _________________ agrees to the following terms: Assumption of Risk. PandaTip: This waiver agreement template protects you by ensuring that your client understands that they are participating in your event at their own risk, and that all risk and liability rests with them. The Client agrees that their participation in [Event.Name] is voluntary. Furthermore, the Client agrees to assume any risk associated with participating in the event, and releases [Sender.Company] from any and all claims of loss or damage that may arise during the Client’s participation. Such releases are without limitation, and include attorneys’ fees, personal injury, property damage, and any other losses or damages suffered by the Client.'
     )
     page.next1_button.click()
     NewWaiverRefer = "Dear Friends"
     page.refer_field.send_keys(NewWaiverRefer)
     page.save_button.click()
     time.sleep(10)
     select = Select(page.entries_per_page)
     select.select_by_visible_text('100')
     time.sleep(2)
     L = []
     for i in range(0, len(page.waiver_names)):
         L.append(page.waiver_names[i].get_attribute("textContent"))
     assert (NewWaiverName + ' ') in L
     for i in range(0, len(page.waiver_entries)):
         if (NewWaiverName +
                 ' ') in page.waiver_name[i].get_attribute("textContent"):
             assert page.count_value[i].get_attribute("textContent") == '0'
Пример #25
0
 def test_726(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page=PeopleHubPage()
     page.open()
     time.sleep(2)
     page.your_customer_button.click()
     time.sleep(2)
     page = CustomerListPage()
     page.add_customer_button.click()
     time.sleep(3)
     select = Select(page.country_list)
     select.select_by_visible_text('United States')
     select = Select(page.state_list)
     time.sleep(3)
     select.select_by_visible_text('Florida')
     page.customer_zip.send_keys('54321')
     State = select.first_selected_option.text
     Zip = page.customer_zip.get_attribute('value')
     select = Select(page.country_list)
     select.select_by_visible_text('Canada')
     time.sleep(5)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State
     assert page.customer_zip.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('Mexico')
     time.sleep(3)
     assert page.customer_zip.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('United States')
     time.sleep(3)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State
     assert page.customer_zip.get_attribute('value') == Zip
 def test_947(self):  #ADD BRANCH
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = BranchPage()
     page.open()
     for i in range(0, len(page.branch_names)):
         if 'Ghost City Tourss Main Branch' == page.branch_names[
                 i].get_attribute('textContent'):
             page.branch_edit_buttons[i].click()
         else:
             continue
         break
     time.sleep(3)
     select = Select(page.state_list)
     State = select.first_selected_option.text
     Zip = page.branch_zip.get_attribute('value')
     select = Select(page.country_list)
     select.select_by_visible_text('Canada')
     time.sleep(3)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State
     assert page.branch_zip.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('Mexico')
     time.sleep(3)
     assert page.branch_zip.get_attribute('value') == Zip
     select = Select(page.country_list)
     select.select_by_visible_text('United States')
     time.sleep(3)
     select = Select(page.state_list)
     assert select.first_selected_option.text == State
     assert page.branch_zip.get_attribute('value') == Zip
 def test_729(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ActivityHubPage()
     page.open()
     page.add_location_button.click()
     page = AddStartingLocationPage()
     page.search_location.send_keys('Chris Falvey')
     page = LocationLink()
     for i in range(0, len(page.location_links)):
         if page.location_links[i].is_displayed():
             page.location_links[i].click()
     page = AddStartingLocationPage()
     select = Select(page.location_state)
     State = select.first_selected_option.text
     Zip = page.location_zipcode.get_attribute('value')
     select = Select(page.location_Country)
     select.select_by_visible_text('Canada')
     time.sleep(3)
     select = Select(page.location_state)
     assert select.first_selected_option.text == State
     assert page.location_zipcode.get_attribute('value') == Zip
     select = Select(page.location_Country)
     select.select_by_visible_text('Mexico')
     time.sleep(3)
     assert page.location_zipcode.get_attribute('value') == Zip
     select = Select(page.location_Country)
     select.select_by_visible_text('United States')
     time.sleep(3)
     select = Select(page.location_state)
     assert select.first_selected_option.text == State
     assert page.location_zipcode.get_attribute('value') == Zip
 def test_186(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     time.sleep(5)
     page = EmployeePage()
     page.open()
     page.add_new_user.click()
     NewUserName = ("autotest_" + ''.join(choice(digits) for i in range(4)))
     page.username_field.send_keys(NewUserName)
     NewUserPassword = ('' + ''.join(choice(digits)
                                     for i in range(8)) + 'qwer')
     page.password_field.send_keys(NewUserPassword)
     first_names = ('Ivan', 'Peter', 'John', 'Bill', 'Michael', 'Sidor',
                    'Alex', 'James')
     NewFirstName = random.choice(first_names)
     page.first_name_field.send_keys(NewFirstName)
     last_names = ('Smith', 'Baker', 'Petroff', 'Smirnoff', 'Black',
                   'White', 'Broun', 'Ivanoff')
     NewLastName = random.choice(last_names)
     page.last_name_field.send_keys(NewLastName)
     NewFullName = NewFirstName + ' ' + ''.join(NewLastName)
     fullname_list.append(NewFullName)
     NewPhone1 = ('' + ''.join(choice(digits) for i in range(10)))
     page.phone1_field.send_keys(NewPhone1)
     NewPhone2 = ('' + ''.join(choice(digits) for i in range(10)))
     page.phone2_field.send_keys(NewPhone2)
     NewEmail = ('' + ''.join(choice(digits)
                              for i in range(10)) + '@mailinator.com')
     page.email_field.send_keys(NewEmail)
     email_list.append(NewEmail)
     select = Select(page.role_list)
     NewRole = "Office Staff"
     select.select_by_visible_text(NewRole)
     select = Select(page.payroll_type_list)
     NewPayrollType = "weekly"
     select.select_by_visible_text(NewPayrollType)
     NewSalaryAmount = '100'
     page.amount_field.send_keys(NewSalaryAmount)
     page.status_checkbox.click()
     NewHireDate = '09/25/2018'
     page.hire_date_field.send_keys(NewHireDate)
     NewEndDate = '09/25/2020'
     page.end_date_field.send_keys(NewEndDate)
     time.sleep(5)
     NewUserHouseNumber = '' + ''.join(choice(digits) for i in range(2))
     page.house_number_field.send_keys(NewUserHouseNumber)
     NewUserStreet = 'Main Street'
     page.street_field.send_keys(NewUserStreet)
     NewUserCity = 'Boston'
     page.city_field.send_keys(NewUserCity)
     NewUserCountry = "United States"
     select = Select(page.country_list)
     select.select_by_visible_text(NewUserCountry)
     NewUserState = 'Florida'
     select = Select(page.state_list)
     time.sleep(3)
     select.select_by_visible_text(NewUserState)
     NewUserZip = '54321'
     page.user_zip.send_keys('54321')
     select = Select(page.branch_list)
     NewBranch = "AlexeyBranch"
     select.select_by_visible_text(NewBranch)
     NewAccountOwnerName = 'TestAccountOwner'
     page.name_account_owner_field.send_keys(NewAccountOwnerName)
     NewBankName = 'BSB Bank'
     page.bank_name_field.send_keys(NewBankName)
     time.sleep(5)
     NewRoutingNumber = '' + ''.join(choice(digits) for i in range(8))
     page.routing_number_field.send_keys(NewRoutingNumber)
     NewAccountNumber = '' + ''.join(choice(digits) for i in range(8))
     page.account_number_field.send_keys(NewAccountNumber)
     NewEmergencyContact = '' + ''.join(choice(digits) for i in range(8))
     page.em_contact_field.send_keys(NewEmergencyContact)
     NewEmergencyPhone = '' + ''.join(choice(digits) for i in range(8))
     page.em_phone_field.send_keys(NewEmergencyPhone)
     L = []
     for i in range(0, len(page.permission_entries)):
         if page.permission_checkbox[i].get_attribute('checked') == 'true':
             L.append(page.permission_entries[i].get_attribute('outerText'))
         else:
             continue
     page.save_button.click()
     time.sleep(6)
     page.search_field.clear()
     page.search_field.send_keys(NewEmail)
     time.sleep(6)
     page.edit_user_button.click()
     time.sleep(2)
     assert page.username_readonly_field.get_attribute(
         'value') == NewUserName
     assert page.first_name_field.get_attribute('value') == NewFirstName
     assert page.last_name_field.get_attribute('value') == NewLastName
     assert page.phone1_field.get_attribute('value') == NewPhone1
     assert page.phone2_field.get_attribute('value') == NewPhone2
     assert page.email_field.get_attribute('value') == NewEmail
     select = Select(page.role_list)
     assert select.first_selected_option.text == NewRole
     select = Select(page.payroll_type_list)
     assert select.first_selected_option.text == NewPayrollType
     assert page.amount_field.get_attribute('value') == NewSalaryAmount
     assert page.status_checkbox.get_attribute('checked') == 'true'
     assert page.hire_date_field.get_attribute('value') == NewHireDate
     assert page.end_date_field.get_attribute('value') == NewEndDate
     assert page.house_number_field.get_attribute(
         'value') == NewUserHouseNumber
     assert page.street_field.get_attribute('value') == NewUserStreet
     assert page.city_field.get_attribute('value') == NewUserCity
     select = Select(page.country_list)
     assert select.first_selected_option.text == NewUserCountry
     select = Select(page.state_list)
     assert select.first_selected_option.text == NewUserState
     assert page.user_zip.get_attribute('value') == NewUserZip
     select = Select(page.branch_list)
     assert select.first_selected_option.text == NewBranch
     assert page.name_account_owner_field.get_attribute(
         'value') == NewAccountOwnerName
     assert page.bank_name_field.get_attribute('value') == NewBankName
     assert page.routing_number_field.get_attribute(
         'value') == NewRoutingNumber
     assert page.account_number_field.get_attribute(
         'value') == NewAccountNumber
     L1 = []
     for i in range(0, len(page.permission_entries)):
         if page.permission_checkbox[i].get_attribute('checked') == 'true':
             L1.append(
                 page.permission_entries[i].get_attribute('outerText'))
         else:
             continue
     assert L == L1
 def test_600(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page=ActivityHubPage() #STEP1
     page.open()
     page.add_activity_button.click() #STEP2
     page=AddEditActivityPage()
     time.sleep(15)
     assert page.switchers1[0].get_attribute("outerHTML") == switcher_OFF
     page.stop_no_sales.send_keys('-1')#STEP3
     page.minimum_not_met_alert.click()
     assert page.stop_no_sales.get_attribute('value')=='0'
     page.stop_no_sales.send_keys('10000001')#STEP4
     page.minimum_not_met_alert.click()
     assert page.stop_no_sales.get_attribute('value')=='100'
     page.stop_no_sales.clear()#STEP5
     page.stop_no_sales.send_keys('1')
     page.minimum_not_met_alert.click()
     assert page.stop_no_sales.get_attribute('value')=='1'
     NewActivityName = ("AutoTest600_" + ''.join(choice(digits) for i in range(4)))
     page.activity_name.send_keys(NewActivityName)
     select = Select(page.activity_status)
     NewActivityStatus = "Inactive"
     select.select_by_visible_text(NewActivityStatus)
     select = Select(page.branch)
     NewActivityBranch = "AlexeyBranch"
     select.select_by_visible_text(NewActivityBranch)
     select = Select(page.starting_location)
     NewActivityLocation = "Hotel California"
     select.select_by_visible_text(NewActivityLocation)
     select = Select(page.time_zone)
     NewActivityTimezone = "Pacific"
     select.select_by_visible_text(NewActivityTimezone)
     NewActivityCancellationPolicy = 'We can cancel an event any time we want.'
     page.cancellation_policy.send_keys(NewActivityCancellationPolicy)
     NewActivityDurationMinutes = '15'
     page.activity_duration_minutes.send_keys(NewActivityDurationMinutes)
     page.ticket_maximum.clear()
     NewActivityMaxTickets = '100'
     page.ticket_maximum.send_keys(NewActivityMaxTickets)
     NewActivityFirstTicketType = "Adult"
     page.first_ticket_type.send_keys(NewActivityFirstTicketType)
     NewActivityFirstTicketPrice = '9.99'
     page.first_ticket_price.send_keys(NewActivityFirstTicketPrice)
     page.stop_booking_sold.click()
     select = Select(page.stop_booking_sold)
     NewActivityStopbookingSold = "15 m"
     select.select_by_visible_text(NewActivityStopbookingSold)
     page.save_button.click()
     time.sleep(5)
     page = ActivityHubPage()
     time.sleep(5)
     page.show_inactive.click()
     page.search_activity_field.send_keys(NewActivityName)  # STEP6
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     assert page.switchers1[0].get_attribute("outerHTML") == switcher_OFF
     assert page.stop_no_sales.get_attribute('value') == '1'
     cnxn = pyodbc.connect(
         'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password)# STEP7
     cursor = cnxn.cursor()
     cursor.execute("SELECT TOP 1 activity_stopbooking_hoursbefore, activity_stopbooking_midnightbefore, activity_name FROM activity ORDER BY activity_id DESC")
     row = cursor.fetchone()
     assert row[0] == 1
     assert row[1] == 0
     assert row[2] == NewActivityName
     page.switchers1[0].click()#STEP8
     assert page.switchers1[0].get_attribute("outerHTML") != switcher_OFF
     assert page.stop_no_sales.get_attribute('value') == ''
     assert page.stop_no_sales.is_enabled()==False
     page.save_button.click()#STEP9
     time.sleep(5)
     page = ActivityHubPage()
     time.sleep(5)
     page.show_inactive.click()
     page.search_activity_field.send_keys(NewActivityName)
     time.sleep(5)
     page.activity_actions.click()
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     assert page.switchers1[0].get_attribute("outerHTML") != switcher_OFF
     assert page.stop_no_sales.is_enabled() == False
     cursor.execute("SELECT TOP 1 activity_stopbooking_hoursbefore, activity_stopbooking_midnightbefore, activity_name FROM activity ORDER BY activity_id DESC")#STEP10
     row = cursor.fetchone()
     assert row[0] == 0
     assert row[1] == 1
     assert row[2] == NewActivityName
 def test_81(self):
     get_driver().maximize_window()
     page = loginpage()
     page.open()
     page.login_field.send_keys(admin_login)
     page.password_field.send_keys(admin_password)
     page.button.click()
     page = ActivityHubPage()
     page.open()
     page.add_activity_button.click()
     page = AddEditActivityPage()
     time.sleep(5)
     NewActivityName = ("AutoTest81_" +
                        ''.join(choice(digits) for i in range(4)))
     ActivityNameList.append(NewActivityName)
     page.activity_name.send_keys(NewActivityName)
     select = Select(page.activity_status)
     NewActivityStatus = "Active"
     select.select_by_visible_text(NewActivityStatus)
     select = Select(page.branch)
     NewActivityBranch = "AlexeyBranch"
     select.select_by_visible_text(NewActivityBranch)
     select = Select(page.starting_location)
     NewActivityLocation = "Hotel California"
     select.select_by_visible_text(NewActivityLocation)
     select = Select(page.time_zone)
     NewActivityTimezone = "Pacific"
     select.select_by_visible_text(NewActivityTimezone)
     NewActivityCancellationPolicy = 'We can cancel an event any time we want.'
     page.cancellation_policy.send_keys(NewActivityCancellationPolicy)
     NewActivityDurationMinutes = '15'
     page.activity_duration_minutes.send_keys(NewActivityDurationMinutes)
     page.ticket_maximum.clear()
     NewActivityMaxTickets = '100'
     page.ticket_maximum.send_keys(NewActivityMaxTickets)
     NewActivityFirstTicketType = "Adult"
     page.first_ticket_type.send_keys(NewActivityFirstTicketType)
     NewActivityFirstTicketPrice = '9.99'
     page.first_ticket_price.send_keys(NewActivityFirstTicketPrice)
     page.stop_booking_sold.click()
     select = Select(page.stop_booking_sold)
     NewActivityStopbookingSold = "15 m"
     select.select_by_visible_text(NewActivityStopbookingSold)
     page.save_button.click()
     time.sleep(5)
     page = ActivityHubPage()
     page.search_activity_field.send_keys(NewActivityName)
     time.sleep(5)
     page.activity_actions.click()
     text = page.activity_title.get_attribute("textContent")
     assert text == NewActivityName
     page.edit_activity.click()
     page = AddEditActivityPage()
     time.sleep(15)
     assert page.activity_name.get_attribute('value') == NewActivityName
     select = Select(page.activity_status)
     assert select.first_selected_option.text == NewActivityStatus
     select = Select(page.branch)
     assert select.first_selected_option.text == NewActivityBranch
     select = Select(page.starting_location)
     assert select.first_selected_option.text == NewActivityLocation
     select = Select(page.time_zone)
     assert select.first_selected_option.text == NewActivityTimezone
     assert page.cancellation_policy.get_attribute(
         'value') == NewActivityCancellationPolicy
     assert page.activity_duration_minutes.get_attribute(
         'value') == NewActivityDurationMinutes
     assert page.ticket_maximum.get_attribute(
         'value') == NewActivityMaxTickets
     assert page.first_ticket_type.get_attribute(
         'value') == NewActivityFirstTicketType
     assert page.first_ticket_price.get_attribute(
         'value') == NewActivityFirstTicketPrice
     for i in range(0, len(page.switchers1)):
         assert page.switchers1[i].get_attribute(
             "outerHTML") == switcher_OFF
     for i in range(0, len(page.switchers2)):
         assert page.switchers2[i].get_attribute(
             "outerHTML") == switcher_OFF
     assert page.switcher_minimum_enforce.get_attribute(
         "outerHTML") == switcher_OFF
     select = Select(page.stop_booking_sold)
     assert select.first_selected_option.text == NewActivityStopbookingSold
     cnxn = pyodbc.connect(
         'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' + server +
         ';DATABASE=' + database + ';UID=' + username + ';PWD=' +
         password)  #STEP8
     cursor = cnxn.cursor()
     cursor.execute(
         "SELECT TOP 1 * FROM activity ORDER BY activity_id DESC")
     row = cursor.fetchone()
     assert row[1] == 68  #company id
     assert row[2] == 47  #location_id
     assert row[3] == 386  #branch_id
     assert row[4] == 9  #timezone_id
     assert row[6] == NewActivityName
     assert row[11] == NewActivityCancellationPolicy
     assert row[14] == 0  #Firstsalecloseevent
     assert row[15] == 0  # StopBookingNoSales
     assert row[16] == 15  # StopBookingSold
     assert row[17] == 0  # StopBookingMidBefore
     assert row[21] == 15  #Duration
     assert row[32] == True  #GuideUponSellout
     assert row[33] == 1  #ActivityStatus
     assert row[36] == 0  #Tickets Minimum Enforce
     assert row[37] == 0  # Viator
     assert row[39] == 0  # 2-step Check In