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); }