//Function 5 public ActionResult DvdLoanFunction() { DvdLoanViewModel dvdLoanView = new DvdLoanViewModel() { dvdDetails = db.DvdDetails.ToList() }; return(View(dvdLoanView)); }
public ActionResult DvdLoanFunction(int dvdId) { DvdLoanViewModel dvdLoanView = (from d in db.DvdDetails join l in db.Loans on d.DvdId equals l.DvdId join m in db.Members on l.MemberId equals m.MemberId select new DvdLoanViewModel { DvdTitle = d.DvdTitle, dateout = l.TakenDate, datedue = l.DueDate, MemberName = m.FirstName + " " + m.LastName, returnDate = l.ReturnDate, dvdDetails = db.DvdDetails.ToList() } ).ToList().Last(); return(View(dvdLoanView)); }