/// <summary>
/// Executes "store" SQL command within transaction.
/// </summary>
private void storeResult(long uid, SqliteTransaction trans, StoredResult sr)
{
cmdInsertResult.Transaction = trans;
cmdInsertResult.Parameters["@uid"].Value = uid;
cmdInsertResult.Parameters["@country"].Value = sr.CountryCode;
cmdInsertResult.Parameters["@quiz_ix"].Value = sr.PrevQuizCount;
cmdInsertResult.Parameters["@survey_ix"].Value = sr.PrevSurveyCount;
cmdInsertResult.Parameters["@score"].Value = sr.Score;
cmdInsertResult.Parameters["@res_enc"].Value = sr.EncodedResult;
cmdInsertResult.Parameters["@survey_enc"].Value = sr.GetEncodedSurvey();
cmdInsertResult.ExecuteNonQuery();
}
