/// <summary>
        /// Retrieve the complete list from db
        /// </summary>
        /// <returns>ExamenList</returns>
        public static ExamenList GetComboAlumno_ExamenList(long oid_promocion)
        {
            CriteriaEx criteria = Examen.GetCriteria(Examen.OpenSession());

            //No criteria. Retrieve all de List
            if (nHManager.Instance.UseDirectSQL)
            {
                criteria.Query = Examens.SELECT_EXAMENES_PENDIENTES(oid_promocion);
            }
            ExamenList list = DataPortal.Fetch <ExamenList>(criteria);

            CloseSession(criteria.SessionCode);

            return(list);
        }
        /// <summary>
        /// Retrieve the complete list from db
        /// </summary>
        /// <returns>ExamenList</returns>
        private static ExamenList GetFechaList(DateTime fecha_examen)
        {
            CriteriaEx criteria = Examen.GetCriteria(Examen.OpenSession());

            //No criteria. Retrieve all de List
            if (nHManager.Instance.UseDirectSQL)
            {
                criteria.Query = Examens.SELECT_BY_FECHA(fecha_examen);
            }
            criteria.Childs = true;
            ExamenList list = DataPortal.Fetch <ExamenList>(criteria);

            CloseSession(criteria.SessionCode);

            return(list);
        }