// GET: bookInfoes/Edit/5
public ActionResult Edit(int?id, string action, string id2)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
bookInfo bookInfo = db.bookInfo.Find(id);
if (bookInfo == null)
{
return(HttpNotFound());
}
if (action == "返回")
{
if (id2 == "2")
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("BookInformation"));
}
}
return(View(bookInfo));
}
public ActionResult Edit([Bind(Include = "bookNo,bookName,authorZhu,authorBian,authorJi,authorZuan,authorYi,authorHui,press,publishDate,price,classificationNo,suoShuNo,huJianNo,pageCount,summary,borrowInfo,remarks")] bookInfo bookInfo, string action)
{
if (action == "修改")
{
int max_no = db.bookInfo.Max(d => d.bookNo);
bookInfo.bookNo = max_no + 1;
if (bookInfo.price == null)
{
bookInfo.price = 0;
}
if (bookInfo.publishDate == null)
{
bookInfo.publishDate = DateTime.Today.Date;
}
try
{
db.bookInfo.Add(bookInfo);
db.SaveChanges();
return(Content("<script >alert('修改成功！');window.history.back();</script >"));
}
catch (Exception)
{
return(Content("<script >alert('修改失败，请检查所填信息！');window.history.back();</script >"));
}
}
else
{
return(RedirectToAction("Index"));
}
return(View(bookInfo));
}
public ActionResult Borrow(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
bookInfo bookInfo = db.bookInfo.Find(id);
ViewBag.no = bookInfo.bookNo;
if (bookInfo == null)
{
return(HttpNotFound());
}
string book = bookInfo.borrowInfo;
if (book == "未借出")
{
ViewBag.borrowDate = DateTime.Now.ToString("yyyy-MM-dd");
ViewBag.returnDate = "";
ViewBag.borrower = "";
ViewData["button1"] = false;
ViewData["button2"] = true;
}
if (book == "已借出")
{
var bookborrowinfo = db.BookBorrowInfo.Where(a => a.bookNo == id).First();
ViewBag.returnDate = DateTime.Now.ToString("yyyy-MM-dd");
ViewBag.borrowDate = bookborrowinfo.borrowDate;
ViewBag.borrower = bookborrowinfo.borrower;
ViewData["button1"] = true;
ViewData["button2"] = false;
}
return(View(bookInfo));
}
// GET: bookInfoes/Delete/5
//public ActionResult Delete(int? id)
//{
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// bookInfo bookInfo = db.bookInfo.Find(id);
// if (bookInfo == null)
// {
// return HttpNotFound();
// }
// return View(bookInfo);
//}
// POST: bookInfoes/Delete/5
//[HttpPost, ActionName("Delete")]
//[ValidateAntiForgeryToken]
public ActionResult Delete(int id)
{
bookInfo bookInfo = db.bookInfo.Find(id);
db.bookInfo.Remove(bookInfo);
db.SaveChanges();
return(Content("<script>alert('已成功删除！');window.location.href='/bookInfoes/Index'</script>"));
}
public ActionResult DeleteConfirmed(int id)
{
//bookInfo bookInfo = db.bookInfo.Find(id);
//db.bookInfo.Remove(bookInfo);
//db.SaveChanges();
bookInfo bookInfo = db.books.SingleOrDefault(b => b.bookID == id);
db.Delete(bookInfo);
return(RedirectToAction("Index"));
}
public IActionResult Put(int id, [FromBody] bookInfo bookInfo)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
db.Entry(bookInfo).State = EntityState.Modified;
db.SaveChanges();
return(AcceptedAtAction("Get", new { id = bookInfo.bookID }, bookInfo));
}
public IActionResult Post([FromBody] bookInfo bookInfo)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
db.bookInfo.Add(bookInfo);
db.SaveChanges();
return(CreatedAtAction("Post", new { id = bookInfo.bookID }, bookInfo));
}
public ActionResult Create([Bind(Include = "bookID,bookName,bookAuthor,bookGenre,bookEdition,bookReleaseYear")] bookInfo bookInfo)
{
if (ModelState.IsValid)
{
//db.bookInfo.Add(bookInfo);
//db.SaveChanges();
db.Save(bookInfo); // use tes repository instead of Entity Framework directly
return(RedirectToAction("Index"));
}
return(View("Create", bookInfo));
}
public ActionResult Edit([Bind(Include = "bookID,bookName,bookAuthor,bookGenre,bookEdition,bookReleaseYear")] bookInfo bookInfo)
{
if (ModelState.IsValid)
{
//db.Entry(bookInfo).State = EntityState.Modified;
//db.SaveChanges();
db.Save(bookInfo);
return(RedirectToAction("Index"));
}
return(View("Edit", bookInfo));
}
public void CreatePostValID()
{
// Arrange
bookInfo b = new bookInfo
{
bookName = "A Game of Thrones",
bookGenre = "Fantasy"
};
// Act
var actual = (RedirectToRouteResult)controller.Create(b);
// Assert
Assert.AreEqual("Index", actual.RouteValues["action"]);
}
public ActionResult Borrow([Bind(Include = "bookNo,bookName,authorZhu,authorBian,authorJi,authorZuan,authorYi,authorHui,press,publishDate,price,classificationNo,suoShuNo,huJianNo,pageCount,summary,borrowInfo,remarks")] bookInfo bookInfo, string action)
{
if (action == "返回")
{
return(RedirectToAction("Index"));
}
if (action == "借阅")
{
bookInfo.borrowInfo = "已借出";
BookBorrowInfo bookborrowinfo = new BookBorrowInfo();
var no = Request.Form["bookNo"];
bookborrowinfo.bookNo = int.Parse(no);
bookborrowinfo.borrower = Request.Form["borrower"];
bookborrowinfo.borrowDate = DateTime.Parse(Request.Form["borrowDate"]);
int maxid = db.BookBorrowInfo.Max(d => d.ID);
bookborrowinfo.ID = maxid + 1;
if (ModelState.IsValid)
{
db.Entry(bookInfo).State = EntityState.Modified;
//db.SaveChanges();
db.BookBorrowInfo.Add(bookborrowinfo);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
if (action == "归还")
{
bookInfo.borrowInfo = "未借出";
var no = int.Parse(Request.Form["bookNo"]);
var book = db.BookBorrowInfo.Where(a => a.bookNo == no).First();
book.bookNo = int.Parse(Request.Form["bookNo"]);
book.borrower = Request.Form["borrower"];
book.borrowDate = DateTime.Parse(Request.Form["borrowDate"]);
book.returnDate = DateTime.Parse(Request.Form["returnDate"]);
//bookborrowinfo.ID = book.ID;
if (ModelState.IsValid)
{
db.Entry(bookInfo).State = EntityState.Modified;
db.Entry(book).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View());
}
public void CreatePostInvalID()
{
// arrange
bookInfo b = new bookInfo
{
bookName = "A Game of Thrones",
bookGenre = "Fantasy"
};
controller.ModelState.AddModelError("key", "cannot add order");
// Act
var actual = (ViewResult)controller.Create(b);
// Assert
Assert.AreEqual("Create", actual.ViewName);
}
// GET: bookInfo/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
return(View("Error"));
}
//bookInfo bookInfo = db.bookInfo.Find(id);
bookInfo bookInfo = db.books.SingleOrDefault(b => b.bookID == id);
if (bookInfo == null)
{
//return HttpNotFound();
return(View("Error"));
}
return(View("Delete", bookInfo));
}
// GET: bookInfoes/Details/5
public ActionResult Details(int?id, string action, string id2)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
bookInfo bookInfo = db.bookInfo.Find(id);
if (bookInfo.borrowInfo == "未借出")
{
ViewBag.borrower = "";
ViewBag.borrowdate = "";
}
else
{
BookBorrowInfo bookborrowInfo = db.BookBorrowInfo.Where(a => a.bookNo == id).First();
ViewBag.borrower = bookborrowInfo.borrower;
ViewBag.borrowdate = bookborrowInfo.borrowDate;
}
if (bookInfo == null)
{
return(HttpNotFound());
}
if (id2 == "2")
{
ViewData["button"] = "display:show";
}
else
{
ViewData["button"] = "display:none";
}
if (action == "返回")
{
if (id2 == "2")
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("BookInformation"));
}
}
return(View(bookInfo));
}
