public static BowlingSummary ParseData(string[] args)
{
Decimal.TryParse(args[6], out var average);
Decimal.TryParse(args[9], out var economy);
var name = args[1];
if (name.Contains('\''))
{
name = name.Insert(name.IndexOf('\''), '\''.ToString());
}
var sum = new BowlingSummary();
sum.PlayerName = name;
sum.Matches = Int32.Parse(args[3]);
sum.Overs = Convert.ToInt32((Convert.ToDouble(args[2])));
sum.Runs = Int32.Parse(args[4]);
sum.Wickets = Int32.Parse(args[5]);
sum.Average = average;
sum.FiveWicketHauls = Int32.Parse(args[7]);
sum.BestFigures = FormatBestFigures(args[8]);
sum.Economy = economy;
return(sum);
}
public static string CreateStatsInsertStatement(BowlingSummary d, string tableName)
{
return($@"
INSERT INTO {tableName} (PlayerId, Matches, Overs, Runs, Wickets, FiveWicketHauls, BestFigsRuns, BestFigsWickets, Economy, Average)
SELECT PlayerId, {d.Matches}, {d.Overs}, {d.Runs}, {d.Wickets}, {d.FiveWicketHauls}, {d.BestFigures.Runs}, {d.BestFigures.Wickets}, {d.Economy}, {d.Average}
FROM Players.Details
WHERE PlayerName = '{d.PlayerName}'; {Environment.NewLine}");
}