updatePost.cs

public static PostData UpdatePostData(MyContext context, int messageId, bool isLiked)
        {
            var post = context.Posts
                .FirstOrDefault(x => x.MessageId == messageId);

            if (isLiked)
            {
                var likesCount = context.Posts
                    .Where(x => x.MessageId == messageId)
                    .Select(x => x.Likes)
                    .FirstOrDefault();
                // var likesCount = conn.ExecuteReader("SELECT (Likes) FROM PostData AS pd WHERE pd.MessageId = @MessageId", new { messageId }).Parse<int>().FirstOrDefault();
                var temp = 1;
                if (likesCount > 0)
                {
                    temp = ++likesCount;
                }

                if (post != null)
                {
                    post.Likes = temp;
                }
                context.SaveChanges();

                // conn.Execute("UPDATE PostData SET Likes = @Likes WHERE MessageId = @MessageId", new { Likes = temp, messageId });

            } else
            {
                var disLikesCount = context.Posts
                    .Where(x => x.MessageId == messageId)
                    .Select(x => x.DisLikes)
                    .FirstOrDefault();
                //var disLikesCount = conn.ExecuteReader("SELECT (DisLikes) FROM PostData AS pd WHERE pd.MessageId = @MessageId", new { messageId }).Parse<int>().FirstOrDefault();
                var temp = 1;
                if (disLikesCount > 0)
                {
                    temp = ++disLikesCount;
                }

                if (post != null)
                {
                    post.DisLikes = temp;
                }
                context.SaveChanges();
                //conn.Execute("UPDATE PostData SET DisLikes = @DisLikes WHERE MessageId = @MessageId", new { DisLikes = temp, messageId });
            }
            // postData = conn.ExecuteReader("SELECT * FROM PostData AS pd WHERE pd.MessageId = @MessageId", new { messageId }).Parse<PostData>().FirstOrDefault();
            return post;
        }