public void Update(Material rpData)
{
using (var rCommand = Connection.CreateCommand())
{
rCommand.CommandText = "INSERT INTO resources(time, fuel, bullet, steel, bauxite, development_material, bucket, instant_construction, improvement_material) " +
"VALUES (strftime('%s', 'now'), @fuel, @bullet, @steel, @bauxite, @development_material, @bucket, @instant_construction, @improvement_material)";
rCommand.Parameters.Add(new SQLiteParameter("@fuel", rpData.Fuel));
rCommand.Parameters.Add(new SQLiteParameter("@bullet", rpData.Bullet));
rCommand.Parameters.Add(new SQLiteParameter("@steel", rpData.Steel));
rCommand.Parameters.Add(new SQLiteParameter("@bauxite", rpData.Bauxite));
rCommand.Parameters.Add(new SQLiteParameter("@development_material", rpData.DevelopmentMaterial));
rCommand.Parameters.Add(new SQLiteParameter("@bucket", rpData.Bucket));
rCommand.Parameters.Add(new SQLiteParameter("@instant_construction", rpData.InstantConstruction));
rCommand.Parameters.Add(new SQLiteParameter("@improvement_material", rpData.ImprovementMaterial));
rCommand.ExecuteNonQuery();
}
}
public Headquarter()
{
Material = new Material();
}
