Esempio n. 1
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();
         }
         // OMR 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;
     }
 }
Esempio n. 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;
     }
 }