static void Main(string[] args)
{
Console.WriteLine("Hello World!");
using (var db = new CryptoCurrencyEntities())
{
Console.WriteLine("Enter data on a crypto currency");
var coinName = "Bitcoin";
var coinSymbol = "BTC";
var marketCap = 13453;
var price = 6920;
var circulatingSupply = 1679;
var volume24hr = 832649;
var changeHour = 61;
var change24hr = 90;
var changeDay = 38;
var cryptoTable = new CryptoTable
{
Id = 1,
Name = coinName,
Symbol = coinSymbol,
MarketCap = marketCap,
Price = price,
CirculatingSupply = circulatingSupply,
Volume24Hour = volume24hr,
ChangeHour = changeHour,
Change24Hour = change24hr,
ChangeDay = changeDay
};
db.CryptoTables.Add(cryptoTable);
db.SaveChanges();
}
}
static void Main(string[] args)
{
IWebDriver chromeDriver = new ChromeDriver();
//string pathToFile = @"C:\Users\jnprogrammer9\Documents\Projects\c#\webScrapper-Selenium\webScrapper-Selenium\webScrapper-Selenium\test.txt";
string coinName, coinSymbol, coinPrice, coinMarketCap, coinSupply, coinVolume24hr;
chromeDriver.Navigate().GoToUrl("https://coinmarketcap.com/all/views/all/");
var table = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']"));
try
{
// "//table[@id='currencies-all']//tr[@id='id-bitcoin']//td[@class='no-wrap currency-name']//a[@class='currency-name-container']"
// coinName = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']//tr/td//a[@class='currency-name-container']")).Text; //$x("//table[@id='currencies-all']//tr[@id='id-bitcoin']")[0]
// foreach (var row in table.FindElements(By.TagName("tbody")))
coinName = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']//tr/td//a[@class='currency-name-container']")).Text;
coinSymbol = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']//tr/td[@class='text-left col-symbol']")).Text;
coinPrice = chromeDriver.FindElement(By.XPath("//table[@id='currencies-all']//tr/td//a[@class='price']")).Text;
// < td class="text-left col-symbol">BTC</td>
Console.WriteLine(coinName);
Console.WriteLine(coinSymbol);
Console.WriteLine(coinPrice);
using (var db = new CryptoContext())
{
var aCryptoTable = new CryptoTable {
CoinName = coinName, CoinSymbol = coinSymbol
};
db.CryptoTables.Add(aCryptoTable);
db.SaveChanges();
var query = from b in db.CryptoTables
orderby b.CoinName
select b;
foreach (var item in query)
{
Console.WriteLine(item.CoinSymbol);
}
}
/* coinSymbol = chromeDriver.FindElement(By.XPath("")).Text;
* coinPrice = chromeDriver.FindElement(By.XPath("")).Text;
* coinMarketCap = chromeDriver.FindElement(By.XPath("")).Text;
* coinSupply = chromeDriver.FindElement(By.XPath("")).Text;
* coinVolume24hr = chromeDriver.FindElement(By.XPath("")).Text;*/
//Console.WriteLine("{0} {1} Price:{2} MarketCap:{3} Supply:{4} 24Hr Volume: {5}\n",coinName,coinSymbol,coinPrice,coinMarketCap,coinSupply,coinVolume24hr); ////table[@id='currencies-all']//tr[@id='id-bitcoin']
}
catch (Exception e)
{
Console.WriteLine("Error:" + e);
}
chromeDriver.Close();
Console.WriteLine("No errors thrown");
}
