public void alterar(Ustba001001 usa001001) { 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 = " UPDATE USTBA001001 " + " SET USA001001_USUARIO = :USA001001_USUARIO " + " USA001001_SENHA = :USA001001_SENHA " + " USA001001_NOME = :USA001001_NOME " + " USA001001_SOBRENOME = :USA001001_SOBRENOME " + " USA001001_EMAIL = :USA001001_EMAIL " + " USA001001_SITUACAO = :USA001001_SITUACAO " + " USA001001_TUA001001_ID = :USA001001_TUA001001_ID " + " USA001001_EMA001001_ID = :USA001001_EMA001001_ID " + " USA001001_FUA001001_ID = :USA001001_FUA001001_ID " + " WHERE USA001001_ID = :USA001001_ID "; oComando.Parameters.Add("USA001001_ID", usa001001Id); oComando.Parameters.Add("USA001001_USUARIO", usa001001Usuario); oComando.Parameters.Add("USA001001_SENHA", usa001001Senha); oComando.Parameters.Add("USA001001_NOME", usa001001Nome); oComando.Parameters.Add("USA001001_SOBRENOME", usa001001Sobrenome); oComando.Parameters.Add("USA001001_EMAIL", usa001001Email); oComando.Parameters.Add("USA001001_SITUACAO", usa001001Situacao); oComando.Parameters.Add("USA001001_TUA001001_ID", usa001001.tutba001001.tua001001Id); oComando.Parameters.Add("USA001001_EMA001001_ID", usa001001.emtba001001.ema001001Id); oComando.Parameters.Add("USA001001_FUA001001_ID", usa001001.futba001001.fua001001Id); oComando.CommandType = System.Data.CommandType.Text; oComando.Connection.Open(); oComando.ExecuteNonQuery(); oComando.Connection.Close(); }
public Ustba001001 buscar(int usa001001Id) { 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 USTBA001001 " + " WHERE USA001001_ID = :USA001001_ID "; oComando.Parameters.Add("USA001001_ID", usa001001Id); oComando.CommandType = System.Data.CommandType.Text; oComando.Connection.Open(); DbDataReader reader = oComando.ExecuteReader(); reader.Read(); var usa001001 = new Ustba001001() { usa001001Id = reader.GetInt("USA001001_ID"), usa001001Usuario = reader.GetString("USA001001_USUARIO"), usa001001Senha = reader.GetString("USA001001_SENHA"), usa001001Nome = reader.GetString("USA001001_NOME"), usa001001Sobrenome = reader.GetString("USA001001_SOBRENOME"), usa001001Email = reader.GetString("USA001001_EMAIL"), usa001001Situacao = reader.GetString("USA001001_SITUACAO"), tutba001001 = new Tutba001001().buscar(reader.GetInt("USA001001_TUA001001_ID")), emtba001001 = new Emtba001001().buscar(reader.GetInt("USA001001_EMA001001_ID")), futba001001 = new Futba001001().buscar(reader.GetInt("USA001001_FUA001001_ID")) }; oComando.Connection.Close(); return(usa001001); }