/// <summary>
/// Selects game player
/// </summary>
/// <param name="gameID">The game ID used to filter game player cards</param>
/// <param name="userId">Current user Id</param>
/// <returns>A list of game player cards that satisfy the supplied filter</returns>
public List<Entities.GamePlayerCard> Execute(Int32 gameID, Int32? userId)
{
Entities.Filters.GamePlayerCard.Select filter = new Entities.Filters.GamePlayerCard.Select();
filter.GameID = gameID;
filter.UserId = userId;
return _select.Execute(filter);
}
/// <summary>
/// Selects game player
/// </summary>
/// <param name="gameID">The game ID used to filter game player cards</param>
/// <param name="userId">Current user Id</param>
/// <returns>A list of game player cards that satisfy the supplied filter</returns>
public List <Entities.GamePlayerCard> Execute(Int32 gameID, Int32?userId)
{
Entities.Filters.GamePlayerCard.Select filter = new Entities.Filters.GamePlayerCard.Select();
filter.GameID = gameID;
filter.UserId = userId;
return(_select.Execute(filter));
}
/// <summary>
/// Selects game player cards base on supplied filter
/// </summary>
/// <param name="filter">Filter used to select game player cards</param>
/// <returns>A list of game player cards that satisfy the supplied filter</returns>
public List <Entities.GamePlayerCard> Execute(Entities.Filters.GamePlayerCard.Select filter)
{
List <Entities.GamePlayerCard> playerCards = new List <Entities.GamePlayerCard>();
using (DbCommand cmd = _db.GetStoredProcCommand("GamePlayerCard_Select"))
{
_db.AddInParameter(cmd, "@GameID", DbType.Int32, filter.GameID);
if (filter.UserId.HasValue)
{
_db.AddInParameter(cmd, "@UserId", DbType.Int32, filter.UserId.Value);
}
using (IDataReader idr = _db.ExecuteReader(cmd))
{
while (idr.Read())
{
playerCards.Add(new Entities.GamePlayerCard(idr));
}
}
}
return(playerCards);
}
/// <summary>
/// Selects game player cards base on supplied filter
/// </summary>
/// <param name="filter">Filter used to select game player cards</param>
/// <returns>A list of game player cards that satisfy the supplied filter</returns>
public List <Entities.GamePlayerCard> Execute(Entities.Filters.GamePlayerCard.Select filter)
{
return(_select.Execute(filter));
}