public StatsInfo GetStatistics(string lastvisit)
{
StatsInfo stats = new StatsInfo();
SqlParameter parm = new SqlParameter("@LastVisit", SqlDbType.VarChar) {Value = lastvisit};
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, ACTIVE_MEMBERS + ACTIVE_TOPICS + ARCHIVED_REPLY + ARCHIVED_TOPICS + TOTAL_MEMBERS + TOTAL_TOPICS + TOTAL_POSTS, parm))
{
while (rdr.Read())
{
stats.ActiveMembers = rdr.GetInt32(0);
}
rdr.NextResult();
while (rdr.Read())
{
stats.ActiveTopicCount = rdr.GetInt32(0);
}
rdr.NextResult();
while (rdr.Read())
{
stats.ArchiveReplyCount = rdr.GetInt32(0);
}
rdr.NextResult();
while (rdr.Read())
{
stats.ArchiveTopicCount = rdr.GetInt32(0);
}
rdr.NextResult();
while (rdr.Read())
{
stats.MemberCount = rdr.GetInt32(0);
}
rdr.NextResult();
while (rdr.Read())
{
stats.TopicCount = rdr.GetInt32(0);
}
rdr.NextResult();
while (rdr.Read())
{
stats.TotalPostCount = rdr.GetInt32(0);
}
}
stats.LastPost = GetLastPost();
if (stats.LastPost != null)
if (stats.LastPost.LastPostAuthorId != null)
stats.LastPostAuthor = GetLastPostAuthor(stats.LastPost.LastPostAuthorId.Value);
stats.NewestMember = GetNewestMember();
return stats;
}
public StatsInfo GetStatistics(string lastvisit)
{
StatsInfo stats = new StatsInfo();
OleDbParameter parm = new OleDbParameter("@LastVisit", OleDbType.VarChar) { Value = lastvisit };
OleDbDataReader rdr = null;
//using (OleDbDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text,
// ACTIVE_MEMBERS + ACTIVE_TOPICS + ARCHIVED_REPLY + ARCHIVED_TOPICS + TOTAL_MEMBERS + TOTAL_TOPICS + TOTAL_POSTS, parm))
//{
rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, ACTIVE_MEMBERS);
while (rdr.Read())
{
stats.ActiveMembers = rdr.GetInt32(0);
}
rdr.Close();
rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, ACTIVE_TOPICS,parm);
while (rdr.Read())
{
stats.ActiveTopicCount = rdr.GetInt32(0);
}
rdr.Close();
rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, ARCHIVED_REPLY);
while (rdr.Read())
{
stats.ArchiveReplyCount = rdr.GetInt32(0);
}
rdr.Close();
rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, ARCHIVED_TOPICS);
while (rdr.Read())
{
stats.ArchiveTopicCount = rdr.GetInt32(0);
}
rdr.Close();
rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, TOTAL_MEMBERS);
while (rdr.Read())
{
stats.MemberCount = rdr.GetInt32(0);
}
rdr.Close();
rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, TOTAL_TOPICS);
while (rdr.Read())
{
stats.TopicCount = rdr.GetInt32(0);
}
rdr.Close();
rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, TOTAL_POSTS);
while (rdr.Read())
{
stats.TotalPostCount = (int) (rdr.GetDouble(0) + rdr.GetDouble(1));
}
rdr.Close();
//}
stats.LastPost = GetLastPost();
if (stats.LastPost != null)
if (stats.LastPost.LastPostAuthorId != null)
stats.LastPostAuthor = GetLastPostAuthor(stats.LastPost.LastPostAuthorId.Value);
stats.NewestMember = GetNewestMember();
return stats;
}
