public static async void get_price(string _code, string _date)
{
StockContext ctx = new StockContext();
// find whatever
var builder = Builders<Stock>.Filter;
var filter = builder.Eq("code", _code) & builder.Eq("date", _date);
var result = await ctx.Stocks.Find(filter).ToListAsync();
Console.Write(result[0].price);
}
public static async void set_data(Stock stock)
{
Console.Write("update now\n");
StockContext ctx = new StockContext();
// add this thing to the database
// this step take a few seconds though
await ctx.Stocks.InsertOneAsync(stock);
Console.Write("waiting\n");
}
public ProductRepository(StockContext context)
{
this.context = context;
}
protected Repository(StockContext db)
{
_db = db;
_dbSet = _db.Set <TEntity>();
}
internal ExchangeConnector(FinnhubClient finnhubClient, StockContext dbContext)
{
_finnhubClient = finnhubClient;
_dbContext = dbContext;
}
public TransactionRepository(StockContext context) => Context = context;
public FacadeDAO(StockContext context)
{
_context = context;
unitOfWork = new UnitOfWork(_context);
}
public HolderInformationService(StockContext context)
{
_context = context;
hiConverter = new HolderInformationConverter();
}
public StockRepository(StockContext context)
{
this.context = context;
}
public SupplierRepository(StockContext context)
{
this.context = context;
}
public CategoryService(StockContext context)
{
_context = context;
converter = new CategoryConverter();
}
// 透過 DI 機制存取已在 Startup.cs 註冊的 StockContext
public StockController(ILogger <StockController> logger, StockContext stockContext)
{
_logger = logger;
_stockContext = stockContext;
}
public ProductRepository(StockContext context)
: base(context)
{
}
public BaseRepository(StockContext context)
{
_context = context;
_dbSet = context.Set <TEntity>();
}
public ReceiptRepository(StockContext context) : base(context)
{
_Context = context;
}
public AddressRepository(StockContext db) : base(db)
{
}
public StockRepository(StockContext dbContext)
{
_dbContext = dbContext;
}
public OperacaoRepository(StockContext context) : base(context)
{
}
public StockController(StockContext context)
{
_context = context;
}
public PaymentRepository(StockContext context)
{
this.context = context;
}
public Repository(StockContext context)
{
this.context = context;
entities = context.Set <T> ();
}
public UnitOfWork(StockContext context)
{
Context = context;
}
public MSSQLProductRepository(StockContext db)
{
this.db = db;
}
public ShopController()
{
_context = new StockContext();
_context.Database.EnsureCreated();
}
public static void ScrapeDat(IServiceProvider serviceProvider)
{
ChromeOptions options = new ChromeOptions();
options.AddArguments("no-sandbox", "--disable-dev-shm-usage");
IWebDriver driver = new ChromeDriver(ChromeDriverService.CreateDefaultService(), options, TimeSpan.FromMinutes(6));
driver.Manage().Timeouts().PageLoad.Add(TimeSpan.FromSeconds(1200));
driver.Navigate().GoToUrl("https://finance.yahoo.com/");
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(1200);
WebDriverWait waitLogin = new WebDriverWait(driver, TimeSpan.FromMinutes(30));
waitLogin.Until(SeleniumExtras.WaitHelpers.ExpectedConditions.ElementToBeClickable(By.Id("uh-signedin")));
driver.Manage().Timeouts().PageLoad = TimeSpan.FromMinutes(10);
IWebElement loginButton = driver.FindElement(By.Id("uh-signedin"));
loginButton.Click();
WebDriverWait waitEnterUsername = new WebDriverWait(driver, TimeSpan.FromMinutes(50));
waitEnterUsername.Until(SeleniumExtras.WaitHelpers.ExpectedConditions.ElementToBeClickable(By.Id("login-username")));
IWebElement userName = driver.FindElement(By.Id("login-username"));
userName.SendKeys("*****@*****.**");
userName.SendKeys(Keys.Enter);
WebDriverWait waitEnterPassword = new WebDriverWait(driver, TimeSpan.FromMinutes(50));
waitEnterPassword.Until(SeleniumExtras.WaitHelpers.ExpectedConditions.ElementToBeClickable(By.Id("login-passwd")));
IWebElement password = driver.FindElement(By.Id("login-passwd"));
password.SendKeys("Soccer_1995");
password.SendKeys(Keys.Enter);
driver.Manage().Timeouts().PageLoad = TimeSpan.FromMinutes(10);
driver.Navigate().GoToUrl("https://finance.yahoo.com/portfolio/p_0/view/v1");
driver.Manage().Timeouts().PageLoad = TimeSpan.FromMinutes(10);
WebDriverWait waitDataTable = new WebDriverWait(driver, TimeSpan.FromMinutes(50));
waitDataTable.Until(SeleniumExtras.WaitHelpers.ExpectedConditions.ElementExists(By.XPath("//tr")));
IWebElement stockTable = driver.FindElement(By.XPath("//tbody"));
List <IWebElement> stocks = driver.FindElements(By.XPath("//tr")).ToList();
List <IWebElement> rows = stockTable.FindElements(By.XPath("//tr")).ToList();
int rowsCount = rows.Count;
using (var context = new StockContext(
serviceProvider.GetRequiredService <
DbContextOptions <StockContext> >()))
{
for (int row = 1; row < rowsCount; row++)
{
List <IWebElement> cells = rows.ElementAt(row).FindElements(By.TagName("td")).ToList();
int cellsCount = cells.Count;
string SymbolData = cells.ElementAt(0).Text;
//Console.WriteLine("Symbol: " + SymbolData);
string LastPriceData = cells.ElementAt(1).Text;
//Console.WriteLine("Last Price: " + LastPriceData);
string ChangeData = cells.ElementAt(2).Text;
//Console.WriteLine("Change: " + ChangeData);
string ChangeRateData = cells.ElementAt(3).Text;
//Console.WriteLine("Change Rate: " + ChangeRateData);
string CurrencyData = cells.ElementAt(4).Text;
//Console.WriteLine("Currency: " + CurrencyData);
string MarketTimeData = cells.ElementAt(5).Text;
//Console.WriteLine("Market Time: " + MarketTimeData);
string VolumeData = cells.ElementAt(6).Text;
//Console.WriteLine("Volume: " + VolumeData);
string ShareData = cells.ElementAt(7).Text;
//Console.WriteLine("Shares: " + ShareData);
string AverageVolumeData = cells.ElementAt(8).Text;
//Console.WriteLine("Avg Vol Data: " + AverageVolumeData);
string MarketCapData = cells.ElementAt(12).Text;
//Console.WriteLine("Market Cap: " + MarketCapData);
// Look for any movies.
//if (context.Stocks.Any())
// {
// return; // DB has been seeded
// }
context.Stock.AddRange(
new Stocks
{
Symbol = SymbolData,
LastPrice = LastPriceData,
DateScrapped = DateTime.Now,
Change = ChangeData,
ChangeRate = ChangeRateData,
Currency = CurrencyData,
MarketTime = MarketTimeData,
Volume = VolumeData,
ShareData = ShareData,
AverageVolume = AverageVolumeData,
MarketCapData = MarketCapData
}
);
context.SaveChanges();
}
}
}
public FavoriteStockRepository(StockContext context) : base(context)
{
}
public ImageService(StockContext context)
{
_context = context;
imageConverter = new ImageConverter();
}
public StockCompanyRepository(StockContext context) : base(context)
{
}
public UnitOfWork(StockContext context)
{
_context = context;
_repositories = new Dictionary <string, object>();
}
public ProductRepository(StockContext dbContext)
{
this.dbContext = dbContext;
dbSet = this.dbContext.Products;
}
public void SetUp()
{
_context = new StockContext();
_initStockContext = new InitStockContext(Mock.Of <ILogger <InitStockContext> >(), _context);
_initStockContext.StartAsync(default).Wait();
public StockInvoiceRepository(StockContext dbContext)
{
_dbContext = dbContext;
}
