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