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