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