private void AddNewBook()
{
Book book = new Book();
Console.WriteLine("Please enter title of new book: ");
Console.Write(">>> ");
book.Title = Console.ReadLine();
Console.WriteLine("Please enter Author of new book: ");
Console.Write(">>> ");
book.Author = Console.ReadLine();
Console.WriteLine("Please enter publish year of new book: ");
Console.Write(">>> ");
book.PublishYear = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Please enter # of pages in new book: ");
Console.Write(">>> ");
book.PageCount = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Please enter Month when book was read: ");
Console.Write(">>> ");
book.MonthRead = (Console.ReadLine());
BookSqlDAL dal = new BookSqlDAL(DatabaseConnection);
int id = dal.AddBook(book);
if (id > 0)
{
Console.WriteLine("*** SUCCESS ***");
}
else
{
Console.WriteLine("*** DID NOT ADD ***");
}
PrintMenu();
}
private void DisplayAllBooks()
{
while (true)
{
BookSqlDAL dal = new BookSqlDAL(DatabaseConnection);
IList <Book> books = dal.GetBooks();
if (books.Count > 0)
{
foreach (var book in books)
{
Console.WriteLine();
Console.WriteLine("Title -- " + book.Title);
Console.WriteLine("Author -- " + book.Author.PadRight(20) + ("Publish Year -- " + book.PublishYear.ToString().PadRight(7)) + ("Page Count -- " + book.PageCount));
}
}
else
{
Console.WriteLine("***** NO RESULTS *****");
}
Console.WriteLine();
Console.Write("Enter (Q) to return to Main Menu: >>> ");
string menuBack = Console.ReadLine().ToUpper();
if (menuBack == "Q")
{
break;
}
Console.Clear();
}
Console.Clear();
PrintMenu();
}
