void InsertRecord(long rpTimestamp)
{
using (var rCommand = Connection.CreateCommand())
{
rCommand.CommandText = "INSERT INTO resources(time, fuel, bullet, steel, bauxite, instant_construction, bucket, development_material, improvement_material) " +
"VALUES(@time, @fuel, @bullet, @steel, @bauxite, @instant_construction, @bucket, @development_material, @improvement_material);";
rCommand.Parameters.AddWithValue("@time", rpTimestamp);
rCommand.Parameters.AddWithValue("@fuel", r_Fuel);
rCommand.Parameters.AddWithValue("@bullet", r_Bullet);
rCommand.Parameters.AddWithValue("@steel", r_Steel);
rCommand.Parameters.AddWithValue("@bauxite", r_Bauxite);
rCommand.Parameters.AddWithValue("@instant_construction", r_InstantConstruction);
rCommand.Parameters.AddWithValue("@bucket", r_Bucket);
rCommand.Parameters.AddWithValue("@development_material", r_DevelopmentMaterial);
rCommand.Parameters.AddWithValue("@improvement_material", r_ImprovementMaterial);
rCommand.ExecuteNonQuery();
}
}
}