public ActionResult Listado(String Personal)
        {
            if (Personal.Trim().Equals("") || Personal == null)
            {
                return(View());
            }
            else
            {
                String[] arr = Personal.Split('-');
                List <sp_personalSeleccionado_Result> listaInicial = new List <sp_personalSeleccionado_Result>();
                try
                {
                    listaInicial = this.databaseManager.sp_personalSeleccionado(arr[0].ToString(), arr[1].ToString(), Convert.ToInt32(arr[2])).ToList();
                }
                catch (IndexOutOfRangeException)
                {
                    listaInicial = this.databaseManager.sp_personalSeleccionado(arr[0].ToString(), "", Convert.ToInt32(arr[1])).ToList();
                }

                sp_personalSeleccionado_Result seleccionado = new sp_personalSeleccionado_Result();
                seleccionado = listaInicial.First();

                return(View(seleccionado));
            }
        }
        public ActionResult Preguntas(String Personal)
        {
            DAOPreguntas general = new DAOPreguntas();

            if (Personal.Trim().Equals("") || Personal == null)
            {
                return(View());
            }
            else
            {
                String[] arr = Personal.Split('-');
                List <sp_personalSeleccionado_Result> listaInicial = new List <sp_personalSeleccionado_Result>();
                try
                {
                    listaInicial = this.databaseManager.sp_personalSeleccionado(arr[0].ToString(), arr[1].ToString(), Convert.ToInt32(arr[2])).ToList();
                }
                catch (IndexOutOfRangeException)
                {
                    listaInicial = this.databaseManager.sp_personalSeleccionado(arr[0].ToString(), "", Convert.ToInt32(arr[1])).ToList();
                }

                sp_personalSeleccionado_Result elegido = new sp_personalSeleccionado_Result();
                elegido = listaInicial.First();

                List <sp_preguntas_Result> listaBase = new List <sp_preguntas_Result>();
                listaBase = this.databaseManager.sp_preguntas().ToList();
                List <SelectListItem> listaFinal = new List <SelectListItem>();
                foreach (var item in listaBase)
                {
                    listaFinal.Add(new SelectListItem
                    {
                        Text  = item.chrDesPre,
                        Value = item.chrNroPre.ToString()
                    });
                }

                general.seleccionado = elegido;
                general.preguntas    = listaFinal;

                return(View(general));
            }
        }