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);
}
}
}