public async Task <IEnumerable <ReceptionGet> > GetStatistics(ReceptionStatistical statistical) { var _fromDate = Convert.ToDateTime(statistical.fromDate); var _toDate = Convert.ToDateTime(statistical.toDate); var reception = await _db.Receptions.Include(x => x.Client) .Include(x => x.Specialty) .Include(x => x.Employee).Where(x => x.DateOfReceipt.Date >= _fromDate.Date && x.DateOfReceipt.Date < _toDate.Date).ToListAsync(); var receptionGet = new List <ReceptionGet>(); foreach (Reception item in reception) { receptionGet.Add(new ReceptionGet { ReceptionId = item.ReceptionId, Client = item.Client, DateOfReceipt = item.DateOfReceipt, EmployeeId = item.Employee.EmployeeId, EmployeeFullName = item.Employee.FullName, SpecialtyId = item.Specialty.SpecialtyId, SpecialtyName = item.Specialty.Name, Registered = item.Registered, Status = item.Status }); } return(receptionGet); }
public async Task <ActionResult> GetStatistics([FromBody] ReceptionStatistical statistical) { var result = await _receptionService.GetStatistics(statistical); if (result == null) { return(BadRequest()); } return(Ok(new { result, reservation = result.Count(), income = result.Count() * 300, hours = result.Count() })); }