public void AddBookCopy(Book book) { dataContext.usp_add_copy(book.ISBN); }
public List<BookCopy> getCopies(Book book) { List<BookCopy> copies = null; var query = from c in dataContext.get_copies_for_a_book(book.ISBN) select new BookCopy { CopyID = c.CopyID }; copies = query.ToList<BookCopy>(); return copies; }
public void ShowChangeBookWindow(Book book) { ChangeBook cb = new ChangeBook(); cb.BookToChange = book; cb.Show(); }
public List<Borrowing> GetAllBorrowings() { var query = from c in dataContext.get_all_borrows() select new { ISBN = c.ISBN, CopyID = c.CopyID, CustomerID = c.CustomerID, Name = c.Name }; List<Borrowing> borrowings = new List<Borrowing>(); foreach (var item in query) { Book book = new Book(); book.ISBN = item.ISBN; BookCopy bc = new BookCopy(); bc.Book = book; bc.CopyID = item.CopyID; Customer cust = new Customer(); cust.CustomerID = item.CustomerID; cust.Name = item.Name; Borrowing b = new Borrowing(); b.BookCopy = bc; b.Customer = cust; borrowings.Add(b); } return borrowings; }