/// <summary>
/// returns all games that need reviewing from the database
/// </summary>
/// <returns>DataTable of all games</returns>
public static DataTable GamesToReview()
{
return(DalHelper.AllWhere("Games", "Review Status", 0));
}
/// <summary>
/// gets all games from a developer
/// </summary>
/// <param name="devId">id of developer</param>
/// <returns></returns>
public static DataTable AllGamesFromDeveloper(int devId)
{
return(DalHelper.AllWhere("Games", "Developer", devId));
}
/// <summary>
/// returns a table of all codes for a game
/// </summary>
/// <param name="game">id of game</param>
/// <returns>table of all codes</returns>
public static DataTable GameCodesForGame(int game)
{
return(DalHelper.AllWhere("GameCodes", "Game", game));
}
/// <summary>
/// gets photos by user
/// </summary>
/// <param name="user">id of user</param>
/// <returns>DataTable of photos</returns>
public static DataTable GetPhotosOfUser(int user)
{
return(DalHelper.AllWhere("UserPhotos", "User", user));
}
/// <summary>
/// gets photos by game
/// </summary>
/// <param name="game">id of game</param>
/// <returns>DataTable of photos</returns>
public static DataTable GetPhotosOfGame(int game)
{
return(DalHelper.AllWhere("GamePhotos", "Game", game));
}
/// <summary>
/// returns a list of all updates of a game
/// </summary>
/// <param name="game">game to retrieve updates of</param>
/// <returns>DataTable of updates</returns>
public static DataTable ListUpdates(int game)
{
return(DalHelper.AllWhere("GameUpdates", "Game", game));
}
