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(); }