//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);
}
