protected void Page_Load(object sender, EventArgs e) { try { QuotesViewTableAdapter quotesAdpt = new QuotesViewTableAdapter(); CoreDataObjects.QuotesViewRow r = (CoreDataObjects.QuotesViewRow)quotesAdpt.GetQuoteOfTheDay().Rows[0]; string likeUrl = string.Format("http://www.whatwouldthefoundersdo.org/showQuote.aspx?q={0}", r.QuoteID); //setup page meta data title Page.Title = string.Format("{0} Quote #{1}", r.FullName, r.QuoteID); Page.AddMetaInfo(OpenGraphMetaTags.Title, string.Format("{0} Quote #{1}", r.FullName, r.QuoteID)); Page.AddMetaInfo(OpenGraphMetaTags.Type, "article"); Page.AddMetaInfo(OpenGraphMetaTags.Site_Name, "WhatWouldTheFoundersDo.org"); Page.AddMetaInfo(OpenGraphMetaTags.URL, likeUrl); Page.AddMetaInfo(OpenGraphMetaTags.Description, string.Format("{0}", r.QuoteText)); //load the quote Wwfd.Web.Quotes.QuoteHelper.LoadQuote(PanelQOTD, r.FullName, r.QuoteText, r.QuoteID, r.ReferenceInfo, r.Keywords, false); //adjust the like page to link to the actual quote of the day url FrameFacebookLike.Attributes.Add("src", string.Format(@"http://www.facebook.com/plugins/like.php?href={0}&layout=standard&show_faces=false&width=330&action=like&font=tahoma&colorscheme=light&height=28", likeUrl)); } catch { } }
protected void txtSearchFounders_TextChanged(object sender, EventArgs e) { PanelCategories.Controls.Clear(); QuotesViewTableAdapter quotesAdpt = new QuotesViewTableAdapter(); QuoteCountsTableAdapter quoteCountsAdpt = new QuoteCountsTableAdapter(); //quotes by founder foreach (CoreDataObjects.QuoteCountsRow r in quoteCountsAdpt.SearchFounders(txtSearchFounders.Text).Where(r => r.TotalQuotes > 0)) { HyperLink link = new HyperLink(); link.NavigateUrl = string.Format("~/search.aspx?searchType=Founders&founderId={0}", r.FounderID); link.Text = string.Format("{0} ({1})", r.FullName, r.TotalQuotes); link.CssClass = "CategoryLink"; link.ToolTip = string.Format("All quotes by '{0}'", r.FullName); link.AppRelativeTemplateSourceDirectory = "~"; PanelCategories.Controls.Add(link); } }
protected void Page_Load(object sender, EventArgs e) { QuotesViewTableAdapter quotesAdpt = new QuotesViewTableAdapter(); QuoteCountsTableAdapter quoteCountsAdpt = new QuoteCountsTableAdapter(); //founders list foreach (CoreDataObjects.QuoteCountsRow r in quoteCountsAdpt.GetQuoteCounts().Where(r => r.TotalQuotes > 0)) { HyperLink link = new HyperLink(); link.NavigateUrl = string.Format("~/search.aspx?searchType=Founders&founderId={0}", r.FounderID); link.Text = string.Format("{0} ({1})", r.FullName, r.TotalQuotes); link.CssClass = "CategoryLink"; link.ToolTip = string.Format("All quotes by '{0}'", r.FullName); link.AppRelativeTemplateSourceDirectory = "~"; PanelCategories.Controls.Add(link); } //for logged in users if (Authenticator.IsUserLoggedIn()) { Contributor user = Authenticator.GetUser(); lblUserEmail.Text = user.EmailAddress + " | "; lblUserEmail.ToolTip = "You have contributed: " + quotesAdpt.GetCountByContributor(user.ContributorId).ToString() + " quotes."; lnkSignInOut.Text = "Sign out"; lnkSignInOut.NavigateUrl = "~/logout.aspx"; lnkSignInOut.ToolTip = "Click here to log out."; lnkDashboard.Visible = true; lnkContribute.Visible = false; } else { lnkSignInOut.Text = "Sign In"; lnkSignInOut.NavigateUrl = "~/contribute/login.aspx"; lnkDashboard.Visible = false; lnkContribute.Visible = true; } //set the subscription email validator regular expression }
private void SearchQuotes(string searchText, bool saveSearch) { searchBox.Text = searchText; string[] words = searchText.Split(' '); var quotesAdpt = new QuotesViewTableAdapter(); var results = quotesAdpt.SearchQuotes(searchText, saveSearch); //if (_sort) // quotesAdpt.SearchQuotes(searchText, saveSearch).OrderBy<Data.QuotesViewRow, System.String>(r => r.FullName).CopyToDataTable<Data.QuotesViewRow>(results, LoadOption.OverwriteChanges); lblSummaryText.Text = string.Format(@"Your search for ""<b>{0}</b>"" returned {1} results from {2} Founders. ", searchText, results.Rows.Count, results.SelectDistinct("FounderID").Rows.Count); if (results.Rows.Count > 0) { ShowResults(results, words); } }
protected void Page_Load(object sender, EventArgs e) { FoundersTableAdapter founders = new FoundersTableAdapter(); ContributionsViewTableAdapter contributors = new ContributionsViewTableAdapter(); QuotesViewTableAdapter quotes = new QuotesViewTableAdapter(); Contributor c = Authenticator.GetUser(); int tquotes = (int)quotes.GetCount();; int cquotes = (int)quotes.GetCountByContributor(c.ContributorId); lblTotalFounders.Text = founders.GetCount().ToString(); lblTotalQuotes.Text = tquotes.ToString(); lblQuotesContributed.Text = cquotes.ToString(); lblContributionRatio.Text = Math.Round(((double)cquotes / (double)tquotes) * 100, 2).ToString(); //popluate grids GridView1.DataSource = contributors.GetData(); GridView1.DataBind(); GridView2.DataSource = quotes.GetTop15ByContributorId(c.ContributorId); GridView2.DataBind(); }