public void AppendScores(string personName, Scores scores)
{
var pathToDb = Path.Combine(Application.persistentDataPath, "data.bytes");
var connectionString = $"URI=file:{pathToDb}";
using (var connection = new SqliteConnection(connectionString))
{
connection.Open();
CreateScoresTableIfNotExists(connection);
var fragSum = scores.Frags.Sum(x => x.Value);
var scoreStorageData = ScoresStorageData.Create(scores);
var summarySerialized = JsonConvert.SerializeObject(scoreStorageData);
var textSummary = TextSummaryHelper.CreateTextSummary(scores);
using (var command = connection.CreateCommand())
{
command.CommandText = $@"INSERT INTO [Scores](Name, Preffix, Mode, Scores, Turns, Frags, Summary, TextSummary)
VALUES ('{personName}', 'preffix', 'mode', {scores.BaseScores}, {scores.Turns}, {fragSum}, '{summarySerialized}', '{textSummary}')";
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
}
connection.Close();
}
}
public void SaveScores()
{
var storageDataObject = ScoresStorageData.Create(_scoreManager.Scores);
SaveInner(storageDataObject, "Scores.txt");
}
