public ActionResult Create([Bind(Include = "Categoria,id_principal,Nome,Responsavel,Cancelado,palavra_chave,palavra_chave2,limite_participantes,Local,Data,data_hora_fim")] evento evento)
{
db.evento.Add(evento);
db.SaveChanges();
return(RedirectToAction("Index"));
//ViewBag.Id = new SelectList(db.comentarios, "Id", "login", evento.Id);
ViewBag.id_principal = new SelectList(db.evento_composto, "Id", "Nome", evento.id_principal);
ViewBag.Responsavel = new SelectList(db.usuario, "login", "pass", evento.Responsavel);
return(View(evento));
}
public ActionResult Create([Bind(Include = "login,pass,Nome,Endereco,CEP,Nascimento,cadastro,CPF,RG,email,r_phone,cel_phone,newsletter")] usuario usuario)
{
if (ModelState.IsValid)
{
db.usuario.Add(usuario);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(usuario));
}
public ActionResult Create([Bind(Include = "login,id_evento,comentario1,likes")] comentario comentario)
{
if (ModelState.IsValid)
{
db.comentario.Add(comentario);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id = new SelectList(db.evento, "Id", "Nome", comentario.Id);
ViewBag.login = new SelectList(db.usuario, "login", "pass", comentario.login);
return(View(comentario));
}
public static void IncluirEvento(Evento evento)
{
using (var context = new EventosEntities()) {
context.Eventos.Add(evento);
context.SaveChanges();
}
}
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 void Cadastrar(evento_composto ec)
{
try
{
EventosEntities db = new EventosEntities();
db.evento_composto.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(pergunta ec)
{
try
{
EventosEntities db = new EventosEntities();
db.pergunta.Add(ec);
db.SaveChanges();
}
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 void Cadastrar(participante part)
{
try
{
EventosEntities db = new EventosEntities();
db.participante.Add(part);
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 Excluir(string id)
{
try
{
EventosEntities db = new EventosEntities();
db.usuario.Remove(db.usuario.Find(id));
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 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;
}
}
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 Cancelar(int?id)
{
try
{
EventosEntities db = new EventosEntities();
evento e = db.evento.Find(id);
if (e.Data > DateTime.Now)
{
e.Cancelado = true;
db.Entry(e).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
