protected void Page_Load(object sender, EventArgs e) { using (var context = new LibrarySystemEntities()) { int bookId = Convert.ToInt32(this.Request.Params["id"]); var book = context.Books.Find(bookId); if (book != null) { this.LabelBookTitle.Text = Server.HtmlEncode(book.Title); this.LabelAuthor.Text = "by " + Server.HtmlEncode(book.Author); if (book.ISBN != null) { this.LabelIsbn.Text = "ISBN " + Server.HtmlEncode(book.ISBN); } if (book.WebSite != null) { this.LabelWebSite.Text = Server.HtmlEncode(book.WebSite); this.LabelWebSite.NavigateUrl = Server.HtmlEncode(book.WebSite); } this.LabelDescription.Text = Server.HtmlEncode(book.Description); } else { ErrorSuccessNotifier.AddErrorMessage("This book doest not exist anymore"); this.Response.Redirect("~/Default.aspx"); } } }
protected List <Book> CategoryBooks(int categoryId) { using (var context = new LibrarySystemEntities()) { var books = context.Books.Where(b => b.CategoryId == categoryId); return(books.ToList()); } }
protected void Page_Load(object sender, EventArgs e) { using (var context = new LibrarySystemEntities()) { var categories = context.Categories.ToList(); this.ListViewCategories.DataSource = categories; this.ListViewCategories.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { using (var context = new LibrarySystemEntities()) { string queryString = this.Request.Params["q"]; string queryStringToLower = queryString.ToLower(); if (queryStringToLower == "") { this.ListViewBooks.DataSource = context.Books.Include("Category").ToList(); } else { var books = context.Books.Include("Category").Where( b => b.Title.ToLower().Contains(queryStringToLower) || b.Author.Contains(queryStringToLower)) .OrderBy(b => b.Title).ThenBy(b => b.Author); this.ListViewBooks.DataSource = books.ToList(); } this.LabelSearchQueryHeader.Text = string.Format("Search Results for Query \"{0}\"", Server.HtmlEncode(queryString)); this.ListViewBooks.DataBind(); } }