public FootballersDataSet.FootballersDataTable MapFootballers(IEnumerable <Footballer> footballers)
{
var footballersDataTable = new FootballersDataSet().Footballers;
foreach (var footballer in footballers)
{
var row = footballersDataTable.NewFootballersRow();
row.FirstName = footballer.first_name;
row.Surname = footballer.second_name;
row.Position = ((Positions)footballer.element_type).ToString();
row.Team = ((Teams)footballer.team).ToString();
row.Cost = (decimal)footballer.now_cost / 10;
row.PointsLstRnd = footballer.event_points;
row.TotalPoints = footballer.total_points;
row.AveragePoints = decimal.Parse(footballer.points_per_game, NumberStyles.Any);
row.AvgPointsPound = (row.AveragePoints / row.Cost) * (footballer.minutes / 1000);
row.TotPointsPound = (row.TotalPoints / row.Cost) * (footballer.minutes / 1000);
//row.AvgPointsPound = footballer.AvgPointsDollar;
//row.TotPointsPound = footballer.TotPointsDollar;
row.TransfersOut = footballer.transfers_out;
row.YellowCards = footballer.yellow_cards;
row.GoalsConceded = footballer.goals_conceded;
//row.GoalsConcededPts = footballer.GoalsConcededPts;
row.Saves = footballer.saves;
//row.SavesPts = footballer.SavesPts;
row.GoalsScored = footballer.goals_scored;
row.ValueSeason = decimal.Parse(footballer.value_season);
row.TransfersOutRnd = footballer.transfers_out_event;
row.PriceRise = footballer.cost_change_start;
row.PriceFallRnd = footballer.cost_change_event_fall;
row.PriceFall = footballer.cost_change_start_fall;
row.ValueForm = decimal.Parse(footballer.value_form);
row.PenaltiesMissed = footballer.penalties_missed;
row.Form = decimal.Parse(footballer.form);
row.Bonus = footballer.bonus;
row.CleanSheets = footballer.clean_sheets;
row.Assists = footballer.assists;
row.SelectedByPcent = decimal.Parse(footballer.selected_by_percent);
row.TransfersIn = footballer.transfers_in;
row.OwnGoals = footballer.own_goals;
row.EAIndex = footballer.ea_index;
row.PenaltiesSaved = footballer.penalties_saved;
row.DreamTeamCount = footballer.dreamteam_count;
row.MinutesPlayed = footballer.minutes;
row.TransfersInRound = footballer.transfers_in_event;
row.PriceRiseRound = footballer.cost_change_event;
row.RedCards = footballer.red_cards;
row.BPS = footballer.bps;
row.News = footballer.news;
row.Influence = decimal.Parse(footballer.influence);
row.Creativity = decimal.Parse(footballer.creativity);
row.Threat = decimal.Parse(footballer.threat);
row.Status = char.Parse(footballer.status);
row.InDreamteam = footballer.in_dreamteam;
row.Photo = System.IO.Path.GetFileNameWithoutExtension(footballer.photo);
row.ID = footballer.id;
footballersDataTable.AddFootballersRow(row);
}
return footballersDataTable;
}
