public List <ViewBookBorrowedModel> ListBooksBorrowed()
{
List <ViewBookBorrowedModel> _books = new List <ViewBookBorrowedModel>();
_borrowTable = _bookDao.ListBooksBorrowed();
foreach (DataSet1.ViewBookBorrowedRow bookRows in _borrowTable.Rows)
{
ViewBookBorrowedModel tempRow = ViewBookBorrowedModel.Parse(bookRows);
_books.Add(tempRow);
}
return(_books);
}
/// <summary>
/// Check if the ISBN if present in the viewBookBorrowed table
/// </summary>
/// <param name="ISBN">string</param>
/// <returns></returns>
public List <ViewBookBorrowedModel> CheckBookSelected(string ISBN)
{
List <ViewBookBorrowedModel> _books = new List <ViewBookBorrowedModel>();
_borrowTable = _bookDao.CheckBookBorrowed(ISBN);
foreach (DataSet1.ViewBookBorrowedRow booksRow in _borrowTable.Rows)
{
ViewBookBorrowedModel tempRow = ViewBookBorrowedModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
/// <summary>
/// Parse of data from the DS object to the model object.
/// Returns null if the row is null.
/// </summary>
/// <param name="row">BookDS.ViewBookBorrowedRow row</param>
/// <returns>ViewBookBorrowedModel</returns>
public static ViewBookBorrowedModel Parse(BookDS.ViewBookBorrowedRow row)
{
if (row == null)
{
return(null);
}
else
{
ViewBookBorrowedModel viewBookBorrowedModel = new ViewBookBorrowedModel();
viewBookBorrowedModel._bookBorrowedISBN = row.ISBN;
viewBookBorrowedModel._bookBorrowedName = row.BookName;
viewBookBorrowedModel._bookBorrowedPublisher = row.Publisher;
viewBookBorrowedModel._bookBorrowedPublishYear = row.PublishYear;
viewBookBorrowedModel._bookBorrowedPages = row.Pages;
viewBookBorrowedModel._bookBorrowedAuthorName = row.AuthorName;
viewBookBorrowedModel._bookBorrowedCategoryName = row.CategoryName;
viewBookBorrowedModel._bookBorrowedLanguageName = row.LanguageName;
return(viewBookBorrowedModel);
}
}
// Get the value from the dataset and stock them in viewBook
public static ViewBookBorrowedModel Parse(DataSet1.ViewBookBorrowedRow BooksRow)
{
if (BooksRow == null)
{
return(null);
}
else
{
ViewBookBorrowedModel viewBook = new ViewBookBorrowedModel();
viewBook.Isbn = BooksRow.ISBN;
viewBook.Publisher = BooksRow.Publisher;
viewBook.BookName = BooksRow.BookName;
viewBook.PublisherYear = BooksRow.PublishYear;
viewBook.Pages = BooksRow.Pages;
viewBook.AuthorName = BooksRow.AuthorName;
viewBook.CategoryName = BooksRow.CategoryName;
viewBook.LanguageName = BooksRow.LanguageName;
return(viewBook);
}
}
/// <summary>
/// Return all registers from Book Borrowed by UserId.
/// </summary>
/// <param name="userId">int userId</param>
/// <returns>List<ViewBookBorrowedModel></returns>
public List <ViewBookBorrowedModel> GetAllBorrowedBooksByUserId(int userId)
{
try
{
_listViewBooksBorrowedModel = new List <ViewBookBorrowedModel>();
_viewBookBorrowedDataTable = _bookDAO.GetAllBooksBorrowedView();
foreach (BookDS.ViewBookBorrowedRow row in _viewBookBorrowedDataTable.Rows)
{
_listViewBooksBorrowedModel.Add(ViewBookBorrowedModel.Parse(row));
}
return(_listViewBooksBorrowedModel);
}
catch (Exception ex)
{
//Error log simulate
Console.WriteLine(ex.ToString());
Console.WriteLine(ex.GetBaseException().ToString());
throw new BusinessLogicException(ex.Message);
}
}
