public static void WriteOperatingCashData(Operating_Cash_DB_Model OperatingCash) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("insert into Operating_cash (DATE, OPERATING_CASH_FLOW, STOCK_TICKER) values (@DATE, @OPERATING_CASH_FLOW, @STOCK_TICKER)", OperatingCash); } }
//making a webclient call syncly public override ValueInvestingCompanyDBModel WebClientAPICall(ValueInvestingCompanyDBModel company) { string Json = ""; WebClient client = new WebClient(); Json = client.DownloadString($"https://financialmodelingprep.com/api/v3/financials/cash-flow-statement/{ company.STOCK_TICKER}"); //StockPriceModel Sp_json = JsonConvert.DeserializeObject<StockPriceModel>(Json); var OCJson = CashFlow_Top_Level.FromJson(Json); Console.WriteLine("Writting to Operating_Cash DB"); foreach (var item in OCJson.Financials) { Operating_Cash_DB_Model OperatingCash = new Operating_Cash_DB_Model { DATE = (item.Date), OPERATING_CASH_FLOW = (item.OperatingCashFlow), STOCK_TICKER = company.STOCK_TICKER }; SQL.WriteOperatingCashData(OperatingCash); } //Operating_Cash_DB_Model OperatingCash = new Operating_Cash_DB_Model { DATE = (OCJson.Symbol[0]), OPERATING_CASH_FLOW = OCJson. , STOCK_TICKER = company.STOCK_TICKER }; //SQL.WriteCurrentFinancialsData(StockPrice); Random rnd = new Random(); company.OPERATING_CASH = Convert.ToDouble(rnd.Next()); return(company); }