public static int AddGenre(string genreName)
{
using (var context = new BookCatalogContext())
{
Genre newGenre = new Genre {
Name = genreName
};
context.Genres.Add(newGenre);
context.SaveChanges();
Console.WriteLine($"Added genre {genreName}");
return(newGenre.Id);
}
}
public static int AddAuthor(string firstName, string lastName)
{
using (var context = new BookCatalogContext())
{
Author newAuthor = new Author {
FirstName = firstName, LastName = lastName
};
context.Authors.Add(newAuthor);
context.SaveChanges();
Console.WriteLine($"Added author {firstName} {lastName}");
return(newAuthor.Id);
}
}
public static void AddBook(BookDTO book)
{
int genreId = GetGenreId(book.Genre);
int authorId = GetAuthorId(book.Author);
using (var context = new BookCatalogContext())
{
Book bookInDB = context.Books
.SingleOrDefault(b => b.RefNumber == book.RefNumber &&
b.Title == book.Title &&
b.AuthorId == authorId);
if (bookInDB == null) // add new book
{
Book newBook = new Book();
newBook.RefNumber = book.RefNumber;
newBook.Title = book.Title;
newBook.AuthorId = authorId;
newBook.Price = book.Price;
newBook.DatePublished = book.DatePublished;
newBook.Description = book.Description;
newBook.Genres = new[] { context.Genres.Find(genreId) };
context.Books.Add(newBook);
Console.Write($"Added book ");
}
else // update book
{
bookInDB.Price = book.Price;
bookInDB.DatePublished = book.DatePublished;
bookInDB.Description = book.Description;
if (bookInDB.Genres.FirstOrDefault(g => g.Id == genreId) == null)
{
bookInDB.Genres.Add(context.Genres.Find(genreId));
}
Console.Write($"Updated book ");
}
Console.WriteLine($"{book.Title} ({book.Author})");
context.SaveChanges();
}
}