package SeleniumLearn.COM;
import java.io.FileInputStream;
import java.util.concurrent.TimeUnit;
import jxl.Sheet;
import jxl.Workbook;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.openqa.selenium.chrome.ChromeDriver;
import org.testng.annotations.Test;
import org.testng.annotations.BeforeTest;
import org.testng.annotations.AfterTest;

public class TechLearn_Login_ReTesting {
public WebDriver driver;
  @Test
  public void TechLearndotin_Login_ReTesting() throws Exception{
  driver.manage().timeouts().implicitlyWait(9, TimeUnit.SECONDS);
  FileInputStream fi=new FileInputStream("/home/chinna/Selenium/Testdata/Login.xls"); // Add you'r Login.xls sheet path
  Workbook w=Workbook.getWorkbook(fi);
  Sheet s=w.getSheet("Sheet1");
  for (int i = 1; i < s.getRows(); i++) {
  driver.get("http://www.techlearn.in/user");
  driver.findElement(By.id("edit-name")).sendKeys(s.getCell(0, i).getContents());
  driver.findElement(By.id("edit-pass")).sendKeys(s.getCell(1, i).getContents());
  driver.findElement(By.id("edit-submit")).click();
try{Thread.sleep(5000);
    driver.findElement(By.linkText("Log out")).click();
    System.out.println("Pass");
    }
catch(Exception e){System.out.println("Fail");}
   }}
  @BeforeTest
  public void beforeTest() {
driver=new FirefoxDriver();
//System.setProperty("webdriver.chrome.driver","/home/chinna/lib/chromedriver"); //--->chrome browser path
//driver=new ChromeDriver();
driver.manage().window().maximize();
}
@AfterTest
public void afterTest() {
}

}