public bool Save(BlogFollowersModel model)
{
if (CheckExisting(model.ID))
{
return(Update(model));
}
else
{
return(Add(model));
}
}
public bool Delete(BlogFollowersModel model)
{
try
{
string sql = string.Format(@"DELETE FROM [dbo].[uSomeBlogFollowers] WHERE (blogId='{0}' and userId='{1}')", model.BlogId, model.UserId);
_dataHelper.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
Log.ErrorLog("Error on deleting blog followers ::" + ex.Message);
return(false);
}
}
private bool Update(BlogFollowersModel model)
{
try
{
string sql = string.Format("UPDATE [dbo].[uSomeBlogFollowers] SET [follow] = '{0}' WHERE id='{1}' and blogId ='{1}' and userId ='{2}'", model.Follow, model.ID, model.BlogId, model.UserId);
_dataHelper.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
Log.ErrorLog("Error on updating blog followers ::" + ex.Message);
return(false);
}
}
private bool Add(BlogFollowersModel model)
{
try
{
string sql = string.Format(@"INSERT INTO [dbo].[uSomeBlogFollowers] ([blogId] ,[userId]) VALUES ('{0}','{1}')", model.BlogId, model.UserId);
_dataHelper.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
Log.ErrorLog("Error on adding blog followers ::" + ex.Message);
return(false);
}
}
//
// GET: /BlogFollower/
public JsonResult AddFollowers(string blogId, string userId, string cmd)
{
var list = new List <BlogFollowersModel>();
var model = new BlogFollowersModel();
model.BlogId = int.Parse(blogId);
model.UserId = int.Parse(userId);
try
{
if (cmd == "follow")
{
new BlogFollowers().Save(model);
model.PostAction = "unfollow";
model.FeedbackMsg = Umbraco.GetDictionaryValue("UnFollowThisBlog");
}
else
{
new BlogFollowers().Delete(model);
model.PostAction = "follow";
model.FeedbackMsg = Umbraco.GetDictionaryValue("FollowThisBlog");
}
var logModel = new LogModel
{
NodeId = model.BlogId,
UserId = model.UserId,
LogHeader = "Blog Post",
LogComment = "Followed Blog",
TableName = "uSomeBlogFollowers"
};
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 <BlogFollowersModel> GetBlogFollowers(string sqlText)
{
var followerList = new List <BlogFollowersModel>();
var dr = _dataHelper.ExecuteReader(sqlText);
if (dr.HasRecords)
{
while (dr.Read())
{
var follower = new BlogFollowersModel();
follower.ID = dr.GetInt("id");
follower.UserId = dr.GetInt("userId");
follower.BlogId = dr.GetInt("blogId");
follower.Follow = dr.GetBoolean("follow");
follower.FollowedDate = dr.GetDateTime("followedDate");
followerList.Add(follower);
}
}
return(followerList);
}
