/// <summary> /// Gets the achievement levels. /// </summary> /// <param name="achievements">The achievements.</param> /// <param name="dbClient">The database client.</param> internal static void GetAchievementLevels(out Dictionary <string, Achievement> achievements, IQueryAdapter dbClient) { achievements = new Dictionary <string, Achievement>(); dbClient.SetQuery("SELECT * FROM achievements_data"); DataTable table = dbClient.GetTable(); foreach (DataRow dataRow in table.Rows) { uint id = Convert.ToUInt32(dataRow["id"]); var category = (string)dataRow["category"]; var text = (string)dataRow["group_name"]; var level = (int)dataRow["level"]; var rewardPixels = (int)dataRow["reward_pixels"]; var rewardPoints = (int)dataRow["reward_points"]; var requirement = (int)dataRow["progress_needed"]; var level2 = new AchievementLevel(level, rewardPixels, rewardPoints, requirement); if (!achievements.ContainsKey(text)) { var achievement = new Achievement(id, text, category); achievement.AddLevel(level2); achievements.Add(text, achievement); } else { achievements[text].AddLevel(level2); } } }
public static void GetAchievementLevels(out Dictionary<string, Achievement> Achievements) { Achievements = new Dictionary<string, Achievement>(); using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `id`,`category`,`group_name`,`level`,`reward_pixels`,`reward_points`,`progress_needed`,`game_id` FROM `achievements`"); DataTable dTable = dbClient.getTable(); if (dTable != null) { foreach (DataRow dRow in dTable.Rows) { int id = Convert.ToInt32(dRow["id"]); string category = Convert.ToString(dRow["category"]); string groupName = Convert.ToString(dRow["group_name"]); int level = Convert.ToInt32(dRow["level"]); int rewardPixels = Convert.ToInt32(dRow["reward_pixels"]); int rewardPoints = Convert.ToInt32(dRow["reward_points"]); int progressNeeded = Convert.ToInt32(dRow["progress_needed"]); AchievementLevel AchievementLevel = new AchievementLevel(level, rewardPixels, rewardPoints, progressNeeded); if (!Achievements.ContainsKey(groupName)) { Achievement Achievement = new Achievement(id, groupName, category, Convert.ToInt32(dRow["game_id"])); Achievement.AddLevel(AchievementLevel); Achievements.Add(groupName, Achievement); } else Achievements[groupName].AddLevel(AchievementLevel); } } } }
public async Task <Dictionary <string, Achievement> > GetAchievementLevelsAsync() { Dictionary <string, Achievement> achievements = new Dictionary <string, Achievement>(); using (IAsyncDbClient client = ConnectionProvider.GetConnection()) { using (IQuery query = client.CreateQuery("SELECT `id`,`category`,`group_name`,`level`,`reward_pixels`,`reward_points`,`progress_needed`,`game_id` FROM `achievements`")) { using (var reader = await query.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { uint id = reader.GetData <uint>("id"); string category = reader.GetData <string>("category"); string groupName = reader.GetData <string>("group_name"); int rewardPixels = reader.GetData <int>("reward_pixels"); int rewardPoints = reader.GetData <int>("reward_points"); int progressNeeded = reader.GetData <int>("progress_needed"); AchievementLevel level = new AchievementLevel(reader.GetData <int>("level"), rewardPixels, rewardPoints, progressNeeded); if (!achievements.ContainsKey(groupName)) { Achievement achievement = new Achievement((int)id, groupName, category, reader.GetData <int>("game_id")); achievement.AddLevel(level); achievements.Add(groupName, achievement); } else { achievements[groupName].AddLevel(level); } } } } } return(achievements); }
public static void GetAchievementLevels(out Dictionary <string, Achievement> Achievements) { Achievements = new Dictionary <string, Achievement>(); using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `id`,`category`,`group_name`,`level`,`reward_pixels`,`reward_points`,`progress_needed`,`game_id` FROM `achievements`"); DataTable dTable = dbClient.GetTable(); if (dTable != null) { foreach (DataRow dRow in dTable.Rows) { int id = Convert.ToInt32(dRow["id"]); string category = Convert.ToString(dRow["category"]); string groupName = Convert.ToString(dRow["group_name"]); int level = Convert.ToInt32(dRow["level"]); int rewardPixels = Convert.ToInt32(dRow["reward_pixels"]); int rewardPoints = Convert.ToInt32(dRow["reward_points"]); int progressNeeded = Convert.ToInt32(dRow["progress_needed"]); AchievementLevel AchievementLevel = new AchievementLevel(level, rewardPixels, rewardPoints, progressNeeded); if (!Achievements.ContainsKey(groupName)) { Achievement Achievement = new Achievement(id, groupName, category, Convert.ToInt32(dRow["game_id"])); Achievement.AddLevel(AchievementLevel); Achievements.Add(groupName, Achievement); } else { Achievements[groupName].AddLevel(AchievementLevel); } } } } }
internal static void GetAchievementLevels(out Dictionary <string, Achievement> achievements) { achievements = new Dictionary <string, Achievement>(); using (var dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery( "SELECT `id`,`category`,`group_name`,`level`,`reward_pixels`,`reward_points`,`progress_needed`,`game_id` FROM `achievements`"); var dTable = dbClient.GetTable(); if (dTable == null) { return; } foreach (DataRow dRow in dTable.Rows) { var id = Convert.ToInt32(dRow["id"]); var category = Convert.ToString(dRow["category"]); var groupName = Convert.ToString(dRow["group_name"]); var level = Convert.ToInt32(dRow["level"]); var rewardPixels = Convert.ToInt32(dRow["reward_pixels"]); var rewardPoints = Convert.ToInt32(dRow["reward_points"]); var progressNeeded = Convert.ToInt32(dRow["progress_needed"]); var achievementLevel = new AchievementLevel(level, rewardPixels, rewardPoints, progressNeeded); if (!achievements.ContainsKey(groupName)) { var achievement = new Achievement(id, groupName, category, Convert.ToInt32(dRow["game_id"])); achievement.AddLevel(achievementLevel); achievements.Add(groupName, achievement); } else { achievements[groupName].AddLevel(achievementLevel); } } } }