public Task GetBookInDataView(string isbn, int isbnLength, ScannerDataProvider scannerData, User user)
{
return(Task.Factory.StartNew(() =>
{
SQLConnection.AddISBNToHistory(user.Id, isbn);
DataTable bookData = SQLConnection.GetAllBooksInDataTable();
var bookInformation = from book in bookData.AsEnumerable() where book.Field <string>("ISBN" + isbnLength) == isbn select book;
scannerData.bookData = bookInformation.AsDataView();
}));
}
public Books(String genre)
{
DataTable bookData = SQLConnection.GetAllBooksInDataTable();
var bookInformation = from book in bookData.AsEnumerable() where (book.Field <string>("Genre").IndexOf(genre, StringComparison.OrdinalIgnoreCase) != -1) select book;
DataView result = bookInformation.AsDataView();
books = new BookInfo[result.Count];
for (int i = 0; i < result.Count; i++)
{
books[i] = new BookInfo(result[i]["BookName"].ToString(), result[i]["CoverLink"].ToString(), result[i]["ISBN13"].ToString());
}
}
