public async Task <IActionResult> Edit(int id, [Bind("TuristAnswerID,SurveyNumber,AnswerDate,TuristAnswerState,TuristID,AnswerID")] TuristAnswer turistAnswer) { if (id != turistAnswer.TuristAnswerID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(turistAnswer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TuristAnswerExists(turistAnswer.TuristAnswerID)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } ViewData["AnswerID"] = new SelectList(_context.Answer, "AnswerID", "AnswerID", turistAnswer.AnswerID); ViewData["TuristID"] = new SelectList(_context.Turist, "TuristID", "Email", turistAnswer.TuristID); return(View(turistAnswer)); }
public async Task <IActionResult> Create(string sortOrder, string currentFilter, string searchString, int?page, bool concluir, [Bind("TuristAnswerID,SurveyNumber,AnswerDate,TuristAnswerState,TuristID,AnswerID")] TuristAnswer turistAnswer) { var user = await _userManager.GetUserAsync(User); string nome = user.UserName; string email = user.Email; string phone = user.PhoneNumber; ViewData["CurrentSort"] = sortOrder; if (searchString != null) { page = 1; } else { searchString = currentFilter; } var lista = from z in _context.Questions.Include(a => a.Answer) select z; int pageSize = 1; var listadeturistas = _context.Turist.Where(t => (t.Email == email)); foreach (var item in listadeturistas) { turistAnswer.TuristID = item.TuristID; } if (ModelState.IsValid && ModelState.Count > 0) { if (turistAnswer.AnswerID != 0) { turistAnswer.SurveyNumber = 1; turistAnswer.AnswerDate = System.DateTime.Today; turistAnswer.TuristAnswerState = true; _context.Add(turistAnswer); await _context.SaveChangesAsync(); } } if (concluir) { return(RedirectToAction("Details")); } else { return(View(await PaginatedList <Questions> .CreateAsync(lista.AsNoTracking(), page ?? 1, pageSize))); /* ViewData["AnswerID"] = new SelectList(_context.Answer, "AnswerID", "AnswerID", turistAnswer.AnswerID); * ViewData["TuristID"] = new SelectList(_context.Turist, "TuristID", "TuristID", turistAnswer.TuristID);*/ } }