public async Task <ActionResult> SalvarConsulta([FromServices] MostraClimaDbContext dbContext, [FromBody] Consulta consulta)
{
dbContext.Consultas.Add(consulta);
await dbContext.SaveChangesAsync();
return(Ok("consulta salva com sucesso"));
}
public async Task <ActionResult <int?> > ConsultarIdDoUltimoHistoricoDoUsuario([FromServices] MostraClimaDbContext dbContext, [FromQuery] string userKey)
{
var UltimaConsulta = await dbContext.Consultas.Where(c => c.UserKey == userKey).OrderBy(c => c.Id).LastOrDefaultAsync();
int idUltimaConsulta;
if (UltimaConsulta == null)
{
idUltimaConsulta = 0;
}
else
{
idUltimaConsulta = UltimaConsulta.Id;
}
return(Ok(idUltimaConsulta));
}
public async Task <ActionResult <List <Consulta> > > ConsultarTodosOsHistoricos([FromServices] MostraClimaDbContext dbContext)
{
var todasConsultas = await dbContext.Consultas.ToListAsync();
return(Ok(todasConsultas));
}
public async Task <ActionResult <List <Consulta> > > ConsultarHistorico([FromServices] MostraClimaDbContext dbContext, [FromQuery] string userKey)
{
var consultas = await dbContext.Consultas.Where(c => c.UserKey == userKey).ToListAsync();
return(Ok(consultas));
}
