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