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