public InternalProcess(PackageTransaction transaccion)
{
this.transaccion = transaccion;
}
private bool CheckExecute(PackageTransaction transaction, out long isecaudit, out string mensajeCheckExecute)
{
OracleConnection sqlConnection = null;
OracleCommand sqlCommand = null;
OracleParameter sqlParameter = null;
int iparamret = -1;
isecaudit = 0;
mensajeCheckExecute = string.Empty;
sqlConnection = new OracleConnection(this.cadena);
try
{
sqlCommand = new OracleCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = String.Format("{0}.{1}", "bza_pq_bts", "sp_prc_checkexecute2");
sqlParameter = sqlCommand.Parameters.Add("o_return", OracleDbType.Int32);
sqlParameter.Direction = ParameterDirection.InputOutput;
sqlParameter.Value = 0;
sqlParameter = sqlCommand.Parameters.Add("i_loginid", OracleDbType.Int32);
sqlParameter.Value = transaction.LoginId;
sqlParameter = sqlCommand.Parameters.Add("i_sessionid", OracleDbType.Int32);
sqlParameter.Value = transaction.SessionId;
sqlParameter = sqlCommand.Parameters.Add("i_bancoid", OracleDbType.Int16);
sqlParameter.Value = transaction.BankId;
sqlParameter = sqlCommand.Parameters.Add("i_tranid", OracleDbType.Int32);
sqlParameter.Value = transaction.TranId;
sqlParameter = sqlCommand.Parameters.Add("i_userid", OracleDbType.Varchar2, 20);
sqlParameter.Value = transaction.UserId;
sqlParameter = sqlCommand.Parameters.Add("i_companyid", OracleDbType.Int32);
sqlParameter.Value = transaction.CompanyId;
sqlParameter = sqlCommand.Parameters.Add("i_usertype", OracleDbType.Varchar2, 1);
sqlParameter.Value = transaction.UserType;
sqlParameter = sqlCommand.Parameters.Add("i_serviceid", OracleDbType.Varchar2, 10);
sqlParameter.Value = transaction.ServiceId;
sqlParameter = sqlCommand.Parameters.Add("i_optionid", OracleDbType.Varchar2, 2);
sqlParameter.Value = transaction.OptionId;
sqlParameter = sqlCommand.Parameters.Add("i_stationid", OracleDbType.Varchar2, 30);
sqlParameter.Value = transaction.StationId;
sqlParameter = sqlCommand.Parameters.Add("i_spname", OracleDbType.Varchar2, 50);
sqlParameter.Value = transaction.Name;
sqlParameter = sqlCommand.Parameters.Add("i_source", OracleDbType.Varchar2, 50);
sqlParameter.Value = transaction.Source;
sqlParameter = sqlCommand.Parameters.Add("i_paramsxml", OracleDbType.Varchar2, 8000);
sqlParameter.Value = string.Empty;
sqlParameter = sqlCommand.Parameters.Add("o_auditoria", OracleDbType.Int32);
sqlParameter.Direction = ParameterDirection.Output;
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
iparamret = int.Parse(sqlCommand.Parameters["o_return"].Value.ToString());
isecaudit = int.Parse(sqlCommand.Parameters["o_auditoria"].Value.ToString());
if (iparamret != 0)
{
mensajeCheckExecute = string.Format("No tiene permiso para ejecutar la transacción. Ret:{0}", iparamret);
}
}
catch (Exception ex)
{
mensajeCheckExecute = ex.Message;
// BizTransactionalServer.Log.ServerEventLog.WriteEntry("CheckExecute :" + sMessage);
}
finally
{
sqlParameter = null;
if (sqlCommand != null)
{
//sqlCommand.Dispose();
sqlCommand = null;
}
if (sqlConnection != null)
{
sqlConnection.Close();
//sqlConnection.Dispose();
sqlConnection = null;
}
}
if (iparamret == 0)
{
return(true);
}
else
{
// PackageWriter pWriter = new PackageWriter(ResultSetError("100030", ReplaceXmlChars(sMessage), TypeResultSet.DbError));
// pWriter.WritePackage(out this._dataPackage);
// pWriter = null;
return(false);
}
}
public ClienteDBMS()
{
_Transaction = new PackageTransaction();
cabeceraDBMS = new CabeceraDBMS();
respuesta = null;
}