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