public ActionResult CreateQuestionaire(Root model)
        {
//create survey by user
            if (model.list != null)
            {
                for (int i = 0; i < model.list.Count; i++)
                {
                    QuestionaireEntries q = new QuestionaireEntries();
                    q.Questionaire_Id          = model.list[i].ID;
                    q.Questionaire_Description = model.list[i].Questionaire_Description;
                    q.Answer      = model.list[i].Answer;
                    q.user_id     = User.Identity.Name;
                    q.dateCreated = DateTime.Now;

                    var query = context.questionareEntries.SingleOrDefault(x => x.Questionaire_Description == q.Questionaire_Description);
                    if (query == null)
                    {
                        context.questionareEntries.Add(q);
                        context.SaveChanges();
                    }
                    else
                    {
                        TempData["error"] = "Questionaire already exists in the system";
                    }
                }
                TempData["success"] = "Questionaire successfully submitted";
            }

            return(RedirectToAction("ViewQuestionaire", "Questionaire"));
        }
        public ActionResult MyQuestionaire()
        {
            // fetch user questionaire entries
            // var currentUser=   User.Identity.GetUserId();
            var currentUser = User.Identity.Name;
            List <QuestionaireEntries> list = new List <QuestionaireEntries>();
            var query = context.questionareEntries.Where(x => x.user_id == currentUser).ToList();

            foreach (var item in query)
            {
                QuestionaireEntries model = new QuestionaireEntries();
                model.ID = item.ID;
                model.Questionaire_Description = item.Questionaire_Description;
                model.Answer = item.Answer;
                list.Add(model);
            }


            return(View(list));
        }