コード例 #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;
     }
 }