private void getBooksSQL_Click(object sender, RoutedEventArgs e) { try { dgBooks.DataContext = Bookshop.GetBooks(true); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnGetServerBooks_Click(object sender, RoutedEventArgs e) { try { //haetaan kirjat BL-kerroksesta dgBooks.DataContext = Bookshop.GetBooks(true); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { Book current = (Book)spBook.DataContext; if (Bookshop.UpdateBook(current) > 0) { MessageBox.Show(string.Format("Kirja {0} päivitetty tietokantaan onnistuneesti.", current.ToString())); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { Book current = (Book)spBook.DataContext; var retval = MessageBox.Show("Haluatko varmasti poistaa kirjan" + current.ToString(), "BookShop", MessageBoxButton.YesNo); if (retval == MessageBoxResult.Yes) { Bookshop.DeleteBook(current); dgBooks.DataContext = Bookshop.GetBooks(true); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { //mistä tiedetään mitä muokata --> Book-olion ID:stä! try { Book current = (Book)spBooks.DataContext; if (Bookshop.UpdateBook(current) > 0) { tbMessage.Text = string.Format("Kirja {0} päivitetty onnistuneesti", current.ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { //Mistä tiedetään mitä muokata? ----> Book-olio ID:stä! try { Book current = (Book)spBooks.DataContext; if (Bookshop.UpadeBook(current) > 0) { MessageBox.Show(string.Format("kirjat päivitetty onnistuneesti")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnNew_Click(object sender, RoutedEventArgs e) { if (btnNew.Content.ToString() == "Uusi") { Book newBook = new Book(0); newBook.Name = "Anna kirjan nimi"; spBook.DataContext = newBook; btnNew.Content = "Tallenna uusi kantaan"; } else { Book current = (Book)spBook.DataContext; Bookshop.InsertBook(current); dgBooks.DataContext = Bookshop.GetBooks(true); MessageBox.Show(string.Format("Kirja {0} tallennettu kantaan onnistuneesti", current.ToString())); btnNew.Content = "Uusi"; } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { //Poistetaan valittu kirja Book current = (Book)spBooks.DataContext; var retval = MessageBox.Show("Haluatko varmasti poistaa kirjan" + current.ToString(), "Wanhat kirjat kysyy", MessageBoxButton.YesNo); if (retval == MessageBoxResult.Yes) { Bookshop.DeleteBook(current); dgBooks.DataContext = Bookshop.GetBooks(true); MessageBox.Show(string.Format("kirjat {0} poistettu tietokannasta", current.ToString())); } else { } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnGetTestBooks_Click(object sender, RoutedEventArgs e) { dgBooks.DataContext = Bookshop.GetTestBooks(); }