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("Тема добавлена"); } } }