public async Task <ActionResult> Index(int?page, string domainname, string sortingmode)
{
const int pageSize = 25;
int pageNumber = (page ?? 0);
if (pageNumber < 0 || String.IsNullOrWhiteSpace(domainname) || pageNumber > 9)
{
return(NotFoundErrorView());
}
if (domainname.Length < 4)
{
return(RedirectToAction("UnAuthorized", "Error"));
}
sortingmode = (sortingmode == "new" ? "new" : "hot");
ViewBag.SelectedSubverse = "domains";
ViewBag.SelectedDomain = domainname;
domainname = domainname.Trim().ToLower();
//TODO: This needs to moved to Query/Repository
var results = CacheHandler.Instance.Register(CachingKey.DomainSearch(domainname, pageNumber, sortingmode), () => {
using (var db = new voatEntities())
{
db.EnableCacheableOutput();
//restrict disabled subs from result list
IQueryable <Submission> q = (from m in db.Submissions
join s in db.Subverses on m.Subverse equals s.Name
where
!s.IsAdminDisabled.Value &&
!m.IsDeleted &&
m.Type == 2 &&
m.Url.ToLower().Contains(domainname)
select m);
if (sortingmode == "new")
{
ViewBag.SortingMode = sortingmode;
q = q.OrderByDescending(x => x.CreationDate);
}
else
{
ViewBag.SortingMode = "hot";
q = q.OrderByDescending(x => x.Rank).ThenByDescending(x => x.CreationDate);
}
var result = q.Skip(pageNumber * pageSize).Take(pageSize).ToList();
return(result);
}
}, TimeSpan.FromMinutes(60));
var paginatedSubmissions = new PaginatedList <Submission>(results, page ?? 0, pageSize);
ViewBag.Title = "Showing all submissions which link to " + domainname;
return(View("Index", paginatedSubmissions));
}