public void AddToNewspaperList(Newspaper newspaper)
{
int newspaperId = _databaseOperation.AddNewspaperToDb(_connectionString, "Newspapers", newspaper);
foreach (Book article in newspaper.Articles)
{
_databaseOperation.AddBookToDb(_connectionString, "NewspaperArticles", article, newspaperId, "NewspaperId");
}
}
public void AddToMagazineList(Magazine magazine)
{
int magazineId = _databaseOperation.AddMagazineToDb(_connectionString, "Magazines", magazine);
foreach (Book article in magazine.Articles)
{
_databaseOperation.AddBookToDb(_connectionString, "MagazineArticles", article, magazineId, "MagazineId");
}
}
public string SaveInDB(List <Book> list)
{
int countAddedBooks = 0;
foreach (Book book in list)
{
if (_databaseOperation.AddBookToDb(_connectionString, "Books", book))
{
countAddedBooks++;
}
}
if (countAddedBooks > 0)
{
return("Successfuly saved!");
}
return("Not saved!");
}