public Models.Book.Book CreateBook(Models.Book.Book book)
{
string sqlStoredProcedure = @"BookOfKnowledge.dbo.Book_Create";
using (var _connection = new SqlConnection(_labsysConnectionString))
{
_connection.Query <Models.Book.Book>(sqlStoredProcedure,
new { Title = book.Title, Description = book.Description }, commandType: CommandType.StoredProcedure);
//var createdBook = ListBooks().Find(x => x.Id == book.Id);
var message = new HttpResponseMessage(HttpStatusCode.OK);
}
return(ListBooks().Find(x => x.Id == book.Id));
}
public Models.Book.Book UpdateBook(int id, Models.Book.Book book)
{
string sqlStoredProcedure = @"BookOfKnowledge.dbo.Book_Update";
if (FindBookById(id) != null)
{
using (var _connection = new SqlConnection(_labsysConnectionString))
{
_connection.Query <Models.Book.Book>(sqlStoredProcedure,
new { Id = book.Id, Title = book.Title, Description = book.Description }, commandType: CommandType.StoredProcedure);
return(ListBooks().Find(x => x.Id == id));
}
}
else
{
throw new InvalidExpressionException("No Book with Id = " + book.Id + " was Found");
}
}
public Models.Book.Book UpdateBook(int id, Models.Book.Book book)
{
return(_bookService.UpdateBook(id, book));
}
public Models.Book.Book CreateBook(Models.Book.Book book)
{
return(_bookService.CreateBook(book));
}
public Models.Book.Book Put(int id, [FromBody] Models.Book.Book book) // Update a book
{
return(new BookOfKnowledge.DataService.BookDataService().UpdateBook(id, book));
}
public Models.Book.Book Post([FromBody] Models.Book.Book book) // create a book
{
return(new BookOfKnowledge.DataService.BookDataService().CreateBook(book));
}
public Models.Book.Book UpdateBook(int id, Models.Book.Book book)
{
return(_bookRepository.UpdateBook(id, book));
}
public Models.Book.Book CreateBook(Models.Book.Book book)
{
return(_bookRepository.CreateBook(book));
}
