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)); }