<%@ Page Language="VB" ContentType="text/html" EnableEventValidation="false" ResponseEncoding="iso-8859-1" Debug="true" %> <% If Request.QueryString("cd") <> "" Then Dim NewsId As String NewsId = Request.QueryString("cd") Dim GeneListDetail As Merit.ICM.Gene GeneListDetail = New Merit.ICM.Gene(APPConfig.ConnString) GeneListDetail.OpenSqlReader("__aClientsNew_Get @code='" & NewsId &"'") GeneListDetail.Reader.Read() PageName = GeneListDetail.Reader.Item("nombre") &" "&GeneListDetail.Reader.Item("apellido") Dim Nacimiento() As String Dim NacimientoConyugue() As String Dim FechaTrabajo() As String Dim NivelAcademico_Val As Integer Dim TipoInversionistaIndice As Integer Nacimiento = GeneListDetail.Reader.Item("fechanacimiento").Split("-") NacimientoConyugue = GeneListDetail.Reader.Item("fechanacimientoconyugue").Split("-") FechaTrabajo = GeneListDetail.Reader.Item("fechaingreso").Split("-") If GeneListDetail.Reader.Item("nivelacademico") = "Primaria" Or GeneListDetail.Reader.Item("nivelacademico") = "Secundaria" Then NivelAcademico_Val = 2 If GeneListDetail.Reader.Item("nivelacademico") = "Universitario" Or GeneListDetail.Reader.Item("nivelacademico") = "Postgrado" Or GeneListDetail.Reader.Item("nivelacademico") = "Maestría" Then NivelAcademico_Val = 5 TipoInversionistaIndice = GeneListDetail.Reader.Item("actividad_financiera") + GeneListDetail.Reader.Item("actividad_agricola") + GeneListDetail.Reader.Item("actividad_comercial") + GeneListDetail.Reader.Item("actividad_industiral") + GeneListDetail.Reader.Item("actividad_turismo") + GeneListDetail.Reader.Item("actividad_construccion") + GeneListDetail.Reader.Item("actividad_servicios") + GeneListDetail.Reader.Item("experiencia_inversionista") + GeneListDetail.Reader.Item("sector_inversion") + GeneListDetail.Reader.Item("ingresos_anuales") + GeneListDetail.Reader.Item("activos_liquidos") + GeneListDetail.Reader.Item("activos_cuentas_corrientes") + GeneListDetail.Reader.Item("activos_certificados_financieros") + GeneListDetail.Reader.Item("activos_papel_comercial") + GeneListDetail.Reader.Item("activos_bonos") + GeneListDetail.Reader.Item("activos_fondos_mutuos") + GeneListDetail.Reader.Item("activos_acciones") + GeneListDetail.Reader.Item("activos_fondos_cerrados") + GeneListDetail.Reader.Item("operaciones_certificado_financiero") + GeneListDetail.Reader.Item("operaciones_bonos") + GeneListDetail.Reader.Item("operaciones_fondos_mutuos") + GeneListDetail.Reader.Item("operaciones_fonods_cerrados") + GeneListDetail.Reader.Item("operaciones_papel_comercial") + GeneListDetail.Reader.Item("operaciones_prestamos_margen") + GeneListDetail.Reader.Item("operaciones_acciones") + GeneListDetail.Reader.Item("operaciones_mutuos") + GeneListDetail.Reader.Item("operaciones_foward") + GeneListDetail.Reader.Item("criterio_rentabilidad_riesgo") + GeneListDetail.Reader.Item("tomar_desicion") + GeneListDetail.Reader.Item("tomar_desicion1") + GeneListDetail.Reader.Item("medios_usa") + GeneListDetail.Reader.Item("margen_bajo") + GeneListDetail.Reader.Item("mutuo_valores") + GeneListDetail.Reader.Item("plazo_objetivos") + GeneListDetail.Reader.Item("destino_inversion") + GeneListDetail.Reader.Item("considera_inversion") + GeneListDetail.Reader.Item("capacidad_absorver") + GeneListDetail.Reader.Item("cuando_retorno") + GeneListDetail.Reader.Item("preferencia_moneda") + GeneListDetail.Reader.Item("patrimonio_cambio") + GeneListDetail.Reader.Item("patrimonio_cambio_total") + GeneListDetail.Reader.Item("redimiento_inversion")+GeneListDetail.Reader.Item("edad") + NivelAcademico_Val Dim YearAge As Integer YearAge = DateTime.Now.Year - Nacimiento(2) %> Formulario - Perfil Confidencial United Capital
<%= GeneListDetail.Reader.Item("nombre") &" "&GeneListDetail.Reader.Item("apellido") %> <%= GeneListDetail.Reader.Item("cedula") %> <%= GeneListDetail.Reader.Item("doc_type") %> <%= IIF(YearAge >= 55, "X", "")%> <%= IIF(YearAge <= 55 And YearAge >= 35, "X", "")%> <%= IIF(YearAge <= 35, "X", "")%> <%= IIF(GeneListDetail.Reader.Item("nivelacademico") = "Primaria", "X", "")%> <%= IIF(GeneListDetail.Reader.Item("nivelacademico") = "Secundaria", "X", "")%> <%= IIF(GeneListDetail.Reader.Item("nivelacademico") = "Universitario", "X", "")%> <%= IIF(GeneListDetail.Reader.Item("nivelacademico") = "Postgrado", "X", "")%> <%= IIF(GeneListDetail.Reader.Item("nivelacademico") = "Maestría", "X", "")%> <%= IIF(GeneListDetail.Reader.Item("experiencia_inversionista") = "2", "X", "")%> <%= IIF(GeneListDetail.Reader.Item("experiencia_inversionista") = "2", "X", "")%> <%= IIF(GeneListDetail.Reader.Item("experiencia_inversionista") = "5", "X", "")%> <%= IIF(GeneListDetail.Reader.Item("experiencia_inversionista") = "8", "X", "")%> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " />
" /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " /> " />
<% GeneListDetail.Reader.Close() Else Response.Redirect("frontpage.aspx") End If %>