public void Salvar(DNA.Entidades.HistoricoPesquisa cli, ref DataTable oDT)
{
try
{
ConexaoPersonalizada oConn = new ConexaoPersonalizada();
try
{
OracleParameter[] arParms = new OracleParameter[6];
arParms[0] = new OracleParameter();
arParms[0].ParameterName = "V_CURSOR";
arParms[0].OracleDbType = OracleDbType.RefCursor;
arParms[0].Direction = ParameterDirection.Output;
arParms[1] = new OracleParameter();
arParms[1].ParameterName = "P_ID_CLIENTE_EMPRESA";
arParms[1].OracleDbType = OracleDbType.Int64;
arParms[1].Direction = ParameterDirection.Input;
arParms[1].Value = cli.IdClienteEmpresa;
arParms[2] = new OracleParameter();
arParms[2].ParameterName = "P_ID_CONTRATO_EMPRESA";
arParms[2].OracleDbType = OracleDbType.Int64;
arParms[2].Direction = ParameterDirection.Input;
arParms[2].Value = cli.IdContratoEmpresa;
arParms[3] = new OracleParameter();
arParms[3].ParameterName = "P_ID_USUARIO_CLIENTE";
arParms[3].OracleDbType = OracleDbType.Int64;
arParms[3].Direction = ParameterDirection.Input;
arParms[3].Value = cli.IdUsuarioConsulta;
arParms[4] = new OracleParameter();
arParms[4].ParameterName = "P_CD_ITEM_PRODUTO";
arParms[4].OracleDbType = OracleDbType.Char;
arParms[4].Direction = ParameterDirection.Input;
arParms[4].Value = cli.CodigoItemProduto;
arParms[5] = new OracleParameter();
arParms[5].ParameterName = "P_IS_DADOS_ENCONTRADOS";
arParms[5].OracleDbType = OracleDbType.Char;
arParms[5].Direction = ParameterDirection.Input;
arParms[5].Value = cli.FlagSucesso;
oConn.Execute("DNASITE.P_I_HISTORICO_CONSULTA", arParms, ref oDT);
}
catch (Exception ex)
{
throw ex;
}
finally
{
oConn.CloseConnection();
oConn = null;
}
}
catch (Exception ex)
{ throw ex; }
}
public void SalvarHistoricoFornecedor(DNA.Entidades.HistoricoPesquisa cli, ref DataTable oDT)
{
try
{
ConexaoPersonalizada oConn = new ConexaoPersonalizada();
try
{
OracleParameter[] arParms = new OracleParameter[8];
arParms[0] = new OracleParameter();
arParms[0].ParameterName = "P_ID_CLIENTE_EMPRESA";
arParms[0].OracleDbType = OracleDbType.Int64;
arParms[0].Direction = ParameterDirection.Input;
arParms[0].Value = cli.IdClienteEmpresa;
arParms[1] = new OracleParameter();
arParms[1].ParameterName = "P_ID_CONTRATO_EMPRESA";
arParms[1].OracleDbType = OracleDbType.Int64;
arParms[1].Direction = ParameterDirection.Input;
arParms[1].Value = cli.IdContratoEmpresa;
arParms[2] = new OracleParameter();
arParms[2].ParameterName = "P_ID_USUARIO_CLIENTE";
arParms[2].OracleDbType = OracleDbType.Int64;
arParms[2].Direction = ParameterDirection.Input;
arParms[2].Value = cli.IdUsuarioConsulta;
arParms[2] = new OracleParameter();
arParms[2].ParameterName = "P_CD_ITEM_PRODUTO";
arParms[2].OracleDbType = OracleDbType.Char;
arParms[2].Direction = ParameterDirection.Input;
arParms[2].Value = cli.CodigoItemProduto;
arParms[3] = new OracleParameter();
arParms[3].ParameterName = "P_RETORNO_SOLCITACAO";
arParms[3].OracleDbType = OracleDbType.Clob;
arParms[3].Direction = ParameterDirection.Input;
arParms[3].Value = cli.HTMLRetornadoFornecedor;
arParms[4] = new OracleParameter();
arParms[4].ParameterName = "P_DATA_INCLUSAO";
arParms[4].OracleDbType = OracleDbType.Date;
arParms[4].Direction = ParameterDirection.Input;
arParms[4].Value = cli.DataConsulta;
arParms[6] = new OracleParameter();
arParms[6].ParameterName = "P_DATA_ALTERACAO";
arParms[6].OracleDbType = OracleDbType.Date;
arParms[6].Direction = ParameterDirection.Input;
if (cli.DataAlteracao == null)
{
arParms[6].Value = DBNull.Value;
}
else
{
arParms[6].Value = cli.DataAlteracao;
}
arParms[7] = new OracleParameter();
arParms[7].ParameterName = "P_ID_USUARIO_ALTERACAO";
arParms[7].OracleDbType = OracleDbType.Int64;
arParms[7].Direction = ParameterDirection.Input;
if (cli.IdUsuarioAlteracao == 0)
{
arParms[7].Value = DBNull.Value;
}
else
{
arParms[7].Value = cli.IdUsuarioAlteracao;
}
oConn.Execute("DNAINFO.P_I_HISTORICO_FORNECEDOR", arParms, ref oDT);
oConn.Commit();
}
catch (Exception ex)
{
oConn.Rollback();
throw ex;
}
finally
{
oConn.CloseConnection();
oConn = null;
}
}
catch (Exception ex)
{ throw ex; }
}
