public ActionResult Edit([Bind(Include = "WishListID,Name,Author,Genre, DateEntered, BookReadID")] DisplayWishList displayWishList)
{
if (ModelState.IsValid)
{
var us = User.Identity.Name;
var user = db.Users.FirstOrDefault(x => x.Email == us);
var books = db.WishLists.Where(x => x.Id == user.Id);
var wishList = (from WL in db.WishLists
where WL.WishListID == displayWishList.WishListID
select WL).First();
wishList.BookDateEntered = displayWishList.DateEntered;
var bookReads = (from BR in db.BooksReads
where BR.BookReadID == displayWishList.BookReadID
select BR).First();
bookReads.BookReadName = displayWishList.Name;
bookReads.BookReadAuthor = displayWishList.Author;
bookReads.BookReadGenre = displayWishList.Genre;
db.Entry(bookReads).State = EntityState.Modified;
db.Entry(wishList).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(displayWishList));
}
public ActionResult Create([Bind(Include = "WishListID,Name,Author,Genre, DateEntered")] DisplayWishList displayWishList)
{
var us = User.Identity.Name;
var user = db.Users.FirstOrDefault(x => x.Email == us);
if (ModelState.IsValid)
{
var addBook = (from a in db.BooksReads
where a.BookReadName == displayWishList.Name
select a);
if (addBook.Count() == 0)
{
var newBook = new BooksRead();
newBook.BookReadName = displayWishList.Name;
newBook.BookReadGenre = displayWishList.Genre;
newBook.BookReadAuthor = displayWishList.Author;
db.BooksReads.Add(newBook);
db.SaveChanges();
var newWL = new WishList();
newWL.BookDateEntered = displayWishList.DateEntered;
newWL.BookReadID = newBook.BookReadID;
newWL.Id = user.Id;
db.WishLists.Add(newWL);
db.SaveChanges();
}
else
{
var newWL = new WishList();
newWL.BookDateEntered = displayWishList.DateEntered;
newWL.BookReadID = addBook.First().BookReadID;
newWL.Id = user.Id;
db.WishLists.Add(newWL);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(displayWishList));
}
