public void Login()
{
LoginPageObject login = new LoginPageObject();
login.login("*****@*****.**", "Romanpete!");
Assert.IsTrue(PropertiesCollection.Validateurl("https://betapostframesolver.azurewebsites.net/"));
}
public void uploadfile()
{
LoginPageObject login = new LoginPageObject();
HomePageObject home;
home = login.login("*****@*****.**", "Romanpete!");
home.settingbtn.Click();
home.materialbtn.Click();
MaterialPageObject t = new MaterialPageObject();
t.UploadData();
PropertiesCollection.Validatemessage("Your update is now processing. You will recieve an email at '*****@*****.**' when it is complete. Be sure to add '*****@*****.**' to your safe sender list so you dont miss it. ", "//*[@id='status']");
System.Threading.Thread.Sleep(2000);
}
public void CreateExcel(int n)
{
_Application excel = new _excel.Application();
workbook = excel.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
worksheet = (Worksheet)workbook.Worksheets[1];
worksheet.Cells[1, 1] = "No";
worksheet.Cells[1, 2] = "Time";
for (int i = 1; i <= n; i++)
{
worksheet.Cells[i + 1, 1] = i;
worksheet.Cells[i + 1, 2] = this.RecordCanvasloadTime();
PropertiesCollection.OpenTabs(1);
// PropertiesCollection.driver.SwitchTo().Window(PropertiesCollection.driver.WindowHandles[i-1]);
//PropertiesCollection.driver.Navigate().GoToUrl("https://betapostframesolver.azurewebsites.net/Account/Login");
}
worksheet.Cells[n + 2, 1] = "Average";
worksheet.Cells[n + 2, 2] = "=AVERAGE(B2:B" + (n + 1) + "," + n + ")";
workbook.SaveAs(@"C:\SysWOW64\config\systemprofile\desktop\test11.xlsx");
workbook.Close();
}
