/* * 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; }