public string GetGenderBreakdown()
{
using (var db = new LiteDatabase(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ConfigurationManager.AppSettings["database"])))
{
var col = db.GetCollection <Player>("Player");
var Male = new InfoCount()
{
Name = "Male",
Value = 0
};
var Female = new InfoCount()
{
Name = "Female",
Value = 0
};
foreach (var player in col.FindAll())
{
if (player.Gender == "Male")
{
Male.Value += 1;
continue;
}
if (player.Gender == "Female")
{
Female.Value += 1;
continue;
}
}
var genderBreakdown = new List <InfoCount>();
genderBreakdown.Add(Male);
genderBreakdown.Add(Female);
var json = JsonConvert.SerializeObject(genderBreakdown);
return(json);
}
}
public string GetRaceBreakdown()
{
using (var db = new LiteDatabase(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ConfigurationManager.AppSettings["database"])))
{
var col = db.GetCollection <Player>("Player");
var Human = new InfoCount()
{
Name = "Human",
Value = 0
};
var Elf = new InfoCount()
{
Name = "Elf",
Value = 0
};
var DarkElf = new InfoCount()
{
Name = "Dark Elf",
Value = 0
};
var Dwarf = new InfoCount()
{
Name = "Dwarf",
Value = 0
};
foreach (var player in col.FindAll())
{
if (player.Race == "Human")
{
Human.Value += 1;
continue;
}
if (player.Race == "Elf")
{
Elf.Value += 1;
continue;
}
if (player.Race == "Dark Elf")
{
DarkElf.Value += 1;
continue;
}
if (player.SelectedClass == "Dwarf")
{
Dwarf.Value += 1;
continue;
}
}
var raceBreakdown = new List <InfoCount>();
raceBreakdown.Add(Human);
raceBreakdown.Add(Elf);
raceBreakdown.Add(DarkElf);
raceBreakdown.Add(Dwarf);
var json = JsonConvert.SerializeObject(raceBreakdown);
return(json);
}
}
public string GetClassBreakdown()
{
using (var db = new LiteDatabase(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ConfigurationManager.AppSettings["database"])))
{
var col = db.GetCollection <Player>("Player");
var Warrior = new InfoCount()
{
Name = "Fighter",
Value = 0
};
var Cleric = new InfoCount()
{
Name = "Cleric",
Value = 0
};
var Thief = new InfoCount()
{
Name = "Thief",
Value = 0
};
var Mage = new InfoCount()
{
Name = "Mage",
Value = 0
};
foreach (var player in col.FindAll())
{
if (player.SelectedClass == "Fighter")
{
Warrior.Value += 1;
continue;
}
if (player.SelectedClass == "Cleric")
{
Cleric.Value += 1;
continue;
}
if (player.SelectedClass == "Mage")
{
Mage.Value += 1;
continue;
}
if (player.SelectedClass == "Thief")
{
Thief.Value += 1;
continue;
}
}
var classBreakdown = new List <InfoCount>();
classBreakdown.Add(Warrior);
classBreakdown.Add(Cleric);
classBreakdown.Add(Mage);
classBreakdown.Add(Thief);
var json = JsonConvert.SerializeObject(classBreakdown);
return(json);
}
}
