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