Exemple #1
0
        public static Book getBook(int bookID)
        {
            Book book;

            using (TestDbContext db = new TestDbContext())
            {
                //book db depends on course db
                if (db.Courses.Count() == 0)
                {
                    CourseUtils.initCourseDb(db);
                }

                //initialize book table if needed
                if (db.Books.Count() == 0)
                {
                    initBookDb(db);
                }

                book = db.Books.Find(bookID);

                if (book == null)
                {
                    //no book with the given ID, report error?
                }
                else
                {
                    //This line is needed because LINQ requests are lazily loaded and the
                    //TestDbContext was being destroyed before the Course was being resolved.
                    //The same thing will need to be done for all foreign key lookups.
                    book.Course = book.Course;
                }
            }

            return(book);
        }
Exemple #2
0
        public static Listing getListing(int listingID)
        {
            Listing listing;

            using (TestDbContext db = new TestDbContext())
            {
                //book db depends on course db
                if (db.Courses.Count() == 0)
                {
                    CourseUtils.initCourseDb(db);
                }

                //initialize book table if needed
                if (db.Books.Count() == 0)
                {
                    BookUtils.initBookDb(db);
                }

                //initialize listing table if needed
                if (db.Listings.Count() == 0)
                {
                    initListingDb(db);
                }

                listing = db.Listings.Find(listingID);

                if (listing != null)
                {
                    //due to lazy loading, resolve all foreign key references
                    //listing.UserProfile = listing.UserProfile;
                    listing.Book        = listing.Book;
                    listing.Book.Course = listing.Book.Course;
                }
                else
                {
                    //no listing with the given ID, report error?
                }
            }

            return(listing);
        }