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