/// <summary>
/// Devuelve una lista de todos los elementos
/// </summary>
/// <returns>Lista de elementos</returns>
public static ExamenList GetModuloList(long oid_modulo)
{
CriteriaEx criteria = Examen.GetCriteria(Examen.OpenSession());
criteria.AddEq("OidModulo", oid_modulo);
ExamenList list = ExamenList.RetrieveList(typeof(Examen), AppContext.ActiveSchema.Code, criteria);
CloseSession(criteria.SessionCode);
return(list);
}
/// <summary>
/// Retrieve the complete list from db
/// </summary>
/// <returns>RespuestaList</returns>
public void FormatCodigoList()
{
foreach (ExamenInfo item in this)
{
if (item.Numero == 0)
{
string query = UPDATE_CODIGO(item.Oid);
CriteriaEx criteria = Examen.GetCriteria(Examen.OpenSession());
nHManager.Instance.SQLNativeExecute(query, Session());
CloseSession(criteria.SessionCode);
}
}
}
/// <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);
}
/// <summary>
/// Retrieve the complete list from db
/// </summary>
/// <param name="get_childs">retrieving the childs</param>
/// <returns></returns>
public ExamenList GetExamenesFiltrados(long oid_modulo, long oid_instructor, long oid_promocion,
string tipo, DateTime fecha_creacion, DateTime fecha_emision,
DateTime fecha_examen, bool desarrollo, bool filtro, string texto)
{
ExamenList lista = new ExamenList();
string query = ExamenList.SELECT_EXAMENES_FILTRADOS(oid_modulo, oid_instructor, oid_promocion, tipo,
fecha_creacion, fecha_examen, fecha_emision, desarrollo, filtro, texto);
int sesion = Examen.OpenSession();
IDataReader reader = nHManager.Instance.SQLNativeSelect(query, Session(sesion));
lista = ExamenList.GetChildList(reader, false);
CloseSession(sesion);
return(lista);
}
// private ExamenList() { }
/// <summary>
/// Retrieve the complete list from db
/// </summary>
/// <returns>ExamenList</returns>
public static ExamenList GetList(bool childs)
{
CriteriaEx criteria = Examen.GetCriteria(Examen.OpenSession());
criteria.Childs = childs;
//No criteria. Retrieve all de List
if (nHManager.Instance.UseDirectSQL)
{
criteria.Query = ExamenList.SELECT();
}
ExamenList list = DataPortal.Fetch <ExamenList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}