public static List <AchievementObject> GetAllAchievements() { List <AchievementObject> achievementList = new List <AchievementObject>(); using (var db = new AchievementsDatabaseEntities()) { var achievements = db.Achievements; foreach (var achievement in achievements) { var achievementObject = ConvertToAchObj(achievement); achievementList.Add(achievementObject); } } return(achievementList); }
public static List <AchievementObject> GetSubCategoryAchievements(string subcategory) { List <AchievementObject> subcategoryAchievements = new List <AchievementObject>(); using (var db = new AchievementsDatabaseEntities()) { var achievements = from a in db.Achievements where a.Subcategories.Any(s => s.Name == subcategory) select a; foreach (var achievement in achievements) { var achievementObject = ConvertToAchObj(achievement); subcategoryAchievements.Add(achievementObject); } } return(subcategoryAchievements); }