/// <summary>
/// carrega todas as excepções ocorridas para um array de excepções
/// </summary>
/// <returns></returns>
public override ExceptionInfo[] load()
{
DataSet dataset = SqlServerUtility.getAllFromDB("OrionsBelt_ExceptionLogLoad");
int i = 0, count = dataset.Tables[0].Rows.Count;
ExceptionInfo[] exceptions = new ExceptionInfo[count];
foreach (DataRow row in dataset.Tables[0].Rows)
{
_exception = row;
exceptions[i++] = new ExceptionInfo(
(int)getField("exceptionLog_id"),
(string)getField("exceptionLog_name"),
(DateTime)getField("exceptionLog_date"),
(string)getField("exceptionLog_message"),
(string)getField("exceptionLog_stackTrace")
);
}
return(exceptions);
}
/// <summary>Obtém as notícias existentes</summary>
protected override NewsList GetNewsFromDB()
{
DataSet ds = SqlServerUtility.getAllFromDB("OrionsBelt_GetNews");
return(NewsFromDataSet(ds));
}
override public UtilityCollection getAllMasterSkinsFromDB()
{
return(storeSkins(SqlServerUtility.getAllFromDB("OrionsBelt_MasterSkinsGetAllMasterSkins")));
}
/// <summary>Obtm a quantidade de utilizadores registados</summary>
public override int getUserCount()
{
DataSet ds = SqlServerUtility.getAllFromDB("OrionsBelt_UsersGetCount");
return((int)ds.Tables[0].Rows[0]["count"]);
}
public override User[] getUsersRanking()
{
DataSet ds = SqlServerUtility.getAllFromDB("OrionsBelt_UsersGetUserRanks");
return(PopulateUserRankings(50, ds, "user_id"));
}
/// <summary>
/// retorna a informao das namedPages da Base de Dados
/// </summary>
/// <returns>collection com as namedPages</returns>
override public UtilityCollection getAllNamedPagesFromDB()
{
return(storeNamedPages(SqlServerUtility.getAllFromDB("OrionsBelt_NamedPagesGetAllNamedPages")));
}