// get the list of borrowed media, including additional information public List <BorrowDTO> GetBorrowInfo() { // list of borrowed media with full info List <BorrowDTO> BorrowedMediaList = new List <BorrowDTO>(); try { // get data from Borrow Table tabBorrowTableAdapter.SelectBorrow(tabBorrowDataTable); // assign each data row to an item of BorrowedMediaList foreach (DataRow borrowRow in tabBorrowDataTable.Rows) { int uID = (int)borrowRow["UID"]; int mediaID = (int)borrowRow["MediaID"]; string title = ""; string userName = ""; // get title of borrowed media MediaDataSet.TabMediaDataTable tabMediaDataTable = new MediaDataSet.TabMediaDataTable(); TabMediaTableAdapter tabMediaTableAdapter = new TabMediaTableAdapter(); tabMediaTableAdapter.SelectMediaByMediaID(tabMediaDataTable, mediaID); foreach (DataRow mediaRow in tabMediaDataTable.Rows) { title = (string)mediaRow["Title"]; } // get name of user who borrowed the media UserDataSet.TabUserDataTable tabUserDataTable = new UserDataSet.TabUserDataTable(); TabUserTableAdapter UserAdapter = new TabUserTableAdapter(); UserAdapter.SelectUserByUID(tabUserDataTable, uID); foreach (DataRow userRow in tabUserDataTable.Rows) { userName = (string)userRow["UserName"]; } BorrowedMediaList.Add(new BorrowDTO(userName, title, borrowRow["BorrowDate"].ToString(), borrowRow["ReturnDate"].ToString(), borrowRow["ActualReturnDate"].ToString())); } } catch (Exception e) { Console.WriteLine(e.Message); } return(BorrowedMediaList); }
// get the list of reserved media, including additional info public List <ReserveDTO> GetReservedInfo() { List <ReserveDTO> ReservedMediaList = new List <ReserveDTO>(); try { //Query get reservation records tabReservedTableAdapter.SelectReserved(tabReservedDataTable); foreach (DataRow reservedRow in tabReservedDataTable.Rows) { int uID = (int)reservedRow["UID"]; int mediaID = (int)reservedRow["MediaID"]; string title = ""; string userName = ""; // get title of reserved media MediaDataSet.TabMediaDataTable tabMediaDataTable = new MediaDataSet.TabMediaDataTable(); TabMediaTableAdapter tabMediaTableAdapter = new TabMediaTableAdapter(); tabMediaTableAdapter.SelectMediaByMediaID(tabMediaDataTable, mediaID); foreach (DataRow mediaRow in tabMediaDataTable.Rows) { title = (string)mediaRow["Title"]; } // get name of user who reserved the media UserDataSet.TabUserDataTable tabUserDataTable = new UserDataSet.TabUserDataTable(); TabUserTableAdapter tabUserTableAdapter = new TabUserTableAdapter(); tabUserTableAdapter.SelectUserByUID(tabUserDataTable, uID); foreach (DataRow userRow in tabUserDataTable.Rows) { userName = (string)userRow["UserName"]; } ReservedMediaList.Add(new ReserveDTO(userName, title, reservedRow["ReservedDate"].ToString())); } } catch (Exception e) { Console.WriteLine(e.Message); } return(ReservedMediaList); }