public async Task <ActionResult> GetMostFrecuent(int num)
{
await Db.Connection.OpenAsync();
var query = new CustomOrdersData(Db);
var result = await query.GetMostFrecuentItemAsync(num);;
if (result is null)
{
return(new NotFoundResult());
}
return(new OkObjectResult(result));
}
public async Task <ActionResult> GetOrdersAfter(int date)
{
DateTime dt = DateTime.ParseExact(date.ToString(), "yyyyMMdd", null);
await Db.Connection.OpenAsync();
var query = new CustomOrdersData(Db);
var result = await query.GetOrdersAfterAsync(dt);
if (result is null)
{
return(new NotFoundResult());
}
return(new OkObjectResult(result));
}
public async Task <IActionResult> GetOrdersBetween(int startDate, int endDate)
{
DateTime dtStart = DateTime.ParseExact(startDate.ToString(), "yyyyMMdd", null);
DateTime dtEnd = DateTime.ParseExact(endDate.ToString(), "yyyyMMdd", null);
await Db.Connection.OpenAsync();
var query = new CustomOrdersData(Db);
var result = await query.GetOrdersBetweenAsync(dtStart, dtEnd);
if (result is null)
{
return(new NotFoundResult());
}
return(new OkObjectResult(result));
}
