public ObservableCollection <ReaderCard> GetReaderCards()
{
using (MyAppContext appContext = new MyAppContext())
{
ReaderCardRepository readerCardRepository = new ReaderCardRepository(appContext);
var ReaderCards = new ObservableCollection <ReaderCard>(readerCardRepository.GetAll(u => u.Status == false));
return(ReaderCards);
}
}
public OrdersViewModel()
{
Readers = new ObservableCollection <Reader>(GetReaders());
Books = new ObservableCollection <Book>(GetBooks());
using (MyAppContext appContext = new MyAppContext())
{
ReaderCardRepository readerCardRepository = new ReaderCardRepository(appContext);
ReaderCards = new ObservableCollection <ReaderCard>(readerCardRepository.GetAll());
}
}
public void take(Book selectedBookCard)
{
using (MyAppContext appContext = new MyAppContext())
{
ReaderCardRepository readerCardRepository
= new ReaderCardRepository(appContext);
ReaderCard selectedReaderCards
= readerCardRepository.GetAll(u => u.BookId
== selectedBookCard.Id).FirstOrDefault();
selectedReaderCards.DateTook = DateTime.Now;
readerCardRepository.Update(selectedReaderCards);
}
}
public void doOrder(ReaderCard SelectedReaderCard)
{
using (MyAppContext appContext = new MyAppContext())
{
ReaderCardRepository readerCardRepository = new ReaderCardRepository(appContext);
var rc = readerCardRepository.GetById(SelectedReaderCard.Id);
rc.Status = true;
rc.DateTook = DateTime.Now;
readerCardRepository.Update(rc);
MessageBox.Show($" {rc.Status} !", "Update ", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public ObservableCollection <Book> GetBookCards(Reader thisreader, ObservableCollection <Book> BookCards)
{
using (MyAppContext appContext = new MyAppContext())
{
ReaderCardRepository readerCardRepository = new ReaderCardRepository(appContext);
var thisreaderCards = readerCardRepository.GetAll(u => u.ReaderId == thisreader.Id);
BookRepository bookRepository = new BookRepository(appContext);
BookCards = new ObservableCollection <Book>();
foreach (var thisreaderCard in thisreaderCards)
{
BookCards.Add(bookRepository.GetById(thisreaderCard.BookId));
}
return(BookCards);
}
}
public ObservableCollection <Book> search(Reader thisreader, ObservableCollection <Book> BookCards, string Search)
{
using (MyAppContext appContext = new MyAppContext())
{
ReaderCardRepository readerCardRepository = new ReaderCardRepository(appContext);
var thisreaderCards = readerCardRepository.GetAll(u => u.ReaderId == thisreader.Id);
BookRepository bookRepository = new BookRepository(appContext);
BookCards = new ObservableCollection <Book>();
foreach (var thisreaderCard in thisreaderCards)
{
BookCards.Add(bookRepository.GetAll(u => u.Title.Contains(Search) & u.Id == thisreaderCard.BookId).FirstOrDefault());
}
return(BookCards);
}
}
