//  private HorarioList() { }

        /// <summary>
        /// Retrieve the complete list from db
        /// </summary>
        /// <returns>HorarioList</returns>
        public static HorarioList GetList(bool childs)
        {
            CriteriaEx criteria = Horario.GetCriteria(Horario.OpenSession());

            criteria.Childs = childs;
            criteria.Query  = Horarios.SELECT();
            //No criteria. Retrieve all de List
            HorarioList list = DataPortal.Fetch <HorarioList>(criteria);

            CloseSession(criteria.SessionCode);

            return(list);
        }
        /// <summary>
        /// Retrieve the complete list from db
        /// </summary>
        /// <returns>HorarioList</returns>
        public static HorarioList GetHorariosPromocionList(long oid_promocion, long oid_plan, DateTime fecha, bool childs)
        {
            CriteriaEx criteria = Horario.GetCriteria(Horario.OpenSession());

            criteria.Childs = childs;

            criteria.Query = Horario.SELECT_BY_PLAN_BY_PROMOCION(oid_plan, oid_promocion, fecha);

            HorarioList list = DataPortal.Fetch <HorarioList>(criteria);

            CloseSession(criteria.SessionCode);

            return(list);
        }