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