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