/// <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);
}
/// <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);
}
// Get the value from the dataset and stock them in tabBorrow
public static TabBorrowModel Parse(DataSet1.TabBorrowRow BooksRow)
{
if (BooksRow == null)
{
return(null);
}
else
{
TabBorrowModel tabBook = new TabBorrowModel();
tabBook.bid = BooksRow.BID;
tabBook.uid = BooksRow.UID;
tabBook.isbn = BooksRow.ISBN;
tabBook.borrowDate = BooksRow.BorrowDate.ToString();
tabBook.returnDate = BooksRow.ReturnDate.ToString();
tabBook.actualReturnDate = BooksRow.ActualReturnDate.ToString();
tabBook.lateFee = BooksRow.LateFee;
return(tabBook);
}
}
