protected void DeleteButton_Click(object sender, EventArgs e) { this.AddBook.Visible = false; this.PanelTitle.Text = "Confirm Delete Category"; this.BookPanel.Visible = true; Button button = sender as Button; int id = Convert.ToInt32(button.CommandArgument); using (var dbContext = new BooksReviewContext()) { var book = dbContext.Books.Find(id); this.TitleTextBox.Text = book.Title; this.TitleTextBox.ReadOnly = true; this.AuthorLabel.Visible = false; this.AuthorTextBox.Visible = false; this.ISBN.Visible = false; this.ISBNTextBox.Visible = false; this.UrlLabel.Visible = false; this.UrlTextBox.Visible = false; this.DescrLabel.Visible = false; this.DescrTextBox.Visible = false; this.CategoryLabel.Visible = false; this.CategoryDropDownList.Visible = false; this.EditOrCreateBook.Text = "Delete"; this.EditOrCreateBook.CommandArgument = id.ToString(); this.EditOrCreateBook.CommandName = "delete"; } }
protected void EditButton_Click(object sender, EventArgs e) { this.BookPanel.Visible = true; Button button = sender as Button; int id = Convert.ToInt32(button.CommandArgument); var dbContext = new BooksReviewContext(); var book = dbContext.Books.Find(id); var categories = dbContext.Categories.ToList(); this.AddBook.Visible = false; this.PanelTitle.Text = "Edit Book"; this.TitleTextBox.Text = book.Title; this.AuthorTextBox.Text = book.Author; this.ISBNTextBox.Text = book.ISBN; this.UrlTextBox.Text = book.SiteURL; this.DescrTextBox.Text = book.Description; this.CategoryDropDownList.DataSource = categories; this.CategoryDropDownList.DataBind(); int indexSel = 0; for (int i = 0; i < categories.Count; i++) { if (categories[i].Id == book.CategoryId) { indexSel = i; break; } } this.CategoryDropDownList.SelectedIndex = indexSel; this.EditOrCreateBook.Text = "Edit"; this.EditOrCreateBook.CommandName = "edit"; this.EditOrCreateBook.CommandArgument = id.ToString(); }
public IQueryable <Category> GridViewCategories_GetData() { IQueryable <Category> cateories = null; var dbContext = new BooksReviewContext(); cateories = dbContext.Categories.AsQueryable <Category>(); return(cateories); }
public IQueryable <BookReviews.Models.Book> GridViewBooks_GetData() { IQueryable <Book> books = null; var dbContext = new BooksReviewContext(); books = dbContext.Books.Include("Category").AsQueryable <Book>(); return(books); }
protected void Page_Load(object sender, EventArgs e) { var dbContext = new BooksReviewContext(); string searchStr = Request.QueryString["str"]; var books = dbContext.Books.Where(b => (b.Author.Contains(searchStr) || b.Author.Contains(searchStr))).ToList(); this.RepeaterSearchResult.DataSource = books; this.RepeaterSearchResult.DataBind(); }
public IQueryable <Category> BookListGetData() { var dbContext = new BooksReviewContext(); IQueryable <Category> categories = null; categories = dbContext.Categories.AsQueryable <Category>(); return(categories); }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["id"]); using (var dbContext = new BooksReviewContext()) { var book = dbContext.Books; this.DetailsFormView.DataSource = book.Where(x => x.Id == id).ToList(); this.DetailsFormView.DataBind(); } }
protected void EditButton_Click(object sender, EventArgs e) { this.PanelTitle.Text = "Edit Category"; this.AddCategory.Visible = false; this.EditOrCreateCategotyPanel.Visible = true; Button button = sender as Button; int id = Convert.ToInt32(button.CommandArgument); using (var dbContext = new BooksReviewContext()) { var category = dbContext.Categories.Find(id); this.EditOrCreateCategotyTextBox.Text = category.Name; this.EditOrCreateCategotyButton.Text = "Edit"; this.EditOrCreateCategotyButton.CommandArgument = id.ToString(); this.EditOrCreateCategotyButton.CommandName = "edit"; } }
protected void AddBook_Click(object sender, EventArgs e) { this.BookPanel.Visible = true; var dbContext = new BooksReviewContext(); var categories = dbContext.Categories.ToList(); this.AddBook.Visible = false; this.PanelTitle.Text = "Add Book"; this.TitleTextBox.Text = string.Empty; this.AuthorTextBox.Text = string.Empty; this.ISBNTextBox.Text = string.Empty; this.UrlTextBox.Text = string.Empty; this.DescrTextBox.Text = string.Empty; this.CategoryDropDownList.DataSource = categories; this.CategoryDropDownList.DataBind(); this.EditOrCreateBook.Text = "Add"; this.EditOrCreateBook.CommandName = "add"; }
protected void EditOrCreateCategotyButton_Click(object sender, EventArgs e) { var dbContext = new BooksReviewContext(); string categoryName = this.EditOrCreateCategotyTextBox.Text; Button button = sender as Button; if (button.CommandName == "edit") { int id = Convert.ToInt32(button.CommandArgument); var category = dbContext.Categories.Find(id); category.Name = categoryName; } else if (button.CommandName == "delete") { int id = Convert.ToInt32(button.CommandArgument); var category = dbContext.Categories.Find(id); var books = category.Books.ToList(); dbContext.Books.RemoveRange(books); dbContext.Categories.Remove(category); } else { var category = new Category { Name = categoryName }; dbContext.Categories.Add(category); } try { dbContext.SaveChanges(); } catch (Exception ex) { this.ErrorLabel.Text = ex.Message; } this.GridViewCategories.DataBind(); this.EditOrCreateCategotyPanel.Visible = false; }
protected void EditOrCreateBook_Click(object sender, EventArgs e) { var dbContext = new BooksReviewContext(); Button button = sender as Button; if (button.CommandName == "edit") { int id = Convert.ToInt32(button.CommandArgument); var book = dbContext.Books.Find(id); book.Title = this.TitleTextBox.Text = book.Title; book.Author = this.AuthorTextBox.Text; book.ISBN = this.ISBNTextBox.Text; book.SiteURL = this.UrlTextBox.Text; book.Description = this.DescrTextBox.Text; book.CategoryId = Convert.ToInt32(this.CategoryDropDownList.SelectedValue); } else if (button.CommandName == "delete") { int id = Convert.ToInt32(button.CommandArgument); var book = dbContext.Books.Find(id); dbContext.Books.Remove(book); } else { var book = new Book(); book.Title = this.TitleTextBox.Text; book.Author = this.AuthorTextBox.Text; book.ISBN = this.ISBNTextBox.Text; book.SiteURL = this.UrlTextBox.Text; book.Description = this.DescrTextBox.Text; book.CategoryId = Convert.ToInt32(this.CategoryDropDownList.SelectedValue); dbContext.Books.Add(book); } dbContext.SaveChanges(); this.GridViewBooks.DataBind(); this.BookPanel.Visible = false; }