public SummaryOrderByIndividualPVModel SearchSummaryOrderByIndividualPVModels(
[FromUri] OrderAdminSearchCriteria searchCriteria, [FromUri] PaginationOptions paginationOptions)
{
var tbl = _orderReportService.SearchSummaryOrderByIndividualPV(_workContext.User, paginationOptions,
searchCriteria);
var dataRows = tbl.AsEnumerable().Skip((paginationOptions.PageIndex - 1) * paginationOptions.PageSize).Take(paginationOptions.PageSize);
var model = dataRows.Select(Mapper.Map <DataRow, SummaryOrderByIndividualPVRowModel>).ToList();
var summaryTotalAmount = 0;
decimal summaryTotalPV = 0;
decimal summaryTotalPrice = 0;
if (model.Count > 0)
{
summaryTotalAmount = Convert.ToInt32(tbl.Compute("Sum(Quantity)", ""));
summaryTotalPV = Convert.ToDecimal(tbl.Compute("Sum(TotalPV)", ""));
summaryTotalPrice = Convert.ToDecimal(tbl.Compute("Sum(TotalPrice)", ""));
}
return(new SummaryOrderByIndividualPVModel()
{
Data = model,
TotalItems = tbl.Rows.Count,
SummaryTotalAmount = summaryTotalAmount,
SummaryTotalPV = summaryTotalPV,
SummaryTotalPrice = summaryTotalPrice
});
}