/// <summary>
/// Get all books from DB and insert them in a List
/// </summary>
public override void CreateMediaLibrary()
{
SQLiteDatabase database = new SQLiteDatabase();
string query = "SELECT * FROM Books";
DataTable books = database.GetDataTable(query);
foreach (DataRow b in books.Rows)
{
Book book = new Book();
book.Isbn = b["isbn"].ToString();
book.Title = b["title"].ToString();
book.Publisher = b["publisher"].ToString();
//book.SiteRating = (decimal?)b["rating"]??0;
book.SiteRating = 0;
//book.UserRating = (decimal?)b["userRating"];
book.UserRating = 0;
//book.PublicationDate = (DateTime?)b["datePublication"] ?? DateTime.MinValue;
int genreId = int.Parse(b["genres"].ToString());
DataTable genresTable = database.GetItemById("Genres", genreId);
foreach (DataRow genre in genresTable.Rows)
{
book.Genres.Add(new Genre { Name = genre.ToString() });
}
//book.NumberOfPages = ulong.Parse(b["pages"].ToString());
book.NumberOfPages = 0;
book.Description = b["description"].ToString();
this.MediaList.Add(book);
}
//throw new NotImplementedException();
}
