public bool Save(ForumFollowersModel model)
{
if (CheckExisting(model.ID))
{
return(Update(model));
}
else
{
return(Add(model));
}
}
public bool Delete(ForumFollowersModel model)
{
try
{
string sql = string.Format(@"DELETE FROM [dbo].[uSomeForumFollowers] WHERE (forumId='{0}' and userId='{1}')", model.ForumId, model.UserId);
_dataHelper.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
Log.ErrorLog("Error on deleting Forum followers ::" + ex.Message);
return(false);
}
}
private bool Update(ForumFollowersModel model)
{
try
{
string sql = string.Format("UPDATE [dbo].[uSomeForumFollowers] SET [follow] = '{0}' WHERE id='{1}' and forumId ='{1}' and userId ='{2}'", model.Follow, model.ID, model.ForumId, model.UserId);
_dataHelper.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
Log.ErrorLog("Error on updating forum followers ::" + ex.Message);
return(false);
}
}
private bool Add(ForumFollowersModel model)
{
try
{
string sql = string.Format(@"INSERT INTO [dbo].[uSomeForumFollowers] ([forumId] ,[userId]) VALUES ('{0}','{1}')", model.ForumId, model.UserId);
_dataHelper.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
Log.ErrorLog("Error on adding Forum followers ::" + ex.Message);
return(false);
}
}
// GET api/<controller>
public JsonResult AddFollowers(string blogId, string userId, string cmd)
{
var list = new List <ForumFollowersModel>();
var model = new ForumFollowersModel();
model.ForumId = int.Parse(blogId);
model.UserId = int.Parse(userId);
try
{
if (cmd == "follow")
{
new ForumFollowers().Save(model);
model.PostAction = "unfollow";
model.FeedbackMsg = Umbraco.GetDictionaryValue("UnFollowThisBlog");
}
else
{
new ForumFollowers().Delete(model);
model.PostAction = "follow";
model.FeedbackMsg = Umbraco.GetDictionaryValue("FollowThisBlog");
}
var logModel = new LogModel
{
NodeId = model.ForumId,
UserId = model.UserId,
LogHeader = "Forum Post",
LogComment = "Followed Forum",
TableName = "uSomeForumFollowers"
};
new LogHelper().Save(logModel);
}
catch (Exception ex)
{
model.FeedbackMsg = Umbraco.GetDictionaryValue("FollowThisBlog");
Log.ErrorLog("Error in adding followers :: " + ex.Message);
}
list.Add(model);
return(Json(list, JsonRequestBehavior.AllowGet));
}
private IList <ForumFollowersModel> GetBlogFollowers(string sqlText)
{
var followerList = new List <ForumFollowersModel>();
var dr = _dataHelper.ExecuteReader(sqlText);
if (dr.HasRecords)
{
while (dr.Read())
{
var follower = new ForumFollowersModel();
follower.ID = dr.GetInt("ID");
follower.UserId = dr.GetInt("userId");
follower.ForumId = dr.GetInt("forumId");
follower.Follow = dr.GetBoolean("follow");
follower.FollowedDate = dr.GetDateTime("followedDate");
followerList.Add(follower);
}
}
return(followerList);
}
