private List <Book> ImportBooksFromSpreadsheet(SpreadsheetDataImport importData, List <Author> authors,
List <Series> seriesList, List <PublishingHouse> publishingHouses, List <Category> categories,
List <StoragePlace> storagePlaces)
{
var books = importData.ImportBooksList();
foreach (var book in books)
{
if (!book.Authors.IsNullOrEmpty())
{
var bookAuthors = book.Authors.ToList();
var collection = authors.Where(a
=> bookAuthors.Any(b => b.FirstName == a.FirstName) &&
bookAuthors.Any(b => b.LastName == a.LastName));
book.Authors = new List <Author>(collection);
}
if (book.Series != null)
{
if (string.IsNullOrEmpty(book.Series.SeriesName))
{
book.Series = null;
}
else
{
book.Series = seriesList.First(a => a.SeriesName == book.Series.SeriesName);
}
}
if (book.PublishingHouse != null)
{
book.PublishingHouse =
publishingHouses.First(a => a.PublisherName == book.PublishingHouse.PublisherName);
}
if (!book.Categories.IsNullOrEmpty())
{
var bookCategories = book.Categories.ToList();
var collection = categories.Where(a => bookCategories.Select(c => c.Name).Contains(a.Name));
book.Categories = new List <Category>(collection);
}
if (book.StoragePlace != null)
{
book.StoragePlace =
storagePlaces.First(a => a.StoragePlaceName == book.StoragePlace.StoragePlaceName);
}
}
return(books);
}
