public ActionResult Edit(FormulariosViewModel formulariosViewModel) { if (ModelState.IsValid) { var MeuFormulario = db.Formularios.Find(formulariosViewModel.FormularioID); MeuFormulario.Informacao = formulariosViewModel.Informacao; MeuFormulario.Data = formulariosViewModel.Data; foreach (var item in db.FormularioExperiencias) { if (item.FormularioId == formulariosViewModel.FormularioID) { db.Entry(item).State = EntityState.Deleted; } } foreach (var item in formulariosViewModel.Experiencias) { if (item.Checked) { db.FormularioExperiencias.Add(new FormularioExperiencia() { FormularioId = formulariosViewModel.FormularioID, ExperienciaId = item.Id }); } } db.SaveChanges(); return(RedirectToAction("Index")); } return(View(formulariosViewModel)); }
public ActionResult EditarModificacaoDePadrao(FormulariosViewModel formulariosViewModel) { if (ModelState.IsValid) { var MeuFormulario = db.Formularios.Find(formulariosViewModel.FormularioID); foreach (var item in db.FormularioExperiencias) { if (item.FormularioId == formulariosViewModel.FormularioID) { db.Entry(item).State = EntityState.Deleted; } } foreach (var item in formulariosViewModel.Experiencias) { if (item.Checked) { db.FormularioExperiencias.Add(new FormularioExperiencia() { FormularioId = formulariosViewModel.FormularioID, ExperienciaId = item.Id }); } } ViewBag.FormularioID = formulariosViewModel.FormularioID; db.SaveChanges(); return(RedirectToAction("Create", "ComoFoiAsExperiencias", new { formulariosViewModel.FormularioID })); } return(View(formulariosViewModel)); }
public ActionResult Create() { var Resultados = from b in db.Experiencias select new { b.ExperienciaId, b.InfoExperiencia, }; FormulariosViewModel MinhaViewModelFormulario = new FormulariosViewModel(); var MinhaListaDeCheckBox = new List <CheckBoxViewModel>(); foreach (var item in Resultados) { MinhaListaDeCheckBox.Add(new CheckBoxViewModel { Id = item.ExperienciaId, Name = item.InfoExperiencia, Checked = false }); } MinhaViewModelFormulario.Experiencias = MinhaListaDeCheckBox; return(View(MinhaViewModelFormulario)); }
public ActionResult Create(FormulariosViewModel formulariosViewModel) { Formulario formulario = new Formulario(); if (ModelState.IsValid) { var MeuFormulario = db.Formularios.Find(formulariosViewModel.FormularioID); //Identificar o id do usuário que está logado var GetIdUser = from b in db.Usuarios where b.Nome == User.Identity.Name select b; foreach (var item in GetIdUser) { formulario.UsuarioId = item.Id; ViewBag.UsuarioID = item.Id; } formulario.Informacao = formulariosViewModel.Informacao; formulario.Data = formulariosViewModel.Data; formulario.Data = formulariosViewModel.Data; //formulario.UsuarioId = 1; db.Formularios.Add(formulario); foreach (var item in db.FormularioExperiencias) { if (item.FormularioId == formulariosViewModel.FormularioID) { db.Entry(item).State = EntityState.Deleted; } } foreach (var item in formulariosViewModel.Experiencias) { if (item.Checked) { db.FormularioExperiencias.Add(new FormularioExperiencia() { FormularioId = formulariosViewModel.FormularioID, ExperienciaId = item.Id, }); } } db.SaveChanges(); return(RedirectToAction("Index")); } return(View(formulariosViewModel)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Formulario formulario = db.Formularios.Find(id); if (formulario == null) { return(HttpNotFound()); } //Capturar os textos em experiencias e filtrar para que o checkbox seja igual ao inserido pelo FormularioExperiencias var Resultados = from b in db.Experiencias select new { b.ExperienciaId, b.InfoExperiencia, Checked = ((from ab in db.FormularioExperiencias where (ab.FormularioId == id) & (ab.ExperienciaId == b.ExperienciaId) select ab).Count() > 0) }; // instancia formulariosviewmodel var MinhaViewModelFormulario = new FormulariosViewModel(); //recebe os dados de formulario pelo banco MinhaViewModelFormulario.FormularioID = id.Value; MinhaViewModelFormulario.Informacao = formulario.Informacao; MinhaViewModelFormulario.Data = formulario.Data; //instancia o checkboxviewmodel var MinhaListaDeCheckBox = new List <CheckBoxViewModel>(); //adiciona ao checkbox viewmodel aquele filtro que foi feito na expressão lambda foreach (var item in Resultados) { MinhaListaDeCheckBox.Add(new CheckBoxViewModel { Id = item.ExperienciaId, Name = item.InfoExperiencia, Checked = item.Checked }); } //guarda esses valores em formularioviewmodel MinhaViewModelFormulario.Experiencias = MinhaListaDeCheckBox; //envia return(View(MinhaViewModelFormulario)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Formulario formulario = db.Formularios.Find(id); if (formulario == null) { return(HttpNotFound()); } var Resultados = from b in db.Experiencias select new { b.ExperienciaId, b.InfoExperiencia, Checked = ((from ab in db.FormularioExperiencias where (ab.FormularioId == id) & (ab.ExperienciaId == b.ExperienciaId) select ab).Count() > 0) }; var MinhaViewModelFormulario = new FormulariosViewModel(); MinhaViewModelFormulario.FormularioID = id.Value; MinhaViewModelFormulario.Informacao = formulario.Informacao; MinhaViewModelFormulario.Data = formulario.Data; var MinhaListaDeCheckBox = new List <CheckBoxViewModel>(); foreach (var item in Resultados) { MinhaListaDeCheckBox.Add(new CheckBoxViewModel { Id = item.ExperienciaId, Name = item.InfoExperiencia, Checked = item.Checked }); } MinhaViewModelFormulario.Experiencias = MinhaListaDeCheckBox; return(View(MinhaViewModelFormulario)); }
public ActionResult EditarModificacaoDePadrao(int?id, int idUsuario) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Formulario formulario = db.Formularios.Find(id); if (formulario == null) { return(HttpNotFound()); } var Resultados = from b in db.Experiencias select new { b.ExperienciaId, b.InfoExperiencia, }; var MinhaViewModelFormulario = new FormulariosViewModel(); MinhaViewModelFormulario.FormularioID = id.Value; var MinhaListaDeCheckBox = new List <CheckBoxViewModel>(); foreach (var item in Resultados) { MinhaListaDeCheckBox.Add(new CheckBoxViewModel { Id = item.ExperienciaId, Name = item.InfoExperiencia, Checked = false }); } MinhaViewModelFormulario.Experiencias = MinhaListaDeCheckBox; MinhaViewModelFormulario.UsuarioId = idUsuario; return(View(MinhaViewModelFormulario)); }