//PROY-24740 public HistorialDataCreditoCorp obtenerHistorialDCCorp(DataCreditoCorpIN p_datacredito) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_TIPO_DOC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_NRO_RUC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_TIPO_SEC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("K_CUR_HISTORIAL_DC", DbType.Object, ParameterDirection.Output), new DAABRequest.Parameter("K_CUR_HISTORIAL_REPLEG", DbType.Object, ParameterDirection.Output) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[0].Value = p_datacredito.istrTipoDocumento.Substring(p_datacredito.istrTipoDocumento.Length - 1, 1); arrParam[1].Value = p_datacredito.istrNumeroDocumento; arrParam[2].Value = p_datacredito.istrTipoSEC; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); string[] sTab = { "historico", "representantes" }; obRequest.TableNames = sTab; obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_HISTORICO_DC + ".SPS_OBTENER_HISTORICO_DC_CORP"; obRequest.Parameters.AddRange(arrParam); IDataReader dr = null; HistorialDataCreditoCorp objConsultaHistorialDataCreditoCorp = new HistorialDataCreditoCorp(); try { dr = obRequest.Factory.ExecuteReader(ref obRequest).ReturnDataReader; while (dr.Read()) { objConsultaHistorialDataCreditoCorp.ws53_Out_Header_CodigoRetorno = Funciones.CheckStr(dr["COD_RETORNO"]); objConsultaHistorialDataCreditoCorp.ws12_Out_Header_NumeroOperacion = Funciones.CheckStr(dr["NUM_OPERACION"]); objConsultaHistorialDataCreditoCorp.ws50_Out_GrupoIntegrantes_IntegranteNombres = Funciones.CheckStr(dr["RAZON_SOCIAL"]); objConsultaHistorialDataCreditoCorp.ws50_Out_CampoValor_Accion = Funciones.CheckStr(dr["RIESGO"]); objConsultaHistorialDataCreditoCorp.ws12_In_Nombres = Funciones.CheckStr(dr["NOMBRES"]); objConsultaHistorialDataCreditoCorp.ws12_In_ApellidoPaterno = Funciones.CheckStr(dr["APE_PAT"]); objConsultaHistorialDataCreditoCorp.ws12_In_ApellidoMaterno = Funciones.CheckStr(dr["APE_MAT"]); objConsultaHistorialDataCreditoCorp.ws50_Out_CampoValor_MsgIngTarjeta = Funciones.CheckStr(dr["MSG_ING_TAR"]); objConsultaHistorialDataCreditoCorp.ws50_Out_CampoValor_MsgIngDHipotecaria = Funciones.CheckStr(dr["MSG_ING_DHIP"]); objConsultaHistorialDataCreditoCorp.ws50_Out_CampoValor_MsgIngDnHipoTarjeta = Funciones.CheckStr(dr["MSG_ING_DNHIPO_TAR"]); objConsultaHistorialDataCreditoCorp.buro_consultado = Funciones.CheckInt(dr["BURO_CREDITICIO"]); //PROY-20054-IDEA-23849 } // Para los representantes legal dr.NextResult(); ArrayList ListaRepresentanteLegal = new ArrayList(); string strNombreCompletoRRLL = ""; string strApePaterno = ""; string strApeMaterno = ""; string strNombre = ""; string[] arrNombre; while (dr.Read()) { RepresentanteLegal oRepresentanteLegal = new RepresentanteLegal(); oRepresentanteLegal.APODC_TIP_DOC_REP = Funciones.CheckStr(dr["TIPO_DOCUMENTO"]); oRepresentanteLegal.APODV_NUM_DOC_REP = Funciones.CheckStr(dr["NUMERO_DOCUMENTO"]); strNombreCompletoRRLL = Funciones.CheckStr(dr["NOMBRES"]); arrNombre = strNombreCompletoRRLL.Split(' '); strApePaterno = ""; strApeMaterno = ""; strNombre = ""; if (arrNombre.Length == 3) { strApePaterno = arrNombre[0]; strApeMaterno = arrNombre[1]; strNombre = arrNombre[2]; } else { if (arrNombre.Length > 3) { strApePaterno = arrNombre[0]; strApeMaterno = arrNombre[1]; strNombre = ""; StringBuilder sblNombre = new StringBuilder(); for (int z = 2; z < arrNombre.Length; z++) { sblNombre.AppendFormat("{0} ", arrNombre[z]); } strNombre = sblNombre.ToString().Trim(); } } oRepresentanteLegal.APODV_APA_REP_LEG = strApePaterno; oRepresentanteLegal.APODV_AMA_REP_LEG = strApeMaterno; oRepresentanteLegal.APODV_NOM_REP_LEG = strNombre; oRepresentanteLegal.APODV_CAR_REP = Funciones.CheckStr(dr["CARGO"]); ListaRepresentanteLegal.Add(oRepresentanteLegal); } objConsultaHistorialDataCreditoCorp.RepresentantesLegales = ListaRepresentanteLegal; } finally { if (dr != null && dr.IsClosed == false) { dr.Close(); } obRequest.Parameters.Clear(); obRequest.Factory.Dispose(); } return(objConsultaHistorialDataCreditoCorp); }
public bool grabarConsultaDCCorp(HistorialDataCreditoCorp item, ref string rMsg) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("K_RESULTADO", DbType.Int64, ParameterDirection.Output), new DAABRequest.Parameter("P_WS12_IN_TIPDOC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_IN_NUMDOC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_IN_APEPAT", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_IN_APEMAT", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_IN_NOM", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_IN_TIPPER", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_IN_TIPSER", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_OUT_HEADER_TRA", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_OUT_HEADER_TIPSER", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_OUT_HEADER_CODRET", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_OUT_HEADER_NUMOPE", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_OUT_ERROR_CODMEN", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS12_OUT_ERROR_MEN", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_IN_TIPSER", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_IN_NUMOPE", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_HEADER_TRA", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_HEADER_TIPSER", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_HEADER_CODRET", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_HEADER_NUMOPE", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_GI_INTTIPDOC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_GI_INTNUMDOC", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_GI_INTNOM", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CN_ACCION", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CECAMPO_ACCION", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CV_ACCION", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CN_MSGINGTAR", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CEC_MSGINGTAR", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CV_MSGINGTAR", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CN_MSGINGDHIP", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CEC_MSGINGDHIP", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CV_MSGINGDHIP", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CN_MSGINGDNHIPOTAR", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CEC_MSGINGDNHIPOTAR", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CV_MSGINGDNHIPOTAR", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CN_EXP", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CEC_EXP", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CV_EXP", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CN_EXPAUX", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CEC_EXPAUX", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS50_OUT_CV_EXPAUX", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS53_IN_TIPSER", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS53_IN_NUMOPE", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS53_OUT_HEADER_TRA", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS53_OUT_HEADER_TIPSER", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS53_OUT_HEADER_CODRET", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_WS53_OUT_HEADER_NUMOPE", DbType.String, ParameterDirection.Input), new DAABRequest.Parameter("P_BURO_CREDITICIO", DbType.Int64, ParameterDirection.Input) // ADD PROY-20054-IDEA-23849 }; int i = 0; for (i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } i = 1; arrParam[i].Value = item.ws12_In_TipoDocumento; ++i; arrParam[i].Value = item.ws12_In_NumeroDocumento; ++i; if (!Funciones.CheckStr(item.ws12_In_ApellidoPaterno).Equals("")) { arrParam[i].Value = item.ws12_In_ApellidoPaterno; } ++i; if (!Funciones.CheckStr(item.ws12_In_ApellidoMaterno).Equals("")) { arrParam[i].Value = item.ws12_In_ApellidoMaterno; } ++i; if (!Funciones.CheckStr(item.ws12_In_Nombres).Equals("")) { arrParam[i].Value = item.ws12_In_Nombres; } ++i; arrParam[i].Value = item.ws12_In_TipoPersona; ++i; arrParam[i].Value = item.ws12_In_TipoServicio; ++i; arrParam[i].Value = item.ws12_Out_Header_Transaccion; ++i; arrParam[i].Value = item.ws12_Out_Header_TipoServicio; ++i; arrParam[i].Value = item.ws12_Out_Header_CodigoRetorno; ++i; arrParam[i].Value = item.ws12_Out_Header_NumeroOperacion; ++i; arrParam[i].Value = item.ws12_Out_Error_CodigoMensajes; ++i; arrParam[i].Value = item.ws12_Out_Error_Mensaje; ++i; arrParam[i].Value = item.ws50_In_TipoServicio; ++i; arrParam[i].Value = item.ws50_In_NumeroOperacion; ++i; arrParam[i].Value = item.ws50_Out_Header_Transaccion; ++i; arrParam[i].Value = item.ws50_Out_Header_TipoServicio; ++i; arrParam[i].Value = item.ws50_Out_Header_CodigoRetorno; ++i; arrParam[i].Value = item.ws50_Out_Header_NumeroOperacion; ++i; arrParam[i].Value = item.ws50_Out_GrupoIntegrantes_IntegranteTipoDocumento; ++i; arrParam[i].Value = item.ws50_Out_GrupoIntegrantes_IntegranteNumeroDocumento; ++i; arrParam[i].Value = item.ws50_Out_GrupoIntegrantes_IntegranteNombres; ++i; arrParam[i].Value = item.ws50_Out_CampoNombre_Accion; ++i; arrParam[i].Value = item.ws50_Out_CampoExisteCampo_Accion; ++i; arrParam[i].Value = item.ws50_Out_CampoValor_Accion; ++i; arrParam[i].Value = item.ws50_Out_CampoNombre_MsgIngTarjeta; ++i; arrParam[i].Value = item.ws50_Out_CampoExisteCampo_MsgIngTarjeta; ++i; arrParam[i].Value = item.ws50_Out_CampoValor_MsgIngTarjeta; ++i; arrParam[i].Value = item.ws50_Out_CampoNombre_MsgIngDHipotecaria; ++i; arrParam[i].Value = item.ws50_Out_CampoExisteCampo_MsgIngDHipotecaria; ++i; arrParam[i].Value = item.ws50_Out_CampoValor_MsgIngDHipotecaria; ++i; arrParam[i].Value = item.ws50_Out_CampoNombre_MsgIngDnHipoTarjeta; ++i; arrParam[i].Value = item.ws50_Out_CampoExisteCampo_MsgIngDnHipoTarjeta; ++i; arrParam[i].Value = item.ws50_Out_CampoValor_MsgIngDnHipoTarjeta; ++i; arrParam[i].Value = item.ws50_Out_CampoNombre_Explicacion; ++i; arrParam[i].Value = item.ws50_Out_CampoExisteCampo_Explicacion; ++i; arrParam[i].Value = item.ws50_Out_CampoValor_Explicacion; ++i; arrParam[i].Value = item.ws50_Out_CampoNombre_ExplicacionAuxiliar; ++i; arrParam[i].Value = item.ws50_Out_CampoExisteCampo_ExplicacionAuxiliar; ++i; arrParam[i].Value = item.ws50_Out_CampoValor_ExplicacionAuxiliar; ++i; arrParam[i].Value = item.ws53_In_TipoServicio; ++i; arrParam[i].Value = item.ws53_In_NumeroOperacion; ++i; arrParam[i].Value = item.ws53_Out_Header_Transaccion; ++i; arrParam[i].Value = item.ws53_Out_Header_TipoServicio; ++i; arrParam[i].Value = item.ws53_Out_Header_CodigoRetorno; ++i; arrParam[i].Value = item.ws53_Out_Header_NumeroOperacion; ++i; arrParam[i].Value = item.buro_consultado; // ADD PROY-20054-IDEA-23849 bool salida = false; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_HISTORICO_DC + ".SPI_GRABAR_HISTORICO_DC_CORP"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); for (int j = 0; j < item.RepresentantesLegales.Count; j++) { if (!grabarConsultaDCCorpRepresentantesLegales((HistorialDataCreditoRepLegCorp)item.RepresentantesLegales[j], ref rMsg)) { obRequest.Factory.RollBackTransaction(); return(salida); } } obRequest.Factory.CommitTransaction(); salida = true; } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); rMsg = "Error al Insertar Historial de Consulta a Data Crédito Corp. \nMensaje : " + ex.Message; throw ex; } finally { obRequest.Factory.Dispose(); } return(salida); }