public List <Participacao> Listar() { using (var db = new SistemaDeEventosContext()) { return(db.Participacoes.ToList()); } }
public Evento ListarCateg(int categoria) { using (var db = new SistemaDeEventosContext()) { return(db.Eventos.Where(x => x.IdCategoriaEvento == categoria).FirstOrDefault()); } }
public CategoriaEvento findById(int id) { using (var db = new SistemaDeEventosContext()) { return(db.CategoriaEventos.Where(x => x.IdCategoriaEvento == id).FirstOrDefault()); } }
public List <CategoriaEvento> Listar() { using (var db = new SistemaDeEventosContext()) { return(db.CategoriaEventos.ToList()); } }
public List <T> Listar() { using (var db = new SistemaDeEventosContext()) { return(db.Set <T>().Where(x => !x.FlagExcluido).ToList()); } }
public List <Participacao> GetParticipanteByEvento(int idEvento) { using (var db = new SistemaDeEventosContext()) { return(db.Participacoes.Where(x => x.IdEvento == idEvento).ToList()); } }
public Participacao findById(int id) { using (var db = new SistemaDeEventosContext()) { return(db.Participacoes.Where(x => x.IdParticipacao == id).FirstOrDefault()); } }
public Evento ListarData(DateTime data) { using (var db = new SistemaDeEventosContext()) { return(db.Eventos.Where(x => x.DataHoraInicio == data).FirstOrDefault()); } }
public Evento Obter(int id) { using (var db = new SistemaDeEventosContext()) { db.Eventos.Include(x => x.IdCategoriaEventoNavigation).Include(x => x.IdEventoStatusNavigation).ToList(); return(db.Eventos.Where(x => x.IdEvento == id).FirstOrDefault()); } }
public List <Evento> ListByData(DateTime data) { using (var db = new SistemaDeEventosContext()) { db.Eventos.Include(x => x.IdCategoriaEventoNavigation).Include(x => x.IdEventoStatusNavigation).ToList(); return(db.Eventos.Where(x => x.DataHoraInicio.Date == data.Date).ToList()); } }
public List <Evento> Listar() { using (var db = new SistemaDeEventosContext()) { //assim se faz left join return(db.Eventos.Include(x => x.IdCategoriaEventoNavigation).Include(x => x.IdEventoStatusNavigation).ToList()); } }
public void Excluir(T modelo) { using (var db = new SistemaDeEventosContext()) { modelo.FlagExcluido = true; Atualizar(modelo); } }
public List <Evento> ListByCategoria(int categoria) { using (var db = new SistemaDeEventosContext()) { db.Eventos.Include(x => x.IdCategoriaEventoNavigation).Include(x => x.IdEventoStatusNavigation).ToList(); return(db.Eventos.Where(x => x.IdCategoriaEvento == categoria).ToList()); } }
public CategoriaEvento create(CategoriaEvento model) { using (var db = new SistemaDeEventosContext()) { db.CategoriaEventos.Add(model); db.SaveChanges(); return(model); } }
public int LimiteVagas(int id) { using (var db = new SistemaDeEventosContext()) { var limite = db.Eventos.Where(e => e.IdEvento == id).Select(e => e.LimiteVagas).First(); return(limite); } }
public Evento Inserir(Evento model) { using (var db = new SistemaDeEventosContext()) { db.Eventos.Add(model); db.SaveChanges(); return(model); } }
public Participacao create(Participacao model) { using (var db = new SistemaDeEventosContext()) { db.Participacoes.Add(model); db.SaveChanges(); return(model); } }
public Evento Inserir(Evento model) { using (var db = new SistemaDeEventosContext()) { db.Eventos.Add(model); db.SaveChanges(); db.Eventos.Include(x => x.IdCategoriaEventoNavigation).Include(x => x.IdEventoStatusNavigation).ToList(); return(model); } }
public Evento Atualizar(Evento model) { using (var db = new SistemaDeEventosContext()) { db.Entry(model).State = EntityState.Modified; db.Eventos.Include(x => x.IdCategoriaEventoNavigation).Include(x => x.IdEventoStatusNavigation).ToList(); db.SaveChanges(); return(model); } }
public int IncricoesEvento(int id) { using (var db = new SistemaDeEventosContext()) { var incricoes = db.Participacoes.Include(p => p.IdEventoNavigation) .Where(p => p.IdEvento == id) .Count(); return(incricoes); } }
public bool delete(Participacao model) { using (var db = new SistemaDeEventosContext()) { db.Entry(model).State = EntityState.Deleted; db.SaveChanges(); return(true); } }
public Participacao update(Participacao model) { using (var db = new SistemaDeEventosContext()) { db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return(model); } }
public CategoriaEvento update(CategoriaEvento model) { using (var db = new SistemaDeEventosContext()) { db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return(model); } }
public T Inserir(T modelo) { using (var db = new SistemaDeEventosContext()) { db.ChangeTracker.AutoDetectChangesEnabled = false; db.Set <T>().Add(modelo); db.SaveChanges(); return(modelo); } }
public T Atualizar(T modelo) { using (var db = new SistemaDeEventosContext()) { db.ChangeTracker.AutoDetectChangesEnabled = false; db.Entry(modelo).State = EntityState.Modified; db.SaveChanges(); return(modelo); } }