protected void ReportEmail(DataRow row) { var tr = new HtmlTableRow().AddTo(CurrentHtmlTable, "trReportDetailHeading"); var td = new HtmlTableCell().AddTo(tr, "tdReportDetail"); new HtmlAnchor { HRef = SecureAdminPage.GetPartiesPageUrl(Parties.GetStateCodeFromKey(row.PartyKey()), row.PartyKey(), row.PartyEmail()), Target = "edit", InnerText = row.PartyEmail() }.AddTo(td); new HtmlTableCell { InnerText = row.PartyContactPhone() }.AddTo(tr, "tdReportDetail"); new HtmlTableCell { InnerText = row.PartyContactFName() }.AddTo(tr, "tdReportDetail"); new HtmlTableCell { InnerText = row.PartyContactLName() }.AddTo(tr, "tdReportDetail"); new HtmlTableCell { InnerText = row.PartyContactTitle() }.AddTo(tr, "tdReportDetail"); new HtmlTableCell { InnerText = row.PartyPassword() }.AddTo(tr, "tdReportDetail"); }
protected void ReportIssue(DataRow row) { var tr = new HtmlTableRow().AddTo(CurrentHtmlTable, "trReportDetail"); new HtmlTableCell { InnerText = row.IssueOrder().ToString() } .AddTo(tr, "tdReportDetail"); var td = new HtmlTableCell().AddTo(tr, "tdReportDetail"); new HtmlAnchor { HRef = SecureAdminPage.GetIssuesPageUrl(row.StateCode(), row.IssueKey()), InnerHtml = $"<nobr>{row.Issue()}</nobr>" }.AddTo(td); td = new HtmlTableCell().AddTo(tr, "tdReportDetail"); new HtmlAnchor { HRef = SecureAdminPage.GetIssuesPageUrl(row.StateCode(), row.IssueKey(), null, !row.IsIssueOmit()), InnerHtml = row.IsIssueOmit() ? "<strong>OMIT</strong>" : "ok" }.AddTo(td); new HtmlTableCell { InnerText = row.IssueKey() } .AddTo(tr, "tdReportDetail"); new HtmlTableCell { InnerText = row.Count().ToString() } .AddTo(tr, "tdReportDetail"); }
private static void AddMasterOfficesMenu(Control parent) { // Masters only see it if they are on an Admin page if (!SecurePage.IsMasterUser) { return; } string stateCode = null; if (SecurePage.IsAdminPage) { stateCode = SecurePage.FindStateCode(); } if (StateCache.IsValidStateCode(stateCode)) { var ul = CreateDropdownMenu(); var countyCode = SecurePage.FindCountyCode(); var localKey = SecurePage.FindLocalKey(); AddMenuItem(ul, "Manage Offices, Office Templates and Incumbents", SecureAdminPage.GetUpdateOfficesPageUrl(stateCode, countyCode, localKey)); AddMenuItem(ul, "Offices Report", SecureAdminPage.GetOfficesPageUrl(stateCode, countyCode, localKey)); AddMenuItem(ul, "Incumbents Report", SecureAdminPage.GetOfficialsPageUrl(stateCode, countyCode, localKey)); AddMenuItem(ul, "Download County or Local Offices CSV", SecureAdminPage.GetAdminFolderPageUrl("DownloadOfficesCsv", "state", stateCode)); AddMenuItem(parent, "Offices", ul); } }
private static void AddJurisdictionsMenu(Control ul) { var stateCode = SecurePage.FindStateCode(); AddMenuItem(ul, "Jurisdictions", SecureAdminPage.GetUpdateJurisdictionsPageUrl(stateCode, SecurePage.FindCountyCode(), SecurePage.FindLocalKey())); }
private static Control MakeUpdateJurisdictionsLink(DataRow row) { return(new HtmlAnchor { HRef = SecureAdminPage.GetUpdateJurisdictionsPageUrl(row.StateCode(), row.CountyCode()), Target = "_blank", InnerText = row.County() }); }
private static HtmlAnchor CreateOfficePageAnchor(string officekey, string text) { var a = new HtmlAnchor { HRef = SecureAdminPage.GetOfficePageEditUrl(officekey), Target = "office", InnerHtml = text }; return(a); }
private static HtmlAnchor CreateAdminOfficialsAnchor(string anchorText, string stateCode, string countyCode = "", string localCode = "") { var a = new HtmlAnchor { HRef = SecureAdminPage.GetOfficialsPageUrl(stateCode, countyCode, localCode), InnerHtml = anchorText }; return(a); }
private static void AddJurisdictionsMenu(Control ul) { var stateCode = SecurePage.GetViewStateStateCode(); if (!StateCache.IsValidStateCode(stateCode)) { stateCode = string.Empty; } AddMenuItem(ul, "Jurisdictions", SecureAdminPage.GetUpdateJurisdictionsPageUrl(stateCode, SecurePage.GetViewStateCountyCode(), SecurePage.GetViewStateLocalCode())); }
protected static HtmlAnchor CreateAdminOfficeAnchor(string officeKey, string anchorText, string target = "office") { var a = new HtmlAnchor { HRef = SecureAdminPage.GetOfficePageEditUrl(officeKey), Target = target, InnerHtml = anchorText }; return(a); }
private static HtmlAnchor CreateOfficePageAnchor(string stateCode, string countyCode, string localKey, OfficeClass officeClass, string text) { var a = new HtmlAnchor { HRef = SecureAdminPage.GetUpdateOfficesPageUrl(stateCode, countyCode, localKey, officeClass), Target = "office", InnerHtml = text }; return(a); }
protected static HtmlAnchor CreateAdminDefaultAnchor(string stateCode, string countyCode, string localKey, string anchorText, string title = "", string target = "") { return new HtmlAnchor { HRef = SecureAdminPage.GetDefaultPageUrl(stateCode, countyCode, localKey), InnerHtml = anchorText, Title = title, Target = target }; }
protected static HtmlAnchor CreateAdminDistrictsAnchor(string stateCode, string countyCode, string localCode, string anchorText, string title = "", string target = "") { return(new HtmlAnchor { HRef = SecureAdminPage.GetDistrictsPageUrl(stateCode, countyCode, localCode), InnerHtml = anchorText, Title = title, Target = target }); }
//private static HtmlAnchor CreateAdminOfficeAnchor(string officeKey, // string anchorText, string target) //{ // var a = new HtmlAnchor // { // HRef = SecureAdminPage.GetOfficePageEditUrl(officeKey), // Target = string.IsNullOrWhiteSpace(target) ? "office" : target, // InnerHtml = anchorText // }; // return a; //} private static HtmlAnchor CreateAdminPoliticianAnchor( PoliticiansAdminReportViewRow row, string anchorText, string target) { var a = new HtmlAnchor { HRef = SecureAdminPage.GetPoliticianPageUrl(row.PoliticianKey), Title = FormatPoliticianName(row) + " administration data edit form", InnerHtml = anchorText, Target = string.IsNullOrWhiteSpace(target) ? "politician" : target }; return(a); }
protected static HtmlAnchor CreateAdminOfficeWinnerAnchor(string electionKey, string officeKey, string anchorText, string target = "officewinner") { var a = new HtmlAnchor { HRef = SecureAdminPage.GetOfficeWinnerPageUrl(electionKey, officeKey), Target = target, InnerHtml = anchorText }; return(a); }
protected static HtmlAnchor CreateAdminPoliticianAnchor(DataRow politician, string anchorText, string target = "politician") { var a = new HtmlAnchor { HRef = SecureAdminPage.GetPoliticianPageUrl(politician.PoliticianKey()), Target = target, Title = Politicians.FormatName(politician) + " administration data edit form", InnerHtml = anchorText }; return(a); }
private static Control MakeUpdateJurisdictionsLink(DataRow row) { var localKey = row.LocalKey(); return(new HtmlAnchor { HRef = SecureAdminPage.GetUpdateJurisdictionsPageUrl(row.StateCode(), row.CountyCode(), localKey), Target = "_blank", InnerHtml = IsNullOrWhiteSpace(localKey) ? "<b>" + row.County() + "</b>" : row.LocalDistrict() }); }
protected static HtmlAnchor CreateAdminOfficeCandidateListAnchor(string electionKey, string officeKey, string anchorText, string title = "", string target = "officecontest") { var a = new HtmlAnchor { HRef = SecureAdminPage.GetOfficeCandidateListUrl(electionKey, officeKey), Target = target, Title = title, InnerHtml = anchorText }; return(a); }
private static void AddElectionsMenu(Control ul) { // Admins always see an elections menu // Masters see it if they are on any Admin page string stateCode = null; if (SecurePage.IsMasterUser && SecurePage.IsAdminPage) { stateCode = SecurePage.FindStateCode(); } if (SecurePage.IsAdminUser || StateCache.IsValidStateCode(stateCode)) { AddMenuItem(ul, "Elections", SecureAdminPage.GetUpdateElectionsPageUrl(stateCode, SecurePage.FindCountyCode(), SecurePage.FindLocalKey())); } }
private static void AddOfficesMenu(Control ul) { // Admins always see an offices menu // Masters see it if they are on any Admin page string stateCode = null; if (SecurePage.IsAdminUser || (SecurePage.IsMasterUser && SecurePage.IsAdminPage)) { stateCode = SecurePage.GetViewStateStateCode(); } if (StateCache.IsValidStateCode(stateCode)) { AddMenuItem(ul, "Offices", SecureAdminPage.GetUpdateOfficesPageUrl(stateCode, SecurePage.GetViewStateCountyCode(), SecurePage.GetViewStateLocalCode())); } }
protected void ReportParty(DataRow row) { var tr = new HtmlTableRow().AddTo(CurrentHtmlTable, "trReportDetail"); new HtmlTableCell { InnerText = row.PartyOrder().ToString() } .AddTo(tr, "tdReportDetail"); new HtmlTableCell { InnerText = row.PartyKey() } .AddTo(tr, "tdReportDetail"); new HtmlTableCell { InnerText = row.PartyCode() } .AddTo(tr, "tdReportDetail"); var td = new HtmlTableCell().AddTo(tr, "tdReportDetail"); new HtmlAnchor { HRef = SecureAdminPage.GetPartiesPageUrl(row.StateCode(), row.PartyKey()), InnerText = row.PartyName(), Target = "edit" }.AddTo(td); td = new HtmlTableCell().AddTo(tr, "tdReportDetail"); var url = row.PartyUrl(); if (IsNullOrWhiteSpace(url)) { td.InnerHtml = " "; } else { new HtmlAnchor { HRef = VotePage.NormalizeUrl(url), InnerText = row.PartyUrl(), Title = "Party Wensite", Target = "view" } }.AddTo(td);
protected void Page_Load(object sender, EventArgs e) { _SecureAdminPage = VotePage.GetPage <SecureAdminPage>(); if (_SecureAdminPage == null) { throw new VoteException( "The NavigateJurisdiction control can only be used in the SecureAdminPage class"); } if (!IsPostBack) { Page.IncludeCss("~/css/vote/controls/NavigateJurisdiction.css"); var cs = Page.ClientScript; var type = GetType(); const string scriptName = "NavigateJurisdiction"; if (cs.IsStartupScriptRegistered(type, scriptName)) { return; } cs.RegisterStartupScript(type, scriptName, "require(['vote/controls/navigateJurisdiction'], function(){{}});", true); if (IsNullOrWhiteSpace(AdminPageName)) { var match = Regex.Match(VotePage.CurrentPath, @"/([^./]+)\."); if (!match.Success) { throw new VoteException("Missing AdminPageName"); } AdminPageName = match.Groups[1].Value; } PageName.Value = AdminPageName; UserSecurityClass.Value = SecurePage.UserSecurityClass; OriginalStateCode.Value = _SecureAdminPage.StateCode; OriginalCountyCode.Value = _SecureAdminPage.CountyCode; OriginalLocalKey.Value = _SecureAdminPage.LocalKey; Initialize(); } }
protected static HtmlAnchor CreateAdminReferendumAnchor(string electionKey, // ReSharper disable once UnusedParameter.Global string referendumKey, string anchorText) { //var a = new HtmlAnchor //{ // HRef = SecureAdminPage.GetReferendumPageUrl(electionKey, referendumKey), // Target = "edit", // Title = "Edit Description, Details and Full Text", // InnerHtml = anchorText //}; var a = new HtmlAnchor { HRef = SecureAdminPage.GetUpdateElectionsPageUrlByElection(electionKey, "addballotmeasures"), Target = "edit", Title = "Edit Description, Details and Full Text", InnerHtml = anchorText }; return(a); }
protected void Page_Load(object sender, EventArgs e) { _SecureAdminPage = VotePage.GetPage <SecureAdminPage>(); if (_SecureAdminPage == null) { throw new VoteException( "The SelectJurisdictionButton control can only be used in the" + " SecureAdminPage class"); } if (!IsPostBack) { Page.IncludeCss("~/css/vote/controls/SelectJurisdictionButton.css"); if (IsNullOrWhiteSpace(AdminPageName)) { var match = Regex.Match(VotePage.CurrentPath, @"/([^./]+)\."); if (!match.Success) { throw new VoteException("Missing AdminPageName"); } AdminPageName = match.Groups[1].Value; } StateLink.NavigateUrl = SecureAdminPage.GetAdminFolderPageUrl(AdminPageName, "state", _SecureAdminPage.StateCode); StateLink.Text = "► " + StateCache.GetStateName(_SecureAdminPage.StateCode); switch (_SecureAdminPage.AdminPageLevel) { case AdminPageLevel.State: if (AddClasses) { Container.AddCssClasses("state"); } break; case AdminPageLevel.County: StateLink.Visible = true; if (AddClasses) { Container.AddCssClasses("county"); } break; case AdminPageLevel.Local: StateLink.Visible = true; if (AddClasses) { Container.AddCssClasses("local"); } CountyLink.Visible = true; CountyLink.NavigateUrl = SecureAdminPage.GetAdminFolderPageUrl(AdminPageName, "state", _SecureAdminPage.StateCode, "county", _SecureAdminPage.CountyCode); CountyLink.Text = "► " + CountyCache.GetCountyName(_SecureAdminPage.StateCode, _SecureAdminPage.CountyCode); break; } } }
protected void ButtonAddNewCandidate_OnClick(object sender, EventArgs e) { bool validateDuplicates; bool.TryParse(AddCandidateValidateDuplicates.GetValue(), out validateDuplicates); AddCandidateDuplicatesHtml.Controls.Clear(); _AddNewCandidateSubTabInfo.ClearValidationErrors(); AddCandidateNewId.SetValue(string.Empty); // No actual updating here, just validation and reformatting _AddNewCandidateSubTabInfo.Update(FeedbackAddNewCandidate, false); if (FeedbackAddNewCandidate.ValidationErrorCount > 0) { return; } var stateCode = ControlAddNewCandidateStateCode.GetValue(); var firstName = ControlAddNewCandidateFName.GetValue(); var middleName = ControlAddNewCandidateMName.GetValue(); var nickname = ControlAddNewCandidateNickname.GetValue(); var lastName = ControlAddNewCandidateLName.GetValue(); var suffix = ControlAddNewCandidateSuffix.GetValue(); var formattedName = Politicians.FormatName(firstName, middleName, nickname, lastName, suffix); if (validateDuplicates) { var duplicatesHtml = Politicians.GetCandidateList(lastName, null, stateCode, null, true); AddCandidateDuplicatesHtml.Controls.Add(duplicatesHtml); if (duplicatesHtml.Controls.Count > 0) { // Set up the duplicates dialog AddCandidateFormattedName.SetValue(formattedName); AddCandidateStateName.SetValue(StateCache.GetStateName(stateCode)); FeedbackAddNewCandidate.PostValidationError(ControlAddNewCandidateLName, "Potential duplicate politician"); return; } } var newPoliticianKey = Politicians.GetUniqueKey(stateCode, lastName, firstName, middleName, suffix); AddCandidateNewId.SetValue(newPoliticianKey); // If it's a primary, get the party key from the election //var partyKey = "X"; var partyKey = string.Empty; // mantis 508 var electionKey = SafeGetElectionKey(); if (Elections.IsPrimaryElection(electionKey)) { partyKey = stateCode + Elections.GetNationalPartyCodeFromKey(electionKey); } Politicians.AddPolitician(newPoliticianKey, firstName, middleName, nickname, lastName, suffix, SafeGetOfficeKey(), partyKey, SecurePage.CreateUniquePassword()); LogDataChange.LogInsert(Politicians.TableName, VotePage.UserName, SecurePage.UserSecurityClass, DateTime.UtcNow, newPoliticianKey); ClearAddNewCandidate(); FeedbackAddNewCandidate.AddInfo("Politician " + formattedName + " was added."); if (Mode == DataMode.AddPoliticians) { FeedbackAddNewCandidate.AddInfo(new HtmlAnchor { InnerText = "Intro Page", HRef = UrlManager.GetIntroPageUri(newPoliticianKey).ToString(), Target = "Politician" }.RenderToString()); FeedbackAddNewCandidate.AddInfo(new HtmlAnchor { InnerText = "Politician Admin Page", HRef = SecureAdminPage.GetPoliticianPageUrl(newPoliticianKey), Target = "Politician" }.RenderToString()); } }
//#region checked //private void PageTitle_() //{ // PageTitle.Text = string.Empty; // PageTitle.Text += // Offices.GetElectoralClassDescription(ViewState["StateCode"].ToString(), // ViewState["CountyCode"].ToString(), ViewState["LocalCode"].ToString()); // PageTitle.Text += "<br>"; // PageTitle.Text += db.PageTitle_Election(ViewState["ElectionKey"].ToString()); // PageTitle.Text += "<br>"; // PageTitle.Text += "REFERENDUMS AND BALLOT MEASURES IN THIS ELECTION"; //} //private void HtmlTablesVisible4Entry(int referendumCount) //{ // TableUpdate.Visible = false; //[Update This Referendum] // TableDelete.Visible = false; //Delete This Referendum: // TableAdd.Visible = false; //[Add This Referendum] // TableSelect4Update.Visible = false; //Edit or Delete a Referendum // TableAddNew.Visible = false; //[Clear Texboxes to Add Another Referendum] // if (referendumCount > 0) TableSelect4Update.Visible = true; // switch (ViewState["FormMode"].ToString()) // { // case "ReferendumsADD": // TableAdd.Visible = true; // break; // case "ReferendumsUPDATE": // TableUpdate.Visible = true; // TableAddNew.Visible = true; // TableDelete.Visible = true; // break; // } //} //private void HtmlTablesVisible4NextButton(int referendumCount) //{ // TableUpdate.Visible = false; //[Update This Referendum] // TableDelete.Visible = false; //Delete This Referendum: // TableAdd.Visible = false; //[Add This Referendum] // TableSelect4Update.Visible = false; //Edit or Delete a Referendum // TableAddNew.Visible = false; //[Clear Texboxes to Add Another Referendum] // if (referendumCount > 0) TableSelect4Update.Visible = true; // TableAdd.Visible = true; //} //private void HtmlTablesVisible4AddNewButton(int referendumCount) //{ // TableUpdate.Visible = false; //[Update This Referendum] // TableDelete.Visible = false; //Delete This Referendum: // TableAdd.Visible = false; //[Add This Referendum] // TableSelect4Update.Visible = false; //Edit or Delete a Referendum // TableAddNew.Visible = false; //[Clear Texboxes to Add Another Referendum] // if (referendumCount > 0) TableSelect4Update.Visible = true; // TableAdd.Visible = true; //} //private void CheckTextBoxes4IlleagelText() //{ // db.Throw_Exception_TextBox_Script(OrderOnBallot); // db.Throw_Exception_TextBox_Html(OrderOnBallot); // db.Throw_Exception_TextBox_Script(ReferendumTitle); // db.Throw_Exception_TextBox_Html(ReferendumTitle); // db.Throw_Exception_TextBox_Script(ReferendumDesc); // db.Throw_Exception_TextBox_Html(ReferendumDesc); // db.Throw_Exception_TextBox_Script(TextBoxDetailLink); // db.Throw_Exception_TextBox_Html(TextBoxDetailLink); // db.Throw_Exception_TextBox_Script(TextBoxFullTextLink); // db.Throw_Exception_TextBox_Html(TextBoxFullTextLink); // db.Throw_Exception_TextBox_Script(ReferendumDetail); // db.Throw_Exception_TextBox_Html(ReferendumDetail); // db.Throw_Exception_TextBox_Script(ReferendumFullText); // db.Throw_Exception_TextBox_Html(ReferendumFullText); //} //private void CheckBallotOrder() //{ // if (!db.Is_Valid_Integer(OrderOnBallot.Text.Trim())) // throw new ApplicationException( // "The Ballot Order needs to be a whole number."); //} //private void CheckDescription() //{ // if (ReferendumDesc.Text.Trim() == string.Empty) throw new ApplicationException("The Referendum Description is required."); //} //private int BallotOrderReferendumNext() //{ // var sql = string.Empty; // sql += " SELECT "; // sql += " Referendums.ElectionKey "; // sql += " ,Referendums.ReferendumKey"; // sql += " ,Referendums.ReferendumTitle "; // sql += " ,Referendums.ReferendumDesc "; // sql += " ,Referendums.OrderOnBallot"; // sql += " ,Referendums.IsReferendumTagForDeletion"; // sql += " FROM Referendums "; // switch (db.Electoral_Class_Election(ViewState["ElectionKey"].ToString())) // { // case db.ElectoralClass.State: // sql += " WHERE Referendums.ElectionKeyState = " + // db.SQLLit(ViewState["ElectionKey"].ToString()); // break; // case db.ElectoralClass.County: // sql += " WHERE Referendums.ElectionKeyCounty = " + // db.SQLLit(ViewState["ElectionKey"].ToString()); // break; // case db.ElectoralClass.Local: // sql += " WHERE Referendums.ElectionKeyLocal = " + // db.SQLLit(ViewState["ElectionKey"].ToString()); // break; // } // sql += " ORDER BY OrderOnBallot DESC"; // var referendumRow = db.Row_First_Optional(sql); // if (referendumRow != null) return Convert.ToInt16(referendumRow["OrderOnBallot"].ToString()) + 10; // return 10; //} //private int ShowReferendumList() //{ // var sqlReferendums = string.Empty; // sqlReferendums += " SELECT "; // sqlReferendums += " Referendums.ElectionKey"; // sqlReferendums += ",Referendums.ReferendumKey"; // sqlReferendums += ",Referendums.ReferendumTitle"; // sqlReferendums += ",Referendums.ReferendumDesc"; // sqlReferendums += ",Referendums.OrderOnBallot"; // sqlReferendums += ",Referendums.IsReferendumTagForDeletion"; // sqlReferendums += ",Referendums.IsResultRecorded"; // sqlReferendums += ",Referendums.IsPassed"; // sqlReferendums += " FROM Referendums"; // sqlReferendums += " WHERE Referendums.ElectionKey = " + // db.SQLLit(ViewState["ElectionKey"].ToString()); // sqlReferendums += " AND Referendums.IsReferendumTagForDeletion = 0"; // sqlReferendums += " ORDER BY OrderOnBallot ASC"; // var referendumTable = db.Table(sqlReferendums); // var theReferendumHtmlTable = string.Empty; // theReferendumHtmlTable += "<table cellspacing=0 cellpadding=0>"; // theReferendumHtmlTable += "<tr class=trReportGroupHeading>"; // theReferendumHtmlTable += // "<td align=center class=tdReportGroupHeading colspan=2>"; // theReferendumHtmlTable += "Ballot Measures"; // theReferendumHtmlTable += "</td>"; // theReferendumHtmlTable += "</tr>"; // theReferendumHtmlTable += "<tr class=trReportDetailHeading>"; // theReferendumHtmlTable += "<td align=center class=tdReportDetailHeading>"; // theReferendumHtmlTable += "Ballot<br>Order"; // theReferendumHtmlTable += "</td>"; // theReferendumHtmlTable += // "<td align=center width=700px class=tdReportDetailHeading>"; // theReferendumHtmlTable += "Referendum or Ballot Measure Title"; // theReferendumHtmlTable += "</td>"; // theReferendumHtmlTable += "</tr>"; // if (referendumTable.Rows.Count > 0) // foreach (DataRow referendumRow in referendumTable.Rows) // { // theReferendumHtmlTable += "<tr class=trReportDetail>"; // theReferendumHtmlTable += "<td valign=top class=tdReportDetail>"; // theReferendumHtmlTable += referendumRow["OrderOnBallot"].ToString(); // theReferendumHtmlTable += "</td>"; // var referendumAnchor = // db.Anchor_Admin_Referendums(referendumRow["ElectionKey"].ToString(), // referendumRow["ReferendumKey"].ToString()); // theReferendumHtmlTable += "<td valign=top class=tdReportDetail>"; // theReferendumHtmlTable += referendumAnchor; // if (Convert.ToBoolean(referendumRow["IsReferendumTagForDeletion"])) theReferendumHtmlTable += " [Tagged for Deletion]"; // if (db.Is_Election_Previous(ViewState["ElectionKey"].ToString())) // if (!Convert.ToBoolean(referendumRow["IsResultRecorded"])) theReferendumHtmlTable += " - Not Recorded"; // else if (Convert.ToBoolean(referendumRow["IsPassed"])) theReferendumHtmlTable += " - Passed"; // else theReferendumHtmlTable += " - Failed"; // theReferendumHtmlTable += "</td>"; // theReferendumHtmlTable += "</tr>"; // } // else // { // theReferendumHtmlTable += "<tr>"; // theReferendumHtmlTable += "<td colspan=2>"; // theReferendumHtmlTable += "<span class=tdReportDetailColor><center>"; // theReferendumHtmlTable += // "No Referndum or Ballot Measures in the database.</center>"; // theReferendumHtmlTable += "</span>"; // theReferendumHtmlTable += "</td>"; // theReferendumHtmlTable += "</tr>"; // } // theReferendumHtmlTable += "</table>"; // ReferendumHTMLTable.Text = theReferendumHtmlTable; // return referendumTable.Rows.Count; //} //private void GetReferendumShowInTextboxes(string electionKey, // string referendumKey) //{ // OrderOnBallot.Text = db.ReferendumsInt(electionKey, referendumKey, // "OrderOnBallot") // .ToString(CultureInfo.InvariantCulture); // RadiobuttonlistDelete.SelectedValue = db.ReferendumsBool(electionKey, // referendumKey, "IsReferendumTagForDeletion") // ? "Yes" // : "No"; // ReferendumTitle.Text = db.Referendums(electionKey, referendumKey, // "ReferendumTitle"); // ReferendumDesc.Text = db.Referendums(electionKey, referendumKey, // "ReferendumDesc"); // ReferendumDetail.Text = db.Referendums(electionKey, referendumKey, // "ReferendumDetail"); // ReferendumFullText.Text = db.Referendums(electionKey, referendumKey, // "ReferendumFullText"); // TextBoxDetailLink.Text = db.Referendums(electionKey, referendumKey, // "ReferendumDetailUrl"); // TextBoxFullTextLink.Text = db.Referendums(electionKey, referendumKey, // "ReferendumFullTextUrl"); //} //private void ClearTextBoxes() //{ // OrderOnBallot.Text = BallotOrderReferendumNext() // .ToString(CultureInfo.InvariantCulture); // RadiobuttonlistDelete.SelectedValue = "No"; // ReferendumTitle.Text = string.Empty; // ReferendumDesc.Text = string.Empty; // ReferendumDetail.Text = string.Empty; // ReferendumFullText.Text = string.Empty; // TextBoxDetailLink.Text = string.Empty; // TextBoxFullTextLink.Text = string.Empty; //} //protected void RadiobuttonlistDelete_SelectedIndexChanged(object sender, // EventArgs e) //{ // try // { // db.ReferendumsUpdateBool(ViewState["ElectionKey"].ToString(), // ViewState["ReferendumKey"].ToString(), "IsReferendumTagForDeletion", // RadiobuttonlistDelete.SelectedValue == "Yes"); // ShowReferendumList(); // GetReferendumShowInTextboxes(ViewState["ElectionKey"].ToString(), // ViewState["ReferendumKey"].ToString()); // Msg.Text = db.Ok(ReferendumTitle.Text + " was UPDATED."); // } // catch (Exception ex) // { // Msg.Text = db.Fail(ex.Message); // db.Log_Error_Admin(ex); // } //} //protected void ButtonNext_Click(object sender, EventArgs e) //{ // try // { // var referendumCount = ShowReferendumList(); // HtmlTablesVisible4NextButton(referendumCount); // Msg.Text = // db.Msg( // "To add another referendum enter the referendum information in the text boxes provided and click 'Add This'."); // ClearTextBoxes(); // } // catch (Exception ex) // { // Msg.Text = db.Fail(ex.Message); // db.Log_Error_Admin(ex); // } //} //protected void ButtonReCase_Click(object sender, EventArgs e) //{ // CheckTextBoxes4IlleagelText(); // ReferendumTitle.Text = db.Str_ReCase(ReferendumTitle.Text); //} //protected void ButtonDescRemoveCrLf_Click(object sender, EventArgs e) //{ // CheckTextBoxes4IlleagelText(); // ReferendumDesc.Text = ReferendumDesc.Text.ReplaceNewLinesWithSpaces(); //} //protected void ButtonDetailRemoveCrLf_Click(object sender, EventArgs e) //{ // CheckTextBoxes4IlleagelText(); // ReferendumDetail.Text = ReferendumDetail.Text.ReplaceNewLinesWithSpaces(); //} //protected void ButtonFullRemoveCrLf_Click(object sender, EventArgs e) //{ // CheckTextBoxes4IlleagelText(); // ReferendumFullText.Text = ReferendumFullText.Text.ReplaceNewLinesWithSpaces(); //} //protected void ButtonRecaseDescription_Click(object sender, EventArgs e) //{ // CheckTextBoxes4IlleagelText(); // ReferendumDesc.Text = db.Str_ReCase(ReferendumDesc.Text); //} //protected void ButtonReCaseFullText_Click(object sender, EventArgs e) //{ // CheckTextBoxes4IlleagelText(); // ReferendumDetail.Text = db.Str_ReCase(ReferendumDetail.Text); //} //protected void ButtonUpdate_Click1(object sender, EventArgs e) //{ // try // { // CheckTextBoxes4IlleagelText(); // CheckDescription(); // CheckBallotOrder(); // var stateCode = ViewState["StateCode"].ToString(); // var electionKey = ViewState["ElectionKey"].ToString(); // var electionDate = db.Elections_ElectionDate(electionKey); // var referendumKey = ViewState["ReferendumKey"].ToString(); // //Update all primary elections on the same date // var tableElectionKeys = DataTable_ElectionKeys(stateCode, electionDate); // foreach (DataRow rowElectionKey in tableElectionKeys.Rows) // { // electionKey = rowElectionKey["ElectionKey"].ToString(); // referendumKey = Modify_ReferendumKey(electionKey, referendumKey); // db.ReferendumsUpdateInt(electionKey, referendumKey, "OrderOnBallot", // Convert.ToUInt16(OrderOnBallot.Text)); // db.ReferendumsUpdate(electionKey, referendumKey, "ReferendumTitle", // ReferendumTitle.Text); // db.ReferendumsUpdate(electionKey, referendumKey, "ReferendumDesc", // ReferendumDesc.Text); // db.ReferendumsUpdate(electionKey, referendumKey, "ReferendumDetail", // ReferendumDetail.Text); // db.ReferendumsUpdate(electionKey, referendumKey, "ReferendumDetailUrl", // db.Str_Remove_Http(TextBoxDetailLink.Text.Trim())); // db.ReferendumsUpdate(electionKey, referendumKey, "ReferendumFullText", // ReferendumFullText.Text); // db.ReferendumsUpdate(electionKey, referendumKey, "ReferendumFullTextUrl", // db.Str_Remove_Http(TextBoxFullTextLink.Text.Trim())); // } // GetReferendumShowInTextboxes(electionKey, referendumKey); // ShowReferendumList(); // Msg.Text = db.Ok(ReferendumTitle.Text + " was UPDATED."); // } // catch (Exception ex) // { // Msg.Text = db.Fail(ex.Message); // db.Log_Error_Admin(ex); // } //} //private string Make_ReferendumKey(string electionKey) //{ // var referendumKey = electionKey; // referendumKey += db.Str_Remove_Non_Key_Chars(ReferendumTitle.Text.Trim()); // referendumKey = referendumKey.ReplaceNewLinesWithEmptyString(); // if (referendumKey.Length > 148) referendumKey = referendumKey.Substring(0, 148); // return referendumKey; //} //private static string Modify_ReferendumKey(string electionKey, // string referendumKey) //{ // referendumKey = referendumKey.Remove(0, electionKey.Length); // referendumKey = referendumKey.Insert(0, electionKey); // referendumKey = referendumKey.ReplaceNewLinesWithEmptyString(); // if (referendumKey.Length > 148) referendumKey = referendumKey.Substring(0, 148); // return referendumKey; //} //private static DataTable DataTable_ElectionKeys(string stateCode, // DateTime electionDate) //{ // var sql = string.Empty; // sql += "SELECT ElectionKey"; // sql += " FROM Elections"; // sql += " WHERE StateCode = " + db.SQLLit(stateCode); // sql += " AND ElectionDate = " + db.SQLLit(Convert.ToDateTime(electionDate) // .ToString("yyyyMMdd")); // return db.Table(sql); //} //protected void ButtonAdd_Click1(object sender, EventArgs e) //{ // try // { // CheckTextBoxes4IlleagelText(); // if (ReferendumTitle.Text.Trim() == string.Empty) throw new ApplicationException("The Referendum Title is required."); // var stateCode = ViewState["StateCode"].ToString(); // var countyCode = ViewState["CountyCode"].ToString(); // var localCode = ViewState["LocalCode"].ToString(); // var electionKey = ViewState["ElectionKey"].ToString(); // var electionDate = db.Elections_ElectionDate(electionKey); // var referendumKey = Make_ReferendumKey(electionKey); // if (Referendums.IsValid(ViewState["ElectionKey"].ToString(), referendumKey)) // throw new ApplicationException( // "This Referendum already exists. Change the Short Title if this is truly a new Referendum."); // CheckDescription(); // CheckBallotOrder(); // int ballotOrder; // if (OrderOnBallot.Text != string.Empty) ballotOrder = Convert.ToInt16(OrderOnBallot.Text); // else if (BallotOrderReferendumNext() != 0) ballotOrder = BallotOrderReferendumNext(); // else ballotOrder = 10; // //Update all primary elections on the same date // var tableElectionKeys = DataTable_ElectionKeys(stateCode, electionDate); // foreach (DataRow rowElectionKey in tableElectionKeys.Rows) // { // electionKey = rowElectionKey["ElectionKey"].ToString(); // referendumKey = Make_ReferendumKey(electionKey); // var electionKeyState = db.ElectionKey_State(electionKey, stateCode); // var electionKeyCounty = db.ElectionKey_County(electionKey, stateCode, // countyCode); // var electionKeyLocal = db.ElectionKey_Local(electionKey, stateCode, // countyCode, localCode); // var insertSQL = "INSERT INTO Referendums" + "(" + " ElectionKey" + // ",ReferendumKey" + ",ElectionKeyState" + ",ElectionKeyCounty" + // ",ElectionKeyLocal" + ",StateCode" + ",CountyCode" + ",LocalCode" + // ",OrderOnBallot" + ",ReferendumTitle" + ",ReferendumDesc" + // ",ReferendumDetail" + ",ReferendumDetailUrl" + ",ReferendumFullText" + // ",ReferendumFullTextUrl" + ")" + " VALUES(" + // db.SQLLit(electionKeyState) + "," + db.SQLLit(referendumKey) + "," + // db.SQLLit(electionKeyState) + "," + db.SQLLit(electionKeyCounty) + "," + // db.SQLLit(electionKeyLocal) + "," + db.SQLLit(stateCode) + "," + // db.SQLLit(countyCode) + "," + db.SQLLit(localCode) + "," + ballotOrder + // "," + db.SQLLit(ReferendumTitle.Text.Trim()) + "," + // db.SQLLit(ReferendumDesc.Text.Trim()) + "," + // db.SQLLit(ReferendumDetail.Text.Trim()) + "," + // db.SQLLit(db.Str_Remove_Http(TextBoxDetailLink.Text.Trim())) + "," + // db.SQLLit(ReferendumFullText.Text.Trim()) + "," + // db.SQLLit(db.Str_Remove_Http(TextBoxFullTextLink.Text.Trim())) + ")"; // db.ExecuteSQL(insertSQL); // } // HtmlTablesVisible4AddNewButton(ShowReferendumList()); // Msg.Text = db.Ok(ReferendumTitle.Text + " was ADDED"); // ClearTextBoxes(); // } // catch (Exception ex) // { // Msg.Text = db.Fail(ex.Message); // db.Log_Error_Admin(ex); // } //} //protected void Button1_Click(object sender, EventArgs e) //{ // ReferendumTitle.Text = ReferendumTitle.Text.ReplaceNewLinesWithSpaces(); //} //protected void ReferendumTitle_TextChanged(object sender, EventArgs e) { } //protected void RadioButtonListPassFail_SelectedIndexChanged(object sender, // EventArgs e) //{ // try // { // CheckTextBoxes4IlleagelText(); // switch (RadioButtonListPassFail.SelectedValue) // { // case "Passed": // db.ReferendumsUpdateBool(ViewState["ElectionKey"].ToString(), // ViewState["ReferendumKey"].ToString(), "IsPassed", true); // break; // case "Failed": // db.ReferendumsUpdateBool(ViewState["ElectionKey"].ToString(), // ViewState["ReferendumKey"].ToString(), "IsPassed", false); // break; // } // db.ReferendumsUpdateBool(ViewState["ElectionKey"].ToString(), // ViewState["ReferendumKey"].ToString(), "IsResultRecorded", true); // HtmlTablesVisible4Entry(ShowReferendumList()); // } // catch (Exception ex) // { // Msg.Text = db.Fail(ex.Message); // db.Log_Error_Admin(ex); // } //} //private void Page_Load(object sender, EventArgs e) //{ // if (!IsPostBack) // { // ViewState["ElectionKey"] = string.Empty; // ViewState["ReferendumKey"] = string.Empty; // if (!string.IsNullOrEmpty(QueryElection)) ViewState["ElectionKey"] = QueryElection; // if (!string.IsNullOrEmpty(QueryReferendum)) ViewState["ReferendumKey"] = QueryReferendum; // //The Session UserStateCode, UserCountyCode, UserLocalCode can be changed // //by a higher administration level using query strings // //This is done in db.State_Code(), db.County_Code(), db.Local_Code() // // // //Using ViewState variables insures these values won't // //change on any postbacks or in different tab or browser Sessions. // // // //ViewState["StateCode"] can be a StateCode or U1, u2, u3 for FederalCode // ViewState["StateCode"] = db.State_Code(); // ViewState["CountyCode"] = db.County_Code(); // ViewState["LocalCode"] = db.Local_Code(); // if (!db.Is_User_Security_Ok()) SecurePage.HandleSecurityException(); // try // { // if (db.Is_Election_Previous(ViewState["ElectionKey"].ToString())) // { // TablePassFail.Visible = true; // RadioButtonListPassFail.Enabled = // !string.IsNullOrEmpty(ViewState["ReferendumKey"].ToString()); // } // else TablePassFail.Visible = false; // if (ViewState["ReferendumKey"].ToString() == string.Empty) ViewState["FormMode"] = "ReferendumsADD"; // else //a referendum slected from the list of referendums // ViewState["FormMode"] = "ReferendumsUPDATE"; // if (ViewState["ReferendumKey"].ToString() != string.Empty) // if ( // !Referendums.IsValid(ViewState["ElectionKey"].ToString(), // ViewState["ReferendumKey"].ToString())) // throw new ApplicationException( // "No ReferendumKey in Referendums Table: " + // ViewState["ReferendumKey"]); // if (ViewState["ElectionKey"].ToString() != string.Empty) // if (!db.Is_Valid_Election(ViewState["ElectionKey"].ToString())) // throw new ApplicationException( // "No ElectionID in Elections Table: " + ViewState["ElectionKey"]); // HtmlTablesVisible4Entry(ShowReferendumList()); // //ThePageTitle(); // PageTitle_(); // if (ViewState["FormMode"].ToString() == "ReferendumsUPDATE") // GetReferendumShowInTextboxes(ViewState["ElectionKey"].ToString(), // ViewState["ReferendumKey"].ToString()); //Update // else ClearTextBoxes(); // } // catch (Exception ex) // { // Msg.Text = db.Fail(ex.Message); // db.Log_Error_Admin(ex); // } // } //} protected override void OnInit(EventArgs e) { LegacyRedirect(SecureAdminPage.GetUpdateElectionsPageUrl(QueryState, QueryCounty, QueryLocal)); base.OnInit(e); }