public static void GetAchievementLevels(out Dictionary <string, Achievement> achievements) { achievements = new Dictionary <string, Achievement>(); using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT * FROM achievements"); foreach (DataRow dataRow in dbClient.GetTable().Rows) { int Id = Convert.ToInt32(dataRow["id"]); string Category = (string)dataRow["category"]; string GroupName = (string)dataRow["group_name"]; AchievementLevel Level = new AchievementLevel((int)dataRow["level"], (int)dataRow["reward_pixels"], (int)dataRow["reward_points"], (int)dataRow["progress_needed"]); if (!achievements.ContainsKey(GroupName)) { Achievement achievement = new Achievement(Id, GroupName, Category); achievement.AddLevel(Level); achievements.Add(GroupName, achievement); } else { achievements[GroupName].AddLevel(Level); } } } }
internal static void GetAchievementLevels(out Dictionary <string, Achievement> achievements, IQueryAdapter dbClient) { achievements = new Dictionary <string, Achievement>(); dbClient.setQuery("SELECT * FROM achievements"); DataTable dTable = dbClient.getTable(); uint id; string category; string groupName; int level; int rewardPixels; int rewardPoints; int progressNeeded; foreach (DataRow dRow in dTable.Rows) { id = Convert.ToUInt32(dRow["id"]); category = (string)dRow["category"]; groupName = (string)dRow["group_name"]; level = (int)dRow["level"]; rewardPixels = (int)dRow["reward_pixels"]; rewardPoints = (int)dRow["reward_points"]; progressNeeded = (int)dRow["progress_needed"]; AchievementLevel achievementLevel = new AchievementLevel(level, rewardPixels, rewardPoints, progressNeeded); if (!achievements.ContainsKey(groupName)) { Achievement achievement = new Achievement(id, groupName, category); achievement.AddLevel(achievementLevel); achievements.Add(groupName, achievement); } else { achievements[groupName].AddLevel(achievementLevel); } } }
internal static void GetAchievementLevels(out Dictionary<string, Achievement> achievements, IQueryAdapter dbClient) { achievements = new Dictionary<string, Achievement>(); dbClient.setQuery("SELECT * FROM achievements"); DataTable dTable = dbClient.getTable(); uint id; string category; string groupName; int level; int rewardPixels; int rewardPoints; int progressNeeded; foreach (DataRow dRow in dTable.Rows) { id = Convert.ToUInt32(dRow["id"]); category = (string)dRow["category"]; groupName = (string)dRow["group_name"]; level = (int)dRow["level"]; rewardPixels = (int)dRow["reward_pixels"]; rewardPoints = (int)dRow["reward_points"]; progressNeeded = (int)dRow["progress_needed"]; AchievementLevel achievementLevel = new AchievementLevel(level, rewardPixels, rewardPoints, progressNeeded); if (!achievements.ContainsKey(groupName)) { Achievement achievement = new Achievement(id, groupName, category); achievement.AddLevel(achievementLevel); achievements.Add(groupName, achievement); } else { achievements[groupName].AddLevel(achievementLevel); } } }