public static string CreateFieldingStatsInsertStatement(string tableName, BattingSummary d)
{
return($@"
INSERT INTO {tableName} (""PlayerId"", ""Catches"", ""Stumpings"")
SELECT PlayerId, {d.Catches}, {d.Stumpings}
FROM Players.Details
WHERE PlayerName = '{d.PlayerName}'; {Environment.NewLine}");
}
public static string CreateStatsInsertStatement(string tableName, BattingSummary d)
{
return($@"
INSERT INTO {tableName} (PlayerId, Matches, innings, notouts, runs, average, fifties, hundreds, highscore, highscorenotout)
SELECT PlayerId, {d.Matches}, {d.Innings}, {d.NotOuts}, {d.Runs}, {d.Average}, {d.Fifties}, {d.Hundreds}, {Tools.FormatHighScore(d.HighScore)}
FROM Players.Details
WHERE PlayerName = '{d.PlayerName}'; {Environment.NewLine}");
}