//Fill ----------
public List <Borrow> getAllReserved()
{
List <Borrow> myList = new List <Borrow>();
BorrowDS.TabBorrowDataTable myData = borrowDAO.getAllBorrowTab();
//parse data from datatable rows to list elements
myList = parseBorrowDataTolistAll(myData);
return(myList);
}
public List <Borrow> getByUserForUserActivity(int userId)
{
List <Borrow> myList = new List <Borrow>();
BorrowDS.TabBorrowDataTable myData = borrowDAO.getByUserIdForActiveBookings(userId);
//parse data from datatable rows to list elements
myList = parseBorrowDataTolistAll(myData);
return(myList);
}
public bool getMediaExists(int mediaId)
{
List <Borrow> myList = new List <Borrow>();
BorrowDS.TabBorrowDataTable myData = borrowDAO.getMediaExists(mediaId);
//parse data from datatable rows to list elements
myList = parseBorrowDataTolistAll(myData);
// results list count == 0
if (myList.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
//functions ---------
public List <Borrow> parseBorrowDataTolistAll(BorrowDS.TabBorrowDataTable myDataTable)
{
//create list
List <Borrow> myList = new List <Borrow>();
// sort through data by rows
foreach (BorrowDS.TabBorrowRow row in myDataTable.Rows)
{
if (row == null)
{
return(null);
}
else
{
Borrow borrowItem = new Borrow(row.BID, row.UID, row.MediaID, row.BorrowDate.ToString(), row.ReturnDate.ToString(), row.ActualReturnDate.ToString(), (int)row.LateFee);
myList.Add(borrowItem);
}
}
return(myList);
}
