public JsonResult Search(Models.BookSearch arg) { Models.BookService BookService = new Models.BookService(); var result = BookService.GetBookByCondtioin(arg); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(Models.BookSearchArg arg) { Models.BookService bookService = new Models.BookService(); ViewBag.SearchResult = bookService.GetBookByCondition(arg); ViewBag.JobTitleCodeData = this.codeService.GetCodeTable("TITLE"); return(View("Index")); }
public ActionResult UpdateBook(Models.Book book) { Models.BookService library = new Models.BookService(); ViewBag.bookClassData = this.codeService.GetBookClassDropdownlist(); ViewBag.borrowerData = this.codeService.GetBorrowerDropdownlist(); ViewBag.statusData = this.codeService.GetBookStatusDropdownlist(); if (library.UpdateBook(book) == 1 && (book.book_Status == "B" || book.book_Status == "C")) { //成功更新一筆資料且為借出狀態,則新增一筆借閱紀錄 if (library.InsertBookIntoLendRecord(book) == 1) { ModelState.Clear(); } else { TempData["updateSuccessfully"] = "系統出現問題"; } } else if (library.UpdateBook(book) == 1) { //更新書籍內容,並未更新借閱狀態 ModelState.Clear(); } else { //更新一筆資料失敗 TempData["updateSuccessfully"] = "系統出現問題"; } return(View(book)); }
public JsonResult Insert(Models.BookData book) { Models.BookService BookService = new Models.BookService(); var result = BookService.Insert(book); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult Delete(string BookId) { Models.BookService BookService = new Models.BookService(); var result = BookService.Delete(BookId); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult Book_Keeper() { Models.BookService BookService = new Models.BookService(); var result = BookService.Book_Keeper(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(Models.BookServiceArg arg) { Models.BookService bookService = new Models.BookService(); ViewBag.SearchResult = bookService.GetBookByCondtioin(arg); ViewBag.ClassName = this.codeService.GetBookClassId("ClassName"); ViewBag.KeeperName = this.codeService.GetMember("KeeperName"); ViewBag.CodeName = this.codeService.GetCodeName("CodeName"); return(View("Index")); }
public ActionResult SearchBook(Models.SearchBook book) { Models.BookService library = new Models.BookService(); ViewBag.bookClassData = this.codeService.GetBookClassDropdownlist(); ViewBag.borrowerData = this.codeService.GetBorrowerDropdownlist(); ViewBag.statusData = this.codeService.GetBookStatusDropdownlist(); ViewBag.searchResult = library.GetBookByData(book); return(View()); }
public ActionResult QueryBook(Models.BookSearchArg arg) { Models.BookService bookService = new Models.BookService(); ViewBag.BookStatusCodeTable = codeService.GetStatusCodeTable(); ViewBag.BookClassCodeTable = codeService.GetBookClassCodeTable(); ViewBag.MemberCodeTable = codeService.GetMemberCodeTable(); ViewBag.SearchResult = bookService.GetBookByCondtioin(arg); return(View()); }
public ActionResult UpdateBook(string book_Id) { Models.BookService library = new Models.BookService(); ViewBag.bookClassData = this.codeService.GetBookClassDropdownlist(); ViewBag.borrowerData = this.codeService.GetBorrowerDropdownlist(); ViewBag.statusData = this.codeService.GetBookStatusDropdownlist(); Models.Book book = library.GetBookById(book_Id); return(View(book)); }
public ActionResult EditBook(string BookID) { Models.BookService bookService = new Models.BookService(); ViewBag.BookStatusCodeTable = codeService.GetStatusCodeTable(); ViewBag.BookClassCodeTable = codeService.GetBookClassCodeTable(); ViewBag.MemberCodeTable = codeService.GetMemberCodeTable(); ViewBag.SearchResult = bookService.GetBookByID(BookID); return(View(new Models.Book())); }
public ActionResult InsertBook(Models.BookData bookdata) { ViewBag.ClassName = this.codeService.GetBookClassId("ClassName"); if (ModelState.IsValid) { Models.BookService bookService = new Models.BookService(); bookService.InsertBook(bookdata); TempData["message"] = "存檔成功"; } return(View(bookdata)); }
public ActionResult Index(Models.BookSearch arg) { ViewBag.LendName = this.Service.GetTable("MEMBER_M", "USER_ENAME", "USER_ID"); ViewBag.BookCategory = this.Service.GetTable("BOOK_CLASS", "BOOK_CLASS_NAME", "BOOK_CLASS_ID"); ViewBag.BookStatus = this.Service.GetCodeTable("BOOK_STATUS"); Models.BookService BookService = new Models.BookService(); //if (arg.HireDateEnd == null) // arg.HireDateEnd = DateTime.Now.ToShortDateString(); ViewBag.SearchResult = BookService.GetBookByCondtioin(arg); //ViewBag.JobTitleCodeData = this.Service.GetCodeTable("TITLE"); return(View("Index")); }
public ActionResult Index(Models.BookSearchArg arg) { Models.CodeService codeService = new Models.CodeService(); ViewBag.BookClassNameItem = codeService.GetBookClassName(); ViewBag.BookBoughterItem = codeService.GetBookBoughter(); ViewBag.BookStatusItem = codeService.GetBookStatus(); Models.BookService bookService = new Models.BookService(); ViewBag.BookSearchResult = bookService.GetBookByCondition(arg); return(InsertBook()); }
public ActionResult InsertBook(Models.Books Book) { ViewBag.BookCategory = this.Service.GetTable("BOOK_CLASS", "BOOK_CLASS_NAME", "BOOK_CLASS_ID"); if (ModelState.IsValid) { Models.BookService BookService = new Models.BookService(); BookService.InsertBook(Book); TempData["message"] = "存檔成功"; } return(View(Book)); }
public ActionResult AddBook(Models.Book book) { ViewBag.BookStatusCodeTable = codeService.GetStatusCodeTable(); ViewBag.BookClassCodeTable = codeService.GetBookClassCodeTable(); ViewBag.MemberCodeTable = codeService.GetMemberCodeTable(); if (ModelState.IsValid) { Models.BookService bookService = new Models.BookService(); bookService.AddBook(book); TempData["message"] = "存檔成功"; // for frontend } return(View(book)); }
public JsonResult DeleteBook(string bookId) { try { Models.BookService BookService = new Models.BookService(); BookService.DeleteBookById(bookId); return(this.Json(true)); } catch (Exception ex) { return(this.Json(false)); } }
public JsonResult DeleteBook(string book_Id) { try { Models.BookService library = new Models.BookService(); library.DeleteBook(book_Id); return(this.Json(true)); } catch (Exception ex) { return(this.Json(false)); } }
public ActionResult EditBook(Models.Book book) { ViewBag.BookStatusCodeTable = codeService.GetStatusCodeTable(); ViewBag.BookClassCodeTable = codeService.GetBookClassCodeTable(); ViewBag.MemberCodeTable = codeService.GetMemberCodeTable(); if (ModelState.IsValid) { Models.BookService bookService = new Models.BookService(); string BookID = bookService.EditBook(book).ToString(); ViewBag.SearchResult = bookService.GetBookByID(BookID); TempData["message"] = "存檔成功"; } return(View(book)); }
public ActionResult InsertEmployee(Models.Books book) { ViewBag.JobTitleCodeData = this.codeService.GetCodeTable("TITLE"); ViewBag.CountryCodeData = this.codeService.GetCodeTable("COUNTRY"); ViewBag.CityCodeData = this.codeService.GetCodeTable("CITY"); ViewBag.GenderCodeData = this.codeService.GetCodeTable("GENDER"); ViewBag.EmpCodeData = this.codeService.GetBook("0"); if (ModelState.IsValid) { Models.BookService bookService = new Models.BookService(); bookService.InsertBook(book); TempData["message"] = "存檔成功"; } return(View(book)); }
public JsonResult DeleteBook(string bookID) { try { Models.BookService bookService = new Models.BookService(); if (bookService.DeleteBook(bookID)) { return(this.Json(true)); } return(this.Json(false)); } catch (Exception ex) { return(this.Json(null)); } }
public ActionResult InsertBook(Models.Book book) { ViewBag.bookClassData = this.codeService.GetBookClassDropdownlist(); Models.BookService library = new Models.BookService(); if (library.InsertBook(book) == 1) { //成功新增一筆資料 ModelState.Clear(); return(RedirectToAction("InsertBook")); } else { //新增一筆資料失敗 TempData["insertSuccessfully"] = "系統出現問題"; } return(View(book)); }
public JsonResult QueryLendRecord(string BookID) { Models.BookService bookService = new Models.BookService(); return(this.Json(bookService.GetLendRecord(BookID))); }
public BookController() { this.bookService = new Models.BookService(); }
public ActionResult InsertBook() { Models.BookService bookService = new Models.BookService(); return(View()); }
public JsonResult PresentBook(string BookID) { Models.BookService bookService = new Models.BookService(); return(this.Json(bookService.GetBookByID(BookID))); }
public JsonResult EditBook(Models.Book book) { Models.BookService bookService = new Models.BookService(); return(this.Json(bookService.EditBook(book))); }
public JsonResult AddBook(Models.Book book) { Models.BookService bookService = new Models.BookService(); TempData["message"] = "存檔成功"; // for frontend return(this.Json(bookService.AddBook(book))); }
public JsonResult QueryBook(Models.BookSearchArg arg) { Models.BookService bookService = new Models.BookService(); return(this.Json(bookService.GetBookByCondtioin(arg))); }
public ActionResult InsertBook(Models.AddBook book) { Models.BookService bookService = new Models.BookService(); ViewBag.AddBookItem = bookService.InsertBook(book); return(View()); }