//Check if book is reserved from TabReserved with UID and ISBN
public List <TabReservedModel> CheckBooksReserved(int UID, string ISBN)
{
List <TabReservedModel> _books = new List <TabReservedModel>();
_tabReservedTable = _bookDao.CheckBookReserved(UID, ISBN);
foreach (DataSet1.TabReservedRow booksRow in _tabReservedTable.Rows)
{
TabReservedModel tempRow = TabReservedModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
//Get all the books reserved from TabReserved with a specific ISBN
public List <TabReservedModel> ListBooksReservedByISBN(string ISBN)
{
List <TabReservedModel> _books = new List <TabReservedModel>();
_tabReservedTable = _bookDao.GetBookReservedByISBN(ISBN);
foreach (DataSet1.TabReservedRow booksRow in _tabReservedTable.Rows)
{
TabReservedModel tempRow = TabReservedModel.Parse(booksRow);
_books.Add(tempRow);
}
return(_books);
}
// Get the value from the dataset and stock them in tabReserved
public static TabReservedModel Parse(DataSet1.TabReservedRow BooksRow)
{
if (BooksRow == null)
{
return(null);
}
else
{
TabReservedModel tabReserved = new TabReservedModel();
tabReserved.rid = BooksRow.RID;
tabReserved.uid = BooksRow.UID;
tabReserved.isbn = BooksRow.ISBN;
tabReserved.reservedDate = BooksRow.ReservedDate.ToString();
return(tabReserved);
}
}
/// <summary>
/// Parse of data from the DS object to the model object.
/// Returns null if the row is null.
/// </summary>
/// <param name="row">BookDS.BookDS.TabReservedDataTable row</param>
/// <returns>TabReservedModel</returns>
public static TabReservedModel Parse(BookDS.TabReservedDataTable row)
{
if (row == null)
{
return(null);
}
else
{
TabReservedModel tabReservedModel = new TabReservedModel();
tabReservedModel._reservedBookName = row.BookNameColumn.ToString();
tabReservedModel._reservedBookIsbn = row.ISBNColumn.ToString();
tabReservedModel._reservedBookDate = row.ReservedDateColumn.ToString();
tabReservedModel._reservedBookUserName = row.UserNameColumn.ToString();
tabReservedModel._reservedBookId = Int32.Parse(row.RIDColumn.ToString());
tabReservedModel._reservedBookUserId = Int32.Parse(row.ISBNColumn.ToString());
return(tabReservedModel);
}
}
/// <summary>
/// Return all registers from Reserved table by UserID.
/// </summary>
/// <param name="userId">int userId</param>
/// <returns>List<TabReservedModel></returns>
public List <TabReservedModel> GetAllReservedBooksByUserId(int userId)
{
try
{
_listTabReservedModel = new List <TabReservedModel>();
_tabReservedDataTable = _bookDAO.GetAllReservedBooksByUserId(userId);
foreach (BookDS.TabReservedDataTable row in _tabReservedDataTable.Rows)
{
_listTabReservedModel.Add(TabReservedModel.Parse(row));
}
return(_listTabReservedModel);
}
catch (Exception ex)
{
//Error log simulate
Console.WriteLine(ex.ToString());
Console.WriteLine(ex.GetBaseException().ToString());
throw new BusinessLogicException(ex.Message);
}
}
