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"));
}
public ActionResult InsertBook(Models.BOOK_DATA book)
{
///後端驗證
if (ModelState.IsValid)
{
book.CREATE_DATE = DateTime.Now;
book.CREATE_USER = "******";
book.MODIFY_DATE = DateTime.Now;
book.MODIFY_USER = "******";
Models.BookService.bookData.Add(book);
}
return(RedirectToAction("Index", "Book", null));
}
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"));
}
public ActionResult UpdateBook(Models.BOOK_DATA book)
{
var books = Models.BookService.bookData;
if (ModelState.IsValid)
{
var changeBook = books.Find(x => x.BOOK_ID == book.BOOK_ID);
books.Remove(changeBook);
changeBook.BOOK_NAME = book.BOOK_NAME;
changeBook.BOOK_CLASS_ID = book.BOOK_CLASS_ID;
changeBook.BOOK_AUTHOR = book.BOOK_AUTHOR;
changeBook.BOOK_NOTE = book.BOOK_NOTE;
changeBook.BOOK_KEEPER = book.BOOK_KEEPER;
changeBook.BOOK_BOUGHT_DATE = book.BOOK_BOUGHT_DATE;
changeBook.BOOK_PUBLISHER = book.BOOK_PUBLISHER;
changeBook.BOOK_STATUS = book.BOOK_STATUS;
changeBook.MODIFY_DATE = DateTime.Now;
changeBook.MODIFY_USER = "******";
books.Add(changeBook);
}
return(RedirectToAction("Index", "Book", null));
}
/// <summary>
/// 新增書籍
/// </summary>
/// <param name="book"></param>
/// <returns>員工編號</returns>
public int InsertEmployee(Models.BOOK_DATA book)
{
string sql = @" INSERT INTO [dbo].[BOOK_DATA]
(
BOOK_NAME, BOOK_CLASS_ID,
BOOK_AUTHOR, BOOK_BOUGHT_DATE, BOOK_PUBLISHER, BOOK_NOTE
BOOK_STATUS, BOOK_KEEPER, CREATE_DATE, CREATE_USER, MODIFY_DATE, MODIFY_USER
)
VALUES
(
@BOOK_NAME, @BOOK_CLASS_ID,
@BOOK_AUTHOR, @BOOK_BOUGHT_DATE, @BOOK_PUBLISHER, @BOOK_NOTE
@BOOK_STATUS, @BOOK_KEEPER, @CREATE_DATE, @CREATE_USER, @MODIFY_DATE, @MODIFY_USER
)
Select SCOPE_IDENTITY()" ;
int BOOK_ID;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@BOOK_NAME", book.BOOK_NAME));
cmd.Parameters.Add(new SqlParameter("@BOOK_CLASS_ID", book.BOOK_CLASS_ID));
cmd.Parameters.Add(new SqlParameter("@BOOK_AUTHOR", book.BOOK_AUTHOR));
cmd.Parameters.Add(new SqlParameter("@BOOK_BOUGHT_DATE", book.BOOK_BOUGHT_DATE));
cmd.Parameters.Add(new SqlParameter("@BOOK_PUBLISHER", book.BOOK_PUBLISHER));
cmd.Parameters.Add(new SqlParameter("@BOOK_NOTE", book.BOOK_NOTE));
cmd.Parameters.Add(new SqlParameter("@BOOK_STATUS", book.BOOK_STATUS));
cmd.Parameters.Add(new SqlParameter("@BOOK_KEEPER", book.BOOK_KEEPER));
cmd.Parameters.Add(new SqlParameter("@CREATE_DATE", book.CREATE_DATE));
cmd.Parameters.Add(new SqlParameter("@CREATE_USER", book.CREATE_USER));
cmd.Parameters.Add(new SqlParameter("@MODIFY_DATE", book.MODIFY_DATE));
cmd.Parameters.Add(new SqlParameter("@MODIFY_USER", book.MODIFY_USER));
BOOK_ID = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
}
return(BOOK_ID);
}
