[![/*import static org.junit.Assert.assertTrue;
import junit.framework.Assert;

import org.junit.BeforeClass;
import org.junit.FixMethodOrder;
import org.junit.Test;
import org.junit.runners.MethodSorters;
*/import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Date;
import java.util.LinkedHashMap;
import java.util.Map;
import java.util.Set;

import jxl.Workbook;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.openqa.selenium.By;
import org.openqa.selenium.NoSuchElementException;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.chrome.ChromeOptions;
import org.openqa.selenium.support.ui.Select;
import org.testng.Assert;
import org.testng.annotations.AfterClass;
import org.testng.annotations.BeforeClass;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;

//@FixMethodOrder(MethodSorters.NAME_ASCENDING)
public class Register
{

    static WebDriver driver;

    String  expectedurl = "http://example.com/account-page/?ihc_register=create_message";

     static HSSFWorkbook workbook;
      static HSSFSheet sheet;
      static Map<String, Object[]> testresultdata;

    @BeforeClass
    public static void setup() throws IOException
    {


        System.setProperty("webdriver.chrome.driver", "E:\Selenium Jar\chromedriver.exe");
        ChromeOptions options = new ChromeOptions();
        options.addArguments("--disable-extensions");
        driver = new ChromeDriver(options);
        driver.manage().window().maximize();

        workbook = new HSSFWorkbook();

           sheet = workbook.createSheet("Register");

           testresultdata = new LinkedHashMap<String, Object[]>();
           testresultdata.put("1", new Object[] {"TestCasesNo", "UserName","Email","Name","Password","Confirm Password","Expected Result","Actual Result", "Pass/Fail"});

    }

    @Test
    public void a_register()
    {
        driver.get("http://example.com/");
        WebElement regmain = driver.findElement(By.className("reg"));
        regmain.click();
    }

    @DataProvider(name = "Authentication")

      public static Object[][] credentials() {

            return new Object[][] { { " ", " "," "," "," "}};

      }


    @Test(dataProvider = "Authentication")
    public void b_blankdata(String uname,String email,String strname,String strpass,String strconpass)
    {
        driver.get("http://example.com//register/");


        WebElement username = driver.findElement(By.name("user_login"));
        username.clear();
        username.sendKeys(uname);

        WebElement mail = driver.findElement(By.name("user_email"));
        mail.clear();
        mail.sendKeys(email);

        WebElement name = driver.findElement(By.name("user_Name"));
        name.clear();
        name.sendKeys(strname);

        Select se = new Select(driver.findElement(By.name("country")));
        se.selectByIndex(3);

        WebElement password = driver.findElement(By.name("pass1"));
        password.clear();
        password.sendKeys(strpass);

        WebElement confirmpassword = driver.findElement(By.name("pass2"));
        confirmpassword.clear();
        confirmpassword.sendKeys(strconpass);

        WebElement submit = driver.findElement(By.id("ihc_submit_bttn"));
        submit.click();

        String actual = driver.getCurrentUrl();

        if(actual.equals(expectedurl))
        {
            Assert.assertTrue(true);
            testresultdata.put("2", new Object[] {1d, uname, email,strname,strpass,strconpass,expectedurl,actual ,"Pass"});
        }
        else
        {
            testresultdata.put("2", new Object[] {1d, uname, email,strname,strpass,strconpass,expectedurl,actual ,"Fail"});
            Assert.assertTrue(false);

        }

    }
    @DataProvider(name = "Authentication2")

      public static Object[][] credentials2() {

            return new Object[][] { { "test93", "test93@tristonsoft.com"," test","12Abcd","12Abcd"}};
      }


    @Test(dataProvider = "Authentication2")
    public void d_validdata(String uname,String email,String strname,String strpass,String strconpass)
    {
        driver.get("http://example.com//register/");


        WebElement username = driver.findElement(By.name("user_login"));
        username.clear();
        username.sendKeys(uname);

        WebElement mail = driver.findElement(By.name("user_email"));
        mail.clear();
        mail.sendKeys(email);

        WebElement name = driver.findElement(By.name("user_Name"));
        name.clear();
        name.sendKeys(strname);

        Select se = new Select(driver.findElement(By.name("country")));
        se.selectByIndex(3);

        WebElement password = driver.findElement(By.name("pass1"));
        password.clear();
        password.sendKeys(strpass);

        WebElement confirmpassword = driver.findElement(By.name("pass2"));
        confirmpassword.clear();
        confirmpassword.sendKeys(strconpass);

        WebElement submit = driver.findElement(By.id("ihc_submit_bttn"));
        submit.click();

        String actual = driver.getCurrentUrl();

        if(actual.equals(expectedurl))
        {
            Assert.assertTrue(true);
            testresultdata.put("4", new Object[] {3d, uname, email,strname,strpass,strconpass,expectedurl,actual ,"Pass"});
        }
        else
        {
            testresultdata.put("4", new Object[] {3d, uname, email,strname,strpass,strconpass,expectedurl,actual ,"Fail"});
            Assert.assertTrue(false);

        }


    }
     @AfterClass
      public void setupAfterSuite() {
             Set<String> keyset = testresultdata.keySet();
                int rownum = 0;
                for (String key : keyset) {
                    Row row = sheet.createRow(rownum++);
                    Object [] objArr = testresultdata.get(key);
                    int cellnum = 0;
                    for (Object obj : objArr) {
                        Cell cell = row.createCell(cellnum++);
                        if(obj instanceof Date)
                            cell.setCellValue((Date)obj);
                        else if(obj instanceof Boolean)
                            cell.setCellValue((Boolean)obj);
                        else if(obj instanceof String)
                        {
                            cell.setCellValue((String)obj);
                            System.out.println(obj);
                        }
                        else if(obj instanceof Double)
                            cell.setCellValue((Double)obj);
                    }
                }
        try {



            FileOutputStream out =new FileOutputStream("E:\TestResult.xls");
            workbook.write(out);
            out.close();
            System.out.println("Excel written successfully..");


        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }


      }

        private boolean isElementPresent(By by) {
            try {
              driver.findElement(by);
              return true;
            } catch (NoSuchElementException e) {
              return false;
            }
          }
}][1]][1]