private void LoadAllStocks()
{
var dbContext = new MagicDbContext();
MagicRepository repository = new MagicRepository(dbContext);
stocks = repository.GetAllStocks();
}
private void GetStock(string id)
{
var dbContext = new MagicDbContext();
MagicRepository repository = new MagicRepository(dbContext);
stock = repository.GetStock(int.Parse(id));
}
private static void ClearDatabase()
{
using (var dbContext = new MagicDbContext())
{
MagicRepository repository = new MagicRepository(dbContext);
bool status = repository.ClearDatabase();
Console.WriteLine("Database Cleared: " + status);
}
}
private static void RemoveDuplicates()
{
using (var dbContext = new MagicDbContext())
{
MagicRepository repository = new MagicRepository(dbContext);
bool status = repository.RemoveDuplicates();
Console.WriteLine("Duplicates Removed: " + status);
}
}
private static void AddStocksToDatabase(List <Stock> stocks, int marketCap)
{
using (var dbContext = new MagicDbContext())
{
MagicRepository repository = new MagicRepository(dbContext);
foreach (Stock stock in stocks)
{
stock.MagicFormulaMarketCap = marketCap;
repository.Add(stock);
}
bool b = repository.Save();
Console.WriteLine("Save status" + b);
}
}
static void GetDataFromGuruFocus()
{
Console.WriteLine("*****Started Rule One ......");
IWebDriver driver = new ChromeDriver();
using (var dbContext = new MagicDbContext())
{
MagicRepository repository = new MagicRepository(dbContext);
var stocks = repository.GetGuruFocusStocks();
foreach (Stock stock in stocks)
{
GuruFocus.Start(driver, stock);
repository.Save();
}
}
driver.Close();
driver.Quit();
}
static void GetDataFromRuleOne(string username, string password)
{
Console.WriteLine("*****Started Rule One ......");
IWebDriver driver = new ChromeDriver();
RuleOne.RuleOneWebsite_Logon(driver, username, password);
System.Threading.Thread.Sleep(1000);
using (var dbContext = new MagicDbContext())
{
MagicRepository repository = new MagicRepository(dbContext);
var stocks = repository.GetRuleOneStocks();
foreach (Stock stock in stocks)
{
RuleOne.Start(driver, stock);
repository.Save();
}
}
driver.Close();
driver.Quit();
}
