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