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