public ActionResult quizVerify(string id) { ViewData["skillID"] = id; int sID = Convert.ToInt16(id); tbSkill model = db.tbSkills.Where(sk => sk.skillID.Equals(sID)).Single(); return(View(model)); }
public ActionResult quiz(string id) { int sklID = Convert.ToInt16(Session["sklID"].ToString()); quizViewModel model = new quizViewModel(); string username = Session["dev"].ToString(); tbUserCredential userCredential = db.tbUserCredentials.Where(uc => uc.username.Equals(username)).Single(); int Uid = userCredential.tbUser.userID; tbClient client = db.tbClients.Where(uc => uc.userID.Equals(Uid)).Single(); int devID = client.tbDevelopers.FirstOrDefault().devID; tbSkill skl = db.tbSkills.Where(uc => uc.devID.Equals(devID) && uc.skillID.Equals(sklID)).Single(); int i = Convert.ToInt16(id); List <tbQuestion> questions = db.tbQuestions.Where(q => q.skill.Equals(skl.name)).ToList(); if (i < questions.Count) { ViewBag.count = questions.Count; int Qid = questions[i].qID; List <tbAnswer> answers = db.tbAnswers.Where(a => a.qID == Qid).ToList(); model.tbSkill = skl; model.tbQuestion = questions; model.tbAnswer = answers; model.tbDeveloper = client.tbDevelopers.FirstOrDefault(); model.i = i; model.score = 0; } else { //quiz completed } return(View(model)); }