public void Get(DefenseLogs defenses)
{
try
{
List <string[]> results = SelectProc("GetAllDefenseSeasonStats", null);
Defense defense;
foreach (string[] result in results)
{
defense = new Defense();
defense.seasonLog = new DefenseStats();
defense.defense.abbr = result[0];
defense.defense.city = result[1];
defense.defense.name = result[2];
defense.seasonLog.pa = result[3];
defense.seasonLog.sck = result[4];
defense.seasonLog.fum = result[5];
defense.seasonLog.intc = result[6];
defense.seasonLog.intTd = result[7];
defense.seasonLog.fumTd = result[8];
defense.seasonLog.sfty = result[9];
defense.seasonLog.krTd = result[10];
defense.seasonLog.prTd = result[11];
defense.seasonLog.fgBlk = result[12];
defense.seasonLog.xpBlk = result[13];
defenses.defenseLogs.Add(defense);
}
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
public void Get(DefenseLogs defenses, string gameid)
{
try
{
Dictionary <string, string> values = new Dictionary <string, string>()
{
{ "@game", gameid }
};
List <string[]> results = SelectProc("GetAllDefensesStatsGame", values);
Defense defense = null;
DefenseGameStats gameStats = null;
foreach (string[] result in results)
{
if (defense == null || defense.defense.abbr != result[0])
{
if (defense != null)
{
defenses.defenseLogs.Add(defense);
}
defense = new Defense();
defense.gameLogs = new List <DefenseGameStats>();
defense.defense.abbr = result[0];
defense.defense.city = result[1];
defense.defense.name = result[2];
}
gameStats = new DefenseGameStats();
gameStats.game.gameid = result[3];
gameStats.game.date = result[4];
gameStats.game.time = result[5];
gameStats.game.homeTeam.abbr = result[6];
gameStats.game.homeTeam.city = result[7];
gameStats.game.homeTeam.name = result[8];
gameStats.game.awayTeam.abbr = result[9];
gameStats.game.awayTeam.city = result[10];
gameStats.game.awayTeam.name = result[11];
gameStats.stats.pa = result[12];
gameStats.stats.sck = result[13];
gameStats.stats.fum = result[14];
gameStats.stats.intc = result[15];
gameStats.stats.intTd = result[16];
gameStats.stats.fumTd = result[17];
gameStats.stats.sfty = result[18];
gameStats.stats.krTd = result[19];
gameStats.stats.prTd = result[20];
gameStats.stats.fgBlk = result[21];
gameStats.stats.xpBlk = result[22];
defense.gameLogs.Add(gameStats);
}
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
public Object GetAllDefenseGameLogs()
{
DefenseLogs defenses = new DefenseLogs();
DefenseGameService service = new DefenseGameService();
try
{
service.Get(defenses);
}
catch (Exception e)
{
return(e);
}
return(defenses);
}
