public async Task <object> TongTienNhapHang(ThongKeParams userParams)
{
var result = _context.DanhSachDonNhapHang.AsQueryable();
var startingTime = userParams.StartingTime;
var endingTime = userParams.EndingTime;
if (startingTime.GetHashCode() != 0 && endingTime.GetHashCode() != 0)
{
result = result.Where(x => x.NgayLap >= startingTime && x.NgayLap <= endingTime);
}
var resultToReturn = result.Select(x => new
{
ThoiGian = x.NgayLap.Date,
GiaTri = x.ThanhTien
}).GroupBy(x => x.ThoiGian).Select(x => new {
ThoiGian = x.Key,
GiaTri = x.Sum(y => y.GiaTri)
});
return(new
{
Data = resultToReturn
});
}
public async Task <IActionResult> TongTienDatSan([FromQuery] ThongKeParams userParams)
{
try
{
var result = await _repo.TongTienDatSan(userParams);
return(StatusCode(200, new SuccessResponseDto
{
Message = "Lấy dữ liệu thống kê thành công!",
Result = new SuccessResponseResultWithMultipleDataDto
{
Data = result
}
}));
}
catch (Exception e)
{
return(StatusCode(500, new FailedResponseDto
{
Message = "Lấy dữ liệu thống kê thất bại!",
Result = new FailedResponseResultDto
{
Errors = e
}
}));
}
}
