public UserStatistics UserStatistics(string email) { User user = (User)context.Users.Where(x => x.Email == email).FirstOrDefault(); UserStatistics us = new UserStatistics(); if (user != null) { us.Wins = context.Winners.Where(x => x.UserEmail == email).Count(); us.Losses = context.UserEvents.Where(x => x.UserEmail == email).Count(); us.NumberOfParticipations = us.Wins + us.Losses; us.TotalSpots = NumberOfUserTicketsHandedOut(email); } else { throw new ArgumentException("User does not exist"); } return us; }