public void AllUnChecked() { using (var db = new BooksDbContext()) { db.Publishers.ToList().ForEach(x => x.IsChecked = false); db.SaveChanges(); } }
public void AllChecked() { using (var db = new BooksDbContext()) { db.Books.ToList().ForEach(x => x.IsChecked = true); db.SaveChanges(); } }
public void UpdateIsCheckedPublisher(Publisher p, bool isChecked) { using (var db = new BooksDbContext()) { var publisher = db.Publishers.Single(x => x.Id == p.Id); publisher.IsChecked = isChecked; db.SaveChanges(); } }
public void UpdateIsCheckedAuthor(Author a, bool isChecked) { using (var db = new BooksDbContext()) { var author = db.Authors.Single(x => x.Id == a.Id); author.IsChecked = isChecked; db.SaveChanges(); } }
public void UpdateIsCheckedBook(Book b, bool isChecked) { using (var db = new BooksDbContext()) { var book = db.Books.Single(x => x.Id == b.Id); book.IsChecked = isChecked; db.SaveChanges(); } }
public void UpdatePublisher(Publisher p) { using (var db = new BooksDbContext()) { var publisher = db.Publishers.Single(x => x.Id == p.Id); publisher.Name = p.Name; publisher.Address = p.Address; publisher.IsChecked = p.IsChecked; db.SaveChanges(); } }
public void DeletePublishers() { using (var db = new BooksDbContext()) { var publishers = db.Publishers.Where(x => x.IsChecked == true); if (publishers != null) { db.Publishers.RemoveRange(publishers); db.SaveChanges(); } } }
public void DeletePublisher(int id) { using (var db = new BooksDbContext()) { var publisher = db.Publishers.SingleOrDefault(x => x.Id == id); if (publisher != null) { db.Publishers.Remove(publisher); db.SaveChanges(); } } }
public void DeleteBook(int id) { using (var db = new BooksDbContext()) { var book = db.Books.SingleOrDefault(x => x.Id == id); if (book != null) { db.Books.Remove(book); db.SaveChanges(); } } }
public void DeleteBooks() { using (var db = new BooksDbContext()) { var books = db.Books.Where(x => x.IsChecked == true); if (books != null) { db.Books.RemoveRange(books); db.SaveChanges(); } } }
public void UpdateAuthor(Author a) { using (var db = new BooksDbContext()) { var author = db.Authors.Single(x => x.Id == a.Id); author.Name = a.Name; author.Birthday = a.Birthday; author.Gender = a.Gender; author.IsChecked = a.IsChecked; db.SaveChanges(); } }
public void DeleteAuthor(int id) { using (var db = new BooksDbContext()) { var author = db.Authors.SingleOrDefault(x => x.Id == id); if (author != null) { db.Authors.Remove(author); db.SaveChanges(); } } }
public void InsertPublisher(Publisher p) { using (var db = new BooksDbContext()) { var publisher = new Publisher { Name = p.Name, Address = p.Address, IsChecked = p.IsChecked }; db.Publishers.Add(publisher); db.SaveChanges(); } }
public void InsertAuthor(Author a) { using (var db = new BooksDbContext()) { var author = new Author { Name = a.Name, Birthday = a.Birthday, Gender = a.Gender, IsChecked = a.IsChecked }; db.Authors.Add(author); db.SaveChanges(); } }
public void UpdateBook(Book b) { using (var db = new BooksDbContext()) { var book = db.Books.Single(x => x.Id == b.Id); var author = db.Authors.Single(a => a.Id == b.Author.Id); var publisher = db.Publishers.Single(p => p.Id == b.Publisher.Id); book.Title = b.Title; book.Author = author; book.PublishedYear = b.PublishedYear; book.Publisher = publisher; book.IsChecked = b.IsChecked; db.SaveChanges(); } }
public void InsertBook(Book b) { using (var db = new BooksDbContext()) { var author = db.Authors.Single(a => a.Id == b.Author.Id); var publisher = db.Publishers.Single(p => p.Id == b.Publisher.Id); var book = new Book { Title = b.Title, Author = author, PublishedYear = b.PublishedYear, Publisher = publisher, IsChecked = b.IsChecked }; db.Books.Add(book); db.SaveChanges(); } }