public SummaryDiscountProductModel SearchSummaryDiscountProductModels( [FromUri] OrderAdminSearchCriteria searchCriteria, [FromUri] PaginationOptions paginationOptions) { var tbl = _orderReportService.SearchSummaryDiscountProduct(_workContext.User, paginationOptions, searchCriteria); var dataRows = tbl.AsEnumerable().Skip((paginationOptions.PageIndex - 1) * paginationOptions.PageSize).Take(paginationOptions.PageSize); var model = dataRows.Select(Mapper.Map <DataRow, SummaryDiscountProductRowModel>).ToList(); int summaryTotalAmount = 0; decimal summaryTotalDiscountedPrice = 0; decimal summaryTotalPrice = 0; if (model.Count > 0) { summaryTotalAmount = Convert.ToInt32(tbl.Compute("Sum(Quantity)", "")); summaryTotalDiscountedPrice = Convert.ToDecimal(tbl.Compute("Sum(TotalDiscountedPrice)", "")); summaryTotalPrice = Convert.ToDecimal(tbl.Compute("Sum(TotalPrice)", "")); } return(new SummaryDiscountProductModel() { Data = model, SummaryTotalPrice = summaryTotalPrice, SummaryTotalAmount = summaryTotalAmount, SummaryTotalDiscountedPrice = summaryTotalDiscountedPrice, TotalItems = tbl.Rows.Count }); }
private SummaryDiscountProductModel GetDiscountOrders(OrderAdminSearchCriteria searchCriteria, PaginationOptions paginationOptions) { searchCriteria.OrderBatchStatus = OrderBatchStatus.Approved; var tbl = _orderReportService.SearchSummaryDiscountProduct(_workContext.User, paginationOptions, searchCriteria); var dataRows = tbl.AsEnumerable() .Skip((paginationOptions.PageIndex - 1) * paginationOptions.PageSize) .Take(paginationOptions.PageSize); var model = dataRows.Select(Mapper.Map <DataRow, SummaryDiscountProductRowModel>).ToList(); int summaryTotalAmount = 0; decimal summaryTotalDiscountedPrice = 0; decimal summaryTotalPrice = 0; if (model.Count > 0) { summaryTotalAmount = Convert.ToInt32(tbl.Compute("Sum(Quantity)", "")); summaryTotalDiscountedPrice = Convert.ToDecimal(tbl.Compute("Sum(TotalDiscountedPrice)", "")); summaryTotalPrice = Convert.ToDecimal(tbl.Compute("Sum(TotalPrice)", "")); } var summaryDiscountProductModel = new SummaryDiscountProductModel() { Data = model, SummaryTotalPrice = summaryTotalPrice, SummaryTotalAmount = summaryTotalAmount, SummaryTotalDiscountedPrice = summaryTotalDiscountedPrice, TotalItems = tbl.Rows.Count }; return(summaryDiscountProductModel); }