public List <Game> ReadExistingGamesSource()
{
StreamReader input = new StreamReader(FileName);
input.ReadLine(); //We ignore this first line - as it's the header
string initalSR = input.ReadLine().Split(',')[0];
var FirstGame = new Game();
List <Game> games = new List <Game>();
FirstGame.SR = int.Parse(initalSR);
games.Add(FirstGame);
Game NextGame;
while (!input.EndOfStream)
{
NextGame = new Game();
string[] currentLine = input.ReadLine().Split(',');
NextGame.SR = int.Parse(currentLine[0]);
NextGame.Map = currentLine[1].Trim();
NextGame.Deaths = int.Parse(currentLine[2]);
NextGame.GameTime = TimeSpan.Parse("0:" + currentLine[3].Trim());
NextGame.PlayedOn = DateTime.Parse(currentLine[4]);
string[] HeroList = currentLine[5].Split(';');
foreach (var HeroString in HeroList)
{
var Hero = new Hero();
Hero.SetHero(HeroString.Trim());
NextGame.Heroes.Add(Hero);
}
games.Add(NextGame);
}
input.Close();
return(games);
}
public List <Game> ReadExistingGamesSource()
{
string query = "SELECT * FROM gamestats";
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader reader = cmd.ExecuteReader();
List <Game> games = new List <Game>();
var FirstGame = new Game();
reader.Read();
FirstGame.SR = int.Parse(reader.GetString("SR"));
FirstGame.PlayedOn = DateTime.Parse(reader.GetString("Played_On"));
games.Add(FirstGame);
while (reader.Read())
{
Game sglGame = new Game();
sglGame.SR = int.Parse(reader.GetString("SR"));
sglGame.Map = reader.GetString("Map");
sglGame.Deaths = int.Parse(reader.GetString("Deaths"));
sglGame.GameTime = TimeSpan.Parse(reader.GetString("Game_Length"));
sglGame.PlayedOn = DateTime.Parse(reader.GetString("Played_On"));
string[] HeroList = reader.GetString("Hero").Split(';');
foreach (var HeroString in HeroList)
{
var Hero = new Hero();
Hero.SetHero(HeroString.Trim());
sglGame.Heroes.Add(Hero);
}
games.Add(sglGame);
}
reader.Close();
return(games);
}
