/// <summary>
 /// Update loan
 /// </summary>
 /// <param name="client"></param>
 /// <param name="book"></param>
 /// <param name="clientBook"></param>
 public void UpdateLoan(ClientBook loan, ClientBook newLoan)
 {
     loan.StartDate    = newLoan.StartDate;
     loan.LoanDuration = newLoan.LoanDuration;
     loan.EndDate      = newLoan.EndDate;
     LibraryDb.SaveChanges();
 }
        /// <summary>
        /// Delete loan by id
        /// </summary>
        /// <param name="loanId"></param>
        public void DeleteLoan(int bookId, int clientId)
        {
            ClientBook clientBook = LibraryDb.ClientBooks.FirstOrDefault(l => l.BookId == bookId && l.ClientId == clientId);

            LibraryDb.ClientBooks.Remove(clientBook);
            LibraryDb.SaveChanges();
        }
        public void CreateLoan(Client client, Book book, int duration)
        {
            ClientBook loan = new ClientBook
            {
                ClientId     = client.Id,
                BookId       = book.Id,
                LoanDuration = duration,
                //Client = client,
                //Book = book,
            };

            client.ClientBooks.Add(loan);
            book.ClientBooks.Add(loan);

            LibraryDb.ClientBooks.Add(loan);
            LibraryDb.SaveChanges();
        }
 public void AddLoan(ClientBook loan)
 {
     LibraryDb.ClientBooks.Add(loan);
     LibraryDb.SaveChanges();
 }