public void saveInfrastructure(Infrastructure Inf)
{
cmd.CommandText = "INSERT INTO infrastructure(name, quantity, price, status)" +
" values(@name, @quantity,@price, @status)";
cmd.Parameters.AddWithValue("@name", Inf.getName());
cmd.Parameters.AddWithValue("@quantity", Inf.getQuantity());
cmd.Parameters.AddWithValue("@price", Inf.getPrice());
cmd.Parameters.AddWithValue("@status", Inf.getStatus());
cmd.ExecuteNonQuery();
conn.Close();
}
public void updateInfrastructure(Infrastructure Inf)
{
cmd.CommandText = " UPDATE infrastructure SET name = @name, quantity = @quantity, " +
" price = @price, status = @status " +
" where id = @id ";
cmd.Parameters.AddWithValue("@id", Inf.getId());
cmd.Parameters.AddWithValue("@name", Inf.getName());
cmd.Parameters.AddWithValue("@quantity", Inf.getQuantity());
cmd.Parameters.AddWithValue("@price", Inf.getPrice());
cmd.Parameters.AddWithValue("@status", Inf.getStatus());
cmd.ExecuteNonQuery();
conn.Close();
}
