public Task <ListEntityVM <TopSellingProductsPerQuantityVM> > Handle(TopSellingProductsPerQuantityQuery request, CancellationToken cancellationToken)
{
var connString = _configuration["ConnectionStrings:BrimoDatabase"];
using (var con = new SqlConnection(connString))
{
var topSellingProductsPerQuantityQuery = "select top 10 ProductName, sum(unitcount) as TotalCount from OrderItems " +
"INNER JOIN orders ON Orders.Id = OrderItems.OrderId1 " +
"group by productName order by totalcount desc";
var topSellingProductsPerQuantityReport = con.Query <TopSellingProductsPerQuantityVM>(topSellingProductsPerQuantityQuery).ToList();
return(Task.FromResult(new ListEntityVM <TopSellingProductsPerQuantityVM> {
Data = topSellingProductsPerQuantityReport
}));
}
}
public async Task <IActionResult> TopSellingProductsPerQuantity(TopSellingProductsPerQuantityQuery query)
{
var result = await Mediator.Send(query);
return(Ok(result));
}
