public void webScrap(string link, string xPathsiteUpdated, int xPathbankId, string xPathbankName, string xPathAUBR, string xPathAUSR, string xPathEUBR, string xPathEUSR, string xPathNORBR, string xPathNORSR, string xPathUSBR, string xPathUSSR) { string DbsiteUpdated = null; string DbAUBR = null; string DbAUSR = null; string DbEUBR = null; string DbEUSR = null; string DbNORBR = null; string DbNORSR = null; string DbUSBR = null; string DbUSSR = null; // Initialize the Chrome Driver using (var driver = new ChromeDriver()) { // Go to the home page driver.Navigate().GoToUrl(link); IWebElement baseTable = driver.FindElement(By.TagName("table")); // gets all table rows ICollection <IWebElement> rows = baseTable.FindElements(By.TagName("tr")); // for every row IWebElement matchedRow = null; //Fetching Site Updated Date IList <IWebElement> all1 = driver.FindElements(By.XPath(xPathsiteUpdated)); String[] allText1 = new String[all1.Count]; String usd1 = null; foreach (IWebElement element in all1) { usd1 = element.Text; DbsiteUpdated = usd1; Console.WriteLine(DbsiteUpdated); } //Fetching AUBR IList <IWebElement> all2 = driver.FindElements(By.XPath(xPathAUBR)); String[] allText2 = new String[all2.Count]; String usd2 = null; foreach (IWebElement element in all2) { usd2 = element.Text; DbAUBR = usd2; Console.WriteLine(DbAUBR); } //Fetching AUSR IList <IWebElement> all3 = driver.FindElements(By.XPath(xPathAUSR)); String[] allText3 = new String[all3.Count]; String usd3 = null; foreach (IWebElement element in all3) { usd3 = element.Text; DbAUSR = usd3; Console.WriteLine(DbAUSR); } //Fetching EUBR IList <IWebElement> all4 = driver.FindElements(By.XPath(xPathEUBR)); String[] allText4 = new String[all4.Count]; String usd4 = null; foreach (IWebElement element in all4) { usd4 = element.Text; DbEUBR = usd4; Console.WriteLine(DbEUBR); } //Fetching EUSR IList <IWebElement> all5 = driver.FindElements(By.XPath(xPathEUSR)); String[] allText5 = new String[all5.Count]; String usd5 = null; foreach (IWebElement element in all5) { usd5 = element.Text; DbEUSR = usd5; Console.WriteLine(DbEUSR); } //Fetching NORBR IList <IWebElement> all6 = driver.FindElements(By.XPath(xPathNORBR)); String[] allText6 = new String[all6.Count]; String usd6 = null; foreach (IWebElement element in all6) { usd6 = element.Text; DbNORBR = usd6; Console.WriteLine(DbNORBR); } //Fetching NORSR IList <IWebElement> all7 = driver.FindElements(By.XPath(xPathNORSR)); String[] allText7 = new String[all7.Count]; String usd7 = null; foreach (IWebElement element in all7) { usd7 = element.Text; DbNORSR = usd7; Console.WriteLine(DbNORSR); } //Fetching USBR IList <IWebElement> all8 = driver.FindElements(By.XPath(xPathUSBR)); String[] allText8 = new String[all8.Count]; String usd8 = null; foreach (IWebElement element in all8) { usd8 = element.Text; DbUSBR = usd8; Console.WriteLine(DbUSBR); } //Fetching USSR IList <IWebElement> all9 = driver.FindElements(By.XPath(xPathUSSR)); String[] allText9 = new String[all9.Count]; String usd9 = null; foreach (IWebElement element in all9) { usd9 = element.Text; DbUSSR = usd9; Console.WriteLine(DbUSSR); } //Sending USD rate to Db DbConnection sql = new DbConnection(); float FDbAUBR = Convert.ToSingle(DbAUBR); float FDbAUSR = Convert.ToSingle(DbAUSR); float FDbEUBR = Convert.ToSingle(DbEUBR); float FDbEUSR = Convert.ToSingle(DbEUSR); float FDbNORBR = Convert.ToSingle(DbNORBR); float FDbNORSR = Convert.ToSingle(DbNORSR); float FDbUSBR = Convert.ToSingle(DbUSBR); float FDbUSSR = Convert.ToSingle(DbUSSR); sql.AddRecord(DbsiteUpdated, xPathbankId, xPathbankName, FDbAUBR, FDbAUSR, FDbEUBR, FDbEUSR, FDbNORBR, FDbNORSR, FDbUSBR, FDbUSSR); //pausing console before exit usd1 = null; usd2 = null; usd3 = null; usd4 = null; usd5 = null; usd6 = null; usd7 = null; usd8 = null; usd9 = null; // Take a screenshot and save it into screen.png //driver.GetScreenshot().SaveAsFile(@"screen.png", ImageFormat.Png); } }