public async Task <IActionResult> Edit(int id, [Bind("LanguageID,LanguageName")] Language language) { if (id != language.LanguageID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(language); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!LanguageExists(language.LanguageID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(language)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Title,Type,From,TO,Description")] Books books) { if (id != books.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(books); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BooksExists(books.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(books)); }
public async Task <IActionResult> Edit(int id, [Bind("Orderid,Bookid")] OrderList orderList) { ViewData["orderid"] = orderid; if (id != orderList.id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(orderList); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OrderListExists(orderList.id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(orderList)); }
public async Task <IActionResult> Edit(int id, [Bind("IdProducts,ProductsName,Image,Price,Unit")] Products products) { if (id != products.IdProducts) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(products); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProductsExists(products.IdProducts)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(products)); }
public async Task <IActionResult> Edit(int id, [Bind("Name,Price")] Want want) { if (id != want.id) { return(NotFound()); } if (ModelState.IsValid) { try { var userId = User.FindFirst(ClaimTypes.NameIdentifier).Value; if (want.OwnerId != userId) { return(NoContent()); } _context.Update(want); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!WantExists(want.id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(want)); }
public async Task <IActionResult> Edit(int id, [Bind("ContactId,Name,Email,Message,DateCreate")] ContactMe contactMe) { if (id != contactMe.ContactId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(contactMe); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ContactMeExists(contactMe.ContactId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(contactMe)); }
public async Task <IActionResult> Edit(Translator translator) { if (ModelState.IsValid) { _context.Update(translator); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(translator)); }
//problem 14 public static void IncreasePrices(BookShopContext context) { var result = context .Books .Where(b => b.ReleaseDate.Value.Year < 2010) .ToList(); foreach (var b in result) { b.Price += 5; context.Update(b); } context.SaveChanges(); }
public async Task <ActionResult <Book> > Put(Book book) { if (book == null) { return(BadRequest()); } if (!db.Books.Any(x => x.Id == book.Id)) { return(NotFound()); } db.Update(book); await db.SaveChangesAsync(); return(Ok(book)); }
public async Task UpdateBook(Book book) { context.Update(book); }
public async Task <IActionResult> Edit(BooksCreateEditViewModel ViewModel) { ViewBag.LanguageID = new SelectList(_context.Languages, "LanguageID", "LanguageName"); ViewBag.PublisherID = new SelectList(_context.Publishers, "PublisherID", "PublisherName"); ViewBag.AuthorID = new SelectList(_context.Authors.Select(t => new AuthorList { AuthorID = t.AuthorID, NameFamily = t.FirstName + " " + t.LastName }), "AuthorID", "NameFamily"); ViewBag.TranslatorID = new SelectList(_context.Translator.Select(t => new TranslatorList { TranslatorID = t.TranslatorID, NameFamily = t.Name + " " + t.Family }), "TranslatorID", "NameFamily"); ViewModel.SubCategoriesVM = new BooksSubCategoriesViewModel(_repository.GetAllCategories(), ViewModel.CategoryID); if (ModelState.IsValid) { try { DateTime?PublishDate; if (ViewModel.IsPublish == true && ViewModel.RecentIsPublish == false) { PublishDate = DateTime.Now; } else if (ViewModel.RecentIsPublish == true && ViewModel.IsPublish == false) { PublishDate = null; } else { PublishDate = ViewModel.PublishDate; } Book book = new Book() { BookID = ViewModel.BookID, Title = ViewModel.Title, ISBN = ViewModel.ISBN, NumOfPages = ViewModel.NumOfPages, Price = ViewModel.Price, Stock = ViewModel.Stock, IsPublish = ViewModel.IsPublish, LanguageID = ViewModel.LanguageID, PublisherID = ViewModel.PublisherID, PublishYear = ViewModel.PublishYear, Summary = ViewModel.Summary, Weight = ViewModel.Weight, PublishDate = PublishDate, Delete = false, }; _context.Update(book); var RecentAuthors = (from a in _context.Author_Books where (a.BookID == ViewModel.BookID) select a.AuthorID).ToArray(); var RecentTranslators = (from a in _context.Book_Translators where (a.BookID == ViewModel.BookID) select a.TranslatorID).ToArray(); var RecentCategories = (from c in _context.Book_Categories where (c.BookID == ViewModel.BookID) select c.CategoryID).ToArray(); var DeletedAuthors = RecentAuthors.Except(ViewModel.AuthorID); var DeletedTranslators = RecentTranslators.Except(ViewModel.TranslatorID); var DeletedCategories = RecentCategories.Except(ViewModel.CategoryID); var AddedAuthors = ViewModel.AuthorID.Except(RecentAuthors); var AddedTranslators = ViewModel.TranslatorID.Except(RecentTranslators); var AddedCategories = ViewModel.CategoryID.Except(RecentCategories); if (DeletedAuthors.Count() != 0) { _context.RemoveRange(DeletedAuthors.Select(a => new Author_Book { AuthorID = a, BookID = ViewModel.BookID }).ToList()); } if (DeletedTranslators.Count() != 0) { _context.RemoveRange(DeletedTranslators.Select(a => new Book_Translator { TranslatorID = a, BookID = ViewModel.BookID }).ToList()); } if (DeletedCategories.Count() != 0) { _context.RemoveRange(DeletedCategories.Select(a => new Book_Category { CategoryID = a, BookID = ViewModel.BookID }).ToList()); } if (AddedAuthors.Count() != 0) { _context.AddRange(AddedAuthors.Select(a => new Author_Book { AuthorID = a, BookID = ViewModel.BookID }).ToList()); } if (AddedTranslators.Count() != 0) { _context.AddRange(AddedTranslators.Select(a => new Book_Translator { TranslatorID = a, BookID = ViewModel.BookID }).ToList()); } if (AddedCategories.Count() != 0) { _context.AddRange(AddedCategories.Select(a => new Book_Category { CategoryID = a, BookID = ViewModel.BookID }).ToList()); } await _context.SaveChangesAsync(); ViewBag.MsgSuccess = "ذخیره تغییرات با موفقیت انجام شد."; return(View(ViewModel)); } catch { ViewBag.MsgFailed = "در ذخیره تغییرات خطایی رخ داده است."; return(View(ViewModel)); } } else { ViewBag.MsgFailed = "اطلاعات فرم نامعتبر است."; return(View(ViewModel)); } }
public async Task <IActionResult> Edit(BooksCreateEditViewModel ViewModel) { ViewBag.LanguageID = new SelectList(_context.Languages, "LanguageID", "LanguageName"); ViewBag.PublisherID = new SelectList(_context.Publishers, "PublisherID", "PublisherName"); if (ModelState.IsValid) { try { DateTime?PublishDate; if (ViewModel.IsPublish == true && ViewModel.RecentIsPublish == false) { PublishDate = DateTime.Now; } else if (ViewModel.RecentIsPublish == true && ViewModel.IsPublish == false) { PublishDate = null; } else { PublishDate = ViewModel.PublishDate; } Book book = new Book() { BookID = ViewModel.BookID, LanguageID = ViewModel.LanguageID, PublisherID = ViewModel.PublisherID, PublishYear = ViewModel.PublishYear, }; _context.Update(book); var RecentCategories = (from c in _context.Book_Categories where (c.BookID == ViewModel.BookID) select c.CategoryID).ToArray(); var DeletedCategories = RecentCategories.Except(ViewModel.CategoryID); var AddedCategories = ViewModel.CategoryID.Except(RecentCategories); if (DeletedCategories.Count() != 0) { _context.RemoveRange(DeletedCategories.Select(a => new Book_Category { CategoryID = a, BookID = ViewModel.BookID }).ToList()); } if (AddedCategories.Count() != 0) { _context.AddRange(AddedCategories.Select(a => new Book_Category { CategoryID = a, BookID = ViewModel.BookID }).ToList()); } await _context.SaveChangesAsync(); ViewBag.MsgSuccess = "ذخیره تغییرات با موفقیت انجام شد."; return(View(ViewModel)); } catch { ViewBag.MsgFailed = "در ذخیره تغییرات خطایی رخ داده است."; return(View(ViewModel)); } } else { ViewBag.MsgFailed = "اطلاعات فرم نامعتبر است."; return(View(ViewModel)); } }