public async Task <ActionResult> GetCandleStick(GetCandleStickModel model)
{
var pair = await _pairsRepository.GetPairByAcronimAsync(model.Acronim.ToUpper());
if (pair == null)
{
return(BadRequest("wrong pair"));
}
if (!model.DateStart.HasValue)
{
model.DateStart = System.DateTime.Now.AddDays(-2);
}
var candleStick = await _candleStickRepository.GetCandleStick(model, pair.SQLTableName);
var currentCandleStick = await _candleStickRepository.GetCurrentCandleStick(pair.SQLTableName);
var resultModel = new CandleStickViewModel()
{
CurrentCandleStick = currentCandleStick,
LastCandleSticks = candleStick
};
return(Ok(resultModel));
}
public async Task <ActionResult> GetCandleStick(GetCandleStickModel model)
{
if (!model.DateStart.HasValue)
{
model.DateStart = System.DateTime.Now.AddDays(-2);
}
var candleStick = await _candleStickRepository.Get_BTC_USDT_CandleSticks(model);
var currentCandleStick = await _candleStickRepository.GetCurrent_BTC_USDT_CandleStick();
var resultModel = new CandleStickViewModel()
{
CurrentCandleStick = currentCandleStick,
LastCandleSticks = candleStick
};
return(Ok(resultModel));
}
public async Task <List <CandleStickTableModel> > GetCandleStick(GetCandleStickModel model, string sqlPairName)
{
try
{
var p = new DynamicParameters();
p.Add("datestart", model.DateStart);
p.Add("dateend", model.DateEnd);
p.Add("interval", model.Interval);
var candleStick = await _db
.QueryAsync <CandleStickTableModel>($"Get_{sqlPairName}_CandleStick",
p,
commandType : CommandType.StoredProcedure);
return(candleStick.ToList());
}
catch (Exception ex)
{
return(null);
}
}
public async Task <List <CandleStickTableModel> > Get_BTC_USDT_CandleSticks(GetCandleStickModel model)
{
try
{
if (model.Interval == null)
{
model.Interval = "1h";
}
var p = new DynamicParameters();
p.Add("datestart", model.DateStart);
p.Add("dateend", model.DateEnd);
p.Add("interval", model.Interval);
return((await _db.QueryAsync <CandleStickTableModel>("Get_BTC_USDT_CandleStick", p, commandType: CommandType.StoredProcedure))
.ToList());
}
catch (Exception ex)
{
return(null);
}
}