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