public async Task <ActionResult <AngajatiDetails> > GetAngajat(long id)
{
var angajat = await _context
.Angajati
// .Include(a => a.Santier )
.FirstOrDefaultAsync(a => a.Id_Angajat == id);
if (angajat == null)
{
return(NotFound());
}
return(AngajatiDetails.FromAngajat(angajat));
/*
* var angajat = await _context.Angajati.FindAsync(id);
*
* if (angajat == null)
* {
* return NotFound();
* }
*
* return angajat;
*/
}
public async Task <ActionResult <IEnumerable <AngajatiDetails> > > GetAngajati(
[FromQuery] DateTimeOffset?from = null,
[FromQuery] DateTimeOffset?to = null)
{
//filter by date from - date to
IQueryable <Angajat> result = _context.Angajati;
if (from != null && to != null)
{
result = result.Where(c => from <= c.Data && c.Data <= to);
}
else if (from == null && to != null)
{
result = result.Where(c => c.Data <= to);
}
else if (from != null && to == null)
{
result = result.Where(c => c.Data >= from);
}
var resultList = await result
// .Include(f => f.Santier)
.Select(f => AngajatiDetails.FromAngajat(f))
.ToListAsync();
return(resultList);
// return await _context.Angajati.ToListAsync();
}