public async Task CreateCandleStick(string pairName, CandleStickTableModel candleStick) { try { /* * var p = new DynamicParameters(); * p.Add("pairName", pairName); * p.Add("close", candleStick.Close); * p.Add("closeTime", candleStick.CloseTime.ToString()); * p.Add("high", candleStick.High); * p.Add("low", candleStick.Low); * p.Add("open", candleStick.Open); * p.Add("openTime", candleStick.OpenTime.ToString()); * * await _db.ExecuteAsync("CreateCandleStick", p, commandType: CommandType.StoredProcedure);*/ var query = $"INSERT INTO [Exchange].[dbo].[{pairName}_CandleStick] ([Close], CloseTime, High, Low, [Open], OpenTime) " + $"VALUES ({candleStick.Close.ToStringInvariant()}, '{candleStick.CloseTime}', {candleStick.High.ToStringInvariant()}, {candleStick.Low.ToStringInvariant()}, {candleStick.Open.ToStringInvariant()}, '{candleStick.OpenTime.ToStringInvariant()}')"; await _db.ExecuteAsync(query); } catch (Exception ex) { } }
public async Task spCreate_BTC_USDT_CandleStick(CandleStickTableModel candleStick) { try { var p = new DynamicParameters(); p.Add("close", candleStick.Close); p.Add("closeTime", candleStick.CloseTime); p.Add("high", candleStick.High); p.Add("low", candleStick.Low); p.Add("open", candleStick.Open); p.Add("openTime", candleStick.OpenTime); await _db.ExecuteAsync("Create_BTC_USDT_CandleStick", p, commandType : CommandType.StoredProcedure); } catch (Exception ex) { } }