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