public IQueryable <Models.Category> GetCategories()
{
var _db = new TuSach.Models.BookContext();
IQueryable <Models.Category> query = _db.Categories;
return(query);
}
public IQueryable <Models.Book> GetBooks()
{
var _db = new TuSach.Models.BookContext();
IQueryable <Models.Book> query = _db.Books;
query = query.Take(32);
return(query);
}
public IQueryable <Models.Book> GetBooks([QueryString("id")] int?categoryId)
{
var _db = new TuSach.Models.BookContext();
IQueryable <Models.Book> query = _db.Books;
if (categoryId.HasValue && categoryId > 0)
{
query = query.Where(p => p.CategoryID == categoryId);
}
return(query);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.Get("id") == null)
{
Response.Redirect("Category.aspx");
}
int BookID = Int32.Parse(Request.QueryString.Get("id"));
if (isExisBook(BookID))
{
var _db = new TuSach.Models.BookContext();
IQueryable <Models.Book> query = _db.Books;
query = query.Where(p => p.BookID == BookID);
BookItem = query.FirstOrDefault();
}
else
{
Response.Redirect("Category.aspx");
}
}
