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