public void Get(PlayerInfoLog players)
{
try
{
List <string[]> results = SelectProc("GetAllPlayers", null);
Player currentPlayer;
foreach (string[] result in results)
{
currentPlayer = new Player();
currentPlayer.player.playerid = result[0];
currentPlayer.player.fname = result[1];
currentPlayer.player.lname = result[2];
currentPlayer.player.number = result[3];
currentPlayer.player.position = result[4];
currentPlayer.team.abbr = result[5];
currentPlayer.team.city = result[6];
currentPlayer.team.name = result[7];
players.playerinformation.Add(currentPlayer);
}
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
public void Get(PlayerInfoLog players, string position)
{
try
{
Dictionary <string, string> values = new Dictionary <string, string>()
{
{ "@pos", position }
};
List <string[]> results = SelectProc("GetPlayersByPosition", values);
Player currentPlayer;
foreach (string[] result in results)
{
currentPlayer = new Player();
currentPlayer.player.playerid = result[0];
currentPlayer.player.fname = result[1];
currentPlayer.player.lname = result[2];
currentPlayer.player.number = result[3];
currentPlayer.player.position = result[4];
currentPlayer.team.abbr = result[5];
currentPlayer.team.city = result[6];
currentPlayer.team.name = result[7];
players.playerinformation.Add(currentPlayer);
}
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
public Object GetAll()
{
PlayerInfoLog players = new PlayerInfoLog();
PlayerInfoService service = new PlayerInfoService();
try
{
service.Get(players);
}
catch (Exception e)
{
return(e);
}
return(players);
}
public Object GetByPosition(string position)
{
PlayerInfoLog players = new PlayerInfoLog();
PlayerInfoService service = new PlayerInfoService();
try
{
service.Get(players, position);
}
catch (Exception e)
{
return(e);
}
return(players);
}
private static IEnumerable <PlayerFieldChange> GetPlayerFieldChanges(PlayerInfoLog oldValues, PlayerInfoLog newValues)
{
var changes = new List <PlayerFieldChange>();
var customLogProperties = new[] { "Id", "Player", "RowVersion" };
typeof(PlayerInfoLog).GetProperties()
.Where(pi => !customLogProperties.Contains(pi.Name))
.ForEach(pi =>
{
var oldValue = pi.GetValue(oldValues) != null ? pi.GetValue(oldValues).ToString() : null;
var newValue = pi.GetValue(newValues) != null ? pi.GetValue(newValues).ToString() : null;
if (oldValue != newValue)
{
changes.Add(new PlayerFieldChange
{
Field = pi.Name,
OldValue = oldValue,
NewValue = newValue
});
}
});
return(changes);
}
