package dataDrivenTestingExample;

import java.io.File;
import java.io.FileInputStream;
import java.util.concurrent.TimeUnit;

import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;

public class DataDrivenTest {
 
 
 @Test(dataProvider = "data")
 public void DataDrivenTest1(String LoanAmount, String InterestRate, String Tenure){
  
  WebDriver driver = new FirefoxDriver();
  
  driver.navigate().to("https://emicalculator.site/");
  
  driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS);
  driver.manage().window().maximize();
  
  driver.findElement(By.xpath("//*[@id='frm-emi']/p[1]/input")).sendKeys(LoanAmount);
  driver.findElement(By.xpath("//*[@id='frm-emi']/p[2]/input")).sendKeys(InterestRate);
  driver.findElement(By.xpath("//*[@id='frm-emi']/div/div/input")).sendKeys(Tenure);
  driver.findElement(By.xpath("//*[@id='frm-emi']/p[3]/input")).click();
  
  driver.close();
  
 }
 
 
 @DataProvider(name = "data")
 public Object[][] testDataSupplier() throws Exception{
 //file path where excel file placed, containing test data.
  String filePath = "C:UsersPrakashworkspaceLearnTestNGTestDataSheet.xlsx";
  
  //read excel file using file input stream, using Apache POI
  FileInputStream fis = new FileInputStream(new File (filePath));
  XSSFWorkbook wb = new XSSFWorkbook(fis);
  XSSFSheet sheet = wb.getSheet("TestData");
  
  //calculate total number of rows and columns so that we can iterate over it.
  int totalNumberOfRows = sheet.getLastRowNum()+1;
  int totalNumberOfCols = sheet.getRow(0).getLastCellNum();
  
  //create an object array. which will store the test data from excel file
  Object[][] testdata1 = new Object[totalNumberOfRows][totalNumberOfCols];

  
  for (int i = 0; i <totalNumberOfRows; i++ ){
   for (int j = 0; j < totalNumberOfCols; j++){

  testdata1[i][j] =  sheet.getRow(i).getCell(j).toString();   
   }
  }
  return testdata1;
 }

}

package runTestNGxmlFromCMD;

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.testng.annotations.Test;

public class RunTestNGTest {
 
 @Test
 public void test() throws InterruptedException{
  
  WebDriver driver = new FirefoxDriver();
  
  driver.navigate().to("https://learnaboutsoftwaretesting.blogspot.in");
  
  System.out.println("navigate to website");
  
  Thread.sleep(3000); //sleep for 3 second so that you can observe that site is opened, before it closes quickly
  
  driver.close();
  
 }

}

package crossBrowserTests;

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.openqa.selenium.ie.InternetExplorerDriver;
import org.testng.annotations.AfterMethod;
import org.testng.annotations.BeforeMethod;
import org.testng.annotations.Parameters;

public class CrossBrowserTestFromTestNG {
 
 WebDriver driver;
 
 @Parameters("browser")
 @BeforeMethod
 public void lanuchBrowser(String browser){
  
  if (browser.equalsIgnoreCase("firefox")){
   
   driver  = new FirefoxDriver();
   System.out.println("Browser selected for testing is :  Firefox");

  }
  else if (browser.equalsIgnoreCase("chrome")){
   System.setProperty("webdriver.chrome.driver", "C:chromedriver.exe");
  
   driver = new ChromeDriver();
   System.out.println("Browser selected for testing is :  Google Chrome");

  }
  else if (browser.equalsIgnoreCase("ie")){
   System.setProperty("webdriver.ie.driver", "C:IEDriverServer.exe");
   driver = new InternetExplorerDriver();
   System.out.println("Browser selected for testing is :  IE");
  }
 }
 
 @org.testng.annotations.Test
 public void Test(){
 
  driver.navigate().to("https://learnaboutsoftwaretesting.blogspot.in");
  System.out.println("Title of the webpage is: "+driver.getTitle());
 }
 
 @AfterMethod
 public void closeBrowser(){
  driver.close();
 }
 

 }