public static List <Book> getFirstBook()
{
return(BookService.getFirstBook());
}
public static int deleteBook(int b_id)
{
return(BookService.deleteBook(b_id));
}
public static int updateBook(Book b)
{
return(BookService.updateBook(b));
}
public static Book getBookByISBN(string isbn)
{
return(BookService.getBookByISBN(isbn));
}
public static Book getBookById(int b_id)
{
return(BookService.getBookById(b_id));
}
public static List <Book> getBooksByGenId(int genid)
{
return(BookService.getBookByCatId(genid));
}
public static int addBook(Book book)
{
return(BookService.addBook(book));
}
static void Main(string[] args)
{
int menuChoice = 0;
BookService bs = new BookService();
GenresService gs = new GenresService();
ReviewsService rs = new ReviewsService();
do
{
showMenu();
menuChoice = Convert.ToInt32(Console.ReadLine());
switch (menuChoice)
{
case 1:
//Add book
Book myBook = new Book();
Console.WriteLine("Inuput book name: ");
myBook.Name = Console.ReadLine();
Console.WriteLine();
Console.WriteLine("Input book isbn: ");
myBook.Isbn = Convert.ToInt32(Console.ReadLine());
Console.WriteLine();
Console.WriteLine("Input book publisher: ");
myBook.Publisher = Console.ReadLine();
Console.WriteLine();
Console.WriteLine("Input book author: ");
myBook.Author = Console.ReadLine();
Console.WriteLine();
Console.WriteLine("Input book year: ");
myBook.Year = Convert.ToInt32(Console.ReadLine());
//get all the genres that i have in my db
Console.WriteLine();
foreach (var g in gs.GetGenres())
{
Console.WriteLine($"{g.Id}. {g.Name}");
}
Console.WriteLine();
Console.WriteLine("Select one of the genres by inputting the number next to the name: ");
myBook.GenreFK = Convert.ToInt32(Console.ReadLine());
bs.Add(myBook);
Console.WriteLine("Book was added successfully");
Console.WriteLine("Press a key to continue...");
Console.ReadKey();
break;
case 2:
//Get Books
var listOfAllBooks = bs.GetBooks();
DisplayListOfBooks(listOfAllBooks);
Console.WriteLine("Press a key to continue...");
Console.ReadKey();
break;
case 3:
//Get books by genre
foreach (var g in gs.GetGenres())
{
Console.WriteLine($"{g.Id}. {g.Name}");
}
Console.WriteLine();
Console.WriteLine("Select one of the genres by inputting the number next to the name: ");
int selectedGenre = Convert.ToInt32(Console.ReadLine());
//overloading
//static polymorphism (for the below line)
var listOfBooksFilteredByGenre = bs.GetBooks(selectedGenre);
DisplayListOfBooks(listOfBooksFilteredByGenre);
Console.WriteLine("Press a key to continue...");
Console.ReadKey();
break;
case 4:
var total = bs.GetTotalNoOfBooks();
Console.WriteLine($"The total number of books in the library database is {total}");
Console.WriteLine("Press a key to continue...");
Console.ReadKey();
break;
case 5:
Console.WriteLine("Please input the number next to the field you want to sort the books by");
Console.WriteLine("1. Name");
Console.WriteLine("2. Author");
Console.WriteLine("3 Year");
Console.WriteLine("Input 1-3: ");
int fieldChoice = Convert.ToInt32(Console.ReadLine());
var sortedList = bs.GetBooksSorted(fieldChoice);
DisplayListOfBooks(sortedList);
Console.WriteLine("Press a key to continue...");
Console.ReadKey();
break;
case 6:
Console.WriteLine("Input isbn of book to be deleted: ");
int bookISBN = Convert.ToInt32(Console.ReadLine());
bs.Delete(bookISBN);
Console.WriteLine("Book has been deleted");
Console.WriteLine("Press any key to continue...");
Console.ReadKey();
break;
case 7:
Console.WriteLine("Input new isbn: ");
int newISBN = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Input new name: ");
string newName = Console.ReadLine();
Console.WriteLine("Input new year: ");
int newYear = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Input new publisher: ");
string newPublisher = Console.ReadLine();
Console.WriteLine("Input new author: ");
string newAuthor = Console.ReadLine();
Console.WriteLine("Input new genre: ");
int newGenre = Convert.ToInt32(Console.ReadLine());
bs.Update(newISBN, newName, newYear, newPublisher, newAuthor, newGenre);
break;
case 8:
Console.WriteLine("Author\t\tTotal");
foreach (AuthorBook item in bs.GetAuthorWithNoOfBooks())
{
Console.WriteLine($"{item.Author}\t\t{item.Total}");
}
break;
case 9:
Console.WriteLine("Input isbn: ");
int isbnForReview = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Input comment: ");
string commentForReview = Console.ReadLine();
Console.WriteLine("Input rating: ");
int ratingForReview = Convert.ToInt32(Console.ReadLine());
rs.ReviewABook(isbnForReview, commentForReview, ratingForReview);
Console.WriteLine("Press any key to continue...");
Console.ReadKey();
break;
case 10:
Console.WriteLine("Input isbn: ");
int isbn = Convert.ToInt32(Console.ReadLine());
foreach (var r in rs.GetReviews(isbn))
{
}
break;
case 11:
Console.WriteLine("Input isbn: ");
int isbn1 = Convert.ToInt32(Console.ReadLine());
Console.WriteLine($"Avg rating for this book is {rs.GetAverageRatingOfBook(isbn1)}");
break;
case 12:
foreach (var item in rs.GetBooksWithNoOfReviews())
{
Console.WriteLine($"Book isbn {item.Isbn} has {item.TotalReviews} with avg rating of {item.AvgRating}");
}
Console.WriteLine("Press any key to continue...");
Console.ReadKey();
break;
default:
if (menuChoice != 999)
{
Console.WriteLine("Input is not valid");
}
break;
}
} while (menuChoice != 999);
}
