public static int ArticleUserPoint(GagsContext context, long userId, long articleId) { try { var user = context.Users.Include(u => u.Votes).ThenInclude(v => v.Article) .Where(u => u.Id == userId).First(); return(user.Votes.Where(v => v.Article.Id == articleId).Select(v => v.Point).First()); } catch (Exception e) { return(0); } }
public static long GetUserIdFromToken(GagsContext context, ClaimsPrincipal user) { var auth0 = user.Claims.FirstOrDefault(c => c.Type == ClaimTypes.NameIdentifier).Value; User userDb; try { userDb = context.Users.Where(u => u.Auth0.Equals(auth0)).First(); } catch (Exception e) { userDb = new User(); } return(userDb.Id); }
public VoteController(IHostingEnvironment environment, GagsContext context) { _environment = environment; _context = context; }