public ActionResult DeleteConfirmed(int id)
{
book_category book_category = db.book_category.Find(id);
db.book_category.Remove(book_category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "book_category_id,book_id,category_id")] book_category book_category)
{
if (ModelState.IsValid)
{
db.Entry(book_category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.book_id = new SelectList(db.books, "book_id", "book_title", book_category.book_id);
ViewBag.category_id = new SelectList(db.categories, "category_id", "category_name", book_category.category_id);
return(View(book_category));
}
public bool UpdateCate(BookCategoryModel bookCate)
{
try
{
book_category bc = IQueryableCategory().FirstOrDefault(o => o.book_category_id == bookCate.book_category_id);
bc.book_category_name = bookCate.book_category_name;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
// GET: book_category/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
book_category book_category = db.book_category.Find(id);
if (book_category == null)
{
return(HttpNotFound());
}
return(View(book_category));
}
// GET: book_category/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
book_category book_category = db.book_category.Find(id);
if (book_category == null)
{
return(HttpNotFound());
}
ViewBag.book_id = new SelectList(db.books, "book_id", "book_title", book_category.book_id);
ViewBag.category_id = new SelectList(db.categories, "category_id", "category_name", book_category.category_id);
return(View(book_category));
}
public bool AddBookCate(BookCategoryModel m)
{
try
{
if (IQueryableCategory().Where(o => o.book_category_name == m.book_category_name).ToList().Count == 0)
{
book_category _obj = Mapping(m);
db.book_category.Add(_obj);
db.SaveChanges();
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
internal BookCategoryModel Mapping(book_category m) //จะ return ไปข้างหน้า จึงreturn เป็น model
{
try
{
if (m != null)
{
BookCategoryModel bm = new BookCategoryModel();
bm.book_category_id = m.book_category_id;
bm.book_category_name = m.book_category_name;
return(bm);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
internal book_category Mapping(BookCategoryModel c)
{
try
{
if (c != null)
{
book_category bc = new book_category();
bc.book_category_id = c.book_category_id;
bc.book_category_name = c.book_category_name;
return(bc);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
internal BookCategoryModel Mapping(book_category o)
{
try
{
if (o != null)
{
return(new BookCategoryModel()
{
book_category_id = o.book_category_id,
book_category_name = o.book_category_name
});
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
internal List <book_category> Mapping(List <BookCategoryModel> list)
{
try
{
if (list != null && list.Count > 0)
{
List <book_category> bcList = new List <book_category>();
foreach (BookCategoryModel bc in list)
{
book_category b = new book_category();
b.book_category_id = bc.book_category_id;
b.book_category_name = bc.book_category_name;
bcList.Add(b);
}
return(bcList);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
