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;
}));
}
