public BooksUserUC(UserMenu userMenu, int userId) { InitializeComponent(); menu = userMenu; this.userId = userId; GenresList.SelectedIndex = -1; ThemesList.SelectedIndex = -1; using (var db = new LibraryDBEntities()) { var books = from u in db.Books select new { Id = u.Id, Name = u.Name, Author = u.Author.FName + " " + u.Author.LName, Genre = u.Genre.Name, Theme = u.Theme.Name, Location = u.Location.Name, Description = u.Description }; Books.ItemsSource = books.ToList(); var genres = from g in db.Genres select new { Id = g.Id, Name = g.Name }; GenresList.ItemsSource = genres.ToList(); var themes = from g in db.Themes select new { Id = g.Id, Name = g.Name }; ThemesList.ItemsSource = themes.ToList(); } }
public WishlistUC(UserMenu um, int userId) { InitializeComponent(); userMenu = um; this.userId = userId; using (var db = new LibraryDBEntities()) { var books = from u in db.Wishlists where u.UserID == userId select new { Id = u.Id, Name = u.Book.Name, Author = u.Book.Author.FName + " " + u.Book.Author.LName, Genre = u.Book.Genre.Name, Theme = u.Book.Theme.Name, Location = u.Book.Location.Name, Description = u.Book.Description }; Books.ItemsSource = books.ToList(); } }