/**
* Returns a list of users with tapes borrowed on a given date from query.
*/
public IEnumerable <User> usersWithTapesBorrowedOnDate(string sDate)
{
IEnumerable <Borrow> borrowedTapes = _context.Borrows;
List <User> usersWithBorrowedTapes = new List <User>();
// Loop through all borrowed tapes.
foreach (var tape in borrowedTapes)
{
// If the tape's dates in question are validated, add the user who borrowed it to list.
if (validation.validateDate(tape.borrow_date, tape.return_date, sDate))
{
var userWithTape = getUser(tape.userId);
usersWithBorrowedTapes.Add(userWithTape);
}
}
return(usersWithBorrowedTapes);
}
/**
* Returns a list of videotapes borrwed on a given date from query.
*/
public IEnumerable <Videotape> tapesBorrowedAtDate(string sDate)
{
IEnumerable <Borrow> borrowedTapes = _context.Borrows;
List <Videotape> usersWithBorrowedTapes = new List <Videotape>();
// Loop through all borrowed tapes.
foreach (var tape in borrowedTapes)
{
// If the tape's dates in question are validated, add the user who borrowed it to list.
if (validation.validateDate(tape.borrow_date, tape.return_date, sDate))
{
var tapeOnLoan = getVideotape(tape.videotapeId);
usersWithBorrowedTapes.Add(tapeOnLoan);
}
}
return(usersWithBorrowedTapes);
}