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