public CommentResult InsertComment(Comment comment) { CommentResult cr = new CommentResult(); CommentsTableAdapter adapter = new CommentsTableAdapter(); comment.date = DateTime.UtcNow; Object obj = adapter.InsertComment(comment.messageID, comment.userID, comment.body, comment.date, comment.isPrivate); if (obj != null) { System.Web.HttpRuntime.Cache.Remove("Comments"); System.Web.HttpRuntime.Cache.Remove("Messages"); cr.Id = Convert.ToInt32(obj); cr.Key = Encrypt(cr.Id.ToString() + ".fgG43$#", true).Replace('+', '$'); ; } return cr; }
public List<Comment> GetCommentsByMessageID(int msgId, int userId, int timeZone = 0, int top = 0) { List<Comment> comments = new List<Comment>(); CommentsTableAdapter adapter = new CommentsTableAdapter(); PostAroundMeDataSet.CommentsDataTable dt = new PostAroundMeDataSet.CommentsDataTable(); dt = adapter.GetCommentsByMessageID(msgId); comments = CommentsDtToList(dt, userId, timeZone); if (top > 0) { comments = comments.OrderByDescending(m => m.date).ToList().Take(top).OrderBy(m => m.date).ToList(); } return comments; }
public List<Comment> GetAllComments(int userId, int timeZone = 0) { List<Comment> comments = new List<Comment>(); CommentsTableAdapter adapter = new CommentsTableAdapter(); PostAroundMeDataSet.CommentsDataTable dt = new PostAroundMeDataSet.CommentsDataTable(); if (System.Web.HttpRuntime.Cache["Comments"] == null) { dt = adapter.GetData(); System.Web.HttpRuntime.Cache.Insert("Comments", dt, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(10)); } else { dt = System.Web.HttpRuntime.Cache["Comments"] as PostAroundMeDataSet.CommentsDataTable; } comments = CommentsDtToList(dt, userId, timeZone); return comments; }
public Comment GetCommentByID(int id) { Comment comment = new Comment(); CommentsTableAdapter adapter = new CommentsTableAdapter(); PostAroundMeDataSet.CommentsDataTable dt = new PostAroundMeDataSet.CommentsDataTable(); dt = adapter.GetCommentByID(id); PostAroundMeDataSet.CommentsRow dr = dt.FirstOrDefault(); comment = CommentTranslator(dr); return comment; }
public int DeleteComment(int commentId, int userid) { Object obj; int res = 0; CommentsTableAdapter commentsAdapter = new CommentsTableAdapter(); obj = commentsAdapter.DeleteCommentByID(commentId, userid); if (obj != null) { res = Convert.ToInt32(obj); System.Web.HttpRuntime.Cache.Remove("Comments"); } return res; }