/// <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);
}
