public BookLogic()
{
_bookDao = new BookDAO();
_bookTable = new DataSet1.ViewBookDataTable();
_categorytable = new DataSet1.TabCategoryDataTable();
_bookAvailableTable = new DataSet1.ViewBookAvailableDataTable();
_authorTable = new DataSet1.TabAuthorDataTable();
_languageTable = new DataSet1.TabLanguageDataTable();
_borrowTable = new DataSet1.ViewBookBorrowedDataTable();
_tabBookTable = new DataSet1.TabBookDataTable();
_tabReservedTable = new DataSet1.TabReservedDataTable();
_tableBorrowedTable = new DataSet1.TabBorrowDataTable();
}
/// <summary>
/// List all the books avaialable
/// </summary>
/// <returns>Return all the books available</returns>
public List <ViewBookAvailableModel> ListBooksAvailable()
{
List <ViewBookAvailableModel> _books = new List <ViewBookAvailableModel>();
_bookAvailableTable = _bookDao.GetBookAvailable();
foreach (DataSet1.ViewBookAvailableRow booksRow in _bookAvailableTable.Rows)
{
ViewBookAvailableModel tempRow = ViewBookAvailableModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
/// <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 <ViewBookAvailableModel> SearchBooksAvailable(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 <ViewBookAvailableModel> _books = new List <ViewBookAvailableModel>();
_bookAvailableTable = _bookDao.GetBookAvailableByBookNameAuthorName(bookName, authorName);
foreach (DataSet1.ViewBookAvailableRow booksRow in _bookAvailableTable.Rows)
{
ViewBookAvailableModel tempRow = ViewBookAvailableModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
else if (categoryName != "All Categories" && authorName != "")
{
//search book with bookName and authorName and categoryName
List <ViewBookAvailableModel> _books = new List <ViewBookAvailableModel>();
_bookAvailableTable = _bookDao.GetBookAvailableByBookNameAuthorNameCategoryName(bookName, authorName, categoryName);
foreach (DataSet1.ViewBookAvailableRow booksRow in _bookAvailableTable.Rows)
{
ViewBookAvailableModel tempRow = ViewBookAvailableModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
else if (categoryName != "All Categories" && authorName == "")
{
//search book with bookName and authorName and categoryName
List <ViewBookAvailableModel> _books = new List <ViewBookAvailableModel>();
_bookAvailableTable = _bookDao.GetBookAvailableByBookNameCategoryName(bookName, categoryName);
foreach (DataSet1.ViewBookAvailableRow booksRow in _bookAvailableTable.Rows)
{
ViewBookAvailableModel tempRow = ViewBookAvailableModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
else
{
List <ViewBookAvailableModel> _books = new List <ViewBookAvailableModel>();
_bookAvailableTable = _bookDao.GetBookAvailableByBookNameOnly(bookName);
foreach (DataSet1.ViewBookAvailableRow booksRow in _bookAvailableTable.Rows)
{
ViewBookAvailableModel tempRow = ViewBookAvailableModel.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 <ViewBookAvailableModel> _books = new List <ViewBookAvailableModel>();
_bookAvailableTable = _bookDao.GetBookAvailable();
foreach (DataSet1.ViewBookAvailableRow booksRow in _bookAvailableTable.Rows)
{
ViewBookAvailableModel tempRow = ViewBookAvailableModel.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 <ViewBookAvailableModel> _books = new List <ViewBookAvailableModel>();
_bookAvailableTable = _bookDao.GetBookAvailableByAuthorOnly(authorName);
foreach (DataSet1.ViewBookAvailableRow booksRow in _bookAvailableTable.Rows)
{
ViewBookAvailableModel tempRow = ViewBookAvailableModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
else
{
List <ViewBookAvailableModel> _books = new List <ViewBookAvailableModel>();
_bookAvailableTable = _bookDao.GetBookAvailableByAuthor(authorName, categoryName);
foreach (DataSet1.ViewBookAvailableRow booksRow in _bookAvailableTable.Rows)
{
ViewBookAvailableModel tempRow = ViewBookAvailableModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
}
}
