コード例 #1
0
        public ActionResult PostTopic(long id, long cid, posttopicModel ins)
        {
            posttopicModel topic = new posttopicModel();

            topic.forumcategory = (from s in db.ForumSubCategories
                                   join m in db.Mems on s.memsid equals m.memsid
                                   where s.SubCatId == id
                                   select new forumcat
                                   {
                                       CatID = s.CatId,
                                       SubCatId = s.SubCatId,
                                       SubCatTitle = s.SubCatTitle,
                                       SubCatDesc = s.SubCatDesc,
                                       memsid = m.memsid,
                                       fname = m.fname,
                                       lname = m.lname,
                                       lastupdate = s.UpdatedDate.ToString(),
                                       gimg = m.gimg,
                                       TopicsCount = db.ForumTopics.Where(c => c.SubCatId == s.SubCatId).Count(),
                                       ReplyCount = db.ForumTopicAnswers.Join(db.ForumTopics, f => f.TopicId, o => o.TopicId, (f, o) => new { f.AnsId, o.SubCatId })
                                       .Where(f => f.SubCatId == s.SubCatId).Count()

                                   }).FirstOrDefault();

            long memid = Convert.ToInt32(Request.Cookies["memsid"].Value);
            string fname = Request.Cookies["fname"].Value;

            commonFun rtp = new commonFun();

            if (ModelState.IsValid)
            {
                string topicttl = rtp.ReplaceBadWords(ins.insertTp.topicTitle);
                string topicdesc = rtp.ReplaceBadWords(ins.insertTp.topicDesc);

                int i = db.forumInsertTopic(topicttl, topicdesc, cid, id, memid, fname, memid, System.DateTime.Now, System.DateTime.Now);
                if (i > 0)
                {
                    ViewBag.Success = true;

                    ViewBag.Message = "Topic posted successfully Queued For approval";
                    return View(topic);
                }
                else
                {
                    ViewBag.Success = false;
                    ViewBag.Message = "Unable to Post";
                    return View(topic);
                }

            }
            else
            {
                ViewBag.Success = false;
                ViewBag.Message = "Unable to Post";
                return View(topic);
            }

        }
コード例 #2
0
        public ActionResult PostTopic(long id, long cid)
        {
            posttopicModel topic = new posttopicModel();

            topic.forumcategory = (from s in db.ForumSubCategories
                                   join m in db.Mems on s.memsid equals m.memsid
                                   where s.SubCatId == id
                                   select new forumcat
                                   {
                                       CatID = s.CatId,
                                       SubCatId = s.SubCatId,
                                       SubCatTitle = s.SubCatTitle,
                                       SubCatDesc = s.SubCatDesc,
                                       memsid = m.memsid,
                                       fname = m.fname,
                                       lname = m.lname,
                                       lastupdate = s.UpdatedDate.ToString(),
                                       gimg = m.gimg,
                                       TopicsCount = db.ForumTopics.Where(c => c.SubCatId == s.SubCatId).Count(),
                                       ReplyCount = db.ForumTopicAnswers.Join(db.ForumTopics, f => f.TopicId, o => o.TopicId, (f, o) => new { f.AnsId, o.SubCatId })
                                       .Where(f => f.SubCatId == s.SubCatId).Count()

                                   }).FirstOrDefault();
            return View(topic);
        }