public ActionResult Create(string createQuestionBox, int? id) { var context = new QuestDbEntities(); Question question; if (!string.IsNullOrWhiteSpace(createQuestionBox)) { question = new Question() { Text = createQuestionBox }; context.Questions.Add(question); context.SaveChanges(); } else if (id != null) { question = context.Questions. Where(x => x.Id == id).FirstOrDefault(); } else { //ViewBag.Message = "You cannot create empty question"; return RedirectToAction("Index", "AdminQuestions"); } var model = new QuestionModel { Id = question.Id, Text = question.Text, Answers = question.Answers.AsQueryable().Select(AnswerModel.FromAnswer) }; return View(model); }
public ActionResult Index() { //Include("Answers").Include("Answers.Votes").Include("Answers.Votes.VoteTypes") var context = new QuestDbEntities(); var questions = context.Questions.Select(QuestionModel.FromQuestion).ToList(); return View(questions); }
public ActionResult ById(int id) { var context = new QuestDbEntities(); var question = context.Questions. Where(x => x.Id == id). Select(QuestionModel.FromQuestion).FirstOrDefault(); return View(question); }
public ActionResult Index(int id) { var context = new QuestDbEntities(); var answer = context.Answers. Where(x => x.Id == id). Select(AnswerModel.FromAnswer).FirstOrDefault(); return View(answer); }
public ActionResult Search(string searchBox) { if (searchBox == null) { searchBox = string.Empty; } var context = new QuestDbEntities(); var questions = context.Questions. Where(x => x.Text.ToLower().Contains(searchBox.ToLower())). Select(QuestionModel.FromQuestion).ToList(); return View(questions); }
public ActionResult VoteYes(int id) { var context = new QuestDbEntities(); var answer = context.Answers.FirstOrDefault(x => x.Id == id); if (answer != null) { var vote = new Vote() { TypeId = 1, AnswerId = id }; answer.Votes.Add(vote); context.SaveChanges(); } return RedirectToAction("ById", "Home", new { id = answer.QuestionId }); }
public ActionResult Create(string createAnswerBox, int id) { if (string.IsNullOrWhiteSpace(createAnswerBox)) { //ViewBag.Message = "You cannot create empty question"; return RedirectToAction("Create", "AdminQuestions", new { id = id }); } var answer = new Answer() { Text = createAnswerBox }; var context = new QuestDbEntities(); var question = context.Questions.FirstOrDefault(x => x.Id == id); question.Answers.Add(answer); context.SaveChanges(); return RedirectToAction("Create", "AdminQuestions", new { id = answer.QuestionId }); }
public ActionResult Index() { var context = new QuestDbEntities(); var questions = context.Questions.Select(QuestionModel.FromQuestion).ToList(); return View(questions); }
public ActionResult Count() { var context = new QuestDbEntities(); var count = context.Votes.Count(); return Content(count.ToString()); }