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)); }