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>
/// Get Book borrowed from tabBoorow (only the one who haven't been returned yet)
/// </summary>
/// <returns></returns>
public List <BorrowedAndUser> GetBorrowAndUser()
{
List <BorrowedAndUser> _borrowUser = new List <BorrowedAndUser>();
_tableBorrowedTable = _bookDao.GetBookBorrowed();
foreach (DataSet1.TabBorrowRow booksRow in _tableBorrowedTable.Rows)
{
BorrowedAndUser tempRow = BorrowedAndUser.Parse(booksRow);
_borrowUser.Add(tempRow);
}
return(_borrowUser);
}
/// <summary>
/// Get all the books borrowed from TabBorrowed by BID
/// </summary>
/// <param name="BID">int</param>
/// <returns></returns>
public List <TabBorrowModel> ListBooksBorrowedByBID(int BID)
{
List <TabBorrowModel> _books = new List <TabBorrowModel>();
_tableBorrowedTable = _bookDao.GetBookBorrowedByBID(BID);
foreach (DataSet1.TabBorrowRow booksRow in _tableBorrowedTable.Rows)
{
TabBorrowModel tempRow = TabBorrowModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
/// <summary>
/// get book borrowed by UID and ISBN ActualReturnDate is also set as 1/1/2000 so no return means book still borrowed
/// </summary>
/// <param name="UID">int</param>
/// <param name="ISBN">string</param>
/// <returns></returns>
public List <TabBorrowModel> ListBooksBorrowedByUIDIsbnActual(int UID, string ISBN)
{
List <TabBorrowModel> _books = new List <TabBorrowModel>();
_tableBorrowedTable = _bookDao.GetBookBorrowedByUIDIsbnActual(UID, ISBN);
foreach (DataSet1.TabBorrowRow booksRow in _tableBorrowedTable.Rows)
{
TabBorrowModel tempRow = TabBorrowModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
