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) { }
}
