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