public static void PopulateInCollection(string fileName, string SheetName)
{
ExcelLib.ClearData();
DataTable table = ExcelToDataTable(fileName, SheetName);
//Iterate through the rows and columns of the Table
for (int row = 1; row <= table.Rows.Count; row++)
{
for (int col = 0; col < table.Columns.Count; col++)
{
Datacollection dtTable = new Datacollection()
{
rowNumber = row,
colName = table.Columns[col].ColumnName,
colValue = table.Rows[row - 1][col].ToString()
};
//Add all the details for each row
dataCol.Add(dtTable);
}
}
}
public void Inititalize()
{
// advisasble to read this documentation before proceeding http://extentreports.relevantcodes.com/net/
switch (Browser)
{
case 1:
GlobalDefinitions.driver = new FirefoxDriver();
break;
case 2:
GlobalDefinitions.driver = new ChromeDriver();
GlobalDefinitions.driver.Manage().Window.Maximize();
break;
}
ExcelLib.PopulateInCollection(Base.ExcelPath, "SignIn");
driver.Navigate().GoToUrl(ExcelLib.ReadData(2, "Url"));
#region Initialise Reports
extent = new ExtentReports(ReportPath, false, DisplayOrder.NewestFirst);
extent.LoadConfig(MarsResource.ReportXMLPath);
test = extent.StartTest("Tests");
#endregion
if (MarsResource.IsLogin == "true")
{
SignIn loginobj = new SignIn();
loginobj.LoginSteps();
}
else
{
SignUp obj = new SignUp();
obj.register();
}
}
