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