/// <inheritdoc />
public List <PaymentReportDto> PaymentReport(PaymentReportRequest request)
{
using (var db = new ApplicationDbContext())
{
var dbResult = db.Payments.Include(x => x.Client)
.Where(x => x.DateTime >= request.From)
.Where(x => x.DateTime <= request.To);
if (request.ClientId != null)
{
dbResult = dbResult.Where(x => x.ClientId == request.ClientId);
}
if (request.PaymentType != null)
{
dbResult = dbResult.Where(x => x.Type == (PaymentType)request.PaymentType);
}
return(dbResult.Select(x => new PaymentReportDto
{
ClientId = x.ClientId,
FullName = x.Client.FullName,
DateTime = x.DateTime,
Amount = x.Amount,
Comment = x.Comment,
PaymentType = x.Type.ToString()
})
.ToList());
}
}
public JsonResult PaymentReport([FromBody] PaymentReportRequest request)
{
var result = _service.PaymentReport(request);
return(Json(result));
}
