Exemple #1
0
        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");
            }
        }