/// <summary> /// Retrieve the complete list from db /// </summary> /// <returns>ClasePracticaList</returns> public static ClasePracticaList GetClasesOrdenadasPlanList(long oid_plan, long oid_promocion = 0, int grupo = 0) { CriteriaEx criteria = ClasePractica.GetCriteria(ClasePractica.OpenSession()); //No criteria. Retrieve all de List if (nHManager.Instance.UseDirectSQL) { criteria.Query = ClasePracticas.SELECT_CLASES_PRACTICAS_PLAN_ORDENADAS(oid_plan, oid_promocion, grupo); } ClasePracticaList list = DataPortal.Fetch <ClasePracticaList>(criteria); CloseSession(criteria.SessionCode); return(list); }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <returns>ClasePracticaList</returns> public static ClasePracticaList GetProgramadasList(long oid_plan, long oid_promocion) { CriteriaEx criteria = ClasePractica.GetCriteria(ClasePractica.OpenSession()); //No criteria. Retrieve all de List if (nHManager.Instance.UseDirectSQL) { criteria.Query = ClasePracticas.SELECT_CLASES_PRACTICAS_PROGRAMADAS(oid_plan, oid_promocion); } ClasePracticaList list = DataPortal.Fetch <ClasePracticaList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static ClasePracticaList GetListBySubmodulo(long oid) { CriteriaEx criteria = ClasePractica.GetCriteria(ClasePractica.OpenSession()); if (nHManager.Instance.UseDirectSQL) { criteria.Query = ClasePracticaList.SELECT_BY_SUBMODULO(oid); } ClasePracticaList list = DataPortal.Fetch <ClasePracticaList>(criteria); CloseSession(criteria.SessionCode); return(list); }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <param name="get_childs">retrieving the childs</param> /// <returns></returns> public static NotaPracticasList GetListByAlumno(bool childs, long oid_alumno) { CriteriaEx criteria = ClasePractica.GetCriteria(ClasePractica.OpenSession()); criteria.Childs = childs; //No criteria. Retrieve all de List if (nHManager.Instance.UseDirectSQL) { criteria.Query = NotaPracticasList.SELECT_NOTAS_ALUMNOS_BY_ALUMNO(oid_alumno); } NotaPracticasList list = DataPortal.Fetch <NotaPracticasList>(criteria); CloseSession(criteria.SessionCode); return(list); }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <returns>ClasePracticaList</returns> public static ClasePracticaList GetImpartidasList(long oid_promocion, DateTime fecha, long grupo) { CriteriaEx criteria = ClasePractica.GetCriteria(ClasePractica.OpenSession()); criteria.Childs = false; //No criteria. Retrieve all de List if (nHManager.Instance.UseDirectSQL) { criteria.Query = ClasePractica.SELECT_IMPARTIDAS(oid_promocion, fecha, grupo, false); } ClasePracticaList list = DataPortal.Fetch <ClasePracticaList>(criteria); CloseSession(criteria.SessionCode); return(list); }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <returns>ClasePracticaList</returns> public static ClasePracticaList GetDisponiblesList(long oid_plan, long oid_promocion, long oid_horario, long grupo) { CriteriaEx criteria = ClasePractica.GetCriteria(ClasePractica.OpenSession()); criteria.Childs = false; //No criteria. Retrieve all de List if (nHManager.Instance.UseDirectSQL) { criteria.Query = ClasePracticas.SELECT_CLASES_PRACTICAS_DISPONIBLES(oid_plan, oid_promocion, oid_horario, grupo); } ClasePracticaList list = DataPortal.Fetch <ClasePracticaList>(criteria); CloseSession(criteria.SessionCode); return(list); }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <returns>ClasePracticaList</returns> public static ClasePracticaList GetClasesPlanList(long oid_plan) { CriteriaEx criteria = ClasePractica.GetCriteria(ClasePractica.OpenSession()); criteria.Childs = false; //No criteria. Retrieve all de List if (nHManager.Instance.UseDirectSQL) { criteria.Query = ClasePracticas.SELECT_CLASES_PRACTICAS_PLAN(oid_plan); } ClasePracticaList list = DataPortal.Fetch <ClasePracticaList>(criteria); CloseSession(criteria.SessionCode); return(list); }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <returns>ClasePracticaList</returns> public static ClasePracticaList GetList(bool childs) { CriteriaEx criteria = ClasePractica.GetCriteria(ClasePractica.OpenSession()); criteria.Childs = childs; //No criteria. Retrieve all de List if (nHManager.Instance.UseDirectSQL) { criteria.Query = ClasePracticas.SELECT(); } ClasePracticaList list = DataPortal.Fetch <ClasePracticaList>(criteria); CloseSession(criteria.SessionCode); return(list); }