public ActionResult Edit(int id)
{
Book targetBook = null;
using (BookstoreEntities dbContext = new BookstoreEntities())
{
targetBook = dbContext.Books.SingleOrDefault(n => n.Id == id);
}
return View("EditBook", targetBook);
}
// GET: Novel
public ActionResult Show(int pageNumber, string categoryname)
{
List<GetBooksofPage_Result> Books = null;
using (BookstoreEntities dbContext = new BookstoreEntities())
{
int bookPerPage = 10;
Books = dbContext.GetBooksofPage(bookPerPage, pageNumber, categoryname).ToList();
ViewBag.MaxPageNumber = dbContext.Books.Where(b=>b.Category==categoryname).Count() / bookPerPage + 1;
ViewBag.Categoryname = categoryname;
}
return View("ShowBook", Books);
}
public ActionResult UserInfoRevise(int id)
{
User targetUser = null;
using (BookstoreEntities dbContext = new BookstoreEntities())
{
targetUser = dbContext.Users.Include("Orders").SingleOrDefault(u => u.Id == id);
}
if (targetUser != null)
{
return View("UserInfoVerify", targetUser);
}
else
{
return View("Error");
}
}
public ActionResult Edit(Book book)
{
using (BookstoreEntities dbContext = new BookstoreEntities())
{
if (this.Request.Files != null && this.Request.Files.Count > 0 && this.Request.Files[0].ContentLength > 0 && this.Request.Files[0].ContentLength < 1024 * 100)
{
string fileName = Path.GetFileName(this.Request.Files[0].FileName);
string filePathOfWebsite = "~/Images/" + fileName;
book.CoverImagePath = filePathOfWebsite;
this.Request.Files[0].SaveAs(this.Server.MapPath(filePathOfWebsite));
}
dbContext.Books.Attach(book);
dbContext.Entry(book).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
return RedirectToAction("Show", new { pageNumber = 1, categoryname = book.Category });
}
public ActionResult UserRevise(User user)
{
if (user.FirstName != null && user.LastName != null && user.DateofBirth != 0 && this.ModelState.IsValid)
{
using (BookstoreEntities dbContext = new BookstoreEntities())
{
dbContext.Users.Attach(user);
dbContext.Entry(user).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
return View("UserInfo", user);
}
else
{
return View("Error");
}
}
public ActionResult UserRegister(User user)
{
User newUser = null;
if (user.FirstName != null && user.LastName != null && user.DateofBirth != 0 && this.ModelState.IsValid)
{
using (BookstoreEntities dbContext = new BookstoreEntities())
{
dbContext.Users.Add(user);
dbContext.SaveChanges();
newUser = dbContext.Users.SingleOrDefault(u => u.FirstName == user.FirstName && u.LastName == user.LastName && u.DateofBirth == user.DateofBirth);
}
return View("UserInfo", newUser);
}
else
{
return View("Error");
}
}
public ActionResult Delete(int id)
{
string category;
using (BookstoreEntities dbContext = new BookstoreEntities())
{
Book targetBook = null;
targetBook = dbContext.Books.SingleOrDefault(n => n.Id == id);
if(targetBook==null)
{
return View("Warning");
}
else
{
category = targetBook.Category;
dbContext.Books.Remove(targetBook);
dbContext.SaveChanges();
}
}
return RedirectToAction("Show", new { pageNumber = 1, categoryname = category});
}
public ActionResult ViewCart(int Id)
{
User targetUser = null;
using (BookstoreEntities dbContext = new BookstoreEntities())
{
targetUser = dbContext.Users.Include("Orders").SingleOrDefault(u => u.Id == Id);
}
if (targetUser != null)
{
return View("Cart", targetUser);
}
else
{
return View("Error");
}
}
public ActionResult EditCart(int id, int userId)
{
Order targetOrder = null;
User targetUser = null;
using (BookstoreEntities dbContext = new BookstoreEntities())
{
targetOrder = dbContext.Orders.SingleOrDefault(o => o.Id == id);
if (targetOrder == null)
{
return View("Warning");
}
else
{
dbContext.Orders.Remove(targetOrder);
dbContext.SaveChanges();
targetUser = dbContext.Users.Include("Orders").SingleOrDefault(u => u.Id == userId);
}
}
return View("Cart", targetUser);
}
public ActionResult AddToCart(Order order)
{
User targetUser = null;
using (BookstoreEntities dbContext = new BookstoreEntities())
{
targetUser = dbContext.Users.SingleOrDefault(u => u.Id == order.UserId);
}
if (targetUser != null)
{
using (BookstoreEntities dbContext = new BookstoreEntities())
{
dbContext.Orders.Add(order);
dbContext.SaveChanges();
targetUser = dbContext.Users.Include("Orders").SingleOrDefault(u => u.Id == order.UserId);
}
return View("Cart", targetUser);
}
else
{
return View("Error");
}
}
