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