// odi.614 Able to generate reports for time range public void search() { String dmName = "US_AIRWAYS"; gotoreports(dmName); try { driver.findElement(By.id("PARAM_START_DATE")).clear(); Alert alert = driver.switchTo().alert(); alert.dismiss(); driver.findElement(By.id("PARAM_START_DATE")).sendKeys("8/11/2013"); driver.findElement(By.id("PARAM_END_DATE")).clear(); alert.dismiss(); driver.findElement(By.id("PARAM_END_DATE")).sendKeys("9/11/2013"); driver.findElement(By.cssSelector("input[type=\"submit\"]")).click(); driver.manage().timeouts().implicitlyWait(20, TimeUnit.SECONDS); new WebDriverWait(driver, 10) .until(ExpectedConditions.frameToBeAvailableAndSwitchToIt("reportContent")); WebElement page = new WebDriverWait(driver, 10) .until(ExpectedConditions.visibilityOfElementLocated(By.id("CrystalViewer"))); WebElement rangeStart = page.findElement(By.xpath("//*[contains(text(),'8/11/2013')]")); WebElement rangeEnd = page.findElement(By.xpath("//*[contains(text(),'9/11/2013')]")); if (rangeStart != null && rangeEnd != null) { System.out.println("Report for selected range is showed"); } ReportFile = new WriteXmlFile(); driver.switchTo().defaultContent(); ReportFile.addTestCase("ODI6.x-614:CSSR-Search", "ODI6.x-614:CSSR-Search => Pass"); } catch (Exception e) { System.out.print("trace: "); e.printStackTrace(); } // driver.quit(); ReportFile.WriteToFile(); }
// odi.618 Method for finding the lables of filters public void findthelables() { String dmname = "US_AIRWAYS"; gotoreports(dmname); try { driver.manage().timeouts().implicitlyWait(20, TimeUnit.SECONDS); isElementpresent(Element1, By.id("date_range_label")); isElementpresent(Element2, By.id("PARAM_START_DATE_label")); isElementpresent(Element3, By.id("PARAM_END_DATE_label")); isElementpresent(Element4, By.id("PARAM_TIME_ZONE_label")); isElementpresent(Element5, By.id("PARAM_APP_ID_label")); isElementpresent(Element6, By.id("PARAM_DNIS_label")); isElementpresent(Element7, By.id("PARAM_LOCALE_label")); ReportFile.addTestCase( "ODI6.x-618:Labeling of Call Stat Summary filters", "ODI6.x-618:Labeling of Call Stat Summary filters => Pass"); } catch (Exception e) { System.out.print("trace: "); e.printStackTrace(); } ReportFile.WriteToFile(); }
// odi.623.Method for DNIS value search public void dnisfilter() { String dmName = "US_AIRWAYS"; gotoreports(dmName); try { WebElement DNISvalue = driver.findElement(By.id("PARAM_DNIS")); Select select = new Select(DNISvalue); select.deselectAll(); select.selectByValue("2404953077"); driver .manage() .timeouts() .implicitlyWait( 20, TimeUnit .SECONDS); // submit should be clickable if delay is there in selecting the DNIS driver.findElement(By.cssSelector("input[type=\"submit\"]")).click(); new WebDriverWait(driver, 10) .until(ExpectedConditions.frameToBeAvailableAndSwitchToIt("reportContent")); WebElement page = new WebDriverWait(driver, 10) .until(ExpectedConditions.visibilityOfElementLocated(By.id("CrystalViewer"))); WebElement tag = page.findElement(By.xpath("//*[contains(text(),'2404953077')]")); if (tag != null) { System.out.println("DNIS:2404953077 filter is present"); ReportFile.addTestCase( "ODI6.x-623:DNIS filter: selected DNIS filter should be shown in report result", "ODI6.x-623:DNIS filter: selected DNIS filter should be shown in report result => Pass"); } } catch (Exception e) { System.out.print("trace: "); e.printStackTrace(); } // driver.quit(); ReportFile.WriteToFile(); driver.switchTo().defaultContent(); }
// ODI6.x-627:generate cssr report with valid filters and check the number if they are reasonable public void cssrNumbers() { int CallVolumeValue = 0, TransfersValue = 0, PeakHourValue = 0; double roundOff = 0, AverageCallValue = 0; String dmName = "US_AIRWAYS"; gotoreports(dmName); pickAvalidDate(); try { new WebDriverWait(driver, 10) .until(ExpectedConditions.frameToBeAvailableAndSwitchToIt("reportContent")); WebElement page = new WebDriverWait(driver, 10) .until(ExpectedConditions.visibilityOfElementLocated(By.id("CrystalViewer"))); List<WebElement> check = page.findElements(By.tagName("span")); for (int i = 0; i < check.size(); i++) { String content = (check.get(i).getText()); if (content.equals("Call Volume")) { String CallVolume = (check.get(i + 1).getText()); String[] CallVolumes = CallVolume.split("\\s"); CallVolumeValue = Integer.parseInt(CallVolumes[1]); System.out.println(CallVolumeValue); } else if (content.equals("Transfers (All)")) { String TransfersAll = (check.get(i + 1).getText()); String[] Tvalues = TransfersAll.split("\\s"); TransfersValue = Integer.parseInt(Tvalues[1]); System.out.println(TransfersValue); } else if (content.equals("Peak Hour Call Volume")) { String PeakHourCallVolume = (check.get(i + 1).getText()); String[] PeakHourCallValues = PeakHourCallVolume.split("\\s"); PeakHourValue = Integer.parseInt(PeakHourCallValues[1]); } else if (content.equals("Call Duration (minutes)")) { String CallDuration = (check.get(i + 1).getText()); String[] CallDurationValues = CallDuration.split("\\s"); double CallDurationValue = Double.parseDouble(CallDurationValues[1]); double x = CallDurationValue / CallVolumeValue; roundOff = Math.round(x * 100.0) / 100.0; } else if (content.equals("Average Call Duration (minutes)")) { String AverageCallDuration = (check.get(i + 1).getText()); String[] AverageCallDurationValues = AverageCallDuration.split("\\s"); AverageCallValue = Double.parseDouble(AverageCallDurationValues[1]); } } try { if (CallVolumeValue >= TransfersValue) { logger.info("the call volume is greater than the Transfer"); System.out.println("CallVolumeValue >= TransfersValue"); } if (PeakHourValue <= CallVolumeValue) { System.out.println("PeakHourValue <= CallVolumeValue"); } if (AverageCallValue == roundOff) { System.out.println("Average Call Duration =Call Duration (minutes)/Call Volume"); } } catch (Exception e) { e.printStackTrace(); } ReportFile.addTestCase( "ODI6.x-627:CSSR numbers must be reasonable", "ODI6.x-627:CSSR numbers must be reasonable => Pass"); } catch (Exception e) { e.printStackTrace(); } ReportFile.WriteToFile(); driver.quit(); }