static void AddAuthor(Authors aut)
{
using (PublishingHouseEntities db = new PublishingHouseEntities())
{
db.Authors.Add(aut);
db.SaveChanges();
Console.WriteLine("New author with name " + aut.FirstName + " " + aut.LastName + " added");
}
}
static void AddBook(Books _book)
{
using (PublishingHouseEntities db = new PublishingHouseEntities())
{
Books currbook = db.Books.Where(b => b.NameBook == _book.NameBook).FirstOrDefault();
if (currbook == null)
{
db.Books.Add(_book);
db.SaveChanges();
Console.WriteLine("Книга добавлена");
}
}
}
static void AddTheme(Themes theme)
{
using (PublishingHouseEntities db = new PublishingHouseEntities())
{
Themes t = db.Themes.Where(h => h.NameTheme == theme.NameTheme).FirstOrDefault();
if (t == null)
{
db.Themes.Add(theme);
db.SaveChanges();
Console.WriteLine("Тема добавлена");
}
}
}