public async Task <Eventos> Get(int id) { using (EasyTalkContext context = new EasyTalkContext()) { return(await context.Eventos.Include(c => c.IdCategoriaNavigation).Include(u => u.IdResponsavelNavigation).FirstOrDefaultAsync(x => x.IdEvento == id)); } }
public async Task <List <Eventos> > Get() { using (EasyTalkContext context = new EasyTalkContext()) { return(await context.Eventos.Include(c => c.IdCategoriaNavigation).Include(u => u.IdResponsavelNavigation).ToListAsync()); } }
public UsuarioModel BuscarPorEmailSenha(string email, string senha) { using (EasyTalkContext ctx = new EasyTalkContext()) { var usuarioProcurado = ctx.Usuario.Include(x => x.IdTipoNavigation).FirstOrDefault(x => x.Email == email && x.Senha == senha); return(usuarioProcurado); } }
public async Task <List <Eventos> > GetEventos(string evento) { using (EasyTalkContext context = new EasyTalkContext()) { List <Eventos> listevent = await context.Eventos.Where(c => c.NomeEvento.Contains(evento) || c.Descricao.Contains(evento)).ToListAsync(); return(listevent); } }
public async Task <List <Eventos> > GetReprovado() { using (EasyTalkContext context = new EasyTalkContext()) { List <Eventos> statusList = await context.Eventos.Where(s => s.Ativo == 3).ToListAsync(); return(statusList); } }
public async Task <Eventos> Put(Eventos evento) { using (EasyTalkContext context = new EasyTalkContext()){ context.Entry(evento).State = EntityState.Modified; await context.SaveChangesAsync(); return(evento); } }
public async Task <Eventos> Delete(Eventos evento) { using (EasyTalkContext context = new EasyTalkContext()){ context.Eventos.Remove(evento); await context.SaveChangesAsync(); return(evento); } }
public async Task <Eventos> Post(Eventos evento) { using (EasyTalkContext context = new EasyTalkContext()){ await context.Eventos.AddAsync(evento); await context.SaveChangesAsync(); return(evento); } }