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