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