public UserBookReturnModel GetIssedUser(string UserID, int BookID)
{
UserBookReturnModel returnBook = db.UserIssuedBooks.Where(x => x.UserID == UserID && x.BookID == BookID).OrderByDescending(x => x.UserID).Select(x => new UserBookReturnModel
{
UserID = x.UserID,
ID = x.ID,
UserName = x.Users.UserName,
ISBN = x.Books.ISBN,
RegNo = x.Users.RegistrationNo,
BookName = x.Books.BookName,
IssuedDate = x.IssueDate,
TimeOutDate = x.TimeOutDate
}).FirstOrDefault();
return(returnBook);
}
public IHttpActionResult GetUserIssuedBook(int id)
{
UserBookReturnModel returnBook = db.UserIssuedBooks.Select(x => new UserBookReturnModel
{
UserID = x.UserID,
ID = x.ID,
UserName = x.Users.UserName,
ISBN = x.Books.ISBN,
RegNo = x.Users.RegistrationNo,
BookName = x.Books.BookName,
IssuedDate = x.IssueDate,
TimeOutDate = x.TimeOutDate
}).SingleOrDefault(x => x.ID == id);
if (returnBook == null)
{
return(NotFound());
}
return(Ok(returnBook));
}
