예제 #1
0
 public static List<Book> GetBooks(Boolean useDB)
 {
     DataTable dt;
     List<Book> temp = new List<Book>();
     if (useDB)
     {
         dt = DBBooks.GetBooks(cs);
     }
     else
     {
         dt = DBBooks.GetTestData();
     }
     // tehdään ORM eli datatablen rivit muutetaan olioiksi
     Book book;
     foreach (DataRow dr in dt.Rows)
     {
         book = new Book((int)dr[0]);
         book.Name = dr["name"].ToString();
         book.Author = dr["author"].ToString();
         book.Country = dr["country"].ToString();
         book.Year = (int)dr["year"];
         // olio lisätään kokoelmaan
         temp.Add(book);
     }
     return temp;
 }
예제 #2
0
 public static void UpdateBook(Book book)
 {
     try
     {
         int lkm = DBBooks.UpdateBook(cs, book.Id, book.Name, book.Author, book.Country, book.Year);
     }
     catch (Exception)
     {
         throw;
     }
 }