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