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