public IActionResult AddBookReview(AddBookReviewCommand newReview)
{
var repo = new BookReviewRepository();
var bookReviewAdded = repo.AddBookReview(newReview);
if (bookReviewAdded != null)
{
return(Ok(newReview));
}
return(BadRequest($"Unable to add review."));
}
public async Task <IActionResult> AddBookReviewAsync(int bookId, [FromBody] AddBookReviewCommand addBookReviewCommand)
{
if (bookId != addBookReviewCommand.BookId)
{
return(BadRequest("Ids do not match."));
}
var result = await mediator.Send(addBookReviewCommand);
if (result != null && result.BookReviewId.HasValue)
{
return(Created($"{Request.Path}{result.BookReviewId}", result));
}
else
{
return(BadRequest());
}
}
public BookReview AddBookReview(AddBookReviewCommand newReview)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"insert into [dbo].[BookReview]
([Review]
,[Rating]
,[BookId]
,[UserId]
,[GoodReadsBookId])
output inserted.*
values (
@Review
,@Rating
,@BookId
,@UserId
,@GoodReadsBookId)";
return(db.QueryFirst <BookReview>(sql, newReview));
}
}
