public List <Book> GetAllBooks()
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
return(context.Books.ToList());
}
}
public Book GetBookById(int Id)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
return(context.Books.FirstOrDefault(b => b.Id == Id));
}
}
public List <Author> GetAllAuthors()
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
return(context.Authors.ToList());
}
}
public void AddBook(Book book)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
context.Books.Add(book);
}
}
public Author GetAuthorById(int id)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
return(context.Authors.FirstOrDefault(x => x.Id == id));
}
}
public void AddAuthor(Author author)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
context.Authors.Add(author);
context.SaveChanges();
}
}
public void EditBook(Book book)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
var edited = context.Books.FirstOrDefault(x => x.Id == book.Id);
book.Title = edited.Title;
book.Genre = edited.Genre;
}
}
public void DeleteBook(int Id)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
var book = context.Books.FirstOrDefault(b => b.Id == Id);
context.Books.Remove(book);
context.SaveChanges();
}
}
public void EditAuthor(Author author)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
var edited = context.Authors.FirstOrDefault(x => x.Id == author.Id);
author.FirstName = edited.FirstName;
author.LastName = edited.LastName;
context.SaveChanges();
}
}
public void DeleteAuthor(int Id)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
var match = context.Authors.FirstOrDefault(a => a.Id == Id);
context.Authors.Remove(match);
context.SaveChanges();
}
}
public void DeleteBook(int id)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
var book = context.Books.FirstOrDefault(x => x.Id == id);
if (book != null)
{
context.Books.Remove(book);
}
}
}
public void EditAuthor(Author author)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
var match = context.Authors.FirstOrDefault(a => a.Id == author.Id);
match.FirstName = author.FirstName;
match.LastName = author.LastName;
context.SaveChanges();
}
}
public void EditBook(Book book)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
var match = context.Books.FirstOrDefault(b => b.Id == book.Id);
match.Title = book.Title;
match.Genre = book.Genre;
match.AuthorID = book.AuthorID;
context.SaveChanges();
}
}
public void DeleteAuthor(int id)
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
var author = context.Authors.FirstOrDefault(x => x.Id == id);
if (author != null)
{
context.Authors.Remove(author);
context.SaveChanges();
}
}
}
private void GetFullList()
{
using (AdoNetDBEntities context = new AdoNetDBEntities())
{
var list = context.Authors.Include(a => a.Books).ToList();
foreach (var author in list)
{
foreach (var book in author.Books)
{
Console.WriteLine($"The author {author.FirstName} {author.LastName} wrote the book \"{book.Title}\"");
}
}
}
}
