public async Task <ActionResult <List <HistoricoStatus> > > Filter(FilterHistoricoStatus filterHistoricoStatus) { var historico = from m in _db.HistoricoStatus.Include(v => v.Funcionario) select m; if (!string.IsNullOrEmpty(filterHistoricoStatus.Status)) { historico = historico.Where(s => s.Status.Contains(filterHistoricoStatus.Status)); } if (filterHistoricoStatus.DataI != null && filterHistoricoStatus.DataF != null) { var date = Convert.ToDateTime(filterHistoricoStatus.DataI); var date1 = Convert.ToDateTime(filterHistoricoStatus.DataF); var nextDay = date1.AddDays(1); historico = historico.Where(s => s.Data_inicio.Value.Date >= date && s.Data_final.Value.Date < nextDay); } else if (filterHistoricoStatus.DataI != null) { var date = Convert.ToDateTime(filterHistoricoStatus.DataI).Date; var nextDay = date.AddDays(1); historico = historico.Where(s => s.Data_inicio.Value.Date >= date && (s.Data_inicio.Value.Date < nextDay || s.Data_inicio.Value.Date == null)); } return(await historico.ToListAsync()); }
public async Task <List <HistoricoStatus> > GetHistoricoStatusFilter(FilterHistoricoStatus filterHistoricoStatus) { var response = await httpService.Post <FilterHistoricoStatus, List <HistoricoStatus> >($"{url}/filter", filterHistoricoStatus); if (!response.Success) { throw new ApplicationException(await response.GetBody()); } return(response.Response); }