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);
}
}
