public int Save(CommentVM comment)
 {
     using (var db = new TeamEntitiesConn())
     {
         var commentEntity = new Comment();
         commentEntity.IssueID = comment.IssueId;
         commentEntity.CommentText = comment.CommentBody;
         commentEntity.CreatedDate = DateTime.Now;
         commentEntity.CreatedByID = comment.Author.Id;
         ;
         db.Comments.Add(commentEntity);
         db.SaveChanges();
         return commentEntity.ID;
     }
 }
        public async Task Delete(int id)
        {
            using (var db = new TeamEntitiesConn())
            {
                var c = new Comment {ID = id};
                db.Comments.Attach(c);
                db.Comments.Remove(c);
                await db.SaveChangesAsync();
                //var c = db.Comments.FirstOrDefault(s => s.ID == id);
                //if (c != null)
                //{
                //    db.Comments.Remove(c);
                //    await db.SaveChangesAsync();
                //}

            }
        }
        public Activity SaveActivity(Comment comment,int teamId)
        {
            var issue = repo.GetIssue(comment.IssueID);

            Activity activity = new Activity();
            activity.CreatedByID = comment.CreatedByID;
            activity.OldState = issue.Title;
            activity.NewState = comment.CommentText;
            activity.ObjectID = comment.ID;
            activity.ObjectType = "IssueComment";
            activity.ActivityDesc = "Commented";
            activity.TeamID = teamId;
            var result = repo.SaveActivity(activity);
            if (result.Status)
            {
                return repo.GetActivity(activity.ID);
            }
            return null;
        }
 public CommentVM GetIssueCommentVM(int currentUserId, Comment item)
 {
     var commentVM = new CommentVM { ID = item.ID, CommentBody = item.CommentText, AuthorName = item.Author.FirstName,
         CreativeDate = item.CreatedDate };
     commentVM.CommentBody = commentVM.CommentBody.ConvertUrlsToLinks();
     commentVM.AvatarHash = UserService.GetAvatarUrl(item.Author.Avatar, 42);
     commentVM.CreatedDateRelative = item.CreatedDate.ToJSONFriendlyDateTime();//.ToRelativeDateTime();
     commentVM.IsOwner = item.CreatedByID == currentUserId;
     return commentVM;
 }
        public OperationStatus SaveComment(Comment comment)
        {
            try
            {
                comment.CreatedDate = DateTime.UtcNow;
                db.Comments.Add(comment);
                db.SaveChanges();
            }
            catch(Exception ex)
            {
                return OperationStatus.CreateFromException("Error in comment", ex);
            }
            

            return new OperationStatus { Status = true, OperationID = comment.ID };

        }