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