public void foo()
{
string XlsPath = @"C:\Users\Bassam\Documents\Training\DataDriven\ExcelTestData\TcoData.xlsx";
//int pax = 45;
//Console.WriteLine(" pay :{0}", CalculateCalimityFund(pax));
var res = ExcelReaderHelper.GetCelldata(XlsPath, "DocketsNumber", 0, 0).ToString();
Console.WriteLine("res is {0}", res);
}
public static void LoginFromExcelFile()
{
string FilePath = @"E:\Users\Bassam\Documents\Training\DataDriven\ExcelTestData\TcoData.xlsx";
NavigateToUrl(ObjectRepository.Config.GetWebSite());
DropDownListHelper.SelectElementByText(By.Id("cmbCompanies"), "Vered Hasharon");
PomLogin TcoLogin = new PomLogin(ObjectRepository.Driver);
TcoLogin.Login(ExcelReaderHelper.GetCelldata(FilePath, "Login", 1, 0).ToString(), ExcelReaderHelper.GetCelldata(FilePath, "Login", 1, 1).ToString());
Thread.Sleep(2000);
}
public static void SelectIncomingToursAndOpenById()
{
LoginFromConfigFile();
LoginPagePOM LogMe = new LoginPagePOM(ObjectRepository.Driver);
QuotationsList quoteList = LogMe.WelcomToTco.ClickIncoming();
string FilePath = @"E:\Users\Bassam\Documents\Training\DataDriven\ExcelTestData\TcoData.xlsx";
//Assert that you are in the right page
Assert.AreEqual("QUOTATION / GROUPS LIST", quoteList.PageTitle, "the titles are not equals");
var HoverAnElement = ObjectRepository.Driver.FindElement(By.XPath("//td[@id='ctl00_ContentPlaceHolder1_mnuTopn0']//a[contains(text(),'Sheets')]"));
var ElementClick = ObjectRepository.Driver.FindElement(By.XPath("//a[contains(text(),'Open Calc.sheet/Group by number')]"));
MouseActionsHelper.HoverAndClick(ObjectRepository.Driver, HoverAnElement, ElementClick);
//switch to the new frame by invoking OpenExistingQuote Method
GenericHelper.OpenExistingQuote(ExcelReaderHelper.GetCelldata(FilePath, "Quotations", 1, 0).ToString());
}