public ActionResult GetResults(FormCollection collection) { var col = collection; var userID = (short)TempData["UserID"]; var db = new PoolEntities(); foreach (string key in col.Keys) { if (key.EndsWith("CheckAnswer")) { bool v = col[key] == "on"; if (v) { var cha = new UserCheckAnswer(); cha.User_ID = userID; cha.CheckAnswer_ID = GetCheckAnswerID(key); db.UserCheckAnswers.Add(cha); } } if (key.EndsWith("TextAnswer")) { string v = col[key]; var oa = new UserOpenAnswer(); oa.User_ID = userID; oa.Question_ID = GetQuestionID(key); oa.Answer = v; db.UserOpenAnswers.Add(oa); } } db.SaveChanges(); return(RedirectToAction("GetReadyResults")); }
public ActionResult CreateUser(User user) { PoolEntities db = new PoolEntities(); var u = db.Users.SingleOrDefault(x => x.Name == user.Name); if (u == null) { db.Users.Add(user); db.SaveChanges(); } else { user = u; } var userPassPoolAlready = db.UserOpenAnswers.Any(x => x.User_ID == user.ID); TempData["UserID"] = user.ID; if (userPassPoolAlready) { return(RedirectToAction("GetReadyResults")); } var pool = db.Pools.FirstOrDefault(); return(View(new UserPool(user, pool))); }