def add_existing_capability(self): so = SeleniumOperations(self.v_task_type, self.v_driver, self.lo) capabilities_sheet = so.call_excel_sheet('Capabilities') for row_counter in range(5, 6): for col_counter in range(2, (capabilities_sheet.max_column) + 1): so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_ADD_EXISTING_CAPABILITY_BUTTON) time.sleep(2) so.switch_child_window_handle() so.switch_to_default_frame() so.click_element_by_xpath( LocalElementLocator.DC4_PREPROD_PLUS_SEARCH_BUTTON) capability_uid = capabilities_sheet.cell( row=row_counter, column=col_counter).value so.send_text_by_xpath( LocalElementLocator.DC4_PREPROD_CAPABILITY_UID, capability_uid) so.click_element_by_xpath( LocalElementLocator.DC4_PREPROD_FEC_SEARCH_BUTTON) so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_SEARCHED_CAPABILITY_UID_CHECKBOX) so.click_element_by_xpath( LocalElementLocator.DC4_PREPROD_FEC_CHOOSE_BUTTON) so.switch_parent_window_handle()
def add_new_capability(self): so = SeleniumOperations(self.v_task_type, self.v_driver, self.lo) po_service_uid = "1007" return_documents_service_uid = "1006" #capabilities_sheet=so.call_excel_sheet('Capabilities') capabilities_sheet = self.v_input_wb.get_sheet_by_name('Capabilities') #Loop to Iterate through the Capabilities Excel Sheet #for row_counter in range (1,(capabilities_sheet.max_row)+1): for row_counter in range(1, 2): for col_counter in range(2, (capabilities_sheet.max_column) + 1): so.click_element_by_xpath( LocalElementLocator.DC4_PREPROD_CAPABILITY_TAB) so.click_element_by_xpath( LocalElementLocator.DC4_PREPROD_ADD_CAPABILITY_BUTTON) sheet_value = capabilities_sheet.cell(row=row_counter, column=col_counter).value #Switch to Create Capability Child Window; so.switch_child_window_handle() so.switch_to_default_frame() time.sleep(2) #Click on the Search Service Torch; Switch to the Search Service Child Window so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_SERVICE_TORCH) time.sleep(2) so.switch_child_window_handle() so.switch_to_default_frame() #If Condition to validate serviceUID input based on Inbound/Outbound Documents if str(sheet_value) == "850" or str( sheet_value) == "850 Outbound": so.send_text_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_SERVICE_SERVICE_UID, po_service_uid) else: so.send_text_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_SERVICE_SERVICE_UID, return_documents_service_uid) so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_SEARCH_SERVICES_SEARCH_BUTTON) so.get_text_by_xpath( LocalElementLocator. DC4_PREPROD_SEARCH_SERVICES_SEARCH_RESULT_SERVICE_UID) #print(so.get_text_by_xpath(LocalElementLocator.DC4_PREPROD_CREATE_CAPABILITY_SERVICE_SERVICE_UID)) #print(so.get_text_by_xpath(LocalElementLocator.DC4_PREPROD_SEARCH_SERVICES_SEARCH_RESULT_SERVICE_UID)) sheet_value_service_uid_validation = str( capabilities_sheet.cell(row=row_counter + 1, column=col_counter).value) print("Adding Capability") print( so.get_text_by_xpath( LocalElementLocator. DC4_PREPROD_SEARCH_SERVICES_SEARCH_RESULT_SERVICE_UID)) #Validating ServiceUID Input with the SearchResult & Clicking Choose if sheet_value_service_uid_validation == str( so.get_text_by_xpath( LocalElementLocator. DC4_PREPROD_SEARCH_SERVICES_SEARCH_RESULT_SERVICE_UID )): so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_SEARCH_SERVICES_CHOOSE_BUTTON) else: print("Service Validation Failed") return time.sleep(1) so.switch_child_window_handle() so.switch_to_default_frame() so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_CAPABILITY_TORCH) time.sleep(1) so.switch_child_window_handle() so.switch_to_default_frame() sheet_value_capability_name = str( capabilities_sheet.cell(row=row_counter + 2, column=col_counter).value) print(sheet_value_capability_name) so.send_text_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_SEARCH_DATATYPES_DATATYPE_NAME, sheet_value_capability_name) so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_SEARCH_DATATYPES_SEARCH_BUTTON ) datatype_name_result_table_count = len( so.list_elements_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_SEARCH_DATATYPES_DATATYPE_NAME_RESULT_TABLE )) #print(datatype_name_result_table_count) if datatype_name_result_table_count > 2: self.v_driver.close() so.switch_child_window_handle() self.v_driver.close() return else: so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_SEARCH_DATATYPES_SEARCHED_CAPABILITY_CHECKBOX ) so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_SEARCH_DATATYPES_CHOOSE_BUTTON ) time.sleep(1) so.switch_child_window_handle() so.switch_to_default_frame() sheet_value_capability_notes = str( capabilities_sheet.cell(row=row_counter + 3, column=col_counter).value) so.send_text_by_xpath( LocalElementLocator.DC4_PREPROD_CREATE_CAPABILITY_NOTES, sheet_value_capability_notes) so.click_element_by_xpath( LocalElementLocator. DC4_PREPROD_CREATE_CAPABILITY_SUBMIT_BUTTON) so.switch_parent_window_handle() #so.switch_to_default_frame() print("Great! New Capabilities have been Added :) ")