public IHttpActionResult PutBook(int id, Book book) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != book.Id) { return(BadRequest()); } db.Entry(book).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!BookExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Edit([Bind(Include = "Id,Title,Category")] Book book) { if (ModelState.IsValid) { db.Entry(book).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(book)); }
public ActionResult Create([Bind(Include = "Id,Title,Category")] Book book) { if (ModelState.IsValid) { db.Books.Add(book); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(book)); }
public ActionResult Create([Bind(Include = "Id,Name")] Author author) { if (ModelState.IsValid) { db.Authors.Add(author); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(author)); }
public ActionResult Create(Book book) { if (ModelState.IsValid) { db.Books.Add(book); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AuthorId = new SelectList(db.Authors, "Id", "Name", book.AuthorId); return(View(book)); }
public ActionResult Create(BooksModel booksmodel) { if (ModelState.IsValid) { db.Books.Add(booksmodel); db.SaveChanges(); return(RedirectToAction("index", "home")); //return RedirectToAction("Index"); } return(View(booksmodel)); }
public void RegisterUser(UserModel user) { user.RoleName = "user"; user.Password = Helpers.SHA1.Encode(user.Password); _db.Users.Add(user); _db.SaveChanges(); }
public ActionResult DeleteConfirmed(int id) { Book book = db.Books.Find(id); db.Books.Remove(book); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Create(BookAndAuthorName bookAndAuthor, HttpPostedFileBase picture) { if (ModelState.IsValid) { var pictureName = await imageService.UploadImageAsync(picture); bookAndAuthor.Book.PictureName = pictureName; bookAndAuthor.Book.ISBN = bookAndAuthor.Book.ISBN.Replace("-", "").Trim(); bookAndAuthor.Book.AuthorId = dbAuthor.Authors.AsEnumerable() .Where(x => string.Format("{0} {1}", x.FirstName, x.LastName) == bookAndAuthor.AuthorName) .Single().AuthorId; dbBooks.Books.Add(bookAndAuthor.Book); dbBooks.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
private static void Seedooks() { using var db = new BooksDb(); try { if (db.Books.Any() == false) { Console.WriteLine("\nInserting..."); var authors = new List <Author> { new Author { AuthorId = 1, FirstName = "John", LastName = "Lennon" }, new Author { AuthorId = 2, FirstName = "Frank", LastName = "Zappa" } }; var books = new List <Book>() { new Book { BookId = 1, AuthorId = 1, Title = "In His On Right" }, new Book { BookId = 2, AuthorId = 1, Title = "Yer Blues" }, new Book { BookId = 3, AuthorId = 2, Title = "Led World" }, }; db.Authors.AddRange(authors); db.Books.AddRange(books); db.SaveChanges(); } } catch (Exception exception) { Console.WriteLine($"Exception: {exception.Message}"); return; } Console.WriteLine("\nREADING"); foreach (var book in db.Books.Include(x => x.Author).ToList()) { Console.WriteLine(book); } }