public JsonResult GetUserPostStats([FromBody] CommunitySearchResults result)
{
var popularPosts = _context.Posts.Where(n => n.GameId == result.gameId && string.IsNullOrEmpty(n.ImageUri)).OrderByDescending(n => n.EmpathyCount).Take(4).ToList();
var popularDrawings = _context.Posts.Where(n => n.GameId == result.gameId && !string.IsNullOrEmpty(n.ImageUri)).OrderByDescending(n => n.EmpathyCount).Take(4).ToList();
popularPosts.AddRange(popularDrawings);
return(Json(new UserPostMetadata()
{
popularPosts = popularPosts
}));
}
public PagedResult <Game> GetCommunitySearchResults([FromBody] CommunitySearchResults result)
{
// var test = JsonConvert.DeserializeObject<PagedResult<Game>>(TestOutput.CommunityString);
// return test;
IQueryable <Game> query;
query = _context.Games.Where(n => n.GameId != "0");
if (!string.IsNullOrEmpty(result.title))
{
query = query.Where(n => n.Title.Contains(result.title));
}
if (!string.IsNullOrEmpty(result.type))
{
query = query.Where(n => n.Title.Contains(result.type));
}
if (!string.IsNullOrEmpty(result.titleId))
{
query = query.Where(n => n.TitleId == result.titleId);
}
if (!string.IsNullOrEmpty(result.gameId))
{
query = query.Where(n => n.TitleId == result.gameId);
}
if (result.searchAmerica)
{
query = query.Where(n => n.ViewRegion == ViewRegion.America);
}
if (result.searchEurope)
{
query = query.Where(n => n.ViewRegion == ViewRegion.Europe);
}
if (result.searchJapan)
{
query = query.Where(n => n.ViewRegion == ViewRegion.Japan);
}
if (result.searchWorld)
{
query = query.Where(n => n.ViewRegion == ViewRegion.World);
}
if (result.sortPosts != SortPosts.None)
{
if (result.sortPosts == SortPosts.Most)
{
query = query.OrderByDescending(n => n.TotalPosts);
}
if (result.sortPosts == SortPosts.Least)
{
query = query.OrderBy(n => n.TotalPosts);
}
}
else if (result.sortReplies != SortPosts.None)
{
if (result.sortReplies == SortPosts.Most)
{
query = query.OrderByDescending(n => n.TotalReplies);
}
if (result.sortReplies == SortPosts.Least)
{
query = query.OrderBy(n => n.TotalReplies);
}
}
else if (result.sortDeletedPosts != SortPosts.None)
{
if (result.sortDeletedPosts == SortPosts.Most)
{
query = query.OrderByDescending(n => n.TotalDeletedPosts);
}
if (result.sortDeletedPosts == SortPosts.Least)
{
query = query.OrderBy(n => n.TotalDeletedPosts);
}
}
else
{
if (result.sortTitle == SortTitle.Ascending)
{
query = query.OrderBy(n => n.Title);
}
if (result.sortTitle == SortTitle.Descending)
{
query = query.OrderByDescending(n => n.Title);
}
}
var community = query.GetPaged(result.page, 50);
return(community);
}
public JsonResult GetGame([FromBody] CommunitySearchResults result)
{
return(Json(_context.Games.FirstOrDefault(n => n.GameId == result.gameId)));
}
public JsonResult GetRelatedGames([FromBody] CommunitySearchResults result)
{
return(Json(_context.Games.Where(n => n.TitleId == result.titleId && n.GameId != result.gameId).ToList()));
}