/// <summary>
/// Search books using ISBN, book name and author, only book name and only author.
/// The book name and author are searched with partialy letter, it is not mandotory
/// to inform the exact name.
/// </summary>
/// <param name="bookISBN">string bookISBN</param>
/// <param name="bookName">string bookName</param>
/// <param name="author">string author</param>
/// <returns>List<ViewBookModel></returns>
public List <ViewBookModel> BookSearch(string bookISBN, string bookName, string author)
{
try
{
_listBooksView = new List <ViewBookModel>();
if (bookISBN != "")
{
_viewBookView = _bookDAO.GetAllBooksViewByISBN(bookISBN);
}
else if (bookName != "" || author != "")
{
_viewBookView = _bookDAO.GetAllBooksViewByBookNameAndAuthor(bookName, author);
}
foreach (BookDS.ViewBookRow row in _viewBookView.Rows)
{
_listBooksView.Add(ViewBookModel.Parse(row));
}
return(_listBooksView);
}
catch (Exception ex)
{
//Error log simulate
Console.WriteLine(ex.ToString());
Console.WriteLine(ex.GetBaseException().ToString());
throw new BusinessLogicException(ex.Message);
}
}
/// <summary>
/// get list of book borrowed with userName from TabUser
/// </summary>
/// <param name="BorrowRows"></param>
/// <returns></returns>
public static BorrowedAndUser Parse(DataSet1.TabBorrowRow BorrowRows)
{
if (BorrowRows == null)
{
return(null);
}
else
{
BorrowedAndUser data = new BorrowedAndUser();
data.userName = GetUserInfoByUID(BorrowRows.UID);
ViewBookModel tempBook = new ViewBookModel();
tempBook = GetBookByISBN(BorrowRows.ISBN);
data.bookName = tempBook.BookName;
data.AuthorName = tempBook.AuthorName;
data.CategoryName = tempBook.CategoryName;
data.Isbn = tempBook.Isbn;
data.LanguageName = tempBook.LanguageName;
data.Pages = tempBook.Pages;
data.Publisher = tempBook.Publisher;
data.PublisherYear = tempBook.PublisherYear;
return(data);
}
}
/// <summary>
/// Get all the Books
/// </summary>
/// <returns>Return list of all the book in tabBook</returns>
public List <ViewBookModel> ListBooks()
{
List <ViewBookModel> _books = new List <ViewBookModel>();
_bookTable = _bookDao.GetBook();
foreach (DataSet1.ViewBookRow booksRow in _bookTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
//Get book info from ViewBook with ISBN
public List <ViewBookModel> GetBookInfo(string ISBN)
{
List <ViewBookModel> _books = new List <ViewBookModel>();
_bookTable = _bookDao.GetBookByISBN(ISBN);
foreach (DataSet1.ViewBookRow booksRow in _bookTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
/// <summary>
/// Get book information
/// </summary>
/// <param name="ISBN">string</param>
/// <returns></returns>
public static ViewBookModel GetBookByISBN(string ISBN)
{
List <ViewBookModel> _books = new List <ViewBookModel>();
BookDAO _bookDao = new BookDAO();
DataSet1.ViewBookDataTable _borrowTable = _bookDao.GetBookByISBN(ISBN);
foreach (DataSet1.ViewBookRow bookRows in _borrowTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(bookRows);
_books.Add(tempRow);
}
return(_books[0]);
}
/// <summary>
/// Parse of data from the DS object to the model object.
/// Returns null if the row is null.
/// </summary>
/// <param name="row">BookDS.ViewBookRow row</param>
/// <returns>ViewBookModel</returns>
public static ViewBookModel Parse(BookDS.ViewBookRow row)
{
if (row == null)
{
return(null);
}
else
{
ViewBookModel viewBookModel = new ViewBookModel();
viewBookModel._bookISBN = row.ISBN;
viewBookModel._bookName = row.BookName;
viewBookModel._bookPublisher = row.Publisher;
viewBookModel._bookPublishYear = row.PublishYear;
viewBookModel._bookPages = row.Pages;
viewBookModel._bookAuthorName = row.AuthorName;
viewBookModel._bookCategoryName = row.CategoryName;
viewBookModel._bookLanguageName = row.LanguageName;
return(viewBookModel);
}
}
// Get the value from the dataset and stock them in tabBook
public static ViewBookModel Parse(DataSet1.ViewBookRow BooksRow)
{
if (BooksRow == null)
{
return(null);
}
else
{
ViewBookModel tabBook = new ViewBookModel();
tabBook.Isbn = BooksRow.ISBN;
tabBook.Publisher = BooksRow.Publisher;
tabBook.BookName = BooksRow.BookName;
tabBook.PublisherYear = BooksRow.PublishYear;
tabBook.Pages = BooksRow.Pages;
tabBook.AuthorName = BooksRow.AuthorName;
tabBook.CategoryName = BooksRow.CategoryName;
tabBook.LanguageName = BooksRow.LanguageName;
return(tabBook);
}
}
/// <summary>
/// Returns all books data from view Book.
/// </summary>
/// <returns>List<ViewBookModel></returns>
public List <ViewBookModel> GetAllBooksView()
{
try
{
_listBooksView = new List <ViewBookModel>();
_viewBookView = _bookDAO.GetAllBooksView();
foreach (BookDS.ViewBookRow row in _viewBookView.Rows)
{
_listBooksView.Add(ViewBookModel.Parse(row));
}
return(_listBooksView);
}
catch (Exception ex)
{
//Error log simulate
Console.WriteLine(ex.ToString());
Console.WriteLine(ex.GetBaseException().ToString());
throw new BusinessLogicException(ex.Message);
}
}
/// <summary>
/// Search Books by authorName and categoryName
/// </summary>
/// <param name="authorName">Name of the author (string)</param>
/// <param name="categoryName">Name of the Category</param>
/// <returns>Return list of books according to the value passed</returns>
public List <ViewBookModel> SearchBooks(string authorName, string categoryName, string bookName)
{
//if user enter book name
if (bookName != "")
{
if (categoryName == "All Categories" && authorName != "")
{
//search book with bookName and authorName in all categories
List <ViewBookModel> _books = new List <ViewBookModel>();
_bookTable = _bookDao.GetBookByBookNameAuthorName(bookName, authorName);
foreach (DataSet1.ViewBookRow booksRow in _bookTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
else if (categoryName != "All Categories" && authorName != "")
{
//search book with bookName and authorName and categoryName
List <ViewBookModel> _books = new List <ViewBookModel>();
_bookTable = _bookDao.GetBookByBookNameAuthorNameCategoryName(bookName, authorName, categoryName);
foreach (DataSet1.ViewBookRow booksRow in _bookTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
else if (categoryName != "All Categories" && authorName == "")
{
//search book with bookName and authorName and categoryName
List <ViewBookModel> _books = new List <ViewBookModel>();
_bookTable = _bookDao.GetBookByBookNameCategoryName(bookName, categoryName);
foreach (DataSet1.ViewBookRow booksRow in _bookTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
else
{
List <ViewBookModel> _books = new List <ViewBookModel>();
_bookTable = _bookDao.GetBookByBookNameOnly(bookName);
foreach (DataSet1.ViewBookRow booksRow in _bookTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
}
else
{
// if all categories and no author we display all the books
if (categoryName == "All Categories" && authorName == "")
{
List <ViewBookModel> _books = new List <ViewBookModel>();
_bookTable = _bookDao.GetBook();
foreach (DataSet1.ViewBookRow booksRow in _bookTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
// If the user select all categories we use only one parameter
else if (categoryName == "All Categories" && authorName != "")
{
List <ViewBookModel> _books = new List <ViewBookModel>();
_bookTable = _bookDao.GetBookByAuthorOnly(authorName);
foreach (DataSet1.ViewBookRow booksRow in _bookTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
else
{
List <ViewBookModel> _books = new List <ViewBookModel>();
_bookTable = _bookDao.GetBookByAuthor(authorName, categoryName);
foreach (DataSet1.ViewBookRow booksRow in _bookTable.Rows)
{
ViewBookModel tempRow = ViewBookModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
}
}
