Exemplo n.º 1
0
        public List <LikeBroadcast> Delete([FromBody] LikeBroadcast like)
        {
            int  broadcastID = like.BroadcastID;
            bool delete      = DB.ExecuteCommand("DELETE FROM Likes WHERE LikeID = @LikeID AND BroadcastID=@BroadcastID",
                                                 (cmd) => {
                cmd.Parameters.AddWithValue("@LikeID", like.LikeID);
                cmd.Parameters.AddWithValue("@BroadcastID", like.BroadcastID);
            }) == 1;

            if (delete)
            {
                return(GetLikesByBroadcast(broadcastID));
            }

            return(null);
        }
Exemplo n.º 2
0
        public List <LikeBroadcast> AddComment([FromBody] LikeBroadcast like)
        {
            int  broadcastID = like.BroadcastID;
            bool insert      = DB.ExecuteCommand("INSERT INTO Likes( BroadcastID, UserEmail) VALUES ( @BroadcastID, @UserEmail)",
                                                 (cmd) => {
                cmd.Parameters.AddWithValue("@BroadcastID", like.BroadcastID);
                cmd.Parameters.AddWithValue("@UserEmail", like.UserEmail);
            }) == 1;

            if (insert)
            {
                return(GetLikesByBroadcast(broadcastID));
            }

            return(null);
        }