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