public static SqlPlayer ToSqlPlayer(Player player)
{
return(new SqlPlayer
{
Id = player.Id,
Name = player.Name,
Position = player.Position,
Age = player.Age,
Nationality = player.Nationality,
Height = player.Height,
Weight = player.Weight,
Rating = player.Rating,
ShotsTotal = player.Per90Stats.Shots.Total,
ShotsOnTarget = player.Per90Stats.Shots.OnTarget,
ShotsPercentageOnTarget = player.Per90Stats.Shots.PercentageOnTarget,
PassesTotal = player.Per90Stats.Passes.Total,
PassesKeyPasses = player.Per90Stats.Passes.KeyPasses,
PassesAccuracy = player.Per90Stats.Passes.Accuracy,
TacklesTotalTackles = player.Per90Stats.Tackles.TotalTackles,
TacklesBlocks = player.Per90Stats.Tackles.Blocks,
TacklesInterceptions = player.Per90Stats.Tackles.Interceptions,
DuelsWon = player.Per90Stats.Duels.Won,
DuelsPercentageWon = player.Per90Stats.Duels.PercentageWon,
DribblesAttempted = player.Per90Stats.Dribbles.Attempted,
DribblesWon = player.Per90Stats.Dribbles.Won,
DribblesPercentageWon = player.Per90Stats.Dribbles.PercentageWon,
FoulsDrawn = player.Per90Stats.Fouls.Drawn,
FoulsCommitted = player.Per90Stats.Fouls.Committed,
GoalsTotal = player.Goals.Total,
GoalsConceded = player.Goals.Conceded,
GoalsAssists = player.Goals.Assists
});
}
public void SetPlayer(Player player)
{
var sqlPlayer = Converter.ToSqlPlayer(player);
Connection.Execute(@"insert into player (id, name, position, age, nationality, height, weight, rating, shotstotal, shotsontarget, shotspercentageontarget, passestotal, passeskeypasses, passesaccuracy, tacklestotaltackles, tacklesblocks, tacklesinterceptions, duelswon, duelspercentagewon, dribblesattempted, dribbleswon, dribblespercentagewon, foulsdrawn, foulscommitted, goalstotal, goalsconceded, goalsassists) values (@id, @name, @position, @age, @nationality, @height, @weight, @rating, @shotstotal, @shotsontarget, @shotspercentageontarget, @passestotal, @passeskeypasses, @passesaccuracy, @tacklestotaltackles, @tacklesblocks, @tacklesinterceptions, @duelswon, @duelspercentagewon, @dribblesattempted, @dribbleswon, @dribblespercentagewon, @foulsdrawn, @foulscommitted, @goalstotal, @goalsconceded, @goalsassists) on conflict (id) do update set (id, name, position, age, nationality, height, weight, rating, shotstotal, shotsontarget, shotspercentageontarget, passestotal, passeskeypasses, passesaccuracy, tacklestotaltackles, tacklesblocks, tacklesinterceptions, duelswon, duelspercentagewon, dribblesattempted, dribbleswon, dribblespercentagewon, foulsdrawn, foulscommitted, goalstotal, goalsconceded, goalsassists) = (@id, @name, @position, @age, @nationality, @height, @weight, @rating, @shotstotal, @shotsontarget, @shotspercentageontarget, @passestotal, @passeskeypasses, @passesaccuracy, @tacklestotaltackles, @tacklesblocks, @tacklesinterceptions, @duelswon, @duelspercentagewon, @dribblesattempted, @dribbleswon, @dribblespercentagewon, @foulsdrawn, @foulscommitted, @goalstotal, @goalsconceded, @goalsassists) where player.id = @id", sqlPlayer);
}
