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