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));
}
