public int AddForumReply(tblForumReply obj)
{
int status = 0;
try
{
db.AddParameter("@ForumId", SqlDbType.Int, obj.ForumId);
db.AddParameter("@UserId", SqlDbType.Int, obj.UserId);
db.AddParameter("@ForumReply", SqlDbType.NText, obj.ForumReply);
db.AddParameter("@status", SqlDbType.Int, ParameterDirection.Output);
status = db.ExecuteQuery("sp_ForumReplyAdd");
if (Convert.ToInt32(db.parameters[3].Value) > 0)
{
status = Convert.ToInt32(db.parameters[3].Value);
}
}
catch (Exception ex)
{
newException.AddException(ex);
//throw ex;
status = -2;
}
return(status);
}
public ActionResult ForumReport(int forumId)
{
tblForumReply objForumReply = new tblForumReply();
TblUser sessionUser = (TblUser)Session["UserSession"];
var lstReply = fr.GetForumReplyReportLearner(forumId, sessionUser.UserId);
objForumReply.lstReply = lstReply;
return(View(objForumReply));
}
public ActionResult GetComment(int forumId)
{
tblForumReply objForumReply = new tblForumReply();
TblUser sessionUser = (TblUser)Session["UserSession"];
var lstReply = fr.GetForumReplyForLearner(forumId, sessionUser.UserId);
objForumReply.lstReply = lstReply;
return(PartialView("_CommentList", objForumReply));
}
public int MarkFlagOnForum(ForumFlaggedModel objectModel)
{
int returnValue = -1;
tblFlagComment tblFlagCommentDb = new tblFlagComment();
if (objectModel.ForumMessageType == "topic")
{
tblFlagCommentDb.TopicId = objectModel.AutoId;
}
else
{
tblFlagCommentDb.ReplyId = objectModel.AutoId;
}
tblFlagCommentDb.Message = objectModel.Comment.Trim();
tblFlagCommentDb.CreatedBy = ClientSessionData.UserClientId;
tblFlagCommentDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress;
tblFlagCommentDb.CreatedOn = DateTime.UtcNow;
context.tblFlagComments.Add(tblFlagCommentDb);
int count = context.SaveChanges();
if (count == 1)
{
if (objectModel.ForumMessageType == "topic")
{
tblForum tblForumDb = new tblForum();
tblForumDb = context.tblForums.Where(x => x.TopicId == objectModel.AutoId).FirstOrDefault();
tblForumDb.IsFlagged = true;
context.tblForums.Attach(tblForumDb);
context.Entry(tblForumDb).Property(x => x.IsFlagged).IsModified = true;
count = context.SaveChanges();
if (count == 1)
{
returnValue = 0;
}
}
else if (objectModel.ForumMessageType == "reply")
{
tblForumReply tblForumReplyDb = new tblForumReply();
tblForumReplyDb = context.tblForumReplies.Where(x => x.ReplyId == objectModel.AutoId).FirstOrDefault();
tblForumReplyDb.IsFlagged = true;
context.tblForumReplies.Attach(tblForumReplyDb);
context.Entry(tblForumReplyDb).Property(x => x.IsFlagged).IsModified = true;
count = context.SaveChanges();
if (count == 1)
{
returnValue = 0;
}
}
else
{
returnValue = -2;
}
}
return(returnValue);
}
public ActionResult AddReply(int forumId, string forumReply)
{
TblUser sessionUser = (TblUser)Session["UserSession"];
tblForumReply objForumReply = new tblForumReply();
objForumReply.ForumId = forumId;
objForumReply.UserId = sessionUser.UserId;
objForumReply.ForumReply = forumReply;
var status = fr.AddForumReply(objForumReply);
return(Json("OK", JsonRequestBehavior.AllowGet));
}
public int DeleteForum(ForumFlaggedModelView objectModel)
{
int returnValue = -1;
int count = -1;
if (objectModel.ForumMessageTypeView == "topic")
{
tblForum tblForumDb = new tblForum();
tblForumDb = context.tblForums.Where(x => x.TopicId == objectModel.AutoIdView).FirstOrDefault();
tblForumDb.Status = 2;
context.tblForums.Attach(tblForumDb);
context.Entry(tblForumDb).Property(x => x.Status).IsModified = true;
count = context.SaveChanges();
if (count == 1)
{
returnValue = 0;
}
}
else if (objectModel.ForumMessageTypeView == "reply")
{
tblForumReply tblForumReplyDb = new tblForumReply();
tblForumReplyDb = context.tblForumReplies.Where(x => x.ReplyId == objectModel.AutoIdView).FirstOrDefault();
tblForumReplyDb.Status = 2;
context.tblForumReplies.Attach(tblForumReplyDb);
context.Entry(tblForumReplyDb).Property(x => x.Status).IsModified = true;
count = context.SaveChanges();
if (count == 1)
{
returnValue = 0;
}
}
else
{
returnValue = -2;
}
return(returnValue);
}
