public int EditForum(tblForum obj)
{
int status = 0;
int forumId = 0;
try
{
db.AddParameter("@ForumId", SqlDbType.Int, obj.ForumId);
db.AddParameter("@Title", SqlDbType.Text, obj.Title);
db.AddParameter("@Description", SqlDbType.Text, obj.Description);
db.AddParameter("@ForumType", SqlDbType.Int, obj.ForumType);
db.AddParameter("@IsBrodcast", SqlDbType.Bit, obj.IsBrodcast);
db.AddParameter("@ForumIdOutput", SqlDbType.Int, ParameterDirection.Output);
status = db.ExecuteQuery("sp_ForumUpdate");
if (Convert.ToInt32(db.parameters[5].Value) > 0)
{
forumId = Convert.ToInt32(db.parameters[5].Value);
}
if (forumId > 0)
{
status = forumId;
}
}
catch (Exception ex)
{
newException.AddException(ex);
//throw ex;
status = -2;
}
return(status);
}
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 AddForum(tblForum objForum)
{
try
{
if (ModelState.IsValid)
{
var id = 0;
TblUser sessionUser = (TblUser)Session["UserSession"];
objForum.CreatedBy = sessionUser.UserId;
objForum.TenantId = sessionUser.TenantId;
if (objForum.ForumType == 2)
{
objForum.IsBrodcast = false;
}
if (objForum.ForumId == 0)
{
id = fr.AddForum(objForum);
}
else
{
id = fr.EditForum(objForum);
}
if (id > 0)
{
TempData["Message"] = "1";
}
else
{
TempData["Message"] = "2";
}
//return View("objForum");
}
return(View("AddForum", objForum));
}
catch (Exception ex)
{
TempData["Message"] = "2";
newException.AddException(ex);
return(View("AddForum", objForum));
}
}
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);
}
public ActionResult AddForum()
{
tblForum objForum = new tblForum();
return(View(objForum));
}
