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