public ActionResult Search(string searchString) { Book targetBooks = new Book(); List <EconomicsBook> targetEconomicsBooks = null; List <CSBook> targetCSBooks = null; List <NovelBook> targetNovelBooks = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { targetCSBooks = dbContext.CSBooks.Where(b => b.Name.Contains(searchString) || b.Author.Contains(searchString)).ToList(); targetNovelBooks = dbContext.NovelBooks.Where(b => b.Name.Contains(searchString) || b.Author.Contains(searchString)).ToList(); targetEconomicsBooks = dbContext.EconomicsBooks.Where(b => b.Name.Contains(searchString) || b.Author.Contains(searchString)).ToList(); targetBooks.CSBooks = targetCSBooks; targetBooks.NovelBooks = targetNovelBooks; targetBooks.EconomicsBooks = targetEconomicsBooks; } if (targetBooks == null) { return(View("InputSearch")); } else { return(View("ReturnSearchBook", targetBooks)); } }
public ActionResult AddToCart(int uniqueId) { SingleBook singlebook = new SingleBook(); CSBook CStargetBook = null; EconomicsBook EconomicstargetBook = null; NovelBook NoveltargetBook = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { if (uniqueId < 2000) { CStargetBook = dbContext.CSBooks.SingleOrDefault(n => n.UniqueId == uniqueId); singlebook.CSBook = CStargetBook; } else if (uniqueId > 2000 & uniqueId < 3000) { EconomicstargetBook = dbContext.EconomicsBooks.SingleOrDefault(n => n.UniqueId == uniqueId); singlebook.Economicsbook = EconomicstargetBook; } else { NoveltargetBook = dbContext.NovelBooks.SingleOrDefault(n => n.UniqueId == uniqueId); singlebook.NovelBook = NoveltargetBook; } } return(View("OrderReview", singlebook)); }
// GET: Book public ActionResult BookList() { Group001BookstoreEntities dbContext = new Group001BookstoreEntities(); List <EconomicsBook> allBooks = dbContext.EconomicsBooks.ToList(); return(View(allBooks)); }
// GET: ChildrenBook public ActionResult Show() { List <ChildrenBook> allChildrenBooks = null; Group001BookstoreEntities dbContext = new Group001BookstoreEntities(); allChildrenBooks = dbContext.ChildrenBooks.ToList(); return(View(allChildrenBooks)); }
public ActionResult AddToCart(int uniqueId) { ChildrenBook targetBook = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { targetBook = dbContext.ChildrenBooks.SingleOrDefault(c => c.UniqueId == uniqueId); } return(View("OrderReview", targetBook)); }
public ActionResult Detail(int uniqueId) { CSBook targetBook = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { targetBook = dbContext.CSBooks.SingleOrDefault(b => b.UniqueId == uniqueId); } return(View(targetBook)); }
public ActionResult Edit(int id) { EconomicsBook targetBook = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { targetBook = dbContext.EconomicsBooks.SingleOrDefault(b => b.Id == id); } return(View(targetBook)); }
public ActionResult Edit(int id) { ChildrenBook targetBook = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { targetBook = dbContext.ChildrenBooks.SingleOrDefault(b => b.Id == id); } return(View("EditChildrenBook", targetBook)); }
public ActionResult Edit(int id) { NovelBook targetNovel = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { targetNovel = dbContext.NovelBooks.SingleOrDefault(n => n.Id == id); } return(View("EditNovel", targetNovel)); }
// GET: Novel public ActionResult Show(int pageNumber) { List <GetNovelBooksofPage_Result> Novels = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { int bookPerPage = 10; Novels = dbContext.GetNovelBooksofPage(bookPerPage, pageNumber).ToList(); ViewBag.MaxPageNumber = dbContext.NovelBooks.Count() / bookPerPage + 1; } return(View("ShowNovel", Novels)); }
public ActionResult Edit(EconomicsBook book) { using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { if (this.Request.Files != null && this.Request.Files.Count > 0 && this.Request.Files[0].ContentLength > 0 && this.Request.Files[0].ContentLength < 1024 * 1024) { book.CoverImagePath = this.Request.Files[0].FileName; } dbContext.EconomicsBooks.Attach(book); dbContext.Entry(book).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } return(RedirectToAction("BookList")); }
public ActionResult Add(ChildrenBook childrenBook) { using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { 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/ChildrenBookCover" + fileName; childrenBook.CoverImagePath = filePathOfWebsite; this.Request.Files[0].SaveAs(this.Server.MapPath(filePathOfWebsite)); } dbContext.ChildrenBooks.Add(childrenBook); dbContext.SaveChanges(); } return(RedirectToAction("Show")); }
public ActionResult Edit(ChildrenBook ChildrenBook) { using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { 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/ChildrenBookCover/" + fileName; ChildrenBook.CoverImagePath = filePathOfWebsite; this.Request.Files[0].SaveAs(this.Server.MapPath(filePathOfWebsite));//无法添加图片,路径名不对。 } dbContext.ChildrenBooks.Attach(ChildrenBook); dbContext.Entry(ChildrenBook).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } return(RedirectToAction("Show")); }
public ActionResult Detail(CSBook book) { using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { if (this.Request.Files != null && this.Request.Files.Count > 0 && this.Request.Files[0].ContentLength > 0 && this.Request.Files[0].ContentLength < 1024 * 1024) { string fileName = Path.GetFileName(this.Request.Files[0].FileName); string pathOfWebsite = "~/Images/CSBookCovers/" + fileName; book.CoverImagePath = pathOfWebsite; this.Request.Files[0].SaveAs(this.Server.MapPath(pathOfWebsite)); } dbContext.CSBooks.Attach(book); dbContext.Entry(book).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } return(RedirectToAction("Show")); }
public ActionResult UserRevise(User user) { if (user.FirstName != null && user.LastName != null && user.DateofBirth != 0 && this.ModelState.IsValid) { using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { 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 ViewCart(int Id) { User targetUser = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { targetUser = dbContext.Users.Include("Orders").SingleOrDefault(u => u.Id == Id); } if (targetUser != null) { return(View("Cart", targetUser)); } else { return(View("Error")); } }
public ActionResult Add(NovelBook novel) { using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { 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/NovelCovers/" + fileName; novel.CoverImagePath = filePathOfWebsite; this.Request.Files[0].SaveAs(this.Server.MapPath(filePathOfWebsite)); } dbContext.NovelBooks.Add(novel); dbContext.SaveChanges(); } return(RedirectToAction("Show", new { pageNumber = 1 })); }
public ActionResult Delete(int id) { using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { ChildrenBook targetBook = null; targetBook = dbContext.ChildrenBooks.SingleOrDefault(b => b.Id == id); if (targetBook == null) { return(View("Warning")); } else { dbContext.ChildrenBooks.Remove(targetBook); dbContext.SaveChanges(); } } return(RedirectToAction("Show")); }
public ActionResult Delete(int id) { using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { NovelBook targetNovel = null; targetNovel = dbContext.NovelBooks.SingleOrDefault(n => n.Id == id); if (targetNovel == null) { return(View("Warning")); } else { dbContext.NovelBooks.Remove(targetNovel); dbContext.SaveChanges(); } } return(RedirectToAction("Show", new { pageNumber = 1 })); }
public ActionResult AddToCart(Order order) { User targetUser = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { targetUser = dbContext.Users.SingleOrDefault(u => u.Id == order.UserId); if (targetUser != null) { 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")); } } }
public ActionResult EditCart(int id, int userId) { Order targetOrder = null; User targetUser = null; using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { targetUser = dbContext.Users.Include("Orders").SingleOrDefault(u => u.Id == userId); targetOrder = dbContext.Orders.SingleOrDefault(o => o.Id == id & o.UserId == userId); if (targetOrder == null) { return(View("Warning")); } else { dbContext.Orders.Remove(targetOrder); dbContext.SaveChanges(); return(View("Cart", targetUser)); } } }
public ActionResult UserRegister(User user) { User newUser = null; if (user.FirstName != null && user.LastName != null && user.DateofBirth != 0 && this.ModelState.IsValid) { using (Group001BookstoreEntities dbContext = new Group001BookstoreEntities()) { 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")); } }