Exemplo n.º 1
0
        private static void CreateAndAddReviewInDb(
            BookStoreDBEntities db, ICollection<Author> authors, ICollection<Rewiew> reviews,
            string title, string isbn, decimal price, string webSite)
        {
            var bookInDb = (from b in db.Books
                            where b.BookTitle == title
                            select b).FirstOrDefault();

            if (bookInDb == null)
            {
                foreach (var a in authors)
                {
                    CreateAndAddBookInDb(db, a.AuthorName, title, isbn, price, webSite);
                }
            }

            bookInDb = (from b in db.Books
                        where b.BookTitle == title
                        select b).FirstOrDefault();

            if (authors != null)
            {
                foreach (var a in authors)
                {
                    bookInDb.Authors.Add(a);
                    db.SaveChanges();
                }
            }

            if (reviews != null)
            {
                foreach (var review in reviews)
                {
                    bookInDb.Rewiews.Add(review);
                    db.Rewiews.Add(review);
                    db.SaveChanges();
                }
            }
        }
Exemplo n.º 2
0
        private static void CreateAndAddBookInDb(
            BookStoreDBEntities db, string author, string title, string isbn, decimal price, string webSite)
        {
            ICollection<Author> bookAuthors = new List<Author>();

            // Check is title exist
            var titleInDb = (from bookDb in db.Books
                             where bookDb.BookTitle == title
                             select bookDb).FirstOrDefault();

            var authorInDb = (from authorDb in db.Authors
                              where authorDb.AuthorName == author
                              select authorDb).FirstOrDefault();

            if (titleInDb != null && authorInDb != null)
            {
                return;
            }

            if (authorInDb == null)
            {
                Author newAuthor = new Author() { AuthorName = author };
                db.Authors.Add(newAuthor);
                db.SaveChanges();
                bookAuthors.Add(newAuthor);

                if (titleInDb != null)
                {
                    titleInDb.Authors.Add(newAuthor);
                }
            }

            Book newBook = new Book() { Authors = bookAuthors, BookTitle = title };

            if (isbn != null)
            {
                newBook.ISBN = isbn;

                var isbnInDb = (from b in db.Books
                                where b.ISBN == isbn
                                select b).FirstOrDefault();

                if (isbnInDb != null)
                {
                    throw new ApplicationException("Duplicated ISBN");
                }
            }

            if (price != 0m)
            {
                newBook.Price = price;
            }

            if (webSite != null)
            {
                newBook.WebSite = webSite;
            }

            db.Books.Add(newBook);
            db.SaveChanges();
        }
Exemplo n.º 3
0
        private static void ParseComplexXml()
        {
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.Load("../../complex-books.xml");

            var books = xmlDoc.DocumentElement.ChildNodes;
            
            using (var db = new BookStoreDBEntities())
            {
                foreach (XmlNode book in books)
                {
                    TransactionScope tran = new TransactionScope(
                        TransactionScopeOption.Required,
                        new TransactionOptions()
                        {
                            IsolationLevel = IsolationLevel.RepeatableRead
                        });
                    using (tran)
                    {
                        string title = book["title"].InnerText.Trim();

                        ICollection<Author> authors = null;
                        if (book.SelectSingleNode("authors") != null)
                        {
                            authors = new List<Author>();

                            foreach (XmlNode author in book.SelectSingleNode("authors").ChildNodes)
                            {
                                string authorName = null;

                                if (author.InnerText != null)
                                {
                                    authorName = author.InnerText.Trim();
                                }

                                var authorInDb = (from a in db.Authors
                                                  where a.AuthorName == authorName
                                                  select a).FirstOrDefault();

                                if (authorInDb == null && authorName != null)
                                {
                                    Author newAuthor = new Author() { AuthorName = authorName };
                                    db.Authors.Add(newAuthor);
                                    db.SaveChanges();
                                    authors.Add(newAuthor);
                                }
                            }
                        }

                        string webSite = null;

                        if (book.SelectSingleNode("web-site") != null)
                        {
                            webSite = book["web-site"].InnerText.Trim();
                        }

                        ICollection<Rewiew> reviews = null;
                        if (book.SelectSingleNode("reviews") != null)
                        {
                            reviews = new List<Rewiew>();

                            foreach (XmlNode review in book.SelectSingleNode("reviews").ChildNodes)
                            {
                                Rewiew currentReview = new Rewiew();

                                string reviewText = null;

                                if (review.InnerText != null)
                                {
                                    reviewText = review.InnerText.Trim();
                                    currentReview.RewiewText = reviewText;
                                }

                                string authorName = null;
                                if (review.Attributes["author"] != null)
                                {
                                    authorName = review.Attributes["author"].Value;
                                }

                                if (authorName != null)
                                {
                                    authorName = authorName.Trim();
                                    var authorInDb = (from a in db.Authors
                                                      where a.AuthorName == authorName
                                                      select a).FirstOrDefault();

                                    if (authorInDb == null)
                                    {
                                        Author newAuthor = new Author() { AuthorName = authorName };
                                        db.Authors.Add(newAuthor);
                                        db.SaveChanges();
                                        currentReview.Author = newAuthor;
                                    }
                                    else
                                    {
                                        currentReview.Author = authorInDb;
                                    }
                                }

                                DateTime reviewDate = DateTime.Now;

                                if (review.Attributes["date"] != null)
                                {
                                    reviewDate = DateTime.Parse(review.Attributes["date"].Value);
                                }

                                currentReview.RewiewDate = reviewDate;

                                reviews.Add(currentReview);
                            }
                        }

                        string isbn = null;

                        if (book.SelectSingleNode("isbn") != null)
                        {
                            isbn = book["isbn"].InnerText.Trim();
                        }

                        decimal price = 0m;

                        if (book.SelectSingleNode("price") != null)
                        {
                            price = decimal.Parse(book["price"].InnerText.Trim(), CultureInfo.InvariantCulture);
                        }

                        CreateAndAddReviewInDb(db, authors, reviews, title, isbn, price, webSite);

                        tran.Complete();
                    }
                }
            }
        }