public static LegaGladio.Entities.Game getGame(int id)
{
LegaGladio.Entities.Game game = null;
LegaGladioDS.gameDataTable gtd = null;
LegaGladioDSTableAdapters.gameTableAdapter gta = null;
LegaGladioDS.gameRow gameRow = null;
try
{
game = new LegaGladio.Entities.Game();
gtd = new LegaGladioDS.gameDataTable();
gta = new LegaGladioDSTableAdapters.gameTableAdapter();
gta.FillById(gtd, id);
gameRow = (LegaGladioDS.gameRow)gtd.Rows[0];
}
catch (Exception ex)
{
throw ex;
}
gta = null;
gtd = null;
return game;
}
public static List<LegaGladio.Entities.Game> listGame(LegaGladio.Entities.Team team)
{
LegaGladioDS.gameDataTable gdt = new LegaGladioDS.gameDataTable();
LegaGladioDSTableAdapters.gameTableAdapter gta = new LegaGladioDSTableAdapters.gameTableAdapter();
try
{
gta.FillByTeamId(gdt, team.Id);
}
catch (Exception ex)
{
gdt.GetErrors();
throw ex;
}
List<LegaGladio.Entities.Game> gameList = new List<LegaGladio.Entities.Game>();
foreach (LegaGladioDS.gameRow gr in gdt.Rows)
{
LegaGladio.Entities.Game game = new LegaGladio.Entities.Game();
game.Id = gr.id;
game.Home = Team.getTeam(gr.homeID);
game.Guest = Team.getTeam(gr.guestID);
game.TdHome = gr.tdHome;
game.TdGuest = gr.tdGuest;
game.CasHome = gr.casHome;
game.CasGuest = gr.casGuest;
game.SpHome = gr.spHome;
game.SpGuest = gr.spGuest;
game.EarningHome = gr.earningHome;
game.EarningGuest = gr.earningGuest;
game.VarFFHome = gr.varFFHome;
game.VarFFGuest = gr.varFFGuest;
gameList.Add(game);
}
gta = null;
gdt = null;
return gameList;
}