public Futba001001 buscar(int fua001001Id)
{
OracleCommand oComando = new OracleCommand();
oComando.Connection = new OracleConnection("Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-VVJBQE3)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = XE)));User Id=OTEO;Password=OTEO");
oComando.CommandText = "SELECT * " +
" FROM FUTBA001001 " +
" WHERE FUA001001_ID = :FUA001001_ID ";
oComando.Parameters.Add("FUA001001_ID", fua001001Id);
oComando.CommandType = System.Data.CommandType.Text;
oComando.Connection.Open();
DbDataReader reader = oComando.ExecuteReader();
reader.Read();
var fua001001 = new Futba001001()
{
fua001001Id = reader.GetInt("FUA001001_ID"),
fua001001Funcao = reader.GetString("FUA001001_FUNCAO"),
fua001001Situacao = reader.GetString("FUA001001_SITUACAO")
};
oComando.Connection.Close();
return(fua001001);
}
public void inserir(Futba001001 fua001001)
{
OracleCommand oComando = new OracleCommand();
oComando.Connection = new OracleConnection("Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-VVJBQE3)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = XE)));User Id=OTEO;Password=OTEO");
oComando.CommandText = " INSERT " +
" INTO FUTBA001001 " +
" VALUES(:FUA001001_ID, " +
" :FUA001001_FUNCAO, " +
" :FUA001001_SITUACAO) ";
oComando.Parameters.Add("FUA001001_ID", fua001001.fua001001Id);
oComando.Parameters.Add("FUA001001_FUNCAO", fua001001.fua001001Funcao);
oComando.Parameters.Add("FUA001001_SITUACAO", fua001001.fua001001Situacao);
oComando.CommandType = System.Data.CommandType.Text;
oComando.Connection.Open();
oComando.ExecuteNonQuery();
oComando.Connection.Close();
}