public static ObservableCollection<User> GetAllUsers()
{
var allUsers = new ObservableCollection<User>();
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
var userData = (from u in data.UserDataProviders
join p in data.ProfileDataProviders on u.id equals p.user_id
select
new User
{
UserName = u.user_name,
UserID = u.id,
Email = p.email,
FirstName = p.first_name,
LastName = p.last_name,
City = p.city,
State = p.state,
Gender = p.gender,
ProfileID = p.id,
Age = p.age,
Weight = p.weight,
Height = p.height,
GreenScore = p.green_score,
ActivityScore = new ActivityScore(
p.activity_score_badges,
p.activity_score_challenges,
p.activity_score_contests)
});
foreach (var user in userData)
{
allUsers.Add(user);
}
}
return allUsers;
}