//truyen dang theo tai khoan public ActionResult ComicsUser() { if (_user != null) { int page = Convert.ToInt32(Request["page"]); if (page <= 0) { page = 1; } int userId = _user.UserId; ComicDAO comicDao = new ComicDAO(); PaginationComic list = comicDao.ComicUser(new Pagination(10, page), userId); ViewBag.Comics = list.Comics; ViewBag.Page = list.Page; ViewBag.Numpage = list.PageSize; return(View()); } else { return(Redirect(Url.Action("Login", "User"))); } }
//phân trang thường public PaginationComic ListPage(Pagination pagination, IOrderedQueryable <comic> comics) { int page = pagination.Page; int size = pagination.Size; if (page < 1) { page = 1; } int skip = (page - 1) * size; int sizePage = comics.Count(); if (sizePage % size > 0) { sizePage = sizePage / size + 1; } else { sizePage = sizePage / size; } var sql = comics.Skip(skip).Take(size).ToList(); PaginationComic paginationComic = new PaginationComic(sizePage, page, sql); return(paginationComic); }
public String Test(String[] arrayIn, String[] arrayNotIn, String nameComic, String status, String author, String nation, String page, String sort) { List <String> listIn = new List <string>(); List <String> listNotIn = new List <string>(); if (arrayIn != null) { listIn = arrayIn.ToList(); } if (arrayNotIn != null) { listNotIn = arrayNotIn.ToList(); } SuperSearch superSearch = new SuperSearch(listIn, listNotIn, Convert.ToInt32(nation), Convert.ToInt32(status), nameComic, author); ComicDAO comicDao = new ComicDAO(); Pagination pagination = new Pagination(16, Convert.ToInt32(page)); PaginationComic paginationComic = comicDao.SearchAdvanced(superSearch, pagination, sort); String json = JsonConvert.SerializeObject(paginationComic, Formatting.Indented); return(json); }
public PaginationComic List(Pagination pagination) { var comics = WcDbContext.comics.OrderBy(comic => comic.ComicId); PaginationComic list = ListPage(pagination, comics); return(list); }
public PaginationComic ComicUser(Pagination pagination, int userId) { var comics = WcDbContext.comics.Where(comic => comic.UserId == userId).OrderBy(comic => comic.ComicId); PaginationComic list = ListPage(pagination, comics); return(list); }
public PaginationComic CensorshipComic(Pagination pagination) { var comics = WcDbContext.comics.Where(comic => comic.StatusComicId == 4).OrderBy(comic => comic.ComicId); PaginationComic list = ListPage(pagination, comics); return(list); }
public PaginationComic CategoryComic(Pagination pagination, String categoryId) { int id = Convert.ToInt32(categoryId); var sql = (WcDbContext.comics .Join(WcDbContext.comic_category, comics => comics.ComicId, comicCategory => comicCategory.ComicId, (comics, comicCategory) => new { comics, comicCategory }) .Where(@t => @t.comicCategory.CategoryId == id) .Select(@t => new ComicCategoryFilte() { ComicId = @t.comics.ComicId, BanerComic = @t.comics.CommicBanner, Chapters = @t.comics.chapters, NameComic = @t.comics.NameComic } )).OrderBy(filte => filte.NameComic); PaginationComic list = ListPage(pagination, sql); return(list); }