public ActionResult Add(Author author)
{
db.Authors.Add(author);
db.SaveChanges();
return(Redirect("/Author?AuthorId=" + author.AuthorId));
}
public ActionResult Edit(Book book, int[] selectedGenres, int[] selectedAuthors)
{
Book newBook = db.Books.Find(book.BookId);
newBook.Title = book.Title;
newBook.Description = book.Description;
newBook.NumberOfPage = book.NumberOfPage;
newBook.YearOfPublishing = book.YearOfPublishing;
newBook.PublishingHouse = db.PublishingHouses.Find(2);
newBook.Genre.Clear();
if (selectedGenres != null)
{
//получаем выбранные жанры
foreach (var g in db.Genres.Where(gen => selectedGenres.Contains(gen.GenreId)))
{
newBook.Genre.Add(g);
}
}
newBook.Author.Clear();
if (selectedAuthors != null)
{
//Получаем выбраных авторов
foreach (var c in db.Authors.Where(co => selectedAuthors.Contains(co.AuthorId)))
{
newBook.Author.Add(c);
}
}
db.Entry(newBook).State = EntityState.Modified;
db.SaveChanges();
return(Redirect("/Book?BookId=" + book.BookId));
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new LibOnlineContext(
serviceProvider.GetRequiredService <DbContextOptions <LibOnlineContext> >()
))
{
if (context.Book.Any() || context.Borrower.Any())
{
return;
}
context.Borrower.AddRange(
new Borrower
{
FirstName = "John",
LastName = "Doe",
City = "Stortorg",
StreetAdress = "Storgatan 1",
PostalCode = "123 45",
Phone = "08-123 456 78",
Email = "*****@*****.**"
},
new Borrower
{
FirstName = "Jane",
LastName = "Doe",
City = "Stortorg",
StreetAdress = "Storgatan 2",
PostalCode = "123 45",
Phone = "08-123 456 78",
Email = "*****@*****.**"
},
new Borrower
{
FirstName = "Erik",
LastName = "Eriksson",
City = "Stortorg",
StreetAdress = "Storgatan 3",
PostalCode = "123 45",
Phone = "08-123 456 78",
Email = "*****@*****.**"
},
new Borrower
{
FirstName = "Karl",
LastName = "Karlsson",
City = "Stortorg",
StreetAdress = "Storgatan 4",
PostalCode = "123 45",
Phone = "08-123 456 78",
Email = "*****@*****.**"
},
new Borrower
{
FirstName = "Sven",
LastName = "Svensson",
City = "Stortorg",
StreetAdress = "Storgatan 5",
PostalCode = "123 45",
Phone = "08-123 456 78",
Email = "*****@*****.**"
}
);
context.SaveChanges();
context.Book.AddRange(
new Book
{
Title = "Liftarens Guide till Galaxen",
Author = "Adam Douglas",
Borrower = context.Borrower.Find(1),
ReturnDate = DateTime.Now.AddDays(-3)
},
new Book
{
Title = "Resturangen vid slutet av universum",
Author = "Adam Douglas",
Borrower = context.Borrower.Find(2),
ReturnDate = DateTime.Now.AddDays(30)
},
new Book
{
Title = "Livet, universum och allting",
Author = "Adam Douglas",
Borrower = context.Borrower.Find(3)
},
new Book
{
Title = "Flickan som lekte med elden",
Author = "Stieg Larsson",
Borrower = context.Borrower.Find(4),
ReturnDate = DateTime.Now.AddDays(-30)
},
new Book
{
Title = "C# 7.0 in a Nutshell",
Author = "Joseph Albahari, Ben Albahari",
Borrower = context.Borrower.Find(5),
ReturnDate = DateTime.Now.AddDays(-30)
},
new Book
{
Title = "Skarp programmering med C#",
Author = "Sven Svensson",
Borrower = context.Borrower.Find(5),
ReturnDate = DateTime.Now.AddDays(-5)
},
new Book
{
Title = "How to Solve It",
Author = "Georg Polya"
},
new Book
{
Title = "Grit : Konsten att inte ge upp",
Author = "Angela Duckworth"
}
);
context.SaveChanges();
}
}
