private OracleDataAdapter obterAdapter(AviaoId aviaoId) { string str = "select * from AVIAO"; if (aviaoId != null) { str += " Where AVIAO_ID = " + Bd.aspas(aviaoId.Id); } dt.Clear(); OracleDataAdapter da = new OracleDataAdapter(str, Bd.Instance.obterConexao()); OracleCommandBuilder cb = new OracleCommandBuilder(da); da.Fill(dt); return(da); }
public Cliente clientePeloEmail(string email) { string str = "select * from CLIENTE Where UPPER(NOM_EMAIL) = " + Bd.aspas(email.ToUpper()); dt.Clear(); OracleDataAdapter da = new OracleDataAdapter(str, Bd.Instance.obterConexao()); OracleCommandBuilder cb = new OracleCommandBuilder(da); da.Fill(dt); if (dt.Rows.Count == 0) { return(null); } return(modeloPelaEntidade(dt.Rows[0])); }
private OracleDataAdapter obterAdapter(CidadeId cidadeId) { string str = "select * from CIDADE"; if (cidadeId != null) { str += " Where CIDADE_ID = " + Bd.aspas(cidadeId.Id); } dt.Clear(); OracleDataAdapter da = new OracleDataAdapter(str, Bd.Instance.obterConexao()); OracleCommandBuilder cb = new OracleCommandBuilder(da); da.Fill(dt); return(da); }
public void cancelarReservaCliente(Voo voo, Cliente cliente) { string str = "select * from RESERVA Where ID_VOO = " + voo._id + " And ID_CLIENTE = " + Bd.aspas(cliente.clienteId().Id); dtReservas.Clear(); OracleDataAdapter da = new OracleDataAdapter(str, Bd.Instance.obterConexao()); OracleCommandBuilder cb = new OracleCommandBuilder(da); da.Fill(dtReservas); foreach (DataRow dr in dtReservas.Rows) { dr.Delete(); } da.Update(dtReservas); }