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(); } }