public void SalvarExistente() { try { using (var cmd = DBcon.DbConnection().CreateCommand()) { cmd.CommandText = " Update Investimento Set " + " Ticker = @Ticker ," + " NomeEmpresa = @NomeEmpresa, " + " Setor= @Setor, " + " SubSetor= @SubSetor, " + " Segmento = @Segmento " + " where Id = @Id"; cmd.Parameters.AddWithValue("@Id", Id); cmd.Parameters.AddWithValue("Ticker", Ticker); cmd.Parameters.AddWithValue("@NomeEmpresa", NomeEmpresa); cmd.Parameters.AddWithValue("@Setor", Setor); cmd.Parameters.AddWithValue("@SubSetor", SubSetor); cmd.Parameters.AddWithValue("@Segmento", Segmento); cmd.ExecuteNonQuery(); } } catch (Exception ex) { throw ex; } }
public void SalvarNovo() { try { using (var cmd = DBcon.DbConnection().CreateCommand()) { cmd.CommandText = " Insert into Investimento (Id, Ticker, NomeEmpresa, Setor, SubSetor, Segmento) " + " Values (@Id, @Ticker, @NomeEmpresa, @Setor, @SubSetor, @Segmento)"; cmd.Parameters.AddWithValue("@Id", Id); cmd.Parameters.AddWithValue("Ticker", Ticker); cmd.Parameters.AddWithValue("@NomeEmpresa", NomeEmpresa); cmd.Parameters.AddWithValue("@Setor", Setor); cmd.Parameters.AddWithValue("@SubSetor", SubSetor); cmd.Parameters.AddWithValue("@Segmento", Segmento); cmd.ExecuteNonQuery(); } } catch (Exception ex) { throw ex; } }