static void Main(string[] args)
{
try
{
BookRepository b1 = new BookRepository();
List <Book> booksFrom2010 = new List <Book>();
booksFrom2010 = b1.GetBooksFrom2010();
List <Book> booksFromMax = new List <Book>();
booksFromMax = b1.GetBooksFromMaximumYear();
foreach (var item in booksFrom2010)
{
Console.WriteLine(item);
}
Console.WriteLine();
Console.WriteLine("Books from max year");
foreach (var item in booksFromMax)
{
Console.WriteLine(item);
}
Console.WriteLine();;
Console.WriteLine("Top 10 books");
List <Book> topTenbooks = new List <Book>();
topTenbooks = b1.GetTopTenBooks();
foreach (var item in topTenbooks)
{
Console.WriteLine(item);
}
PublisherRepository publ1 = new PublisherRepository();
Console.WriteLine("Number of Publishers is: " + publ1.GetNumberOfRows());
Console.WriteLine();
Console.WriteLine("Top 10 Publishers:");
List <Publisher> listaPublishers = new List <Publisher>();
listaPublishers = publ1.GetTopTenPublishers();
foreach (var item in listaPublishers)
{
Console.WriteLine(item);
}
Console.WriteLine("GetNumberOfBooksPerPublisher:");
publ1.GetNumberOfBooksPerPublisher();
Console.WriteLine();
Console.WriteLine("GetPricePerPublisher:");
publ1.GetNumberOfBooksPerPublisher();
Console.WriteLine();
Console.WriteLine("introduceti Id-ul Editurii pentru care doriti sa calculati pretul total al cartilor publicate:");
int var = int.Parse(Console.ReadLine());
Console.WriteLine(publ1.GetTotalPricePerPublisher(var));
Console.WriteLine();
List <Book> totalBooks = new List <Book>();
totalBooks = b1.GetAllBooks();
string totalXML = Reader.SeralizeToXML(totalBooks);
Reader.SeralizeToJson(totalBooks);
Console.WriteLine(totalXML);
_ = Console.ReadLine();
}
catch (System.Data.SqlClient.SqlException e)
{
Console.WriteLine(e.StackTrace);
}
catch (ArgumentException e)
{
Console.WriteLine(e.StackTrace);
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
}
finally
{
Console.WriteLine("Final program");
_ = Console.ReadLine();
}
}
