public Task <BorrowsViewModel> GetBorrowDetails(int?id) { BorrowsViewModel borrowslist = new BorrowsViewModel(); var item = (from bk in _context.Book from c in bk.Copies from br in _context.Borrows where c.ID == br.CopyID && br.UserID == userIdX && br.BorrowID == id orderby(br.BorrowDate) select new { br.BorrowID, bk.Title, br.BorrowDate, br.DueDate, br.ActualReturnDate, br.Fine }).FirstOrDefault(); BorrowsViewModel b = new BorrowsViewModel(); if (item == null) { return(Task.FromResult(b)); } else { b.BorrowID = item.BorrowID; b.Title = item.Title; b.BorrowDate = item.BorrowDate; b.DueDate = (DateTime)item.DueDate; b.ActualReturnDate = item.ActualReturnDate; b.Fine = item.Fine; return(Task.FromResult(b)); } }
public Task <List <BorrowsViewModel> > GetBorrows() { //IQueryable<BorrowsViewModel> borrowedBooks = (IQueryable < BorrowsViewModel >) List <BorrowsViewModel> borrowslist = new List <BorrowsViewModel>(); var bb = from b in _context.Book from c in b.Copies from br in _context.Borrows where c.ID == br.CopyID && br.UserID == userIdX orderby(br.BorrowDate) select new { br.BorrowID, b.Title, br.BorrowDate, br.DueDate, br.ActualReturnDate, br.Fine }; //_context.Borrows.Include(c => c.Copi).Where(x =>x.UserID == userIdX); foreach (var item in bb) { BorrowsViewModel b = new BorrowsViewModel(); b.BorrowID = item.BorrowID; b.Title = item.Title; b.BorrowDate = item.BorrowDate; b.DueDate = (DateTime)item.DueDate; b.ActualReturnDate = item.ActualReturnDate; b.Fine = item.Fine; borrowslist.Add(b); } return(Task.FromResult(borrowslist)); }
// GET: BorrowsController public async Task <IActionResult> OwnerDetail(int id) { BorrowsViewModel borrows = new BorrowsViewModel { Lender = await _borrowService.GetAllLenderFromBorrow(id), }; return(View(borrows)); }
// GET: BorrowsController public async Task <IActionResult> Index() { BorrowsViewModel borrows = new BorrowsViewModel { Lender = await _borrowService.GetAllByLender(User), Borrower = await _borrowService.GetAllByOwner(User) }; return(View(borrows)); }