async Task ExecuteLoadItemsCommand()
{
if (IsBusy)
{
return;
}
IsBusy = true;
try
{
BooksItem.Clear();
var items = await BooksStore.GetItemsAsync(true);
foreach (var item in items)
{
BooksItem.Add(item);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
finally
{
IsBusy = false;
}
}
//public void addBookToLibrary(OrderLines orderLine)
//{
// using (var connection = new SqlConnection(ConnectionString))
// {
// connection.Open();
// connection.Execute(@"insert into OrderLines(OrderId, ProductId) values (@OrderId,@ProductId)", orderLine);
// }
//}
public void addBookToLibrary(BooksItem bookitem)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
connection.Execute(@"INSERT INTO BooksItem(title, authors, description, categories, MyLibraryId, WishListId, ImageLink)
values (@title, @authors, @description, @categories, @MyLibraryId, @WishListId, @ImageLink)", bookitem);
}
}
public void AddBook(BooksItem bookItem)
{
Libray.addBookToLibrary(bookItem);
}
