Esempio n. 1
0
        public void Update(BOOK bookObj)
        {
            using (var db = new LibDb())
            {
                var b = db.BOOKs.Include(x => x.AUTHORs).ToList().Find(d => d.ISBN ==
                                                                       bookObj.ISBN);
                b.AUTHORs.Clear();

                db.SaveChanges();
            }

            var newAuthors = bookObj.AUTHORs;

            bookObj.AUTHORs = new List <AUTHOR>();

            using (var db = new LibDb())
            {
                db.BOOKs.Attach(bookObj);
                db.Entry(bookObj).State = EntityState.Modified;

                foreach (var author in newAuthors)
                {
                    db.AUTHORs.Attach(author);
                    bookObj.AUTHORs.Add(author);
                }
                db.SaveChanges();
            }
        }
Esempio n. 2
0
        public void Update(AUTHOR authorObj)
        {
            using (var db = new LibDb())
            {
                var b = db.AUTHORs.Include(x => x.BOOKs).ToList().Find(d => d.Aid ==
                                                                       authorObj.Aid);
                b.BOOKs.Clear();

                db.SaveChanges();
            }

            var newBooks = authorObj.BOOKs;

            authorObj.BOOKs = new List <BOOK>();

            using (var db = new LibDb())
            {
                db.AUTHORs.Attach(authorObj);
                db.Entry(authorObj).State = EntityState.Modified;

                foreach (var book in newBooks)
                {
                    db.BOOKs.Attach(book);
                    authorObj.BOOKs.Add(book);
                }

                db.SaveChanges();
            }
        }
Esempio n. 3
0
 public void Update(USER user)
 {
     using (var db = new LibDb())
     {
         db.USERs.Attach(user);
         db.Entry(user).State = EntityState.Modified;
         db.SaveChanges();
     }
 }