private void tstButFind_Click(object sender, EventArgs e)
{
CatalogoDL catDl = new CatalogoDL();
// Set cursor as hourglass
Cursor.Current = Cursors.WaitCursor;
try
{
string cond = (chkBoxLike.Checked ? "LIKE " + MyStringUtils.entreComas("%" + txtNom_Servicio.Text + "%") :
" = " + MyStringUtils.entreComas(txtNom_Servicio.Text));
OracleDataReader dr = catDl.getCatalogoEntries("NOM_SERVICIO " + cond);
bool drVacio = (!dr.HasRows);
DataTable dt = new DataTable();
dt.Load(dr);
dgrData.DataSource = dt;
if (drVacio)
{
dataGridView1_RowEnter(null, null);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public void Modificar(CatalogoServBE pCatSrvBE)
{
string wsql = string.Empty;
decimal codRegistroN = ObtenerCodRegistro(pCatSrvBE.CodServicioN);
wsql = "update GE_AMBCATALOGO SET " + Environment.NewLine +
"COD_TIPRETORNO_N = " + Convert.ToString(pCatSrvBE.CodTipretornoN) + "," + Environment.NewLine +
"COD_OBJPROP_N = " + Convert.ToString(pCatSrvBE.CodObjpropN) + "," + Environment.NewLine +
"COD_TIPSERVICIO_N = " + Convert.ToString(pCatSrvBE.CodTipservicioN) + "," + Environment.NewLine +
"COD_ACCSERV_N = " + Convert.ToString(pCatSrvBE.CodAccservN) + "," + Environment.NewLine +
"NOM_SERVICIO = " + MyStringUtils.entreComas(pCatSrvBE.NomServicio) + "," + Environment.NewLine +
"IND_ATOMSERV_V = " + MyStringUtils.entreComas(pCatSrvBE.IndAtomservV) + "," + Environment.NewLine +
"COD_MODULO_N = " + Convert.ToString(pCatSrvBE.CodModuloN) + "," + Environment.NewLine +
"DES_SERVICIO = " + MyStringUtils.entreComas(pCatSrvBE.DesServicio) + "," + Environment.NewLine +
"NUM_CACHE = " + Convert.ToString(pCatSrvBE.NumCache) + "," + Environment.NewLine +
"DES_INVOCADOR = " + MyStringUtils.entreComas(pCatSrvBE.DesInvocador) + "," + Environment.NewLine +
"COD_REGISTRO_N = " + Convert.ToString(pCatSrvBE.CodRegistroN) + "," + Environment.NewLine +
"COD_ESTADO_N = " + Convert.ToString(pCatSrvBE.CodEstadoN) + "," + Environment.NewLine +
"IND_LOGUEO = " + Convert.ToString(pCatSrvBE.IndLogueo) + "," + Environment.NewLine +
"IND_PUBLICO = " + Convert.ToString(pCatSrvBE.IndPublico) + "," + Environment.NewLine +
"DES_ESQUEMA = " + MyStringUtils.entreComas(pCatSrvBE.DesEsquema) + Environment.NewLine +
"WHERE COD_SERVICIO_N = " + Convert.ToString(pCatSrvBE.CodServicioN);
using (DbConnection connection = database.CreateOpenConnection())
{
using (DbCommand command = database.CreateCommand(wsql, connection))
{
int numRows = command.ExecuteNonQuery();
}
}
string usuario = Environment.UserName;
bitObjDL.Registrar(3, "GE_AMBCATALOGO", codRegistroN, usuario);
}
public string ObtServiceInvoker(string pServiceName)
{
//DataSet ds = null;
string res = string.Empty;
string wSql = string.Empty;
wSql = "SELECT A.DES_INVOCADOR " + Environment.NewLine +
" FROM GE_AMBCATALOGO A " + Environment.NewLine +
" WHERE A.NOM_SERVICIO = " + MyStringUtils.entreComas(pServiceName);
using (DbConnection connection = database.CreateOpenConnection())
{
using (DbCommand command = database.CreateCommand(wSql, connection))
{
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
res = Convert.ToString(reader["DES_INVOCADOR"]);
}
}
}
}
return(res);
}
private OracleDataReader getOraMetaParamsSp(string packageName, string methodName, string schemaDb)
{
OracleDataReader res = null;
string sql = "SELECT A.package_name , A.object_name ,A.argument_name, A.data_type, A.in_out " + Environment.NewLine +
"FROM all_arguments A " + Environment.NewLine +
"WHERE package_name = " + MyStringUtils.entreComas(packageName.ToUpper()) + Environment.NewLine +
"AND object_name = " + MyStringUtils.entreComas(methodName.ToUpper()) + Environment.NewLine +
"AND OWNER = " + MyStringUtils.entreComas(schemaDb).Trim() + Environment.NewLine +
" ORDER BY POSITION";
res = MyOracleUtils.executeSqlStm(sql, this.conn);
return(res);
}
/// <summary>
///
//FUNCTION get_ddl (
// object_type IN VARCHAR2,
// name IN VARCHAR2,
// schema IN VARCHAR2 DEFAULT NULL,
// version IN VARCHAR2 DEFAULT 'COMPATIBLE',
// model IN VARCHAR2 DEFAULT 'ORACLE',
// transform IN VARCHAR2 DEFAULT 'DDL')
// RETURN CLOB;
/// </summary>
/// <param name="pOwner"></param>
/// <param name="pType"></param>
/// <param name="pObjectName"></param>
/// <returns></returns>
public string GetDll(string pSchema, string pObjectType, string pObjectName)
{
string res = string.Empty;
string wObjType = pObjectType.Replace(' ', '_');
string wsql = "select dbms_metadata.get_ddl( OBJECT_TYPE => " + MyStringUtils.entreComas(wObjType) +
", NAME =>" + MyStringUtils.entreComas(pObjectName) +
", SCHEMA => " + MyStringUtils.entreComas(pSchema) +
" ) as res from dual";
OracleDataReader dr = MyOracleUtils.executeSqlStm(wsql, ConnGl.Instance.Conn);
while (dr.Read())
{
res = (Convert.ToString(dr["RES"]));
}
return(res);
}
private void tstButFind_Click(object sender, EventArgs e)
{
BitacoraServDL bitServDL;
// Set cursor as hourglass
Cursor.Current = Cursors.WaitCursor;
try
{
bitServDL = new BitacoraServDL();
string scrap = string.Empty;
string cond = string.Empty;
scrap = (chkPorCodServ.Checked ? " A.nom_servicio = " + MyStringUtils.entreComas(txtNom_Servicio.Text) : string.Empty);
cond = scrap;
scrap = (chkPorCodUsuario.Checked ? " A.cod_usuario_v = " + MyStringUtils.entreComas(txtCodUsuario.Text) : string.Empty);
cond += (cond.Length > 0 && scrap.Length > 0 ? " AND " : string.Empty) + scrap;
scrap = " TRUNC(A.FEC_INICIO) between " + MyDateUtils.toDate(dtpFecInic.Value) + " AND " +
MyDateUtils.toDate(dtpFecFin.Value);
cond += (cond.Length > 0 && scrap.Length > 0 ? " AND " : string.Empty) + scrap;
OracleDataReader dr = bitServDL.getBitacoraEntries(cond);
bool drVacio = (!dr.HasRows);
DataTable dt = new DataTable();
dt.Load(dr);
dgrData.DataSource = dt;
if (drVacio)
{
dgrData_RowEnter(null, null);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public DataSet GetDependencies(DbObjectBE pDbObjectBE)
{
DataSet res = null;
string wsql = "select a.referenced_owner, a.referenced_type, a.referenced_name " + Environment.NewLine +
"from all_dependencies a " + Environment.NewLine +
" where a.owner = " + MyStringUtils.entreComas(pDbObjectBE.Owner) + Environment.NewLine +
" and a.type = " + MyStringUtils.entreComas(pDbObjectBE.Type) + Environment.NewLine +
" and a.name = " + MyStringUtils.entreComas(pDbObjectBE.Name) + Environment.NewLine;
try
{
res = MyOracleUtils.executeSqlStmDs(wsql, this.conn);
}
catch (Exception)
{
throw;
}
return(res);
}
public void Insertar(CatalogoServBE pCatSrvBE)
{
pCatSrvBE.CodRegistroN = bitObjDL.ObtenerCodRegistro();
string wsql = "Insert into GE_AMBCATALOGO (" + Environment.NewLine +
"COD_SERVICIO_N, COD_TIPRETORNO_N,COD_OBJPROP_N,COD_TIPSERVICIO_N, " + Environment.NewLine +
"COD_ACCSERV_N,NOM_SERVICIO,IND_ATOMSERV_V,COD_MODULO_N, " + Environment.NewLine +
"DES_SERVICIO, NUM_CACHE,DES_INVOCADOR,COD_REGISTRO_N, " + Environment.NewLine +
"COD_ESTADO_N,IND_LOGUEO,IND_PUBLICO,DES_ESQUEMA) " + Environment.NewLine +
"values (" + Environment.NewLine +
pCatSrvBE.CodServicioN.ToString() + ", " + pCatSrvBE.CodTipretornoN.ToString() + ", " +
pCatSrvBE.CodObjpropN.ToString() + ", " + pCatSrvBE.CodTipservicioN.ToString() + ", " +
pCatSrvBE.CodAccservN.ToString() + ", " + MyStringUtils.entreComas(pCatSrvBE.NomServicio) + ", " +
MyStringUtils.entreComas(pCatSrvBE.IndAtomservV) + ", " + pCatSrvBE.CodModuloN.ToString() + ", " +
MyStringUtils.entreComas(pCatSrvBE.DesServicio) + ", " + pCatSrvBE.NumCache.ToString() + ", " +
MyStringUtils.entreComas(pCatSrvBE.DesInvocador) + ", " + pCatSrvBE.CodRegistroN.ToString() +
", " + pCatSrvBE.CodEstadoN.ToString() + ", " + pCatSrvBE.IndLogueo.ToString() + ", " +
pCatSrvBE.IndPublico.ToString() + ", " + "'" + pCatSrvBE.DesEsquema + "')";
using (DbConnection connection = database.CreateOpenConnection())
{
using (DbCommand command = database.CreateCommand(wsql, connection))
{
int numRows = command.ExecuteNonQuery();
}
}
/*
* GE_PAMBBITOBJETO.registrar(pcod_accionreg_n => 1,
* pdes_tabla => 'GE_AMBDOCUMENTO',
* pcod_registro_n => wcod_registro,
* pcod_usuario_v => pCOD_USUARIOREG_V);
* */
string usuario = Environment.UserName;
bitObjDL.Registrar(1, "GE_AMBCATALOGO", pCatSrvBE.CodRegistroN, usuario);
}
string ObtServiceInvoker(string pServiceName)
{
DataSet ds = null;
string res = string.Empty;
string wSql = string.Empty;
try
{
wSql = "SELECT A.DES_INVOCADOR " + Environment.NewLine +
" FROM GE_AMBCATALOGO A " + Environment.NewLine +
" WHERE A.NOM_SERVICIO = " + MyStringUtils.entreComas(pServiceName);
ds = MyOracleUtils.executeSqlStmDs(wSql, this.conn);
foreach (DataRow dr in ds.Tables[0].Rows)
{
res = Convert.ToString(dr["DES_INVOCADOR"]);
}
}
catch (Exception)
{
throw;
}
return(res);
}