/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <CommentEntity> GetCommentAll() { string sql = @"SELECT [Id],[ProductId], [OrderCode],[OrderDetailId],[ProductName],[ProductStar],[SeviceStar],[TrafficStar],[CommentContent],[ClientType],[HasPic],[IpAddress],[MemId],[CreateTime],[Status],[CheckManId],[CheckTime],[ReplyContent] from dbo.[Comment] WITH(NOLOCK) "; IList <CommentEntity> entityList = new List <CommentEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { CommentEntity entity = new CommentEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ProductId = StringUtils.GetDbInt(reader["ProductId"]); entity.OrderCode = StringUtils.GetDbLong(reader["OrderCode"]); entity.OrderDetailId = StringUtils.GetDbInt(reader["OrderDetailId"]); entity.ProductName = StringUtils.GetDbString(reader["ProductName"]); entity.ProductStar = StringUtils.GetDbInt(reader["ProductStar"]); entity.SeviceStar = StringUtils.GetDbInt(reader["SeviceStar"]); entity.TrafficStar = StringUtils.GetDbInt(reader["TrafficStar"]); entity.CommentContent = StringUtils.GetDbString(reader["CommentContent"]); entity.ClientType = StringUtils.GetDbInt(reader["ClientType"]); entity.HasPic = StringUtils.GetDbInt(reader["HasPic"]); entity.IpAddress = StringUtils.GetDbString(reader["IpAddress"]); entity.MemId = StringUtils.GetDbInt(reader["MemId"]); entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.CheckManId = StringUtils.GetDbInt(reader["CheckManId"]); entity.CheckTime = StringUtils.GetDbDateTime(reader["CheckTime"]); entity.ReplyContent = StringUtils.GetDbString(reader["ReplyContent"]); entityList.Add(entity); } } return(entityList); }
/// <summary> /// 判断当前节点是否已存在相同的 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int ExistNum(CommentEntity entity) { ///id=0,判断总数,ID>0判断除自己之外的总数 string sql = @"Select count(1) from dbo.[Comment] WITH(NOLOCK) "; string where = "where "; if (entity.Id == 0) { where = where + "[ProductId]=@ProductId";//即针对一个Id一个StyleId只能有一条评论 } else { where = where + "[Id]<>@Id and [ProductId]=@ProductId"; } sql = sql + where; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@ProductId", DbType.Int32, entity.ProductId); if (entity.Id > 0) { db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); } object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <summary> /// 插入一条记录到表Comment,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="comment">待插入的实体对象</param> public int AddComment(CommentEntity entity) { string sql = @"insert into Comment( [ProductId], [OrderCode],[OrderDetailId],[ProductName],[ProductStar],[SeviceStar],[TrafficStar],[CommentContent],[ClientType],[HasPic],[IpAddress],[MemId],[CreateTime],[Status],[CheckManId],[CheckTime],[ReplyContent])VALUES ( @ProductId, @OrderCode,@OrderDetailId,@ProductName,@ProductStar,@SeviceStar,@TrafficStar,@CommentContent,@ClientType,@HasPic,@IpAddress,@MemId,@CreateTime,@Status,@CheckManId,@CheckTime,@ReplyContent); SELECT SCOPE_IDENTITY();" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@ProductId", DbType.Int32, entity.ProductId); db.AddInParameter(cmd, "@OrderCode", DbType.String, entity.OrderCode); db.AddInParameter(cmd, "@OrderDetailId", DbType.Int32, entity.OrderDetailId); db.AddInParameter(cmd, "@ProductName", DbType.String, entity.ProductName); db.AddInParameter(cmd, "@ProductStar", DbType.Int32, entity.ProductStar); db.AddInParameter(cmd, "@SeviceStar", DbType.Int32, entity.SeviceStar); db.AddInParameter(cmd, "@TrafficStar", DbType.Int32, entity.TrafficStar); db.AddInParameter(cmd, "@CommentContent", DbType.String, entity.CommentContent); db.AddInParameter(cmd, "@ClientType", DbType.Int32, entity.ClientType); db.AddInParameter(cmd, "@HasPic", DbType.Int32, entity.HasPic); db.AddInParameter(cmd, "@IpAddress", DbType.String, entity.IpAddress); db.AddInParameter(cmd, "@MemId", DbType.Int32, entity.MemId); db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, entity.CreateTime); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); db.AddInParameter(cmd, "@CheckManId", DbType.Int32, entity.CheckManId); db.AddInParameter(cmd, "@CheckTime", DbType.DateTime, entity.CheckTime); db.AddInParameter(cmd, "@ReplyContent", DbType.String, entity.ReplyContent); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
public async Task <ActionResult <CommentEntity> > PostCommentEntity(CommentEntity commentEntity) { _context.Comments.Add(commentEntity); await _context.SaveChangesAsync(); return(CreatedAtAction("GetCommentEntity", new { id = commentEntity.Id }, commentEntity)); }
public Commentary ToComment(CommentEntity commentEntity) { User maker = usersMapper.ToUser(commentEntity.Maker, new List <TeamEntity>()); Commentary conversion = new Commentary(commentEntity.Id, commentEntity.Text, maker); return(conversion); }
/// <summary> /// 添加评论确定按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void submit_Click(object sender, EventArgs e) { DataBase db = new DataBase(); CommentEntity ce = new CommentEntity(); ce.Agree = 0; ce.nid = int.Parse(Request.QueryString["nid"].ToString()); ce.DisAgree = 0; ce.CommentTitle = ""; ce.ConText = tb_comment.Text; ce.uid = int.Parse(Session["uid"].ToString()); ce.UpTime = DateTime.Now; if (ce.ConText == "") { Response.Write("请填写评论内容!"); return; } if (CommentOperation.AddComment(ce)) { Response.Redirect("LoadComment.aspx?nid=" + ce.nid ); return; } else { Response.Write("添加评论失败"); } }
protected void AddReview_Click(object sender, EventArgs e) { TextBox ReviewTitleTextBox = null; TextBox ReviewTextBox = null; RadioButtonList ReviewRateRadioButtonList = null; foreach (RepeaterItem item in ProductRepeater.Items) { ReviewTitleTextBox = (TextBox)item.FindControl("ReviewTitleTextBox"); ReviewTextBox = (TextBox)item.FindControl("ReviewTextBox") ; ReviewRateRadioButtonList = (RadioButtonList)item.FindControl("ReviewRateRadioButtonList"); } CommentEntity comment = new CommentEntity(); comment.ProductId = Convert.ToInt32(ViewState["ProductId"]); comment.Title = ReviewTitleTextBox.Text; comment.Content = ReviewTextBox.Text; comment.RateId = GetRateIdByRadioButtonListSelection(Convert.ToInt32(ReviewRateRadioButtonList.SelectedValue)); comment.Status = false; comment.Save(); LoadData(); }
public ActionResult GetCommentsList(CommentListViewModel model) { if (ModelState.IsValid) { UserEntity currentUser = _userService.GetUserByEmail(User.Identity.Name); CommentEntity newComment = new CommentEntity { LotId = model.LotId, Text = model.Text, Date = DateTime.Now, UserId = currentUser.Id }; _commentService.CreateComment(newComment); if (!Request.IsAjaxRequest()) { return(RedirectToAction("LotDetails", new { id = model.LotId })); } else { model.Comments = _commentService.GetAllCommentEntitiesByLotId(model.LotId).Select(c => c.ToMvcComment()).OrderBy(c => c.Date); return(PartialView(model)); } } if (!Request.IsAjaxRequest()) { return(RedirectToAction("LotDetails", new { id = model.LotId })); } else { model.Comments = _commentService.GetAllCommentEntitiesByLotId(model.LotId).Select(c => c.ToMvcComment()).OrderBy(c => c.Date); return(PartialView(model)); } }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static CommentEntity GetEntityFromrdr(NullableDataReader rdr) { CommentEntity info = new CommentEntity(); info.CommentID = rdr.GetInt32("CommentID"); info.GeneralID = rdr.GetInt32("GeneralID"); info.NodeID = rdr.GetInt32("NodeID"); info.TopicID = rdr.GetInt32("TopicID"); info.CommentTitle = rdr.GetString("CommentTitle"); info.Email = rdr.GetString("Email"); info.Content = rdr.GetString("Content"); info.Face = rdr.GetString("Face"); info.UpdateDateTime = rdr.GetNullableDateTime("UpdateDateTime"); info.Position = rdr.GetInt32("Position"); info.IsPassed = rdr.GetBoolean("IsPassed"); info.Agree = rdr.GetInt32("Agree"); info.Oppose = rdr.GetInt32("Oppose"); info.Neutral = rdr.GetInt32("Neutral"); info.Score = rdr.GetInt32("Score"); info.IP = rdr.GetString("IP"); info.IsElite = rdr.GetBoolean("IsElite"); info.IsPrivate = rdr.GetBoolean("IsPrivate"); info.UserName = rdr.GetString("UserName"); info.Reply = rdr.GetString("Reply"); info.ReplyAdmin = rdr.GetString("ReplyAdmin"); info.ReplyDatetime = rdr.GetNullableDateTime("ReplyDatetime"); info.ReplyIsPrivate = rdr.GetBoolean("ReplyIsPrivate"); info.ReplyUserName = rdr.GetString("ReplyUserName"); return(info); }
/// <summary> /// 更新一条记录(异步方式) /// </summary> /// <param name="entity">实体模型</param> /// <returns></returns> public virtual async Task <bool> UpdateAsync(CommentEntity entity) { Dictionary <string, object> dict = new Dictionary <string, object>(); GetParameters(entity, dict); string strSQL = "Update Comment SET " + "GeneralID = @GeneralID," + "NodeID = @NodeID," + "TopicID = @TopicID," + "CommentTitle = @CommentTitle," + "Email = @Email," + "Content = @Content," + "Face = @Face," + "UpdateDateTime = @UpdateDateTime," + "Position = @Position," + "IsPassed = @IsPassed," + "Agree = @Agree," + "Oppose = @Oppose," + "Neutral = @Neutral," + "Score = @Score," + "IP = @IP," + "IsElite = @IsElite," + "IsPrivate = @IsPrivate," + "UserName = @UserName," + "Reply = @Reply," + "ReplyAdmin = @ReplyAdmin," + "ReplyDatetime = @ReplyDatetime," + "ReplyIsPrivate = @ReplyIsPrivate," + "ReplyUserName = @ReplyUserName" + " WHERE " + "CommentID = @CommentID"; return(await Task.Run(() => _DB.ExeSQLResult(strSQL, dict))); }
public static CommentEntity CommentImageDTO_To_CommentEntity(CommentImageDTO commentImageDTO) { var mapper = new MapperConfiguration(cfg => cfg.CreateMap <CommentImageDTO, CommentEntity>()).CreateMapper(); CommentEntity commentEntity = mapper.Map <CommentImageDTO, CommentEntity>(commentImageDTO); return(commentEntity); }
/// <summary> /// 把实体类转换成键/值对集合 /// </summary> /// <param name="entity"></param> /// <param name="dict"></param> private static void GetParameters(CommentEntity entity, Dictionary <string, object> dict) { dict.Add("CommentID", entity.CommentID); dict.Add("GeneralID", entity.GeneralID); dict.Add("NodeID", entity.NodeID); dict.Add("TopicID", entity.TopicID); dict.Add("CommentTitle", entity.CommentTitle); dict.Add("Email", entity.Email); dict.Add("Content", entity.Content); dict.Add("Face", entity.Face); dict.Add("UpdateDateTime", entity.UpdateDateTime); dict.Add("Position", entity.Position); dict.Add("IsPassed", entity.IsPassed); dict.Add("Agree", entity.Agree); dict.Add("Oppose", entity.Oppose); dict.Add("Neutral", entity.Neutral); dict.Add("Score", entity.Score); dict.Add("IP", entity.IP); dict.Add("IsElite", entity.IsElite); dict.Add("IsPrivate", entity.IsPrivate); dict.Add("UserName", entity.UserName); dict.Add("Reply", entity.Reply); dict.Add("ReplyAdmin", entity.ReplyAdmin); dict.Add("ReplyDatetime", entity.ReplyDatetime); dict.Add("ReplyIsPrivate", entity.ReplyIsPrivate); dict.Add("ReplyUserName", entity.ReplyUserName); }
public void Update(Comment source, CommentEntity destination) { destination.User = new UserEntity(source.User); destination.TimeStamp = source.TimeStamp; destination.Message = source.Message; destination.Id = source.Id; }
public void StartUp() { testMapper = new CommentMapper(); UserId identity = new UserId { Name = "aName", Surname = "aSurname", UserName = "******", Password = "******", Email = "*****@*****.**" }; Mock <User> stub = new Mock <User>(identity, true); comment = new Commentary("this is a comment", stub.Object); commentEntity = new CommentEntity() { Id = 3, Text = "another comment", Maker = new UserEntity() { Name = "aName", Surname = "aSurname", UserName = "******", Password = "******", Email = "*****@*****.**" } }; }
public virtual IComment Execute(CommandContext commandContext) { if (ReferenceEquals(ProcessInstanceId, null) && ReferenceEquals(TaskId, null)) { throw new ProcessEngineException("Process instance id and ITask id is null"); } EnsureUtil.EnsureNotNull("Message", Message); var userId = commandContext.AuthenticatedUserId; var comment = new CommentEntity(); comment.UserId = userId; //comment.Type = CommentEntity.TYPE_COMMENT; comment.Time = ClockUtil.CurrentTime; comment.TaskId = TaskId; comment.ProcessInstanceId = ProcessInstanceId; comment.Action = EventFields.ActionAddComment; var eventMessage = Message.Replace("\\s+", " "); if (eventMessage.Length > 163) { eventMessage = eventMessage.Substring(0, 160) + "..."; } comment.Message = eventMessage; comment.FullMessage = Message; commandContext.CommentManager.Insert(comment); return((IComment)comment); }
public async Task <BaseResult <bool> > Disable(string comment_id, string disable_desc, int type) { if (string.IsNullOrEmpty(comment_id)) { return(new BaseResult <bool>(808)); } var str = ""; CommentEntity commentEntity = await commentRepository.GetAsync(c => c.comment_id.Equals(comment_id)); if (string.IsNullOrEmpty(commentEntity.disabledesc)) { str = "{'disable':'" + commentEntity.disable + "','disable_desc':'" + disable_desc + "'}"; } else { str = commentEntity.disabledesc + ",{'disable':'" + commentEntity.disable + "','disable_desc':'" + disable_desc + "'}"; } CommentEntity comment = new CommentEntity() { comment_id = comment_id, disabledesc = str, disable = type }; var isTrue = await commentRepository.UpdateAsync(comment, true, true, c => c.disable, c => c.disabledesc); if (!isTrue) { return(new BaseResult <bool>(201, false)); } return(new BaseResult <bool>(200, true)); }
public void ChangeStatusComment(bool status, int id) { CommentEntity comment = new CommentEntity(id); comment.Status = status; comment.Save(); }
public async Task AddComment(CommentEntity comment) { await Task.Run(() => { _commentService.AddComment(comment); }); }
public async Task RegisterCommentAsync(CommentEntity comment) { var data = _convertComment.Execute(comment); await DbSet.AddAsync(data); await _context.SaveChangesAsync(); }
public ActionResult AddComment(CommentEntity model, bool captchaValid, string captchaErrorMessage) { string error = CitizenPortal.Resources.Views.Data.Comment.FormError; if (!ModelState.IsValid) { error = CitizenPortal.Resources.Views.Data.Comment.FormErrorFields; } else if (!captchaValid) { error = CitizenPortal.Resources.Views.Data.Comment.FormErrorCaptcha; } else { try { // Update Azure Table AzureHelper.GetCloudTable("Comments").Execute(TableOperation.Insert(model)); return(Json(model)); } catch (Exception ex) { error = ex.Message; } } model.Error = error; return(Json(model)); }
public async Task <IActionResult> PutCommentEntity(Guid id, CommentEntity commentEntity) { if (id != commentEntity.Id) { return(BadRequest()); } _context.Entry(commentEntity).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CommentEntityExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
/// <summary> /// Default constructur /// </summary> public ObjectCommentRepository() { _comments = new Collection <CommentEntity>(); Random rand = new Random(); for (long i = 1; i < Repository.UserPostRepositoryInstance.GetCount(); i++) { // random count of comments for post for (int j = 1; j < rand.Next(1, 100); j++) { if (Repository.UserPostRepositoryInstance.IsExists(i)) { CommentEntity comment = new CommentEntity(); comment.Id = identityIdCounter++; comment.CreatedUTC = DateTime.Now; comment.PostId = i; comment.UserId = Repository.UserPostRepositoryInstance.Get(i).AuthorUserId; comment.Message = ""; for (int k = 0; k < rand.Next(1, 10); k++) { comment.Message += "Nice post!"; } _comments.Add(comment); } } } }
public bool DeleteCommentByAvatar(int userId = 0, bool?admin = null, int commentId = 0) { var comment = new CommentEntity(); if (admin == true) { var comments = _ctx.CommentEntity .Include(c => c.ReplyTo).AsTracking() .Include(l => l.Likes) .Include(f => f.Flags) .AsSingleQuery() .ToList(); // to allow deletion of any user's post comment = comments.FirstOrDefault(c => c.Id == commentId); } else { var avatars = _ctx.AvatarEntity .Include(c => c.Comments) .ThenInclude(r => r.ReplyTo).AsTracking() .AsSingleQuery() .ToList(); comment = avatars .FirstOrDefault(c => c.Id == userId).Comments .FirstOrDefault(r => r.Id == commentId); } if (comment != null) { _ctx.Remove(comment); return(Save()); } return(false); }
public async Task <Comment> CreateCommentAsync(Comment comment, Guid blogPostId, string userId, CancellationToken ct) { var blogPost = _context.BlogPosts.Where(r => r.Id == blogPostId).FirstOrDefault(); if (blogPost == null) { return(null); } comment.Author = _context.Users.Find(userId); var newComment = new CommentEntity { Id = Guid.NewGuid(), CreatedAt = DateTimeOffset.Now, ModifedAt = DateTimeOffset.Now, Content = comment.Content, BlogPostEntityId = blogPostId.ToString(), BlogPostEntity = blogPost, ApplicationUserId = userId }; blogPost.Comments.Add(newComment); _context.Comments.Add(newComment); await _context.SaveChangesAsync(); return(comment); }
public List<CommentEntity> GetCommentOrderByUcode(string ucode,string cellPhone) { List<CommentEntity> result = new List<CommentEntity>(); try { StringBuilder strSql = new StringBuilder(); string sCellPhone = ""; if (!string.IsNullOrEmpty(sCellPhone)) { sCellPhone =string.Format(" and CellPhone='{0}'",cellPhone); } strSql.AppendFormat(@"Select top 20 * from [dbo].[D_DriverComment](nolock) where ucode='{0}' and Comment!='' {1} order by create_time desc;", ucode, sCellPhone); var dt = helper.GetDataTable(strSql.ToString()); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { CommentEntity entity = new CommentEntity(); entity.CellPhone = dt.Rows[i]["Cellphone"]==DBNull.Value?"":dt.Rows[i]["Cellphone"].ToString(); entity.Comment = dt.Rows[i]["Comment"] == DBNull.Value ? "" : dt.Rows[i]["Comment"].ToString(); entity.CreateTime = dt.Rows[i]["create_time"] == DBNull.Value ? "" : Convert.ToDateTime(dt.Rows[i]["create_time"]).ToString("yyyy-MM-dd"); entity.Evaluate = dt.Rows[i]["Evaluate"] == DBNull.Value ? 0 :Convert.ToInt32(dt.Rows[i]["Evaluate"]); entity.Ucode = dt.Rows[i]["ucode"] == DBNull.Value ? "" : dt.Rows[i]["ucode"].ToString(); result.Add(entity); } } } catch (Exception ex) { LogControl.WriteError(string.Format("{0}|GetCommentOrderByUcode获取失败|Error:{1}",DateTime.Now, ex.Message)); } return result; }
public async Task <ActionResult> SaveMessage([FromBody] CommentEntity param) { // 获取IP地址 if (param.location != null) { if (Request.HttpContext.Connection.RemoteIpAddress != null) { var ip = Request.HttpContext.Connection.RemoteIpAddress.MapToIPv4().ToString(); param.location = ip; } } param.createDate = DateTime.Now; param.targetId ??= 0; var flag = await _commentService.AddCommentAsync(param); // 发送邮件 if (param.targetId == 0 || param.targetUserId == null) { return(Ok(flag)); } var toComment = await _commentService.GetCommentByIdAsync(param.targetId.Value); var fromComment = await _commentService.GetCommentByIdAsync(param.id); flag = _emailHelper.ReplySendEmail(toComment, fromComment, SendEmailType.回复评论); return(Ok(flag)); }
internal static void Seed(BloggingDbContext dbContext) { var blog = new BlogEntity { Id = 1, Title = "每个人都有选择幸福的自由", Content = "每个人都要为自己的选择负责 很多前来心理咨询的来访者,几乎都是是还没有学会爱自己的人,也是还不大明白对自己负责", Created = new DateTime(2017, 3, 19), }; dbContext.Blogs.AddOrUpdate(b => b.Id, blog); var firstComment = new CommentEntity { Id = 1, Blog = blog, Content = "我感同身受", }; var secondComment = new CommentEntity { Id = 2, BlogId = 1, //两种指定外键的方式,或者指定BlogId,或者指定Blog, EF会自动算出来. Content = "我感同身受", }; dbContext.Comments.AddOrUpdate(c => c.Id, firstComment); dbContext.Comments.AddOrUpdate(c => c.Id, secondComment); }
/// <summary> /// 设置批注 /// </summary> /// <param name="cell"></param> /// <param name="suffix"></param> /// <param name="comment"></param> /// <param name="col1"></param> /// <param name="row1"></param> /// <param name="col2"></param> /// <param name="row2"></param> public static void SetCellComment(this ICell cell, CommentEntity entitiy) { ISheet sheet = cell.Sheet; IClientAnchor clientAnchor = sheet.Workbook.GetCreationHelper().CreateClientAnchor(); clientAnchor.AnchorType = AnchorType.MoveDontResize.GetType().ToInt(); clientAnchor.Dx1 = entitiy.Dx1; clientAnchor.Dy1 = entitiy.Dy1; clientAnchor.Dx2 = entitiy.Dx2; clientAnchor.Dy2 = entitiy.Dy2; clientAnchor.Col1 = cell.ColumnIndex; clientAnchor.Row1 = cell.RowIndex; clientAnchor.Col2 = cell.ColumnIndex + entitiy.Width; clientAnchor.Row2 = cell.RowIndex + entitiy.Height; IDrawing draw = sheet.CreateDrawingPatriarch(); IComment comment = draw.CreateCellComment(clientAnchor); comment.Visible = false; if (sheet.Workbook is HSSFWorkbook) { comment.String = new HSSFRichTextString(entitiy.Text); } else { comment.String = new XSSFRichTextString(entitiy.Text); } cell.CellComment = comment; }
public async Task <bool> Handle(RegisterAnswerCommentCommand request, CancellationToken cancellationToken) { var question = await _questionRepository.GetByIdAsync(request.QuestionId); if (question == null) { return(false); } var answer = question.Answers.ToList().FirstOrDefault(answer => answer.Id == request.AnswerId); if (answer == null) { return(false); } var comment = new CommentEntity( request.UserId, request.Body ); comment.DefineId(request.Id); comment.SetParent(answer); await _repository.RegisterCommentAsync(comment); return(true); }
public ActionResult SaveContact([FromBody] CommentEntity objComment) { APIResponse objResponse = new APIResponse(); try { if (ModelState.IsValid) { DBResponse obj = new DBResponse(); CommentDetails objCommentDetails = new CommentDetails(); obj = objCommentDetails.SaveComment(objComment); obj.Result = obj.ID > 0; objResponse.StatusMessage = obj.Result ? "Thanks for reply." : AppMessage.SystemError; objResponse.StatusCode = obj.Result ? APIStatusCode.Success.ToString() : APIStatusCode.InternalError.ToString();; } else { objResponse.StatusCode = APIStatusCode.ValidationFailed.ToString(); objResponse.StatusMessage = "Please fill in all required fields"; } } catch (Exception ex) { objResponse.StatusMessage = ex.Message; objResponse.StatusCode = APIStatusCode.SystemError; } return(Ok(objResponse)); }
public bool CreateComment(CommentCreateRAO model) { if (model.Content == null) { return(false); } var comment = new CommentEntity { OwnerId = _userId, Content = model.Content, ParentId = model.ParentId, GroupId = model.GroupId }; using (var ctx = new ApplicationDbContext()) { var parent = ctx.Comments.FirstOrDefault(c => c.CommentId == model.ParentId); if (parent == null && model.ParentId != 0) { return(false); } ctx.Comments.Add(comment); return(ctx.SaveChanges() == 1); } }
public static void Comment_Insert(CommentEntity ce) { using (MainDB db = new MainDB(BOAdv.MasterConnectionString)) { db.StoredProcedures.Comment_Insert(ce); } }
/// <summary> /// 添加评论 /// </summary> /// <param name="ce">评论的实例</param> /// <returns>添加成功返回true,添加失败返回 false</returns> public static bool AddComment(CommentEntity ce) { DataBase db = new DataBase(); try { string sql = string.Format("INSERT INTO tb_comment ( commentTitle, context, agree, disagree, uid, nid, uptime)VALUES ( '{0}', '{1}','{2}', '{3}', '{4}','{5}','{6}')", ce.CommentTitle, ce.ConText, ce.Agree, ce.DisAgree, ce.uid, ce.nid, ce.UpTime); db.ExCommandNoBack(sql); return true; } catch { return false; } }
public static CommentEntity GetComment(int commentId) { /*获取评论信息*/ DataBase db = new DataBase(); DataSet rs = db.RunProcReturn("select * from tb_comment where id=" + commentId, "tb_comment"); if (rs.Tables[0].Rows.Count > 0) { CommentEntity ce = new CommentEntity(); ce.Id = int.Parse(rs.Tables[0].Rows[0]["id"].ToString()); ce.CommetTitle = rs.Tables[0].Rows[0]["commenttitle"].ToString(); ce.ConText = rs.Tables[0].Rows[0]["context"].ToString(); ce.Agree = int.Parse(rs.Tables[0].Rows[0]["agree"].ToString()); ce.DisAgree = int.Parse(rs.Tables[0].Rows[0]["disagree"].ToString()); ce.uid = int.Parse(rs.Tables[0].Rows[0]["uid"].ToString()); ce.nid = int.Parse(rs.Tables[0].Rows[0]["nid"].ToString()); ce.UpTime = DateTime.Parse(rs.Tables[0].Rows[0]["uptime"].ToString()); return ce; } return null; }
/// <summary> /// 利用Nid获取评论信息 /// </summary> /// <param name="nid"></param> /// <returns></returns> public static List<CommentEntity> GetCommentsByNid(int nid) { DataBase db = new DataBase(); DataSet rs = db.RunProcReturn("select * from tb_comment where nid=" + nid.ToString(), "tb_comment"); List<CommentEntity> comments = new List<CommentEntity>(); for (int i = 0; i < rs.Tables[0].Rows.Count; i++) { CommentEntity ce = new CommentEntity(); ce.CommentTitle = rs.Tables[0].Rows[i]["commentTitle"].ToString(); ce.UpTime = DateTime.Parse(rs.Tables[0].Rows[i]["upTime"].ToString()); ce.Id = int.Parse(rs.Tables[0].Rows[i]["id"].ToString()); ce.Agree = int.Parse(rs.Tables[0].Rows[i]["agree"].ToString()); ce.DisAgree = int.Parse(rs.Tables[0].Rows[i]["disagree"].ToString()); ce.ConText = rs.Tables[0].Rows[i]["Context"].ToString(); ce.uid = int.Parse(rs.Tables[0].Rows[i]["uid"].ToString()); ce.User = UserOperation.GetUser(ce.uid); comments.Add(ce); } return comments; }
/// <summary> /// Create a new CommentEntity object. /// </summary> /// <param name="id">Initial value of Id.</param> /// <param name="blogEntryId">Initial value of BlogEntryId.</param> /// <param name="title">Initial value of Title.</param> /// <param name="name">Initial value of Name.</param> /// <param name="datePublished">Initial value of DatePublished.</param> /// <param name="text">Initial value of Text.</param> public static CommentEntity CreateCommentEntity(int id, int blogEntryId, string title, string name, global::System.DateTime datePublished, string text) { CommentEntity commentEntity = new CommentEntity(); commentEntity.Id = id; commentEntity.BlogEntryId = blogEntryId; commentEntity.Title = title; commentEntity.Name = name; commentEntity.DatePublished = datePublished; commentEntity.Text = text; return commentEntity; }
/// <summary> /// There are no comments for CommentEntitySet in the schema. /// </summary> public void AddToCommentEntitySet(CommentEntity commentEntity) { base.AddObject("CommentEntitySet", commentEntity); }
public void CreateCommentEntity(CommentEntity comment) { uow.CommentRepository.Create(comment.ToDalComment()); uow.Commit(); }
/// <summary> /// The add comment. /// </summary> /// <param name="commentEntity"> /// The comment entity. /// </param> public void AddComment(CommentEntity commentEntity) { commentEntity.PostedTime = DateTime.Now; this.commentTable.InsertOnSubmit(commentEntity); this.Context.SubmitChanges(); }
public bool InsertComment(CommentEntity entity) { try { var paras = new SqlParameter[] { new SqlParameter("@Ucode",SqlDbType.NVarChar,30), new SqlParameter("@Evaluate", SqlDbType.Int), new SqlParameter("@CellPhone", SqlDbType.NVarChar,50), new SqlParameter("@Comment", SqlDbType.NVarChar,2000), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@CreateUser", SqlDbType.NVarChar,20), }; paras[0].Value = entity.Ucode; paras[1].Value = entity.Evaluate; paras[2].Value = entity.CellPhone; paras[3].Value = entity.Comment; paras[4].Value = DateTime.Now; paras[5].Value = 1; paras[6].Value = "Aidaijia.API.CommentOrder.ashx"; string sql = " Insert into D_DriverComment(Ucode,Evaluate,CellPhone,Comment,Create_Time,Create_User,Status)Values(@Ucode,@Evaluate,@CellPhone,@Comment,@CreateTime,@CreateUser,@Status)"; //插入订单 var value = helper.ExecuteCommand(sql, paras); if (value >= 0) { return true; } else { return false; } } catch (Exception ex) { LogControl.WriteError("InsertComment插入评论失败|Error:" + ex.Message); return false; } }