Beispiel #1
0
 private void btnNew_Click(object sender, RoutedEventArgs e)
 {
     if(btnNew.Content.ToString() == "Uusi")
     { 
         //luodaan uusi kirja olio
         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 bool InsertBook(Book book)
        {
            try
            {
                int lkm = DBShop.InsertBook(cs, book.Name, book.Author, book.Country, book.Year);
                if (lkm > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception ex)
            {

                throw ex;
            }
        }
Beispiel #3
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 = DBShop.GetBooks(cs);
                }
                else
                {
                    dt = DBShop.GetTestData();
                }
                Book book;
                //ORM = muutetaan datatalen rivit olioiksi
                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 #4
0
        public static int UpdateBook(Book book)
        {
            try
            {
                int lkm = DBShop.UpdateBook(cs, book.ID, book.Name, book.Author, book.Country, book.Year);
                return lkm;
            }
            catch (Exception ex)
            {

                throw ex;
            }
        }