public ActionResult GetAll() { var formularioList = new FormulariosExperienciasViewModel(); var MinhaListaDeCheckBox = new List <FormulariosExperienciasViewModel>(); var MinhaViewModelFormulario = new List <FormulariosExperienciasViewModel>(); foreach (var item in db.Formularios) { int c = 0; c++; MinhaViewModelFormulario.Add(new FormulariosExperienciasViewModel { FormularioExperienciasViewModelID = c, FormularioID = item.FormularioID, Informacao = item.Informacao, Data = item.Data }); } formularioList.FormulariosExperienciasVM = MinhaViewModelFormulario; var testee = db.Experiencias; int ContForms = 0; List <int> guardaFormsContados = new List <int>(); int getValorMaxIDFormulario = 0; foreach (var item in db.Formularios) { getValorMaxIDFormulario = item.FormularioID; } for (int i = 0; i <= getValorMaxIDFormulario; i++) { var Resultados = from b in db.Experiencias select new { b.ExperienciaId, b.InfoExperiencia, Checked = ((from ab in db.FormularioExperiencias where (ab.FormularioId == i) & (ab.ExperienciaId == b.ExperienciaId) select ab).Count() > 0) }; foreach (var item in Resultados) { if (item.Checked) { MinhaListaDeCheckBox.Add(new FormulariosExperienciasViewModel { FormularioID = ContForms, CheckBoxID = item.ExperienciaId, Name = item.InfoExperiencia, Checked = item.Checked }); } } if (ContForms == i) { guardaFormsContados.Add(ContForms); } ContForms++; } ViewBag.guardaFormsContados = guardaFormsContados; formularioList.ExperienciasFormulariosVM = MinhaListaDeCheckBox; return(View(MinhaListaDeCheckBox)); }
public ActionResult TestFormulario(int?Id, int?formularioID, int?ocultaFormID) { ViewBag.OcultForm2 = ocultaFormID; var formularioList = new FormulariosExperienciasViewModel(); var MinhaListaDeCheckBox = new List <FormulariosExperienciasViewModel>(); var MinhaViewModelFormulario = new List <FormulariosExperienciasViewModel>(); foreach (var item in db.Formularios) { int c = 0; c++; MinhaViewModelFormulario.Add(new FormulariosExperienciasViewModel { FormularioExperienciasViewModelID = c, FormularioID = item.FormularioID, Informacao = item.Informacao, Data = item.Data, UsuarioId = item.UsuarioId }); ViewBag.UsuarioId = item.UsuarioId; } formularioList.FormulariosExperienciasVM = MinhaViewModelFormulario; var testee = db.Experiencias; int ContForms = 0; List <int> guardaFormsContados = new List <int>(); int getValorMaxIDFormulario = 0; foreach (var item in db.Formularios) { getValorMaxIDFormulario = item.FormularioID; } for (int i = 0; i <= getValorMaxIDFormulario; i++) { var Resultados = from b in db.Experiencias select new { b.ExperienciaId, b.InfoExperiencia, Checked = ((from ab in db.FormularioExperiencias where (ab.FormularioId == i) & (ab.ExperienciaId == b.ExperienciaId) select ab).Count() > 0) }; foreach (var item in Resultados) { if (item.Checked) { MinhaListaDeCheckBox.Add(new FormulariosExperienciasViewModel { FormularioID = ContForms, CheckBoxID = item.ExperienciaId, Name = item.InfoExperiencia, Checked = item.Checked }); } } if (ContForms == i) { guardaFormsContados.Add(ContForms); } ContForms++; } var GetIdUser = from b in db.Usuarios where b.Nome == User.Identity.Name select b; foreach (var item in GetIdUser) { ViewBag.UsuarioID = item.Id; } //ver se o insight foi informado e usar ComoFoiAexperiencia para comparar List <int> listVerSeTemFormsRepetidos1 = new List <int>(); List <int> listVerSeTemFormsRepetidos2 = new List <int>(); foreach (var item2 in db.ComoFoiAsExperiencias) { var verSeFoiCad2ComoFoiNoMesmoForm = item2.PlanejamentoFixoId; if (ViewBag.UsuarioID == item2.UsuarioId) { listVerSeTemFormsRepetidos1.Add(item2.PlanejamentoFixoId); } } listVerSeTemFormsRepetidos2 = listVerSeTemFormsRepetidos1; var count = listVerSeTemFormsRepetidos2.Count; var count2 = 1; var count3 = 0; foreach (var item in listVerSeTemFormsRepetidos1) { if (listVerSeTemFormsRepetidos2.Count == count) { formularioList.FormIdComoFoiAExper.Add(item); count = 1; count3 = listVerSeTemFormsRepetidos2[0]; } else if (listVerSeTemFormsRepetidos2[count2] != count3) { formularioList.FormIdComoFoiAExper.Add(item); count3 = listVerSeTemFormsRepetidos2[count2]; count2++; } } if (true) { } ViewBag.guardaFormsContados = guardaFormsContados; formularioList.UsuarioId = ViewBag.UsuarioID; formularioList.ExperienciasFormulariosVM = MinhaListaDeCheckBox; ViewBag.UsuarioFormularioTeste = from b in db.Usuarios where b.Nome == User.Identity.Name select b; return(View(formularioList)); }