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