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";
     }
 }
Beispiel #2
0
        public static List<Book> GetBooks(bool useDB) {
            try {
                DataTable dt;
                List<Book> books = new List<Book>();
                if (useDB) {
                    dt = DBBookShop.GetBooks(cs);
                } else {
                    dt = DBBookShop.GetTestData();
                }
                Book book;
                foreach (DataRow row in dt.Rows) {
                    book = new Book((int)row[0]);
                    book.Name = row["name"].ToString();
                    book.Author = row["author"].ToString();
                    book.Country = row["country"].ToString();
                    book.Year = (int)row["year"];
                    books.Add(book);
                }
                return books;
            } catch (Exception ex) {

                throw ex;
            }
        }
Beispiel #3
0
        public static int UpdateBook(Book book) {
            try {
                int lkm = DBBookShop.UpdateBook(cs, book.ID, book.Name, book.Author, book.Country, book.Year);
                return lkm;
            } catch (Exception ex) {

                throw ex;
            }
        }
Beispiel #4
0
        public static bool DeleteBook(Book book) {
            try {
                int lkm = DBBookShop.DeleteBook(cs, book.ID);
                if (lkm > 0) {
                    return true;
                } else {
                    return false;
                }
            } catch (Exception ex) {

                throw ex;
            }
        }
Beispiel #5
0
        public static bool InsertBook(Book book) {
            try {
                int lkm = DBBookShop.InsertBook(cs, book.Name, book.Author, book.Country, book.Year);
                if (lkm > 0) {
                    return true;
                } else {
                    return false;
                }
            } catch (Exception ex) {

                throw ex;
            }
        }
Beispiel #6
0
 public static List<Book> GetBooks(bool useDB)
 {
     try
     {
         DataTable dt;
         List<Book> books = new List<Book>();
         if (useDB)
         {
             //pyydetään DB-kerrokselta kirjojen tiedot
             dt = DBBookshop.GetBooks(cs);
         }
         else
         {
             dt = DBBookshop.GetTestData();
         }
         //ORM = muutetaan datatablen rivit olioiksi
         Book book;
         foreach (DataRow row in dt.Rows)
         {
             book = new Book((int)row[0]);
             book.Name = row["name"].ToString();
             book.Author = row["author"].ToString();
             book.Country = row["country"].ToString();
             book.Year = (int)row["year"];
             books.Add(book);
         }
         //palautus
         return books;
     }
     catch (Exception ex)
     {
        
         throw ex;
     }
 }
Beispiel #7
0
        public static bool Deletebook(Book book)
        {
            try
            {
                int lkm = DBBookshop.DeleteBook(cs, book.ID);
                if (lkm > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception)
            {

                throw;
            }
        }