/// <summary>
/// Selects game rounds base on gameID
/// </summary>
/// <param name="gameID">Filter used to select game rounds</param>
/// <returns>A list of game rounds that satisfy the supplied filter</returns>
public List<Entities.GameRound> Execute(Int32 gameID)
{
Entities.Filters.GameRound.Select filter = new Entities.Filters.GameRound.Select();
filter.GameID = gameID;
return _selectGameRound.Execute(filter);
}
/// <summary>
/// Selects game rounds base on gameID
/// </summary>
/// <param name="gameID">Filter used to select game rounds</param>
/// <returns>A list of game rounds that satisfy the supplied filter</returns>
public List <Entities.GameRound> Execute(Int32 gameID)
{
Entities.Filters.GameRound.Select filter = new Entities.Filters.GameRound.Select();
filter.GameID = gameID;
return(_selectGameRound.Execute(filter));
}
/// <summary>
/// Selects game rounds base on supplied filter
/// </summary>
/// <param name="filter">Filter used to select game rounds</param>
/// <returns>A list of game rounds that satisfy the supplied filter</returns>
public List <Entities.GameRound> Execute(Entities.Filters.GameRound.Select filter)
{
List <Entities.GameRound> gameRounds = new List <Entities.GameRound>();
using (DbCommand cmd = _db.GetStoredProcCommand("GameRound_Select"))
{
_db.AddInParameter(cmd, "@GameID", DbType.Int32, filter.GameID);
using (IDataReader idr = _db.ExecuteReader(cmd))
{
while (idr.Read())
{
gameRounds.Add(new Entities.GameRound(idr));
}
}
}
return(gameRounds);
}
/// <summary>
/// Selects game rounds base on supplied filter
/// </summary>
/// <param name="filter">Filter used to select game rounds</param>
/// <returns>A list of game rounds that satisfy the supplied filter</returns>
public List <Entities.GameRound> Execute(Entities.Filters.GameRound.Select filter)
{
return(_selectGameRound.Execute(filter));
}
