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