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