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();
}
}