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