public void ReadJsonDeserialize(string fileName, IPlayer _players, DateTime date)
{
SaveStats playerStats = new SaveStats();
int i = 0;
try
{
Rootobject rootObject = JsonConvert.DeserializeObject <Rootobject>(File.ReadAllText(fileName));
foreach (var p in rootObject.dailyplayerstats.playerstatsentry)
{
System.Diagnostics.Debug.WriteLine("#: " + i++ + "Id: " + p.player.ID + " " + p.player.LastName);
if (p.player.Position == "P")
{
PitcherStats stats = playerStats.BuildPitcherStatModel(Convert.ToInt32(p.player.ID), p.stats, date);
_players.AddPitcherStats(stats);
}
else
{
HitterStats stats = playerStats.BuildHitterMStatModel(Convert.ToInt32(p.player.ID), p.stats, date);
_players.AddHitterStats(stats);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Error reading Json file: " + ex);
}
System.Diagnostics.Debug.WriteLine(i + " Daily Stats Records Read. ");
}
public void BuildHitterMStatModel(int id, Stats stats, IPlayer _context, DateTime date)
{
HitterStats playerStats = new HitterStats
{
PlayerId = id,
GamesPlayed = Convert.ToInt32(stats.GamesPlayed.text),
AtBats = Convert.ToInt32(stats.AtBats.text),
Doubles = Convert.ToInt32(stats.SecondBaseHits.text),
ExtraBases = Convert.ToInt32(stats.ExtraBaseHits.text),
Hits = Convert.ToInt32(stats.Hits.text),
HomeRuns = Convert.ToInt32(stats.Homeruns.text),
RBI = Convert.ToInt32(stats.RunsBattedIn.text),
Runs = Convert.ToInt32(stats.Runs.text),
Sacrifices = Convert.ToInt32(stats.BatterSacrificeBunts.text)
+ Convert.ToInt32(stats.BatterSacrificeFlies.text),
TotalBases = Convert.ToInt32(stats.TotalBases.text),
StolenBases = Convert.ToInt32(stats.StolenBases.text),
Triples = Convert.ToInt32(stats.ThirdBaseHits.text),
Walks = Convert.ToInt32(stats.BatterWalks.text),
Strikeouts = Convert.ToInt32(stats.BatterWalks.text),
Average = (float)Convert.ToDouble(stats.BattingAvg.text),
IsCumulative = true,
Date = DateTime.Today
};
_context.AddHitterStats(playerStats);
}
public void AddHitterStats(HitterStats stats)
{
try
{
_context.HitterStats.Add(stats);
_context.SaveChanges();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Error Adding Hitter Stat:" + ex);
}
}