public async Task <IActionResult> GetGeneralStatistics([FromQuery] DichVuGeneralStatisticsParams userParams) { try { var result = await _repo.GetGeneralStatistics(userParams); return(StatusCode(200, new SuccessResponseDto { Message = "Lấy dữ liệu thống kê tổng quan về " + _entityName + " thành công!", Result = new SuccessResponseResultWithSingleDataDto { Data = result } })); } catch (Exception e) { return(StatusCode(500, new FailedResponseDto { Message = "Lấy dữ liệu thống kê tổng quan về " + _entityName + " thất bại!", Result = new FailedResponseResultDto { Errors = e } })); } }
public async Task <Object> GetGeneralStatistics(DichVuGeneralStatisticsParams userParams) { var result = _context.DanhSachDichVu.AsQueryable(); var totalServices = 0; var cheapestService = 0.0; var mostExpensiveService = 0.0; if (userParams != null && userParams.StartingTime.GetHashCode() != 0 && userParams.EndingTime.GetHashCode() != 0) { totalServices = result.Count(); cheapestService = result.Where(x => x.ThoiGianTao >= userParams.StartingTime && x.ThoiGianTao <= userParams.EndingTime).Min(x => x.DonGia); mostExpensiveService = result.Where(x => x.ThoiGianTao >= userParams.StartingTime && x.ThoiGianTao <= userParams.EndingTime).Max(x => x.DonGia); } else { totalServices = result.Count(); cheapestService = result.Min(x => x.DonGia); mostExpensiveService = result.Max(x => x.DonGia); } return(new { Total = totalServices, Cheapest = cheapestService, MostExpensive = mostExpensiveService, }); }