public IActionResult Post(BookCategoryModel model)
{
var bookCategory = _mapper.Map <BookCategoryModel, BookCategory>(model);
_applicationDataContext.BookCategories.Add(bookCategory);
_applicationDataContext.SaveChanges();
return(Ok(bookCategory));
}
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;
}
}
public async Task <BookCategoryModel> Edit(BookCategoryModel category)
{
try
{
category.Name = category.Name.ToUpper();
_context.Update(category);
await _context.SaveChangesAsync();
return(category);
}
catch (DbUpdateConcurrencyException)
{
return(await Get(category.Id));
}
}
public async Task <BookCategoryModel> Add(BookCategoryModel category)
{
category.Name = category.Name.ToUpper();
BookCategoryModel categorySameName = await GetByName(category.Name);
if (categorySameName != null)
{
return(categorySameName);
}
_context.Add(category);
await _context.SaveChangesAsync();
return(category);
}
public ActionResult UpdateBookCate(BookCategoryModel bookCate)
{
try
{
bool updated = bookHelp.UpdateCate(bookCate);
if (updated)
{
var bc = bookHelp.GetBookCate();
return(Json(bc, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult AddBookCate(BookCategoryModel m)
{
try
{
bool added = bookHelp.AddBookCateList(m);
if (added)
{
var bookCateList = bookHelp.GetBookCate();
return(Json(bookCateList, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
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;
}
}
public List <BookCategoryModel> GetBookCategoryList()
{
try
{
List <book_category> bookcateDB = IQueryableBookCate().ToList();
List <BookCategoryModel> bookList = new List <BookCategoryModel>();
foreach (book_category b in bookcateDB)
{
BookCategoryModel bookModel = new BookCategoryModel();
bookModel.book_category_id = b.book_category_id;
bookModel.book_category_name = b.book_category_name;
bookList.Add(bookModel);
}
return(bookList);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <bool> Delete(int id)
{
BookCategoryModel item = await Get(id);
if (item == null)
{
return(true);
}
try
{
_context.Remove(item);
await _context.SaveChangesAsync();
return(true);
}
catch (DbUpdateConcurrencyException)
{
item = await Get(id);
return(item == null);
}
}
internal List <BookCategoryModel> Mapping(List <book_category> list)
{
try
{
if (list != null && list.Count > 0)
{
List <BookCategoryModel> bList = new List <BookCategoryModel>();
foreach (book_category bc in list)
{
BookCategoryModel b = new BookCategoryModel();
b.book_category_id = bc.book_category_id;
b.book_category_name = bc.book_category_name;
bList.Add(b);
}
return(bList);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateCate(BookCategoryModel bookCate)
{
return(new BookCateTypeLibrary().UpdateCate(bookCate));
}
public bool AddBookCateList(BookCategoryModel m)
{
return(new BookCategoryLibrary().AddBookCategory(m));
}
public bool AddBookCategory(BookCategoryModel bookCategory)
{
return(new BookCategoryLibrary().AddBookCategory(bookCategory));
}
