public BookDAO() { //Initialize objects _bookDataSet = new BookDS(); _tabBookTableAdapter = new TabBookTableAdapter(); _viewBookTableAdapter = new ViewBookTableAdapter(); }
/// <summary> /// Class constructor /// </summary> public BookDAO() { //Initialize objects _bookDataSet = new BookDS(); _tabBookTableAdapter = new TabBookTableAdapter(); _tabReservedTableAdapter = new TabReservedTableAdapter(); _tabBorrowTableAdapter = new TabBorrowTableAdapter(); _viewBookTableAdapter = new ViewBookTableAdapter(); _viewBookAvailableTableAdapter = new ViewBookAvailableTableAdapter(); _viewBookBorrowedTableAdapter = new ViewBookBorrowedTableAdapter(); _viewBookBorrowedWithUserTableAdapter = new ViewBookBorrowedWithUserTableAdapter(); _viewBookReservedTableAdapter = new ViewBookReservedTableAdapter(); }
/// <summary> /// Returns all registers from BookReserved view by userID. /// </summary> /// <param name="userId">int userId</param> /// <returns>BookDS.ViewBookReservedDataTable</returns> /// <exception cref="ex">Exception</exception> public BookDS.ViewBookReservedDataTable GetAllBooksReservedViewByUserId(int userId) { try { _bookDataSet = new BookDS(); _viewBookReservedTableAdapter.FillAllReservedBooksByUserId(_bookDataSet.ViewBookReserved, userId); return(_bookDataSet.ViewBookReserved); } catch (Exception ex) { //Error log simulate Console.WriteLine(ex.ToString()); Console.WriteLine(ex.GetBaseException().ToString()); throw; } }