public ActionResult Edit(Models.BOOK_DATA b_data) { if (this.ModelState.IsValid) { using (Models.BooksManagementEntities db = new Models.BooksManagementEntities()) { var l_result = (from m in db.BOOK_DATA where m.BOOK_ID == b_data.BOOK_ID select m).FirstOrDefault(); l_result.BOOK_NAME = b_data.BOOK_NAME; l_result.BOOK_AUTHOR = b_data.BOOK_AUTHOR; l_result.BOOK_PUBLISHER = b_data.BOOK_PUBLISHER; l_result.BOOK_NOTE = b_data.BOOK_NOTE; l_result.BOOK_BOUGHT_DATE = b_data.BOOK_BOUGHT_DATE; l_result.BOOK_CLASS_ID = b_data.BOOK_CLASS_ID; l_result.BOOK_STATUS = b_data.BOOK_STATUS; l_result.BOOK_KEEPER = b_data.BOOK_KEEPER; db.SaveChanges(); TempData["ResultMessage"] = string.Format("書籍[{0}]修改成功", b_data.BOOK_NAME); } } else { ViewBag.ResultMessage = string.Format("資料有誤,請檢查", b_data.BOOK_NAME); } return(RedirectToAction("Index")); }
// GET: Book public ActionResult Index() { List <Models.BOOK_DATA> l_result = new List <Models.BOOK_DATA>(); ViewBag.ResultMessage = TempData["ResultMessage"]; using (Models.BooksManagementEntities db = new Models.BooksManagementEntities()) { l_result = (from m in db.BOOK_DATA select m).ToList(); return(View(l_result)); } }
public ActionResult Edit(int?b_id) { using (Models.BooksManagementEntities db = new Models.BooksManagementEntities()) { var l_result = (from m in db.BOOK_DATA where m.BOOK_ID == b_id select m).FirstOrDefault(); if (l_result != default(Models.BOOK_DATA)) { return(View(l_result)); } else { TempData["ResultMessage"] = string.Format("資料有誤,請檢查"); return(RedirectToAction("Index")); } } }
public ActionResult Delete(int?b_id) { using (Models.BooksManagementEntities db = new Models.BooksManagementEntities()) { var l_result = (from m in db.BOOK_DATA where m.BOOK_ID == b_id select m).FirstOrDefault(); if (l_result != default(Models.BOOK_DATA)) { db.BOOK_DATA.Remove(l_result); db.SaveChanges(); TempData["ResultMessage"] = string.Format("書籍[{0}]刪除成功", l_result.BOOK_NAME); } else { TempData["ResultMessage"] = string.Format("資料有誤,請檢查"); } return(RedirectToAction("Index")); } }
public ActionResult Create(Models.BOOK_DATA b_data) { if (this.ModelState.IsValid) { using (Models.BooksManagementEntities db = new Models.BooksManagementEntities()) { b_data.BOOK_STATUS = "v"; db.BOOK_DATA.Add(b_data); db.SaveChanges(); TempData["ResultMessage"] = string.Format("書籍[{0}]建立成功", b_data.BOOK_NAME); } } else { ViewBag.ResultMessage = string.Format("資料有誤,請檢查", b_data.BOOK_NAME); } return(RedirectToAction("Index")); }