/// <summary>
/// Select all game players based on <paramref name="filter"/>
/// </summary>
/// <param name="filter">Filter used to select game players for a specific user</param>
/// <returns>A list of game players that satisfy <paramref name="filter"/></returns>
public List <Entities.GamePlayer> Execute(Entities.Filters.GamePlayer.SelectForUser filter)
{
List <Entities.GamePlayer> gamePlayers = new List <Entities.GamePlayer>();
using (DbCommand cmd = _db.GetStoredProcCommand("GamePlayer_SelectForUser"))
{
_db.AddInParameter(cmd, "@UserId", DbType.Int32, filter.UserId);
_db.AddInParameter(cmd, "@Type", DbType.Int32, filter.PlayerType);
using (IDataReader idr = _db.ExecuteReader(cmd))
{
while (idr.Read())
{
gamePlayers.Add(new Entities.GamePlayer(idr));
}
idr.NextResult();
while (idr.Read())
{
filter.TotalPoints = idr.GetValueByName <Int64>("Points");
}
}
}
return(gamePlayers);
}
public ActionResult Index(int id)
{
Entities.User viewedProfile = _selectUser.Execute(id);
Int32 currentUserId = Authentication.Security.CurrentUserId;
if (viewedProfile != null)
{
Entities.Models.Profile.Profile model = new Entities.Models.Profile.Profile();
model.ViewedProfile = viewedProfile;
model.MyProfile = viewedProfile.UserId == currentUserId;
Entities.Filters.GamePlayer.SelectForUser filter = new Entities.Filters.GamePlayer.SelectForUser();
filter.UserId = id;
filter.PlayerType = Entities.Enums.GamePlayerType.Player;
model.GameProfiles = _selectGamePlayer.Execute(filter);
model.TotalPoints = filter.TotalPoints;
TempData["showSignOut"] = model.MyProfile;
return(View(model));
}
else
{
return(Redirect(string.Format("/Profile/{0}", currentUserId)));
}
}
/// <summary>
/// Select all game players based on <paramref name="filter"/>
/// </summary>
/// <param name="filter">Filter used to select game players for a specific user</param>
/// <returns>A list of game players that satisfy <paramref name="filter"/></returns>
public List <Entities.GamePlayer> Execute(Entities.Filters.GamePlayer.SelectForUser filter)
{
return(_selectGamePlayers.Execute(filter));
}
public ActionResult Index(int id)
{
Entities.User viewedProfile = _selectUser.Execute(id);
Int32 currentUserId = Authentication.Security.CurrentUserId;
if (viewedProfile != null)
{
Entities.Models.Profile.Profile model = new Entities.Models.Profile.Profile();
model.ViewedProfile = viewedProfile;
model.MyProfile = viewedProfile.UserId == currentUserId;
Entities.Filters.GamePlayer.SelectForUser filter = new Entities.Filters.GamePlayer.SelectForUser();
filter.UserId = id;
filter.PlayerType = Entities.Enums.GamePlayerType.Player;
model.GameProfiles = _selectGamePlayer.Execute(filter);
model.TotalPoints = filter.TotalPoints;
TempData["showSignOut"] = model.MyProfile;
return View(model);
}
else
{
return Redirect(string.Format("/Profile/{0}", currentUserId));
}
}
