public void StoreQuestionToUsersAnswers(Question question)
        {
            Answer selectedAnswer   = CurrentAnswers.Where(x => x.IsSelected == true).Single();
            Answer dbSelectedAnswer = QuizEntities.Answers.Where(x => x.Id == selectedAnswer.Id).Single();

            UsersAnswers.Add(question, dbSelectedAnswer);
        }
示例#2
0
        public void Delete(DalUsersAnswers e)
        {
            if (context.Database.Connection.State != ConnectionState.Open)
            {
                context.Database.Connection.Open();
            }
            UsersAnswers ua = context.Set <UsersAnswers>().
                              FirstOrDefault(a => a.UsersTestId == e.UserTestId &&
                                             a.QuestionId == e.QuestionId &&
                                             a.BeginningTime == e.BeginningTime);

            context.Set <UsersAnswers>().Remove(ua);
        }
示例#3
0
        public void Update(DalUsersAnswers entity)
        {
            if (context.Database.Connection.State != ConnectionState.Open)
            {
                context.Database.Connection.Open();
            }
            UsersAnswers ua = context.Set <UsersAnswers>().
                              FirstOrDefault(a => a.UsersTestId == entity.UserTestId &&
                                             a.QuestionId == entity.QuestionId &&
                                             a.BeginningTime == entity.BeginningTime);

            ua.AnswerStructure = entity.AnswerStructure;
            ua.EndingTime      = entity.EndingTime;
        }
示例#4
0
        public void Create(DalUsersAnswers e)
        {
            if (context.Database.Connection.State != ConnectionState.Open)
            {
                context.Database.Connection.Open();
            }
            UsersAnswers ua = new UsersAnswers()
            {
                AnswerStructure = e.AnswerStructure,
                BeginningTime   = e.BeginningTime,
                EndingTime      = e.EndingTime,
                QuestionId      = e.QuestionId,
                UsersTestId     = e.UserTestId
            };

            context.Set <UsersAnswers>().Add(ua);
        }
示例#5
0
        public IActionResult CheckAnswers()
        {
            int?userID = HttpContext.Session.GetInt32("LogedUserID");

            if (userID != null)
            {
                dbUser = _context.users.SingleOrDefault(u => u.id == userID);
                if (dbUser == null)
                {
                    return(RedirectToAction("Index", "Home"));
                }


                Console.WriteLine("***********************************");
                // int score = 0;
                // globalQuestions
                try{
                    foreach (string key in Request.Form.Keys)
                    {
                        string value = Request.Form[key];
                        int    keyId;
                        if (int.TryParse(key, out keyId))
                        {
                            Questions qest        = null;
                            string    user_answer = null;

                            foreach (var gq in globalQuestions)
                            {
                                if (gq.id == keyId)
                                {
                                    qest = gq;
                                }
                            }
                            foreach (var ans in qest.Answers)
                            {
                                if (ans.id == int.Parse(value))
                                {
                                    user_answer = ans.answer;
                                    if (ans.correct_answer == 1)
                                    {
                                        score += 100;
                                    }
                                }
                            }

                            UsersAnswers ua = new UsersAnswers()
                            {
                                userId     = dbUser.id,
                                questionId = qest.id,
                                answer     = user_answer
                            };
                            _context.Add(ua);
                            // _context.SaveChanges();
                        }
                    }
                }catch (Exception e) {
                    Console.WriteLine("*********************************" + e.ToString() + "*********************************");
                }
                finally{
                    game.status    = "Closed";
                    dbUser.points += score;
                    // _context.Add(dbUser);
                    _context.SaveChanges();
                }
            }
            Console.WriteLine("***********************************");
            // return RedirectToAction("Index", "Home");
            return(RedirectToAction("ViewResults"));
        }