public void TuslaSubmission()
        {
            AJAXCall.WaitForAjax();
            Thread.Sleep(900);

            CommonUtils CookiesAction = new CommonUtils(webDriver);

            CookiesAction.RejectAll_Cookies();
            Thread.Sleep(900);

            SignIn_Page.Click();


            Excel_Suite userEmail = new Excel_Suite(Env.EXCEL_TEST_URL);

            userEmail.getCellData("SPP_TestData", true);
            UserEmail.SendKeys(Env.Email_Id);
            Password.SendKeys("Test@123");

            WebDriverWait wait = new WebDriverWait(webDriver, TimeSpan.FromSeconds(800));

            Thread.Sleep(800);
            SubmitButton.Click();

            MyAccount_Toggle.Click();

            TuslaCertificateLink.Click();


            AddTusla_Button.Click();

            var tuslaNum = Constant_functions.randomString(2);

            Constant_functions.tuslaNumber = tuslaNum + "1380";
            TuslaText.SendKeys(Constant_functions.tuslaNumber);
            actionButton.Click();
            NextButton.Click();

            Thread.Sleep(1000);

            UploadtuslaCert.Click();
            Thread.Sleep(1000);

            webDriver.SwitchTo().Frame(1);

            Thread.Sleep(1000);
            AJAXCall.WaitForReady(webDriver);

            // docOption.Click();
            SelectElement docSelection = new SelectElement(eyp_documenttypeid_dropdown);

            docSelection.SelectByText("TUSLA Certificate");


            IWebElement upload = webDriver.FindElement(By.Id("AttachFile"));

            upload.SendKeys("C:\\temp\\Tech_Cities_Future_report.pdf");

            webDriver.FindElement(By.Id("InsertButton")).Click();

            Thread.Sleep(1000);
            AJAXCall.WaitForReady(webDriver);
            webDriver.SwitchTo().DefaultContent();

            IJavaScriptExecutor js = (IJavaScriptExecutor)webDriver;

            js.ExecuteScript("window.scrollBy(0,500)", "");

            js.ExecuteScript("arguments[0].scrollIntoView();", NextButton);
            Thread.Sleep(500);
            ReportsGeneration._test.Log(Status.Pass, "SPP TUSLA CERT" + "      " + webDriver.Url + "      " + "PASSED");

            if (AJAXCall.IsElementPresent(By.Id("NextButton")))
            {
                NextButton.Click();
            }
            else
            {
                js = (IJavaScriptExecutor)webDriver;
                js.ExecuteScript("arguments[0].scrollIntoView();", NextButton);
                NextButton.Click();
            }
            Thread.Sleep(900);

            //Get Parent window handle
            var winHandleBefore = webDriver.CurrentWindowHandle;

            Thread.Sleep(2000);
        }
        public void FeeList_Submission_SPP()
        {
            AJAXCall.WaitForAjax();
            Thread.Sleep(900);

            CommonUtils cookiesScreen = new CommonUtils(driver);

            cookiesScreen.RejectAll_Cookies();

            Thread.Sleep(900);
            SignIn_Page.Click();


            Excel_Suite userEmail = new Excel_Suite(Env.EXCEL_TEST_URL);

            userEmail.getCellData("SPP_TestData", true);
            UserEmail.SendKeys(Env.Email_Id);
            Password.SendKeys("Test@123");



            WebDriverWait wait = new WebDriverWait(driver, System.TimeSpan.FromSeconds(800));

            Thread.Sleep(800);
            SubmitButton.Click();

            MyAccount_Toggle.Click();

            AJAXCall.WaitForAjax();
            FeesList_Link.Click();

            AJAXCall.WaitForAjax();
            Thread.Sleep(1000);
            EditLink.Click();
            EditButton.Click();

            createBox.Click();
            Thread.Sleep(800);

            driver.SwitchTo().Frame(1);

            Eyp_name.SendKeys("TestAutomation");

            Eyp_agerange.SendKeys("5-10");

            SelectElement option = new SelectElement(Eyp_ecceavailable);

            option.SelectByText("Yes");

            Eyp_fullpriceperweek_Text.SendKeys("100.00");

            Thread.Sleep(800);
            Eyp_daysperweek.SendKeys("5");
            Eyp_hoursperweek.SendKeys("40");


            Effective_Date.SendKeys("01/11/2020");

            InsertButton.Click();
            AJAXCall.WaitForAjax();
            driver.SwitchTo().DefaultContent();
        }
        public void ServiceCalendar_Page()
        {
            CommonUtils cookieIgnore = new CommonUtils(webDriver);

            cookieIgnore.RejectAll_Cookies();



            SignIn_Page.Click();


            Excel_Suite userEmail = new Excel_Suite(Env.EXCEL_TEST_URL);

            userEmail.getCellData("SPP_TestData", true);
            UserEmail.SendKeys(Env.Email_Id);
            Password.SendKeys("Test@123");

            WebDriverWait wait = new WebDriverWait(webDriver, TimeSpan.FromSeconds(800));

            System.Threading.Thread.Sleep(800);
            SubmitButton.Click();

            Thread.Sleep(1000);

            MyAccount_Toggle.Click();

            AJAXCall.WaitForAjax();
            ServiceCalendar_Tab.Click();


            CreateCalendar.Click();

            SelectElement ProgCell = new SelectElement(Eyp_programmecall);
            var           ECCE2021 = "ECCE 2021";
            var           ECCE2022 = "ECCE 2022";

            var NCS2020 = "NCS 2020";
            var NCS2021 = "NCS 2021";
            var NCS2022 = "NCS 2022";

            ProgCell.SelectByText(NCS2020);

            Thread.Sleep(800);
            NextButton.Click();

            var startDate = "09:00";
            var closeDate = "12:00";

            Eyp_monopeningtime.SendKeys(startDate);
            Eyp_monclosingtime.SendKeys(closeDate);

            Eyp_tueopeningtime.SendKeys(startDate);
            Eyp_tueclosingtime.SendKeys(closeDate);

            Eyp_wedopeningtime.SendKeys(startDate);
            Eyp_wedclosingtime.SendKeys(closeDate);

            Eyp_thuopeningtime.SendKeys(startDate);
            Eyp_thuclosingtime.SendKeys(closeDate);

            Eyp_friopeningtime.SendKeys(startDate);
            Eyp_friclosingtime.SendKeys(closeDate);

            Thread.Sleep(800);

            NextButton.Click();
        }
        public void SearchThroughAccountName(IWebDriver driver)
        {
            SignIn_Page.Click();

            UserEmail.SendKeys("*****@*****.**");
            Password.SendKeys("Test@123");

            WebDriverWait wait = new WebDriverWait(driver, TimeSpan.FromSeconds(800));

            Thread.Sleep(800);
            SubmitButton.Click();

            MyAccount_Toggle.Click();

            BankAccount_Page.Click();

            AJAXCall.WaitForAjax();
            Thread.Sleep(1000);
            downArrow.Click();

            wait = new WebDriverWait(driver, TimeSpan.FromSeconds(900));

            Thread.Sleep(1000);
            EditLink.Click();

            Actions action = new Actions(driver);

            action.KeyDown(Keys.Control).SendKeys(Keys.End).Perform();

            NextButton.Click();
            AJAXCall.WaitForAjax();
            Thread.Sleep(2000);

            if (AJAXCall.IsElementPresent(By.PartialLinkText("Upload Document")))
            {
                action.KeyDown(Keys.Control).SendKeys(Keys.End).Perform();
                NextButton.Click();
            }
            else
            {
                Thread.Sleep(1000);
            }

            AJAXCall.WaitForAjax();
            Thread.Sleep(1000);

            Thread.Sleep(2000);

            wait = new WebDriverWait(driver, TimeSpan.FromSeconds(100));

            if (AJAXCall.IsElementPresent(By.Id("eyp_validationcode")))
            {
                Excel_Suite read_BankCode = new Excel_Suite(@"C:\Pobal_AutomationProject\Pobal_Test_Project\Automation_Suite\TestData_Repository\BankCode.xlsx");
                read_BankCode.getCellData("Bank_Sheet", false);

                IWebElement value_Code = driver.FindElement(By.XPath("//*[@id='eyp_validationcode']"));
                value_Code.Click();
                value_Code.Clear();
                Thread.Sleep(2000);

                value_Code.SendKeys(Keys.Tab);
                value_Code.SendKeys(Env.Data_Retrieve);
            }
            NextButton.Click();
        }
        public void SP_Portal_SignIN_Submit(IWebDriver driver)
        {
            CommonUtils Cu = new CommonUtils(driver);

            Cu.AcceptAll_Cookies();

            SignIn_Page.Click();
            Thread.Sleep(900);

            Excel_Suite userEmail = new Excel_Suite(Env.EXCEL_TEST_URL);

            userEmail.getCellData("SPP_TestData", true);
            UserEmail.SendKeys(Env.Email_Id);

            // UserEmail.SendKeys(Constant_functions.UserEmailId);
            Password.SendKeys("Test@123");

            WebDriverWait wait = new WebDriverWait(driver, TimeSpan.FromSeconds(800));

            SubmitButton.Click();

            MyAccount_Toggle.Click();

            BankAccount_Page.Click();
            ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "pageload is working fine");
            BankAccountLink_Button.Click();
            Thread.Sleep(1000);
            Excel_Suite   Es               = new Excel_Suite(Env.EXCEL_BANK_DATA);
            ExcelData     bankData         = Es.getBankData("Sheet1");
            SelectElement bankBranchOption = new SelectElement(DropDown_Bank);


            if (bankData != null)
            {
                accountName.SendKeys(bankData.AccountName);

                List <string> bankNames = new List <string>
                {
                    "AIB",
                    "An Post",
                    "Bank of Ireland",
                    "First Active",
                    "ING Bank",
                    "Aareal Bank AG",
                    "Bank of America Merrill Lynch International Ltd",
                    "Ulster Bank"
                };

                Thread.Sleep(800);

                IList <IWebElement> bankNames_1 = bankBranchOption.Options;
                DropDown_Bank.Click();


                wait = new WebDriverWait(driver, TimeSpan.FromSeconds(900));
                string val = "";


                Thread.Sleep(1000);
                foreach (var bankNameText in bankNames)
                {
                    if (bankNameText.Contains(bankData.BankName))
                    {
                        val = bankNameText;
                        if (AJAXCall.IsElementPresent(By.Id("eyp_bank")))
                        {
                            bankBranchOption.SelectByText(val);
                        }
                    }
                    else
                    {
                        bankBranchOption.SelectByIndex(4);
                        break;
                    }
                }
                Thread.Sleep(1000);
                foreach (char c in bankData.IBAN1)
                {
                    iban_text.SendKeys(c.ToString());
                }

                Bank_branch.SendKeys(bankData.BankBranch);
                Accountnumber.SendKeys(bankData.AccountNumber);



                Thread.Sleep(600);
                foreach (char s in bankData.BIC)
                {
                    BIC_Num.SendKeys(s.ToString());
                }
                Thread.Sleep(600);
                sortCode.SendKeys(bankData.SortCode);
            }

            wait = new WebDriverWait(driver, TimeSpan.FromSeconds(900));
            NextButton.Click();

            AJAXCall.WaitForReady(driver);

            Thread.Sleep(1000);
            Upload_Document.Click();

            AJAXCall.WaitForAjax();

            Thread.Sleep(1000);
            driver.SwitchTo().Frame(1);
            SelectElement doc = new SelectElement(dropdown_documenttypeid);

            doc.SelectByText("Bank Account Statement");

            Thread.Sleep(500);
            AJAXCall.WaitForAjax();

            IWebElement upload = driver.FindElement(By.Id("AttachFile"));

            upload.SendKeys("C:\\temp\\Tech_Cities_Future_report.pdf");

            upload_Btn.Click();
            Thread.Sleep(1000);

            AJAXCall.WaitForReady(driver);

            driver.SwitchTo().DefaultContent();
            Thread.Sleep(1000);

            IJavaScriptExecutor js = (IJavaScriptExecutor)driver;

            js.ExecuteScript("window.scrollBy(0, 500)", "");

            js.ExecuteScript("arguments[0].scrollIntoView();", NextButton);

            if (AJAXCall.IsElementPresent(By.Id("NextButton")))
            {
                NextButton.Click();
            }
            else
            {
                IJavaScriptExecutor jse = (IJavaScriptExecutor)driver;
                jse = (IJavaScriptExecutor)driver;
                jse.ExecuteScript("arguments[0].scrollIntoView();", NextButton);
            }


            ReportsGeneration._test.Log(Status.Pass, "SPP" + "      " + driver.Url + "      " + "PASSED");

            Thread.Sleep(700);
        }
        public void MyAccount_NavigationTest(IWebDriver driver)
        {
            try
            {
                Thread.Sleep(900);

                CommonUtils CookiesAction = new CommonUtils(driver);
                CookiesAction.RejectAll_Cookies();
                Thread.Sleep(900);

                SignIn_Page.Click();


                Excel_Suite userEmail = new Excel_Suite(Env.EXCEL_TEST_URL);
                userEmail.getCellData("SPP_TestData", true);
                UserEmail.SendKeys(Env.Email_Id);
                Password.SendKeys("Test@123");

                WebDriverWait wait = new WebDriverWait(driver, TimeSpan.FromSeconds(800));
                Thread.Sleep(800);


                SubmitButton.Click();

                MyAccount_Toggle.Click();

                Organisation.Click();
                ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "dropdown is working fine");

                wait = new WebDriverWait(driver, TimeSpan.FromSeconds(800));
                AJAXCall.WaitForAjax();

                MyAccount_Toggle.Click();
                ServiceProvider_Page.Click();
                ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "dropdown is working fine");

                Thread.Sleep(1000);
                MyAccount_Toggle.Click();

                userRoles_Page.Click();
                ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "pageload is working fine");

                MyAccount_Toggle.Click();
                BankAccount_Page.Click();
                ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "pageload is working fine");


                MyAccount_Toggle.Click();
                TuslaCertificate_Page.Click();
                ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "pageload is working fine");



                Thread.Sleep(500);
                MyAccount_Toggle.Click();
                FeesList_Page.Click();
                ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "pageload is working fine");


                MyAccount_Toggle.Click();
                ServiceCalendar_Page.Click();
                ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "pageload is working fine");


                MyAccount_Toggle.Click();

                ECCEPreContracting_Page.Click();
                ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "pageload is working fine");

                MyAccount_Toggle.Click();

                CapitalWorksEquipment_Page.Click();

                ReportsGeneration._test.Log(Status.Pass, " " + "   " + driver.Url + "   " + "dropdown is working fine");
            }

            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
        }