public ICollection<Books> listBooks()
{
BookRepo BookRepo = new BookRepo();
IEnumerable<BOOK> books = BookRepo.getAll();
ICollection<Books> bookList = new List<Books>();
Books book = null;
foreach (BOOK b2 in books)
{
book = new Books();
book.BOOK_ID = b2.BOOK_ID;
book.BOOK_TITLE = b2.BOOK_TITLE;
book.BOOK_DESC = b2.BOOK_DESC;
book.USER_ID = b2.USER_ID;
book.BOOK_AUTHOR = b2.BOOK_AUTHOR;
book.BOOK_EDITION = b2.BOOK_EDITION;
book.BOOK_PRICE = b2.BOOK_PRICE;
book.BOOK_PUBLISHER = b2.BOOK_PUBLISHER;
book.CATEGORY_ID = b2.CATEGORY_ID;
book.CONDITION_ID = b2.CONDITION_ID;
book.CREATED_TIMESTAMP = b2.CREATED_TIMESTAMP;
bookList.Add(book);
}
BookRepo = null;
return bookList;
}
public Books getBookById(int bookId)
{
BookRepo bookRepo = new BookRepo();
BOOK b3 = bookRepo.getById(new BOOK{BOOK_ID=bookId});
Books book = new Books();
book.BOOK_ID = b3.BOOK_ID;
book.BOOK_TITLE = b3.BOOK_TITLE;
book.BOOK_DESC = b3.BOOK_DESC;
book.USER_ID = b3.USER_ID;
book.BOOK_AUTHOR = b3.BOOK_AUTHOR;
book.BOOK_EDITION = b3.BOOK_EDITION;
book.BOOK_PRICE = b3.BOOK_PRICE;
book.BOOK_PUBLISHER = b3.BOOK_PUBLISHER;
book.CATEGORY_ID = b3.CATEGORY_ID;
book.CONDITION_ID = b3.CONDITION_ID;
book.CREATED_TIMESTAMP = b3.CREATED_TIMESTAMP;
return book;
}
public Books insertBooks(Books newBook)
{
Books book2add = newBook;
BOOK u3 = new BOOK();
BookRepo bookRepo = new BookRepo();
u3.BOOK_TITLE = book2add.BOOK_TITLE;
u3.BOOK_EDITION = book2add.BOOK_EDITION;
u3.BOOK_DESC = book2add.BOOK_DESC;
u3.BOOK_AUTHOR = book2add.BOOK_AUTHOR;
u3.BOOK_PUBLISHER = book2add.BOOK_PUBLISHER;
u3.BOOK_PRICE = book2add.BOOK_PRICE;
u3.CATEGORY_ID = book2add.CATEGORY_ID;
u3.CONDITION_ID = book2add.CONDITION_ID;
u3.USER_ID = book2add.USER_ID;
u3.CREATED_TIMESTAMP = DateTime.Now;
bookRepo.add(u3);
return book2add;
}
/*
* 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;
}
public ActionResult CreateBook(Books book)
{
BookService service = new BookService();
service.insertBooks(book);
return RedirectToAction("Index", "Books");
}
