public override void Execute() { Logger.Instance.Debug($"handling like of comment {reqParams.comment_id}"); //add like count in comment this.comment = Comments.GetByCommentId(reqParams.comment_id); comment.like_count++; Comments.UpdateLikeCount(comment.comment_id, comment.like_count); CoreLike like = new CoreLike() { creation_date = DateTime.Now, poster_id = userId, poster_type = "user", reaction = "like", resource_id = comment.comment_id, resource_type = "activity_comment" }; var likeId = CoreLikes.Add(like); Logger.Instance.Debug($"like id = {likeId}"); SendNotifications(); }
public static ulong Add(CoreLike newLike) { Console.WriteLine($"adding like to table:{JsonConvert.SerializeObject(newLike)}"); return(DbUtils.ConnectAndExecute(conn => { var query = "INSERT INTO engine4_core_likes(resource_type,resource_id,poster_type,poster_id,reaction,creation_date) " + "VALUES (@resource_type,@resource_id,@poster_type,@poster_id,@reaction,@creation_date)"; var cmd = new MySqlCommand(query, conn); cmd.Parameters.AddWithValue("resource_type", newLike.resource_type); cmd.Parameters.AddWithValue("resource_id", newLike.resource_id); cmd.Parameters.AddWithValue("poster_type", newLike.poster_type); cmd.Parameters.AddWithValue("poster_id", newLike.poster_id); cmd.Parameters.AddWithValue("reaction", newLike.reaction); cmd.Parameters.AddWithValue("creation_date", newLike.creation_date); var rc = cmd.ExecuteNonQuery(); cmd.CommandText = "Select @@Identity"; newLike.like_id = (uint)(ulong)cmd.ExecuteScalar(); return newLike.like_id; })); }