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); }