public AuditoriaLogs ConsultarLogs(int intIDAudit)
{
AuditoriaLogs _p_Auditoria = new AuditoriaLogs();
ValidarClienteClaro _obj = new ValidarClienteClaro();
_p_Auditoria = _obj.Listar_logs(intIDAudit);
return(_p_Auditoria);
}
public bool Actualizar_Logs(ref AuditoriaLogs _pAuditoriaLog)
{
DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_AUDII_ITEM", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_NROEQUIPO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_NROENVIOSMS", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_NROINTENTO", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_NROINDICADOR", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_DISPONIBLESMS", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_COMENTARIO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_PDV", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_IPSERVICIO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_USUARIO_MODI", DbType.String, ParameterDirection.Input) };
for (int i = 0; i < arrParam.Length; i++)
{
arrParam[i].Value = DBNull.Value;
}
arrParam[0].Value = _pAuditoriaLog.AUDII_ITEM;
arrParam[1].Value = _pAuditoriaLog.AUDIV_NROEQUIPO;
arrParam[2].Value = _pAuditoriaLog.AUDII_NROENVIOSMS;
arrParam[3].Value = _pAuditoriaLog.AUDII_NROINTENTO;
arrParam[4].Value = _pAuditoriaLog.AUDII_NROINDICADOR;
arrParam[5].Value = _pAuditoriaLog.AUDII_DISPONIBLESMS;
arrParam[6].Value = _pAuditoriaLog.AUDIV_COMENTARIO;
arrParam[7].Value = _pAuditoriaLog.AUDII_PDV;
arrParam[8].Value = _pAuditoriaLog.AUDIV_IPSERVICIO;
arrParam[9].Value = _pAuditoriaLog.AUDIV_USUARIO_MODI;
bool salida = false;
BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT);
DAABRequest objRequest = obj.CreaRequest();
objRequest.CommandType = CommandType.StoredProcedure;
objRequest.Command = BaseDatos.SISACT_ACTUALIZARLOGS;
objRequest.Parameters.AddRange(arrParam);
objRequest.Transactional = true;
try
{
objRequest.Factory.ExecuteNonQuery(ref objRequest);
objRequest.Factory.CommitTransaction();
salida = true;
}
catch (Exception e)
{
throw e;
}
finally
{
objRequest.Factory.Dispose();
}
return(salida);
}
public bool ActualizarAuditoriaLog(ref AuditoriaLogs _pAuditoriaLog)
{
ValidarClienteClaro _obj = new ValidarClienteClaro();
return(_obj.Actualizar_Logs(ref _pAuditoriaLog));
}
public int ValidarCliente(string strTipDoc, string strDocumento, int intNroSEC, string strTipoOpera, string strFecha, string strUsuario, ref int p_intLogs)
{
int _intValidar = 0;
int _intValidarBRMS = 0;
int _intValidarWhite = 0;
int _intValidarBlack = 0;
AuditoriaLogs p_Auditoria = new AuditoriaLogs();
ArrayList arrLineasActivas = new ArrayList();
arrLineasActivas = ListarLineasActivas(0, strDocumento);
p_Auditoria.AUDIV_COMENTARIO = "ValidacionClienteClaro";
p_Auditoria.AUDIV_IPSERVICIO = System.Net.Dns.GetHostName();
p_Auditoria.AUDIV_NROSEC = Convert.ToString(intNroSEC);
p_Auditoria.AUDIV_TIPODOCU = strTipDoc;
p_Auditoria.AUDIV_NRODOCU = strDocumento;
p_Auditoria.AUDIV_USUARIO_CREAC = strUsuario;
if (arrLineasActivas.Count <= 0)
{
arrLineasActivas = ListarLineasActivas(Funciones.CheckInt(strTipDoc), strDocumento);
}
if (arrLineasActivas.Count <= 0)
{
p_Auditoria.AUDII_LINEAACTIVA = _intValidar;
p_Auditoria.AUDII_POPUP = 0;
GuardarAuditoriaLog(ref p_Auditoria);
p_intLogs = p_Auditoria.AUDII_ITEM;
return(_intValidar);
}
foreach (Claro.SisAct.Entidades.ItemGenerico ArrListActivas in arrLineasActivas)
{
if (ArrListActivas.Codigo == "")
{
p_Auditoria.AUDII_LINEAACTIVA = _intValidar;
p_Auditoria.AUDII_POPUP = 0;
GuardarAuditoriaLog(ref p_Auditoria);
p_intLogs = p_Auditoria.AUDII_ITEM;
return(_intValidar);
}
}
p_Auditoria.AUDII_LINEAACTIVA = 1;
string strValidarBRMS;
strValidarBRMS = ValidarBRMS(intNroSEC);
if (strValidarBRMS == "")
{
strValidarBRMS = "1";
}
if (Funciones.IsNumeric(strValidarBRMS))
{
_intValidarBRMS = Funciones.CheckInt(strValidarBRMS);
}
else
{
_intValidarBRMS = 1;
}
p_Auditoria.AUDII_BRMS = _intValidarBRMS;
p_Auditoria.AUDII_BLACKWHITE = 0;
//Ingresar Codigo Validar WHITE LIST
_intValidarWhite = ValidarWhiteBlackList(strTipDoc, strDocumento, "", strFecha, "01");
if (_intValidarWhite == 1)
{
p_Auditoria.AUDII_BLACKWHITE = 1;
p_Auditoria.AUDII_POPUP = 0;
GuardarAuditoriaLog(ref p_Auditoria);
p_intLogs = p_Auditoria.AUDII_ITEM;
_intValidar = 0;
return(_intValidar);
}
//Ingresar Codigo Validar BLACK LIST.
_intValidarBlack = ValidarWhiteBlackList(strTipDoc, strDocumento, strTipoOpera, strFecha, "02");
if (_intValidarBlack == 1)
{
_intValidar = 2;
p_Auditoria.AUDII_BLACKWHITE = 2;
p_Auditoria.AUDII_POPUP = 1;
GuardarAuditoriaLog(ref p_Auditoria);
p_intLogs = p_Auditoria.AUDII_ITEM;
return(_intValidar);
}
_intValidar = _intValidarBRMS;
//Guardar LOGS
if (_intValidar > 0)
{
p_Auditoria.AUDII_POPUP = 1;
}
//p_intLogs =2;
GuardarAuditoriaLog(ref p_Auditoria);
p_intLogs = p_Auditoria.AUDII_ITEM;
return(_intValidar);
}
public AuditoriaLogs Listar_logs(int intIdAudit)
{
DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_CONSULTA", DbType.Object, ParameterDirection.Output),
new DAABRequest.Parameter("K_AUDII_ITEM", DbType.Int32, ParameterDirection.Input), };
for (int i = 0; i < arrParam.Length; i++)
{
arrParam[i].Value = DBNull.Value;
}
arrParam[1].Value = intIdAudit;
BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT);
DAABRequest obRequest = obj.CreaRequest();
obRequest.CommandType = CommandType.StoredProcedure;
obRequest.Command = BaseDatos.SISACT_CONSULTARLOGS;
obRequest.Parameters.AddRange(arrParam);
//ArrayList filas = new ArrayList();
IDataReader dr = null;
AuditoriaLogs p_Auditoria = new AuditoriaLogs();
try
{
dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader;
if (dr != null)
{
while (dr.Read())
{
//ItemGenerico item = new ItemGenerico();
p_Auditoria.AUDII_ITEM = Funciones.CheckInt(dr["AUDII_ITEM"]);
p_Auditoria.AUDII_BLACKWHITE = Funciones.CheckInt(dr["AUDII_BLACKWHITE"]);
p_Auditoria.AUDII_BRMS = Funciones.CheckInt(dr["AUDII_BRMS"]);
p_Auditoria.AUDII_DISPONIBLESMS = Funciones.CheckInt(dr["AUDII_DISPONIBLESMS"]);
p_Auditoria.AUDII_LINEAACTIVA = Funciones.CheckInt(dr["AUDII_LINEAACTIVA"]);
p_Auditoria.AUDII_NROENVIOSMS = Funciones.CheckInt(dr["AUDII_NROENVIOSMS"]);
p_Auditoria.AUDII_NROINDICADOR = Funciones.CheckInt(dr["AUDII_NROINDICADOR"]);
p_Auditoria.AUDII_NROINTENTO = Funciones.CheckInt(dr["AUDII_NROINTENTO"]);
p_Auditoria.AUDII_PDV = Funciones.CheckInt(dr["AUDII_PDV"]);
p_Auditoria.AUDII_POPUP = Funciones.CheckInt(dr["AUDII_POPUP"]);
p_Auditoria.AUDIV_COMENTARIO = Funciones.CheckStr(dr["AUDIV_COMENTARIO"]);
p_Auditoria.AUDIV_NRODOCU = Funciones.CheckStr(dr["AUDIV_NRODOCU"]);
p_Auditoria.AUDIV_NROSEC = Funciones.CheckStr(dr["AUDIV_NROSEC"]);
p_Auditoria.AUDIV_SECUENCIA = Funciones.CheckStr(dr["AUDIV_SECUENCIA"]);
p_Auditoria.AUDIV_TIPODOCU = Funciones.CheckStr(dr["AUDIV_TIPODOCU"]);
//filas.Add(item);
}
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (dr != null && dr.IsClosed == false)
{
dr.Close();
}
obRequest.Parameters.Clear();
obRequest.Factory.Dispose();
}
return(p_Auditoria);
}
public bool Guardar_Logs(ref AuditoriaLogs _pAuditoriaLog)
{
DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_AUDI_ITEM", DbType.Int32, ParameterDirection.Output),
new DAABRequest.Parameter("K_AUDI_SEC", DbType.String, 20,ParameterDirection.Output),
new DAABRequest.Parameter("K_AUDIV_SECUENCIA", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_NROSEC", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_TIPODOCU", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_NRODOCU", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_LINEAACTIVA", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_BRMS", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_BLACKWHITE", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_POPUP", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_NROEQUIPO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_NROENVIOSMS", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_NROINTENTO", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_NROINDICADOR", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_DISPONIBLESMS", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_COMENTARIO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDII_PDV", DbType.Int32, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_IPSERVICIO", DbType.String, ParameterDirection.Input),
new DAABRequest.Parameter("K_AUDIV_USUARIO_CREAC", DbType.String, ParameterDirection.Input) };
for (int i = 0; i < arrParam.Length; i++)
{
arrParam[i].Value = DBNull.Value;
}
arrParam[0].Value = DBNull.Value;
arrParam[1].Value = DBNull.Value;
arrParam[2].Value = _pAuditoriaLog.AUDIV_SECUENCIA;
arrParam[3].Value = _pAuditoriaLog.AUDIV_NROSEC;
arrParam[4].Value = _pAuditoriaLog.AUDIV_TIPODOCU;
arrParam[5].Value = _pAuditoriaLog.AUDIV_NRODOCU;
arrParam[6].Value = _pAuditoriaLog.AUDII_LINEAACTIVA;
arrParam[7].Value = _pAuditoriaLog.AUDII_BRMS;
arrParam[8].Value = _pAuditoriaLog.AUDII_BLACKWHITE;
arrParam[9].Value = _pAuditoriaLog.AUDII_POPUP;
arrParam[10].Value = _pAuditoriaLog.AUDIV_NROEQUIPO;
arrParam[11].Value = _pAuditoriaLog.AUDII_NROENVIOSMS;
arrParam[12].Value = _pAuditoriaLog.AUDII_NROINTENTO;
arrParam[13].Value = _pAuditoriaLog.AUDII_NROINDICADOR;
arrParam[14].Value = _pAuditoriaLog.AUDII_DISPONIBLESMS;
arrParam[15].Value = _pAuditoriaLog.AUDIV_COMENTARIO;
arrParam[16].Value = _pAuditoriaLog.AUDII_PDV;
arrParam[17].Value = _pAuditoriaLog.AUDIV_IPSERVICIO;
arrParam[18].Value = _pAuditoriaLog.AUDIV_USUARIO_CREAC;
bool salida = false;
BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT);
DAABRequest objRequest = obj.CreaRequest();
objRequest.CommandType = CommandType.StoredProcedure;
objRequest.Command = BaseDatos.SISACT_GUARDARLOGS;
objRequest.Parameters.AddRange(arrParam);
objRequest.Transactional = true;
try
{
objRequest.Factory.ExecuteNonQuery(ref objRequest);
objRequest.Factory.CommitTransaction();
salida = true;
}
catch (Exception e)
{
throw e;
}
finally
{
IDataParameter parSalida1;
IDataParameter parSalida2;
parSalida1 = (IDataParameter)objRequest.Parameters[0];
_pAuditoriaLog.AUDII_ITEM = Funciones.CheckInt(parSalida1.Value);
parSalida2 = (IDataParameter)objRequest.Parameters[1];
_pAuditoriaLog.AUDIV_SECUENCIA = Funciones.CheckStr(parSalida2.Value);
objRequest.Factory.Dispose();
}
return(salida);
}
