public static void IncluirEvento(Evento evento) { using (var context = new EventosEntities()) { context.Eventos.Add(evento); context.SaveChanges(); } }
public static Evento BuscarEvento(int id) { using (var context = new EventosEntities()) { return(context.Eventos.FirstOrDefault(p => p.Id == id)); //expressão lambida (delagate) } }
public static List <Evento> ListarEventos() { using (var context = new EventosEntities()) { return(context.Eventos.ToList()); } }
public static Evento BuscarEvento(int id) { using (var context = new EventosEntities()) { return(context.Eventos.FirstOrDefault(p => p.Id == id)); } }
public static void IncluirConvidado(Convidado convidado) { using (var context = new EventosEntities()) { context.Convidados.Add(convidado); context.SaveChanges(); } }
public static void IncluirEvento(Evento evento) { using (var context = new EventosEntities()) //EventosEntities abre e fecha a conexão { //using faz a variável ser liberada, isso otimiza os objetos (economiza a memória) context.Eventos.Add(evento); context.SaveChanges(); } }
public static List <resposta> Listar() { try { EventosEntities db = new EventosEntities(); return(db.resposta.Include(r => r.pergunta).Include(r => r.usuario1).ToList()); } catch (Exception) { throw; } }
public static DbSet <evento_composto> PegarDB() { try { EventosEntities db = new EventosEntities(); return(db.evento_composto); } catch (Exception) { throw; } }
public static List <usuario> ListarPorEvento(evento e) { try { EventosEntities db = new EventosEntities(); return(db.usuario.SqlQuery("SELECT * FROM dbo.usuario JOIN dbo.participante ON participante.login = usuario.login WHERE id_evento =" + e.Id + ";").ToList()); } catch (Exception) { throw; } }
public static List <usuario> Listar() { try { EventosEntities db = new EventosEntities(); return(db.usuario.ToList()); } catch (Exception) { throw; } }
public static DbSet <usuario> PegarDB() { try { EventosEntities db = new EventosEntities(); return(db.usuario); } catch (Exception) { throw; } }
public static usuario VerificaUsuario(usuario u) { try { EventosEntities db = new EventosEntities(); return(db.usuario.Where(a => a.login.Equals(u.login) && a.pass.Equals(u.pass)).FirstOrDefault()); } catch (Exception) { throw; } }
public static DbSet <pergunta> PegarDB() { try { EventosEntities db = new EventosEntities(); return(db.pergunta); } catch (Exception) { throw; } }
public static List <evento_composto> Listar() { try { EventosEntities db = new EventosEntities(); return(db.evento_composto.ToList()); } catch (Exception) { throw; } }
public static void Cadastrar(evento_composto ec) { try { EventosEntities db = new EventosEntities(); db.evento_composto.Add(ec); db.SaveChanges(); } catch (Exception) { throw; } }
public static List <usuario> ListarNews() { try { EventosEntities db = new EventosEntities(); return(db.usuario.SqlQuery("SELECT * FROM dbo.usuario WHERE newsletter=1;").ToList()); } catch (Exception) { throw; } }
public static void Cadastrar(pergunta ec) { try { EventosEntities db = new EventosEntities(); db.pergunta.Add(ec); db.SaveChanges(); } catch (Exception) { throw; } }
public static void Excluir(int id) { try { EventosEntities db = new EventosEntities(); db.pergunta.Remove(db.pergunta.Find(id)); db.SaveChanges(); } catch (Exception) { throw; } }
public static void Cadastrar(participante part) { try { EventosEntities db = new EventosEntities(); db.participante.Add(part); db.SaveChanges(); } catch (Exception) { throw; } }
public static List <evento> Listar() { try { EventosEntities db = new EventosEntities(); var evento = db.evento.Include(e => e.comentario).Include(e => e.evento_composto).Include(e => e.usuario); return(db.evento.ToList()); } catch (Exception) { throw; } }
public static List <participante> Listar() { try { EventosEntities db = new EventosEntities(); var participantes = db.participante.Include(p => p.evento).Include(p => p.usuario); return(participantes.ToList()); } catch (Exception) { throw; } }
public static void Editar(pergunta ec) { try { EventosEntities db = new EventosEntities(); db.Entry(ec).State = EntityState.Modified; db.SaveChanges(); } catch (Exception) { throw; } }
public static List <pergunta> Listar() { try { EventosEntities db = new EventosEntities(); return(db.pergunta.Include(p => p.evento).ToList()); } catch (Exception) { throw; } }
public static void Excluir(string id) { try { EventosEntities db = new EventosEntities(); db.usuario.Remove(db.usuario.Find(id)); db.SaveChanges(); } catch (Exception) { throw; } }
public static void Cadastrar(usuario u) { try { u.cadastro = DateTime.Now; EventosEntities db = new EventosEntities(); db.usuario.Add(u); db.SaveChanges(); } catch (Exception) { throw; } }
public static void RemoverCancelamento(int?id) { try { EventosEntities db = new EventosEntities(); evento e = db.evento.Find(id); e.Cancelado = false; db.Entry(e).State = EntityState.Modified; db.SaveChanges(); } catch (Exception) { throw; } }
public static void Cadastrar(evento e) { try { e.Cancelado = false; e.emitidos = false; EventosEntities db = new EventosEntities(); db.evento.Add(e); db.SaveChanges(); } catch (Exception) { throw; } }
public static void Dispose(bool disposing) { try { EventosEntities db = new EventosEntities(); if (disposing) { db.Dispose(); } } catch (Exception) { throw; } }
public static void Ausente(string id) { try { EventosEntities db = new EventosEntities(); var ids = id.Split('-'); var participantes = db.participante.SqlQuery("SELECT * FROM dbo.participante WHERE id_evento=" + ids[0] + " AND login='******';").ToList(); participantes[0].Presenca = false; db.Entry(participantes[0]).State = EntityState.Modified; db.SaveChanges(); } catch (Exception) { throw; } }
public static void Excluir(string id) { try { EventosEntities db = new EventosEntities(); var ids = id.Split('-'); var participantes = db.participante.SqlQuery("SELECT * FROM dbo.participante WHERE id_evento=" + ids[0] + " AND login="******";").ToList(); db.participante.Remove(participantes[0]); db.SaveChanges(); } catch (Exception) { throw; } }