void InsertRankingPointsBonusRecord(int rpPoint)
{
using (var rCommand = Connection.CreateCommand())
{
rCommand.CommandText = "INSERT INTO ranking_point_bonus(sortie, step, time, point) " +
"VALUES((SELECT MAX(id) FROM sortie), " +
"(SELECT max(step) FROM sortie_detail WHERE id = (SELECT MAX(id) FROM sortie)), " +
"strftime('%s', 'now'), @point);";
rCommand.Parameters.AddWithValue("@point", rpPoint);
rCommand.ExecuteNonQuery();
}
}
}