public static List<Book> GetBooks(bool useDB) { DataTable dt; List<Book> books = new List<Book>(); Book book; if (useDB) { dt = DBBookshop.GetBooks(cs); } else { dt = DBBookshop.GetTestData(); } 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; }
public static int UpdateBook(Book book) { try { int rows = DBBookshop.UpdateBook(cs, book.ID, book.Name, book.Author, book.Country, book.Year); return rows; } catch (Exception ex) { throw ex; } }
private void btnNew_Click(object sender, RoutedEventArgs e) { if (btnNew.Content.ToString() == "Uusi") { Book book = new Book(0); book.Name = "Anna kirjan nimi"; spRigth.DataContext = book; btnNew.Content = "Tallenna uusi kirja"; } else { Book book = (Book)spRigth.DataContext; BLBookshop.InsertBook(book); dataGrid.DataContext = BLBookshop.GetBooks(true); btnNew.Content = "Uusi"; } }
public static bool InsertBook(Book book) { try { int rows = DBBookshop.InsertBook(cs, book.Name, book.Author, book.Country, book.Year); if (rows > 0) return true; else return false; } catch (Exception ex) { throw ex; } }
public static bool DeleteBook(Book book) { try { int rows = DBBookshop.DeleteBook(cs, book.ID); if (rows > 0) return true; else return false; } catch (Exception ex) { throw ex; } }