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