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