public void Delete(int id) { HttpResponseMessage response = new HttpResponseMessage(); try { LibraryRepository libraryRepository = new LibraryRepository(Constants.ConnectionString); libraryRepository.DeleteBook(id); } catch (DataDependencyException ex) { response.StatusCode = HttpStatusCode.InternalServerError; response.Content = new StringContent(ex.ErrorMessage); //return response; } catch (DataLayerException ex) { response.StatusCode = HttpStatusCode.InternalServerError; response.Content = new StringContent(ex.ErrorMessage); //return response; } response.StatusCode = HttpStatusCode.OK; response.Content = new StringContent("Book deleted."); //return response; }
public IActionResult DeleteBookForAuthor(Guid authorId, Guid id) { if (LibraryRepository.AuthorNotExists(authorId)) { return(NotFound()); } var book = LibraryRepository.GetBookForAuthor(authorId, id); if (book == null) { return(NotFound()); } LibraryRepository.DeleteBook(book); if (LibraryRepository.NotSave()) { throw new Exception($"Deleting book {id} for author {authorId} failed on save."); } Logger.LogInformation(100, $"Book {id} for author {authorId} was deleted."); return(NoContent()); }
public async Task <IActionResult> DeleteConfirmed(int id) { var book = _repository.GetBook(id); _repository.DeleteBook(id); return(RedirectToAction(nameof(Index))); }
public void DeleteBookTest() { AddBookTest(); Assert.AreEqual(3, _dataLayer.GetAllBooks().Count()); Book book = _dataLayer.GetAllBooks().First(); _dataLayer.DeleteBook(book); Assert.AreEqual(2, _dataLayer.GetAllBooks().Count()); Assert.ThrowsException <KeyNotFoundException>(() => _dataLayer.GetBook(4)); }
public void SaveBookTest() { DatabasePackage databasePackage = new DatabasePackage(_ConnectionString); SqlDataReader reader = null; try { LibraryRepository libraryRepository = new LibraryRepository(_ConnectionString); // Test Add Book Book newBook = new Book(); newBook.Name = "Unit Test Book"; libraryRepository.SaveBook(newBook); databasePackage.CommandText = "Select ID From Book Where Name = 'Unit Test Book'"; reader = databasePackage.GetReader(); reader.Read(); int bookID = databasePackage.FieldToInt(reader["ID"]); Assert.AreNotEqual(0, bookID); // Test Modify Book Book existingBook = libraryRepository.GetBookByID(bookID); existingBook.Name = "Unit Test Book (Modified)"; libraryRepository.SaveBook(existingBook); Book modifiedBook = libraryRepository.GetBookByID(bookID); Assert.AreEqual("Unit Test Book (Modified)", modifiedBook.Name); // Delete newly added book libraryRepository.DeleteBook(bookID); } catch (Exception) { throw; } finally { if (reader != null) { reader.Close(); } } }
public void GetBookByIDTest() { DatabasePackage databasePackage = new DatabasePackage(_ConnectionString); SqlDataReader reader = null; LibraryRepository libraryRepository = new LibraryRepository(_ConnectionString); try { // Add a new book Book newBook = new Book(); newBook.Name = "Unit Test Book"; libraryRepository.SaveBook(newBook); databasePackage.CommandText = "Select ID From Book Where Name = 'Unit Test Book'"; reader = databasePackage.GetReader(); reader.Read(); int bookID = databasePackage.FieldToInt(reader["ID"]); // Test the function Book book = libraryRepository.GetBookByID(bookID); Assert.AreEqual(book.ID, bookID); // Delete newly added book libraryRepository.DeleteBook(bookID); } catch (Exception) { throw; } finally { if (reader != null) { reader.Close(); } } }
public void ReturnBookTest() { DatabasePackage databasePackage = new DatabasePackage(_ConnectionString); SqlDataReader reader = null; LibraryRepository libraryRepository = new LibraryRepository(_ConnectionString); try { // Add a new Book Book newBook = new Book(); newBook.Name = "Unit Test Book"; libraryRepository.SaveBook(newBook); databasePackage.CommandText = "Select ID From Book Where Name = 'Unit Test Book'"; reader = databasePackage.GetReader(); reader.Read(); int bookID = databasePackage.FieldToInt(reader["ID"]); // Add a new Member Member newMember = new Member(); newMember.Name = "Unit Test Member"; libraryRepository.SaveMember(newMember); databasePackage.CommandText = "Select ID From Member Where Name = 'Unit Test Member'"; reader = databasePackage.GetReader(); reader.Read(); int memberID = databasePackage.FieldToInt(reader["ID"]); // Issue this Book to a Member libraryRepository.IssueBook(bookID, memberID, DateTime.Now); // Test the function libraryRepository.ReturnBook(bookID); Book returnBook = libraryRepository.GetBookByID(bookID); Assert.AreEqual(returnBook.MemberID, 0); // Delete newly added book libraryRepository.DeleteBook(bookID); // Delete newly added Member libraryRepository.DeleteMember(memberID); } catch (Exception) { throw; } finally { if (reader != null) { reader.Close(); } } }