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);
}
public string AddKeysParametersInvoke()
{
const string lexFldDb = "<%fldDb>";
string res = string.Empty;
string scrap = string.Empty;
List <OraclePkColumnDef> tblCols = null;
string template = " GE_PAMBCOMMON.ADDPARAMNUMBER(pParams => arrParams, " + Environment.NewLine +
" PPARAMNAME => " + MyStringUtils.entreChar(lexFldDb, '\'') + ", " + Environment.NewLine +
" PVALUE => P" + lexFldDb + ") ";
bool ft = true;
try
{
tblCols = this.oraTblMeta.ObtPkColumnDef();
foreach (var item in tblCols)
{
scrap = template;
scrap = scrap.Replace(lexFldDb, item.ColumnName);
res += (ft? string.Empty : Environment.NewLine + "; ") +
scrap;
ft = false;
}
return(res);
}
catch (Exception)
{
throw;
}
}
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;
}
}
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);
}
public string AddKeysParametersInvoke()
{
string res = string.Empty;
string sqlStm;
string scrap;
string template = " GE_PAMBCOMMON.ADDPARAMNUMBER(pParams => arrParams, " + Environment.NewLine +
" PPARAMNAME => " + MyStringUtils.entreChar(lexFldDb, '\'') + ", " + Environment.NewLine +
" PVALUE => P" + lexFldDb + ") ";
bool ft = true;
try
{
sqlStm = sqlKeysTable;
sqlStm = sqlStm.Replace(lexTableName, this.TableName);
using (DbConnection connection = database.CreateOpenConnection())
{
using (DbCommand command = database.CreateCommand(sqlStm, connection))
{
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
scrap = template;
scrap = scrap.Replace(lexFldDb, Convert.ToString(reader["COLUMN_NAME"]));
res += (ft ? string.Empty : Environment.NewLine + "; ") +
scrap;
ft = false;
}
}
}
}
return(res);
}
catch (Exception)
{
throw;
}
}
//make list of textures here
public void LoadContent()
{
MyMwcLog.WriteLine("MySpriteListVideoPlayer.LoadContent - START");
MyMwcLog.IncreaseIndent();
m_spriteBatch = new SpriteBatch(MyMinerGame.Static.GraphicsDevice, "SpriteListVideoPlayer");
// We must iterate over defined number of frames. We can't relly on reading files from a folder because in final
// build that folder will contain "hash" files and it may contain some other random files too, so then iteration won't work correctly.
for (int frame = m_frameFirst; frame <= m_frameLast; frame++)
{
string toput = "Videos\\" + m_fileName + "\\" + MyStringUtils.AlignIntToRight(frame, 4, '0');
MyMwcLog.WriteLine("Loading file: " + toput, SysUtils.LoggingOptions.LOADING_SPRITE_VIDEO);
MyTexture2D tx = MyTextureManager.GetTexture <MyTexture2D>(toput);
if (tx != null)
{
m_frames.Add(tx);
}
}
MyMwcLog.DecreaseIndent();
MyMwcLog.WriteLine("MySpriteListVideoPlayer.LoadContent - END");
}
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);
}
public static int WordCount(this String str)
{
return(MyStringUtils.WordCount(str));
}
private string GetServerName()
{
return(MyStringUtils.StartTo(ServerName, "\\"));
}
private string GetInstanceName()
{
return(MyStringUtils.EndTo(ServerName, "\\"));
}
