public ActionResult Create(int id) { Topic topic = entVote.Topics.Find(id); ViewBag.TopicTitle = topic.Topic1; ViewBag.TopicID = id.ToString(); //ViewBag.TopicID = new SelectList(entVote.Topics, "TopicID", "Topic1"); // If user is logged in, get UserID and set it to ViewBag to pass to the View. if (User.Identity.IsAuthenticated) { var userName = User.Identity.Name; Identity ident = new Identity(); var userID = ident.GetUserID(userName); ViewBag.UserID = userID.ToString(); } else { ViewBag.UserID = "0"; } return View(); }
public ActionResult Create([Bind(Include="TopicID,Topic1,TopicURL,Search,Tags,CategoryID,UserId,TimeStamp")] Topic topic) { if (ModelState.IsValid) { // If user is logged in, get UserID. To get to this point, user must be logged in. if (User.Identity.IsAuthenticated) { var userName = User.Identity.Name; Identity ident = new Identity(); topic.UserId = ident.GetUserID(userName); } else { topic.UserId = 0; } SearchTools st = new SearchTools(); topic.TopicURL = st.CreateSearchURL(topic.Topic1); topic.TimeStamp = DateTime.Now; entVote.Topics.Add(topic); entVote.SaveChanges(); return RedirectToAction("Index"); } ViewBag.CategoryID = new SelectList(entVote.CategoryLists, "CategoryID", "Category", topic.CategoryID); return View(topic); }
public ActionResult TopicAnswers(int id) { // Get topic title for id. var topicTitle = (from t in entVote.Topics where t.TopicID == id select t.Topic1).FirstOrDefault(); ViewBag.TopicTitle = topicTitle; ViewBag.TopicID = id; // Get base URL (e.g., http://www.eusVille.com) ViewBag.BaseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/"; // Get top 8 answers for topic based on TopicID. // listAnswers = (from a in entVote.Answers // where a.TopicID == id // orderby a.RatingScore descending // select new {a.UserID, a.AnswerID, a.Detail, a.RatingScore}).Take(8); //var answers = (from a in entVote.Answers // where a.TopicID == id // orderby a.RatingScore descending // select a).Take(8); //ViewBag.Count = answers.Count(); // If user is logged in, get UserID and set it to ViewBag to pass to the View. var userID = 0; if (User.Identity.IsAuthenticated) { var userName = User.Identity.Name; Identity ident = new Identity(); userID = (int)ident.GetUserID(userName); } ViewBag.UserID = userID.ToString(); //else //{ // ViewBag.UserID = "0"; //} //List<webUI.Models.GetTopicAnswers_Result> topicAnswersList = new List<webUI.Models.GetTopicAnswers_Result>(); var answers = entVote.GetTopicAnswers(id, userID).ToList(); //topicAnswersList.Add(answers); return View(answers); }
public string TopicGet(string Filter, string FilterData) { string jsonReturn = ""; try { switch (Filter) { case "AnswersGet": { int topicID = Convert.ToInt32(FilterData); // Get topic title for id. var topicTitle = (from t in entVote.Topics where t.TopicID == topicID select t.Topic1).FirstOrDefault(); ViewBag.TopicTitle = topicTitle; ViewBag.TopicID = topicID; // Get top 8 answers for topic based on TopicID. //var answers = (from o in entVote.Answers // where o.TopicID == topicID // orderby o.RatingScore descending // select o).Take(8); // If user is logged in, get UserID and set it to ViewBag to pass to the View. var userID = 0; if (User.Identity.IsAuthenticated) { var userName = User.Identity.Name; Identity ident = new Identity(); userID = (int)ident.GetUserID(userName); ViewBag.UserID = userID.ToString(); } else { ViewBag.UserID = "0"; } var answers = entVote.GetTopicAnswers(topicID, userID).ToList(); ViewBag.Count = answers.Count(); jsonReturn = JsonConvert.SerializeObject(answers, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); break; } case "CommentsGet": { int answerID = Convert.ToInt32(FilterData); using (eusVoteEntities entVote = new eusVoteEntities()) { var comments = (from c in entVote.Comments where c.AnswerID == answerID select c).Take(5).ToArray(); jsonReturn = JsonConvert.SerializeObject(comments, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); } break; } default: { break; } } } catch (Exception ex) { var seriesContent = new Dictionary<string, string> { {"user" , "test"}, {"detail", ex.ToString()}, {"action", Filter}, {"errorLocation", "eusVote > TopicController > Topic > Get > " + Filter} , {"level", "high"} }; jsonReturn = JsonConvert.SerializeObject(seriesContent); // Log error CommonController cont = new CommonController(); cont.Common("ErrorHandle", jsonReturn); return jsonReturn; } return jsonReturn; }
// GET: eusVote/Home - Get a list of trending topics public ActionResult Index() { // If user is logged in, get UserID and set it to ViewBag to pass to the View. var userID = 0; if (User.Identity.IsAuthenticated) { var userName = User.Identity.Name; Identity ident = new Identity(); userID = (int)ident.GetUserID(userName); } ViewBag.UserID = userID.ToString(); var topics = db.Topics.Include(t => t.CategoryList); return View(topics.ToList()); }