public void TestLogin()
{
ExtentTest test3 = extent.CreateTest("Login");
test3.Log(Status.Info, "First");
test3.Log(Status.Debug, "Go to URl");
driver.Navigate().GoToUrl("http://thedemosite.co.uk");
var homePage = new HomePage();
PageFactory.InitElements(driver, homePage);
test3.Log(Status.Debug, "Go to create new user");
homePage.ClickCreateUser();
var createUser = new CreateElements();
PageFactory.InitElements(driver, createUser);
test3.Log(Status.Debug, "Create Usernamer");
createUser.setUser("Testing");
test3.Log(Status.Debug, "Create Password");
createUser.setPass("Test123");
test3.Log(Status.Debug, "Create New User");
createUser.ClickSubmit();
test3.Log(Status.Debug, "Login Page");
homePage.ClickLogin();
var login = new LoginPage();
PageFactory.InitElements(driver, login);
test3.Log(Status.Debug, "Enter Username");
login.EnterUser("Testing");
test3.Log(Status.Debug, "Enter Password");
login.EnterPass("Test123");
test3.Log(Status.Debug, "Check Login");
login.ClickTestLogin();
try
{
Assert.AreEqual("**Successful Login**", login.getLoginCheck());
test3.Log(Status.Pass, "Pass");
} catch (AssertionException e)
{
test3.Log(Status.Fail, "Failed");
Assert.Fail();
}
}
public void spreadsheet()
{
excel.Application x1Appl = new excel.Application();
//Creates excel workbook object for specified file
string pth = System.Reflection.Assembly.GetCallingAssembly().CodeBase;
string actualpath = pth.Substring(0, pth.LastIndexOf("bin"));
string projectpath = new Uri(actualpath).LocalPath;
string reportPath = projectpath + "Data\\TestData.xlsx";
excel.Workbook x1WorkBook = x1Appl.Workbooks.Open(reportPath);
//Creates excel work sheet object for sheet 1
excel._Worksheet x1WorkSheet = x1WorkBook.Sheets[1];
//Gets used range of excel file(here range is 3)
excel.Range x1Range = x1WorkSheet.UsedRange;
int xlRowCnt = 0;
String Username;
String Password;
for (xlRowCnt = 1; xlRowCnt <= x1Range.Rows.Count; xlRowCnt++)
{
Username = (string)(x1Range.Cells[xlRowCnt, 1] as excel.Range).Value2;
Password = (string)(x1Range.Cells[xlRowCnt, 2] as excel.Range).Value2;
ExtentTest test4 = extent.CreateTest("URL");
test4.Log(Status.Info, "First");
test4.Log(Status.Debug, "Go to URl");
driver.Navigate().GoToUrl("http://thedemosite.co.uk");
var homePage = new HomePage();
PageFactory.InitElements(driver, homePage);
test4.Log(Status.Debug, "Go to create new user");
homePage.ClickCreateUser();
var createUser = new CreateElements();
PageFactory.InitElements(driver, createUser);
test4.Log(Status.Debug, "Create Usernamer");
createUser.setUser(Username);
test4.Log(Status.Debug, "Create Password");
createUser.setPass(Password);
test4.Log(Status.Debug, "Create New User");
createUser.ClickSubmit();
test4.Log(Status.Debug, "Login Page");
homePage.ClickLogin();
var login = new LoginPage();
PageFactory.InitElements(driver, login);
test4.Log(Status.Debug, "Enter Username");
login.EnterUser(Username);
test4.Log(Status.Debug, "Enter Password");
login.EnterPass(Password);
test4.Log(Status.Debug, "Check Login");
Thread.Sleep(1000);
login.ClickTestLogin();
try
{
Assert.AreEqual("**Successful Login**", login.getLoginCheck());
test4.Log(Status.Pass, "Pass");
}
catch (AssertionException e)
{
test4.Log(Status.Fail, "Failed");
Assert.Fail();
}
}
x1WorkBook.Close();
x1Appl.Quit();
}