using OfficeOpenXml;
using OpenQA.Selenium;
using OpenQA.Selenium.Chrome;
using OpenQA.Selenium.Interactions;
using System;
using System.IO;
using System.Linq;


namespace LoginSuperUser_New
{

    public class LoginSuperuser
    {
        private static void Main(String[] args)
        {
            
            //Open Chrome Driver
            IWebDriver driver = new ChromeDriver(@"C:\Users\27828\source\repos\");
            ExcelPackage.LicenseContext = LicenseContext.Commercial;
            
            // path to your excel file
            string path = "C:\\DATA\\UserLoginData.xlsx";
            FileInfo fileInfo = new FileInfo(path);

            ExcelPackage package = new ExcelPackage(fileInfo);
            ExcelWorksheet worksheet = package.Workbook.Worksheets.FirstOrDefault();

            // get number of rows and columns in the sheet
            int rows = worksheet.Dimension.Rows;
            int columns = worksheet.Dimension.Columns;

            int i = 2;
            int j = 1;

            //Open Environment
            string URl = worksheet.Cells[i, j].Value.ToString();
            driver.Navigate().GoToUrl((string)URl);
            driver.Manage().Window.Maximize();
            driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(10);
            

            // loop through the worksheet rows and columns
            while (i <= rows)
            {
                //Enter the Username
                string UserN = worksheet.Cells[i, 2].Value.ToString();
                IWebElement UserName = driver.FindElement(By.Id("Input_Email"));
                UserName.SendKeys((string)UserN);

                //Enter the Password
                string PassW = worksheet.Cells[i, 3].Value.ToString();
                IWebElement PassWOrd = driver.FindElement(By.Id("Input_Password"));
                PassWOrd.SendKeys((string)PassW);

                //Click on the Login Button
                IWebElement LoginButton1 = driver.FindElement(By.CssSelector("#account > div:nth-child(7) > div > button"));
                LoginButton1.Click();

                //Click on the Logout Link
                Actions action1 = new Actions(driver);
                action1.MoveToElement(driver.FindElement(By.XPath("//*[@id='navbarDropdownProfile']/img"))).Build().Perform();
                IWebElement manageProfile = driver.FindElement(By.XPath("//*[@id='navbarDropdownProfile']/img"));
                manageProfile.Click();
                IWebElement LogInoutButton2 = driver.FindElement(By.XPath("/html/body/div/main/nav/div/div[2]/ul/li[4]/div/a[3]"));
                LogInoutButton2.Click();

                                    
                i = i + 1;

                if (i > rows)
                {
                    break;
                }
            }

            //Quit Browser
            driver.Quit();
            package.Dispose();
                       
        }
        
    }
}