/*
* books = book class
* BOOK = Book Table
*/
public ICollection<Books> listBooksByUser(int userId)
{
BookRepo BookRepo = new BookRepo();
IEnumerable<BOOK> books = BookRepo.query(p => p.USER_ID == userId);
ICollection<Books> bookList = new List<Books>();
Books book = null;
foreach (BOOK b1 in books)
{
book = new Books();
book.BOOK_ID = b1.BOOK_ID;
book.BOOK_TITLE = b1.BOOK_TITLE;
book.BOOK_DESC = b1.BOOK_DESC;
book.USER_ID = userId;
book.BOOK_AUTHOR = b1.BOOK_AUTHOR;
book.BOOK_EDITION = b1.BOOK_EDITION;
book.BOOK_PRICE = b1.BOOK_PRICE;
book.BOOK_PUBLISHER = b1.BOOK_PUBLISHER;
book.CATEGORY_ID = b1.CATEGORY_ID;
book.CONDITION_ID = b1.CONDITION_ID;
book.CREATED_TIMESTAMP = b1.CREATED_TIMESTAMP;
bookList.Add(book);
}
BookRepo = null;
return bookList;
}
public ICollection<Books> searchBookByTitle(string SearchString)
{
string searchText = SearchString;
BookRepo BookRepo = new BookRepo();
IEnumerable<BOOK> books = BookRepo.query(s => s.BOOK_TITLE.Contains(searchText));
ICollection<Books> bookList = new List<Books>();
Books book = null;
foreach (BOOK b1 in books)
{
book = new Books();
book.BOOK_ID = b1.BOOK_ID;
book.BOOK_TITLE = b1.BOOK_TITLE;
book.BOOK_DESC = b1.BOOK_DESC;
book.USER_ID = b1.USER_ID;
book.BOOK_AUTHOR = b1.BOOK_AUTHOR;
book.BOOK_EDITION = b1.BOOK_EDITION;
book.BOOK_PRICE = b1.BOOK_PRICE;
book.BOOK_PUBLISHER = b1.BOOK_PUBLISHER;
book.CATEGORY_ID = b1.CATEGORY_ID;
book.CONDITION_ID = b1.CONDITION_ID;
book.CREATED_TIMESTAMP = b1.CREATED_TIMESTAMP;
bookList.Add(book);
}
return bookList;
}