public ActionResult Create(long book_id, [Bind(Include = "id,series")] Series serie) { if (ModelState.IsValid) { long series_id; BooksController bc = new BooksController(); if (bc.IsInDatabase(serie.series, null, 2) == false) { db.Series.Add(serie); db.SaveChanges(); series_id = serie.id; } else { series_id = db.Series.Where(s => s.series == serie.series).Select(s => s.id).First(); } if (book_id != 0) { Book_Series bs = new Book_Series() { BookId = book_id, SeriesId = series_id }; db.Book_Series.Add(bs); db.TrySaveChanges(); } return(RedirectToAction("Details", "Books", new { id = book_id })); } return(View(serie)); }
public ActionResult Create(long book_id, [Bind(Include = "id,firstName,lastName,birthDate,sex,birthPlace,BIO,photo")] Authors authors) { if (ModelState.IsValid) { long author_id; BooksController bc = new BooksController(); if (bc.IsInDatabase(authors.firstName, authors.lastName, 3) == false) { db.Authors.Add(authors); db.SaveChanges(); author_id = authors.id; } else { author_id = db.Authors.Where(a => a.firstName == authors.firstName && a.lastName == authors.lastName).Select(a => a.id).First(); } if (book_id != 0) { Book_Authors bk = new Book_Authors() { BookId = book_id, AuthorId = author_id }; db.Book_Authors.Add(bk); db.TrySaveChanges(); } return(RedirectToAction("Details", "Books", new { id = book_id })); } return(View(authors)); }
public ActionResult Create(long book_id, [Bind(Include = "id,genre")] Genres genres) { if (ModelState.IsValid) { long genre_id; BooksController bc = new BooksController(); if (bc.IsInDatabase(genres.genre, null, 1) == false) { db.Genres.Add(genres); db.SaveChanges(); genre_id = genres.id; } else { genre_id = db.Genres.Where(g => g.genre == genres.genre).Select(g => g.id).First(); } if (book_id != 0) { Book_Genres bg = new Book_Genres() { BookId = book_id, GenreId = genre_id }; db.Book_Genres.Add(bg); db.TrySaveChanges(); } return(RedirectToAction("Details", "Books", new { id = book_id })); } return(View(genres)); }