public async Task <ActionResult <Publisher> > PostPublisherDetails()
{
var publisher = new Publisher();
publisher.PublisherName = "Harper & Brothers";
publisher.City = "New York City";
publisher.State = "NY";
publisher.Country = "USA";
Book book1 = new Book();
book1.Title = "Good night moon - 1";
book1.PublishedDate = DateTime.Now;
Book book2 = new Book();
book2.Title = "Good night moon - 2";
book2.PublishedDate = DateTime.Now;
Sale sale1 = new Sale();
sale1.Quantity = 2;
sale1.StoreId = "8042";
sale1.OrderNum = "XYZ";
sale1.PayTerms = "Net 30";
sale1.OrderDate = DateTime.Now;
Sale sale2 = new Sale();
sale2.Quantity = 2;
sale2.StoreId = "7131";
sale2.OrderNum = "QA879.1";
sale2.PayTerms = "Net 30";
sale2.OrderDate = DateTime.Now;
book1.Sale.Add(sale1);
book2.Sale.Add(sale2);
publisher.Book.Add(book1);
publisher.Book.Add(book2);
_context.Add(publisher);
_context.SaveChanges();
var publishers = await _context.Publisher
.Include(pub => pub.Book)
.ThenInclude(book => book.Sale)
.Include(pub => pub.User)
.ThenInclude(user => user.Job)
.Where(pub => pub.PubId == publisher.PubId)
.FirstOrDefaultAsync();
if (publisher == null)
{
return(NotFound());
}
return(publishers);
}
public async Task <IActionResult> Create([Bind("AuthorId,LastName,FirstName,Phone,Address,City,State,Zip,EmailAddress")] Author author)
{
if (ModelState.IsValid)
{
_context.Add(author);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(author));
}
public async Task <IActionResult> Create([Bind("BookId,Title,Type,PubId,Price,Advance,Royalty,YtdSales,Notes,PublishedDate")] Book book)
{
if (ModelState.IsValid)
{
_context.Add(book);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PubId"] = new SelectList(_context.Publisher, "PubId", "PubId", book.PubId);
return(View(book));
}