示例#1
0
        private List <Loans> GetBooks(List <Loans> loans)
        {
            BookRepository     bookRepository     = new BookRepository();
            BookTypeRepository bookTypeRepository = new BookTypeRepository();

            foreach (Loans loan in loans)
            {
                loan.Book          = bookRepository.GetBookOfId(loan.book_id);
                loan.Book.BookType = bookTypeRepository.GetSingleBookType(loan.Book.BookTypes_id);
            }
            return(loans);
        }
示例#2
0
        public Loans GetLoanFromBookId(int bookId)
        {
            BookRepository     bookRepository     = new BookRepository();
            BookTypeRepository bookTypeRepository = new BookTypeRepository();
            UserRepository     userRepository     = new UserRepository();
            string             sqlString          = $"SELECT * FROM Loans Where book_id = '{bookId}' AND returned = 'false';";
            Loans loan = _db.Query <Loans>(sqlString).SingleOrDefault();

            loan.Book          = bookRepository.GetBookOfId(loan.book_id);
            loan.Book.BookType = bookTypeRepository.GetSingleBookType(loan.Book.BookTypes_id);
            loan.user          = userRepository.GetSingleUser(loan.user_id);
            return(loan);
        }