//Task-7: Delete Queries public int DeleteQuery(forum objforum) { objforum = objdb.forums.Find(objforum.questionid); List <int> replyids = objdb.forumreplies.Where(r => r.questionid == objforum.questionid).Select(r => r.replyid).ToList(); try { //if we want to delete query //first we have to delete child table records that is forum replies //later we have to delete parent table query if (replyids != null) { foreach (int rid in replyids) { forumreply objreply = objdb.forumreplies.Find(rid); objdb.forumreplies.Remove(objreply); } } objdb.forums.Remove(objforum); objdb.SaveChanges(); return(1); } catch { return(0); } }
//Task-7: Reply Query public int ReplyQuery(forumreply objfreply) { try { objfreply = objdb.forumreplies.Add(objfreply); objdb.SaveChanges(); return(1); } catch { return(0); } }
public ActionResult ReplyQuery() { if (Request["btnReply"] == "Reply") { forumreply objfreply = new forumreply(); objfreply.replyid = objdb.forumreplies.Select(r => r.replyid).DefaultIfEmpty(0).Max() + 1; objfreply.reply = Request["txtQReply"]; objfreply.questionid = Convert.ToInt32(TempData["questionid"]); objfreply.loginid = (int)Session["loginid"]; ViewData["replyvalue"] = objusermodel.ReplyQuery(objfreply); ViewBag.forums = objusermodel.GetQueries(); return(View("~/Views/User/ViewAllQueries.cshtml")); } else { forum objforum = objdb.forums.Find(int.Parse(Request.QueryString["qid"])); ViewData["SelectedQuery"] = objforum.question; TempData["questionid"] = Request.QueryString["qid"]; return(View()); } }