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