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