public ActionResult displayQuestionwithAnswers() { var paramQuesID = new SqlParameter("@QuestionID", SqlDbType.Int); var paramRepCnt = new SqlParameter("@viewcount", SqlDbType.Int); int quesID = Convert.ToInt16(Request.QueryString["QuestionID"].ToString()); paramQuesID.Value = quesID; var viewcount = db.tblQuestions.Where(e1 => e1.QuestionID == quesID).FirstOrDefault(); vwcnt = viewcount.viewCount; if (vwcnt == 0) { vwcnt++; paramRepCnt.Value = vwcnt; var v = db.ExecuteStoreCommand("UPDATE tblQuestions SET viewCount = @viewcount WHERE QuestionID = @QuestionID", paramRepCnt, paramQuesID); } else { vwcnt = vwcnt + 1; paramRepCnt.Value = vwcnt; var v = db.ExecuteStoreCommand("UPDATE tblQuestions SET viewCount = @viewcount WHERE QuestionID = @QuestionID", paramRepCnt, paramQuesID); } List <mvcForumapp.Questionwithreplys_Result> disp = db.Questionwithreplys(quesID).ToList(); return(View(disp)); }
public ActionResult PostReply(mvcForumapp.Models.Replys reply) { int repcnt = 0; int quesID = 0; int techID = 0; if (ModelState.IsValid) { using (var db = new newForumDBEntities()) { quesID = Convert.ToInt16(Request.QueryString["QuestionID"].ToString()); techID = Convert.ToInt16(Request.QueryString["TechID"].ToString()); var postrep = db.tblReplies.CreateObject(); postrep.TechID = Convert.ToInt16(Request.QueryString["TechID"].ToString()); postrep.QuestionID = Convert.ToInt16(Request.QueryString["QuestionID"].ToString()); postrep.date = DateTime.Now; postrep.ReplyMsg = reply.ReplyContent; postrep.UserName = Session["UserName"].ToString(); db.tblReplies.AddObject(postrep); db.SaveChanges(); var paramQuesID = new SqlParameter("@QuestionID", SqlDbType.Int); var paramRepCnt = new SqlParameter("@Repcount", SqlDbType.Int); paramQuesID.Value = quesID; var repcount = db.tblQuestions.Where(e1 => e1.QuestionID == quesID).FirstOrDefault(); repcnt = repcount.ReplyCount; if (repcnt == 0) { repcnt++; paramRepCnt.Value = repcnt; var v = db.ExecuteStoreCommand("UPDATE tblQuestions SET ReplyCount = @Repcount WHERE QuestionID = @QuestionID", paramRepCnt, paramQuesID); } else { repcnt = repcnt + 1; paramRepCnt.Value = repcnt; var v = db.ExecuteStoreCommand("UPDATE tblQuestions SET ReplyCount = @Repcount WHERE QuestionID = @QuestionID", paramRepCnt, paramQuesID); } return(RedirectToAction("displayQuestionwithAnswers", "Question_Answer", new { QuestionID = quesID })); } } return(View(reply)); }
public ActionResult PostReply(mvcForumapp.Models.Replys reply) { int repcnt = 0; int quesID = 0; int techID = 0; if (ModelState.IsValid) { using (var db = new newForumDBEntities()) { quesID = Convert.ToInt16(Request.QueryString["QuestionID"].ToString()); techID = Convert.ToInt16(Request.QueryString["TechID"].ToString()); var postrep = db.tblReplies.CreateObject(); postrep.TechID = Convert.ToInt16(Request.QueryString["TechID"].ToString()); postrep.QuestionID = Convert.ToInt16(Request.QueryString["QuestionID"].ToString()); postrep.date = DateTime.Now; postrep.ReplyMsg = reply.ReplyContent; postrep.UserName = Session["UserName"].ToString(); db.tblReplies.AddObject(postrep); db.SaveChanges(); var paramQuesID = new SqlParameter("@QuestionID", SqlDbType.Int); var paramRepCnt = new SqlParameter("@Repcount", SqlDbType.Int); paramQuesID.Value = quesID; var repcount = db.tblQuestions.Where(e1 => e1.QuestionID == quesID).FirstOrDefault(); repcnt = repcount.ReplyCount; if (repcnt == 0) { repcnt++; paramRepCnt.Value = repcnt; var v = db.ExecuteStoreCommand("UPDATE tblQuestions SET ReplyCount = @Repcount WHERE QuestionID = @QuestionID", paramRepCnt, paramQuesID); } else { repcnt = repcnt + 1; paramRepCnt.Value = repcnt; var v = db.ExecuteStoreCommand("UPDATE tblQuestions SET ReplyCount = @Repcount WHERE QuestionID = @QuestionID", paramRepCnt, paramQuesID); } return RedirectToAction("displayQuestionwithAnswers", "Question_Answer", new { QuestionID = quesID }); } } return View(reply); }