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