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