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