public IActionResult GetBooks()
{
var tableModel = new DataTablesAjaxRequestModel(Request);
var model = new BookModel(_configuration);
var data = model.GetBooks(tableModel);
return(Json(data));
}
public ActionResult DisApproveBook(int bookid)
{
BOOK book = BookModel.FilterBook(bookid);
if (book == null)
{
return(HttpNotFound());
}
book.STATUS = Constant.DISAPPROVE_TEXT;
BookModel.UpdateBook(book);
int pendingApprovalCount = BookModel.GetBooks().Where(query => String.IsNullOrEmpty(query.STATUS)).Count();
return(Json(pendingApprovalCount, JsonRequestBehavior.AllowGet));
}
// GET: Search
public ActionResult Index(int id = -1, String query = "", int page = 1, int pageSize = 4)
{
String[] searchSequence = query.Split(' ');
IEnumerable <String> wordSequesnce = searchSequence.ToList();
List <BOOK> books = new List <BOOK>();
if (id == -1 && query == "")
{
books = BookModel.GetBooks();
}
else if (id != -1 && query != "")
{
IEnumerable <BOOK_CATEGORY> bookCat = BookModel.GetBookCategories();
foreach (BOOK_CATEGORY bCat in bookCat)
{
if (bCat.CATEGORYID == id && bCat.BOOK.NAME.ToLower().Contains(query.ToLower()) || bCat.BOOK.SYNOPOSIS.ToLower().Contains(query.ToLower()))
{
books.Add(bCat.BOOK);
}
}
}
else if (id == -1 && query != "")
{
IEnumerable <BOOK> listBooks = BookModel.GetBooks();
foreach (BOOK book in listBooks)
{
if (book.NAME.ToLower().Contains(query.ToLower()) || book.SYNOPOSIS.ToLower().Contains(query.ToLower()))
{
books.Add(book);
}
}
}
else if (id != -1 && query == "")
{
IEnumerable <BOOK_CATEGORY> bookCat = BookModel.GetBookCategories();
foreach (BOOK_CATEGORY bCat in bookCat)
{
if (bCat.CATEGORYID == id)
{
books.Add(bCat.BOOK);
}
}
}
IPagedList <BOOK> pBooks = new PagedList <BOOK>(books, page, pageSize);
return(View(pBooks));
}
public ActionResult AutoComplete(string keyword)
{
List <BOOK> match = new List <BOOK>();
int cnt = 0;
foreach (BOOK book in BookModel.GetBooks())
{
if (book.NAME.ToLower().Contains(keyword.ToLower()))
{
match.Add(book);
cnt++;
}
if (cnt >= 4)
{
break;
}
}
return(Json(match, JsonRequestBehavior.AllowGet));
}
public ActionResult PendingBooks()
{
return(View(BookModel.GetBooks().Where(query => String.IsNullOrEmpty(query.STATUS))));
}
public ActionResult BookList(int page = 1, int pageSize = 6)
{
IPagedList <BOOK> books = new PagedList <BOOK>(BookModel.GetBooks(), page, pageSize);
return(View(books));
}
public ActionResult Index()
{
return(View(BookModel.GetBooks()));
}
