private void RemoveBookButton_Click(object sender, EventArgs e) { if (BooksToEditGrid.SelectedRows.Count == 0) { return; } using (LibraryDBEntities dBContext = new LibraryDBEntities()) { List <Book> books = dBContext.Books.ToList(); int id = Convert.ToInt32(BooksToEditGrid.SelectedRows[0].Cells[5].Value); foreach (Book book in books) { if (book.Book_Id == id) { dBContext.Books.Remove(book); } } dBContext.SaveChanges(); DataGridViewRow rowToDelete = BooksToEditGrid.SelectedRows[0]; BooksToEditGrid.Rows.Remove(rowToDelete); BooksToEditGrid.ClearSelection(); } }
private void UpdateBookButton_Click(object sender, EventArgs e) { bool isChanged = false; string newBookTitle = EditBookTitleTextbox.Text; string newBookAutor = EditAutorTextbox.Text; string newBookGenre = EditGenreTextbox.Text; string newBookYear = EditYearTextbox.Text; string newBookPublication = EditPublicationTextbox.Text; using (LibraryDBEntities dbContex = new LibraryDBEntities()) { if (BooksToEditGrid.SelectedRows.Count == 0) { return; } int id = Convert.ToInt32(BooksToEditGrid.SelectedRows[0].Cells[5].Value); Book book = dbContex.Books.SingleOrDefault(b => b.Book_Id == id); if (book != null) { if (newBookTitle != null && newBookTitle.Trim().Length > 0) { book.Name = newBookTitle; BooksToEditGrid.SelectedRows[0].Cells[0].Value = newBookTitle; } if (newBookAutor != null && newBookAutor.Trim().Length > 0) { book.Autor = newBookAutor; BooksToEditGrid.SelectedRows[0].Cells[1].Value = newBookAutor; } if (newBookGenre != null && newBookGenre.Trim().Length > 0) { book.Genre = newBookGenre; BooksToEditGrid.SelectedRows[0].Cells[2].Value = newBookGenre; } if (newBookYear != null && newBookYear.Trim().Length > 0) { int num; if (!int.TryParse(EditYearTextbox.Text, out num)) { MessageBox.Show("Incorrect year!", "Error"); return; } book.Year = newBookYear; BooksToEditGrid.SelectedRows[0].Cells[3].Value = newBookYear; } if (newBookPublication != null && newBookPublication.Trim().Length > 0) { book.Publication = newBookPublication; BooksToEditGrid.SelectedRows[0].Cells[4].Value = newBookPublication; } isChanged = true; dbContex.SaveChanges(); } BooksToEditGrid.Refresh(); EditBookTitleTextbox.Clear(); EditAutorTextbox.Clear(); EditGenreTextbox.Clear(); EditYearTextbox.Clear(); EditPublicationTextbox.Clear(); if (isChanged) { MessageBox.Show("Information changed successfuly", "Success", MessageBoxButtons.OK); } } }