protected void Page_Load(object sender, EventArgs e)
{
if (!IsPoliticianUser)
{
Page.Title = H1.InnerHtml = "Database Statistics";
CandidatesCount.InnerText = Politicians.CountTable().ToString("N0");
CandidatePicturesCount.InnerText =
PoliticiansImagesData.CountTable().ToString("N0");
OfficesCount.InnerText = Offices.CountAllActualOffices().ToString("N0");
var officeCandidates = ElectionsPoliticians.GetOfficeCandidatesByYear();
OfficeCandidatesCount.InnerText = officeCandidates.Sum(y => y.Value).ToString("N0");
var officeCandidatesRowIndex =
OfficeCandidatesRow.Parent.Controls.IndexOf(OfficeCandidatesRow);
foreach (var kvp in officeCandidates.OrderBy(i => i.Key))
{
var newRow = new HtmlTableRow();
newRow.AddCssClasses("office-candidates-year");
newRow.AddCssClasses(OfficeCandidatesRow.Attributes["class"].SafeString());
OfficeCandidatesRow.Parent.Controls.AddAt(++officeCandidatesRowIndex, newRow);
new Literal
{
Text = kvp.Key
}.AddTo(new HtmlTableCell().AddTo(newRow, "year"));
new Literal
{
Text = kvp.Value.ToString("N0")
}.AddTo(new HtmlTableCell().AddTo(newRow, "value"));
}
var officeContests = ElectionsOffices.GetOfficeContestsByYear();
OfficeContestCount.InnerText = officeContests.Sum(y => y.Value).ToString("N0");
var officeContestsRowIndex =
OfficeContestsRow.Parent.Controls.IndexOf(OfficeContestsRow);
foreach (var kvp in officeContests.OrderBy(i => i.Key))
{
var newRow = new HtmlTableRow();
newRow.AddCssClasses("office-contests-year");
newRow.AddCssClasses(OfficeContestsRow.Attributes["class"].SafeString());
OfficeContestsRow.Parent.Controls.AddAt(++officeContestsRowIndex, newRow);
new Literal
{
Text = kvp.Key
}.AddTo(new HtmlTableCell().AddTo(newRow, "year"));
new Literal
{
Text = kvp.Value.ToString("N0")
}.AddTo(new HtmlTableCell().AddTo(newRow, "value"));
}
var electionsCount = Elections.CountStateElectionsByYear();
ElectionsCount.InnerText = electionsCount.Sum(y => y.Value).ToString("N0");
var electionsRowIndex =
ElectionsRow.Parent.Controls.IndexOf(ElectionsRow);
foreach (var kvp in electionsCount.OrderBy(i => i.Key))
{
var newRow = new HtmlTableRow();
newRow.AddCssClasses("elections-year");
newRow.AddCssClasses(ElectionsRow.Attributes["class"].SafeString());
ElectionsRow.Parent.Controls.AddAt(++electionsRowIndex, newRow);
new Literal
{
Text = kvp.Key
}.AddTo(new HtmlTableCell().AddTo(newRow, "year"));
new Literal
{
Text = kvp.Value.ToString("N0")
}.AddTo(new HtmlTableCell().AddTo(newRow, "value"));
}
SocialMediaLinksCount.InnerText =
Politicians.CountAllSocialMediaLinks().ToString("N0");
BioInfoCount.InnerText = Answers.CountBioAnswersNew().ToString("N0");
PersonalCount.InnerText = Answers.CountPersonalAnswersNew().ToString("N0");
IssueResponsesCount.InnerText = Answers.CountActiveIssueAnswersNew().ToString("N0");
}
}