public async Task LikeComment(string applicationUserIdCurrent, int commentId) { var applicationUser = repositoryOfApplicationUser.Read(a => a.Id == applicationUserIdCurrent); if (await serviceOfUser.GetUserPriority(applicationUser) >= 1) { var commentLike = new CommentLikeEntity() { CommentId = commentId, UserProfileId = applicationUser.UserProfileId }; var commentLikeEntity = repositoryOfCommentLike.Create(commentLike); } }
/// <summary> /// 评论点赞插入 /// </summary> /// <param name="entity"></param> /// <returns></returns> public OperationResult <ReplyCommonEntity> CommentsLike_Insert(CommentLikeEntity entity) { try { ReplyCommonEntity rcEntity = new ReplyCommonEntity(); using (SqlConnection con = new SqlConnection(SQlHelper.MyConnectStr)) { SqlTransaction trans = null; con.Open(); trans = con.BeginTransaction(); SqlParameter[] prms = { new SqlParameter("@CommentID", entity.CommentID), new SqlParameter("@UserID", entity.UserID), new SqlParameter("@LikeCnt", entity.LikeCnt), new SqlParameter("@LikeTime", entity.LikeTime == null ? DateTime.Now :entity.LikeTime) }; SqlParameter[] commPrms = { new SqlParameter("@CommentID", entity.CommentID), new SqlParameter("@UserID", entity.UserID) }; int state = SQlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "M_Comments_Like_Insert", prms); trans.Commit(); DataTable table = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "M_ReplyCommon_Get", commPrms).Tables[0]; if (table != null && table.Rows.Count != 0) { rcEntity = ConvertDataTable <ReplyCommonEntity> .ConvertToList(table)[0]; } if (state > 0) { return(new OperationResult <ReplyCommonEntity>(OperationResultType.Success, "评论点赞成功!", rcEntity)); } else { return(new OperationResult <ReplyCommonEntity>(OperationResultType.NoChanged, "您已点过赞了!", rcEntity)); } } } catch (Exception ex) { LogUtil.WriteLog(ex); return(new OperationResult <ReplyCommonEntity>(OperationResultType.NoConnection, Description.EnumDescription(OperationResultType.NoConnection))); } }
public void Like(int commentId, int userId) { if (_commentLikeRepository.Table.Any(x => x.CommentLikeCommentIdFk == commentId && x.CommentLikeUserIdFk == userId)) { throw new CommentAlreadyLikedException(); } var like = new CommentLikeEntity { CommentLikeCommentIdFk = commentId, CommentLikeUserIdFk = userId, CommentLikeCreatedAt = DateTime.Now }; _commentLikeRepository.Insert(like); _commentLikeRepository.SaveAll(); }
public ArticleModules() : base("/Article") { #region 添加评论 Post["AddReviews"] = _ => { try { EventItemCommentEntity entity = new EventItemCommentEntity(); dynamic data = FetchFormData(); string contents = data.Contents; int eventItemID = data.EventItemID; bool isAnon = data.IsAnon;//是否匿名 entity.CommentContent = contents; entity.EventItemID = eventItemID; entity.IsAnonymous = isAnon; entity.UserID = CurrentUser.UserID; entity.ViewStateID = 1; if (contents == null) { return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = (int)OperationResultType.Error, Msg = "评论内容不能为空!", Value = new ReviewCommonEntity() })); } else if (contents.Length > 1000) { return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = (int)OperationResultType.Error, Msg = "评论内容过长!", Value = new ReviewCommonEntity() })); } OperationResult <ReviewCommonEntity> result = BCtrl_Article.Instance.ArticleComments_Insert(entity); return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = (int)result.ResultType, Msg = result.Message, Value = result.AppendData })); } catch (Exception ex) { LogUtil.WriteLog(ex); return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = 0, Msg = "数据提交不完全", Value = new ReviewCommonEntity() })); } }; #endregion #region 给文章点赞 Get["ClickLikeArticle"] = _ => { try { EventItemLikeEntity entity = new EventItemLikeEntity(); dynamic data = FecthQueryData(); int eventItemID = data.EventItemID; entity.EventItemID = eventItemID; entity.UserID = CurrentUser.UserID; entity.LikeCnt = 1; OperationResult <ReviewCommonEntity> result = BCtrl_Article.Instance.ArticleLike_Insert(entity); return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = (int)result.ResultType, Msg = result.Message, Value = result.AppendData })); } catch (Exception ex) { LogUtil.WriteLog(ex); return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = 0, Msg = "数据提交不完全", Value = new ReviewCommonEntity() })); } }; #endregion #region 回复列表 Get["ReplyList"] = _ => { try { dynamic data = FecthQueryData(); int reviewsId = data.ReviewsId; int replyId = data.ReplyId; bool isHeader = data.IsHeader; int userid = CurrentUser.UserID; int pageSize = data.PageSize == null ? 20 : data.PageSize; int pageIndex = data.PageIndex == null ? 1 : data.PageIndex; if (pageSize > 50) { pageSize = 50; } OperationResult <ReplyHeaderEntity> harder = null; if (isHeader)//是否返回回复头信息 { harder = BCtrl_Article.Instance.ArticleReplyHeader_Get(reviewsId, userid); } //回复列表 OperationResult <List <EventItemReplyEntity> > result = BCtrl_Article.Instance.ArticleReply_GetList(reviewsId, replyId, pageIndex, pageSize); if (result.ResultType == OperationResultType.Success) { var jsonBase = new JsonMessageBase <ReplyHeaderEntity, List <EventItemReplyEntity> >(); jsonBase.Status = 1; jsonBase.Msg = "回复抓取完成!"; jsonBase.Value = harder == null ? null : harder.AppendData; jsonBase.Value2 = result == null ?null : result.AppendData; return(JsonObj <JsonMessageBase <ReplyHeaderEntity, List <EventItemReplyEntity> > > .ToJson(jsonBase)); } else { var jsonBase = new JsonMessageBase <ReplyHeaderEntity, List <EventItemReplyEntity> >(); jsonBase.Status = 0; jsonBase.Msg = "回复数据抓取异常!"; jsonBase.Value = harder == null ? null : harder.AppendData; jsonBase.Value2 = result == null ? null : result.AppendData; return(JsonObj <JsonMessageBase <ReplyHeaderEntity, List <EventItemReplyEntity> > > .ToJson(jsonBase)); } } catch (Exception ex) { LogUtil.WriteLog(ex); return(JsonObj <JsonMessageBase> .ToJson(new JsonMessageBase() { Status = 0, Msg = "数据提交不完全" })); } }; #endregion #region 添加回复 Post["AddReply"] = _ => { try { EventItemReplyEntity entity = new EventItemReplyEntity(); dynamic data = FetchFormData(); string contents = data.Contents; int rid = data.ReviewsId; int toReplyID = data.ToReplyID; bool isAnon = data.IsAnon; entity.ReplyContent = contents; entity.CommentID = rid; entity.ReplyParentID = toReplyID; entity.IsAnonymous = isAnon; entity.ViewStateID = 1; entity.UserID = CurrentUser.UserID; if (contents == null) { return(JsonObj <JsonMessageBase <AddReplyCommonEntity> > .ToJson(new JsonMessageBase <AddReplyCommonEntity>() { Status = (int)OperationResultType.Error, Msg = "评论内容不能为空!", Value = new AddReplyCommonEntity() })); } else if (contents.Length > 1000) { return(JsonObj <JsonMessageBase <AddReplyCommonEntity> > .ToJson(new JsonMessageBase <AddReplyCommonEntity>() { Status = (int)OperationResultType.Error, Msg = "评论内容过长!", Value = new AddReplyCommonEntity() })); } OperationResult <AddReplyCommonEntity> result = BCtrl_Article.Instance.ArticleReply_Insert(entity); return(JsonObj <JsonMessageBase <AddReplyCommonEntity> > .ToJson(new JsonMessageBase <AddReplyCommonEntity>() { Status = (int)result.ResultType, Msg = result.Message, Value = result.AppendData })); } catch (Exception ex) { LogUtil.WriteLog(ex); return(JsonObj <JsonMessageBase <AddReplyCommonEntity> > .ToJson(new JsonMessageBase <AddReplyCommonEntity>() { Status = 0, Msg = "数据提交不完全", Value = new AddReplyCommonEntity() })); } }; #endregion #region 给评论点赞 Get["ClickLikeReview"] = _ => { try { CommentLikeEntity entity = new CommentLikeEntity(); dynamic data = FecthQueryData(); int rid = data.ReviewsId; entity.CommentID = rid; entity.UserID = CurrentUser.UserID; entity.LikeCnt = 1; OperationResult <ReplyCommonEntity> result = BCtrl_Article.Instance.CommentsLike_Insert(entity); return(JsonObj <JsonMessageBase <ReplyCommonEntity> > .ToJson(new JsonMessageBase <ReplyCommonEntity>() { Status = (int)result.ResultType, Msg = result.Message, Value = result.AppendData })); } catch (Exception ex) { LogUtil.WriteLog(ex); return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = 0, Msg = "数据提交不完全", Value = new ReviewCommonEntity() })); } }; #endregion #region 无用户下的 文章点赞数及评论数 Get["ArticleCommon"] = _ => { try { EventItemCommentEntity entity = new EventItemCommentEntity(); dynamic data = FecthQueryData(); int eid = data.EventItemID; entity.EventItemID = eid; entity.UserID = CurrentUser == null ? 0: CurrentUser.UserID; OperationResult <ReviewCommonEntity> result = BCtrl_Article.Instance.ReviewCommon_Get(entity); return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = (int)result.ResultType, Msg = result.Message, Value = result.AppendData })); } catch (Exception ex) { LogUtil.WriteLog(ex); return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = 0, Msg = "数据提交不完全", Value = new ReviewCommonEntity() })); } }; #endregion #region 用户下的 文章点赞数及评论数 Get["UserArticleCommon"] = _ => { try { EventItemCommentEntity entity = new EventItemCommentEntity(); dynamic data = FecthQueryData(); int eid = data.EventItemID; entity.EventItemID = eid; entity.UserID = CurrentUser == null ? 0 : CurrentUser.UserID; OperationResult <ReviewCommonEntity> result = BCtrl_Article.Instance.ReviewCommon_Get(entity); return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = (int)result.ResultType, Msg = result.Message, Value = result.AppendData })); } catch (Exception ex) { LogUtil.WriteLog(ex); return(JsonObj <JsonMessageBase <ReviewCommonEntity> > .ToJson(new JsonMessageBase <ReviewCommonEntity>() { Status = 0, Msg = "数据提交不完全", Value = new ReviewCommonEntity() })); } }; #endregion #region 2016-01-05 重构文章列表 Post["List"] = _ => { try { dynamic data = FetchFormData(); int aid = data.ArticleId; int pagesize = 10; int pageno = 1; if (data != null) { pagesize = data.pagesize == null ? 10 : data.pagesize; pageno = data.pageno == null ? 1 : data.pageno; } if (pagesize > 50) { pagesize = 50; } BCtrl_EventItem eventitemobj = new BCtrl_EventItem(); List <EventItemGroupEntity> lists = eventitemobj.QueryAllEventItemGroups(pageno, pagesize); OperationResult <dynamic> result = new OperationResult <dynamic>(OperationResultType.Success, "OK"); return(JsonObj <JsonMessageBase <object> > .ToJson(new JsonMessageBase <object>() { Status = (int)result.ResultType, Msg = result.Message, Value = new PictureServerEntity() })); } catch (Exception ex) { LogUtil.WriteLog(ex); return(JsonObj <JsonMessageBase> .ToJson(new JsonMessageBase() { Status = 0, Msg = "数据提交不完全" })); } }; #endregion #region 评论举报 Post["Report"] = _ => { try { dynamic data = FetchFormData(); int reportInfoTypeID = data.TagType; int reportInfoID = data.Tag; int userId = CurrentUser.UserID; ReportEntity entity = new ReportEntity(); entity.ReportInfoTypeID = reportInfoTypeID; entity.ReportInfoID = reportInfoID; entity.FromUserID = userId; entity.ReportTypeID = 1; //举报类型 OperationResult <bool> result = BCtrl_Article.Instance.Report_Insert(entity); return(JsonObj <JsonMessageBase <bool> > .ToJson(new JsonMessageBase <bool>() { Status = (int)result.ResultType, Msg = result.Message, Value = result.AppendData })); } catch (Exception ex) { LogUtil.WriteLog(ex); return(JsonObj <JsonMessageBase <bool> > .ToJson(new JsonMessageBase <bool>() { Status = 0, Msg = "数据提交不完全", Value = false })); } }; #endregion }
public OperationResult <ReplyCommonEntity> CommentsLike_Insert(CommentLikeEntity entity) { return(dao.CommentsLike_Insert(entity)); }