public void MasterSearchTest()
        {
            // Arrange
            BookSqlDAO testDAO = new BookSqlDAO(connectionString);

            // Act
            List <Book> testResults = new List <Book>();

            testResults = testDAO.MasterSearch("Star", "John", "Test");

            // Assert
            Assert.AreEqual(1, testResults.Count);
            Assert.AreEqual("John Fulton", testResults[0].Author);
        }
        public void MasterSearchNewBookTest()
        {
            // Arrange
            BookSqlDAO testDAO = new BookSqlDAO(connectionString);

            // Act
            List <Book> testResults = new List <Book>();

            testResults = testDAO.MasterSearchNewBooks(Convert.ToDateTime("2018-08-10"), "Cats", "", "");

            // Assert
            Assert.AreEqual(1, testResults.Count);
            Assert.AreEqual("Bradon Studebaker, John Fulton", testResults[0].Author);
        }
        public void BookSqlDAOAddBookTest()
        {
            // Arrange
            BookSqlDAO testDAO  = new BookSqlDAO(connectionString);
            Book       testBook = new Book();

            testBook.Author      = "Alyson Wood";
            testBook.Title       = "Turtles";
            testBook.Genre       = "Non-fiction";
            testBook.ShelfNumber = 7;

            // Act
            bool        didWork  = testDAO.AddBook(testBook);
            List <Book> testList = testDAO.MasterSearch("", "Alyson", "");

            // Assert
            Assert.AreEqual(true, didWork);
            Assert.AreEqual("Alyson Wood, Drew Woitovich", testList[0].Author);
        }