protected void btnEmail_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(PUsername.Text.Trim()))
            {
                var patron = Patron.GetObjectByUsername(PUsername.Text.Trim());
                // Show message no matter what, even if we can't do it, because of hacking concerns

                if (patron == null || string.IsNullOrEmpty(patron.EmailAddress))
                {
                    new SessionTools(Session).AlertPatron("Your account could not be located or is not associated with an email address. Please visit your local library branch to reset your password.", PatronMessageLevels.Warning, "exclamation-sign");
                }
                else
                {
                    string remoteAddress = Request.UserHostAddress;

                    string passwordResetToken = patron.GeneratePasswordResetToken();
                    if (string.IsNullOrEmpty(passwordResetToken))
                    {
                        new SessionTools(Session).AlertPatron("Unable to reset your password. Please visit your local library branch.", PatronMessageLevels.Warning, "exclamation-sign");
                        return;
                    }

                    string systemName = SRPSettings.GetSettingValue("SysName");

                    var values = new {
                        SystemName        = systemName,
                        PasswordResetLink = string.Format("{0}{1}?token={2}",
                                                          WebTools.GetBaseUrl(Request),
                                                          "/PasswordRecovery.aspx",
                                                          passwordResetToken),
                        ContactName          = SRPSettings.GetSettingValue("ContactName"),
                        ContactEmail         = SRPSettings.GetSettingValue("ContactEmail"),
                        RemoteAddress        = remoteAddress,
                        UserEmail            = patron.EmailAddress,
                        Username             = patron.Username,
                        PasswordResetSubject = string.Format("{0} password reset request", systemName)
                    };

                    StringBuilder body = new StringBuilder();
                    body.Append("<p>A password reset request was received by {SystemName} for ");
                    body.Append("your account: {Username}.</p><p>Please ");
                    body.Append("<a href=\"{PasswordResetLink}\">click here</a> in the next hour ");
                    body.Append("to create a new password for your account.</p>");
                    body.Append("<p>If you did not initiate this request, take no action and your ");
                    body.Append("password will not be changed.</p>");
                    body.Append("<p>If you have any comments or questions, please contact ");
                    body.Append("{ContactName} at ");
                    body.Append("<a href=\"mailto:{ContactEmail}\">{ContactEmail}</a>.</p>");
                    body.Append("<p style=\"font-size: smaller;\"><em>This password request was ");
                    body.Append("submitted from: {RemoteAddress}.</em></p>");

                    new EmailService().SendEmail(patron.EmailAddress,
                                                 "{SystemName} - {PasswordResetSubject}".FormatWith(values),
                                                 body.ToString().FormatWith(values));
                    new SessionTools(Session).AlertPatron("Processing your password reset request, you should receive an email soon.",
                                                          glyphicon: "ok");
                }

                new SessionTools(Session).ClearPatron();
                Response.Redirect("~");
            }
        }
Beispiel #2
0
        protected void btnLogin_Click(object sender, EventArgs e)
        {
            if (Page.IsValid)
            {
                object tokenObject = this.ViewState["token"];
                if (tokenObject == null)
                {
                    new SessionTools(Session).AlertPatron(GetResourceString("password-recovery-expired"),
                                                          PatronMessageLevels.Warning,
                                                          "exclamation-sign");
                    Response.Redirect("~/Recover.aspx");
                    return;
                }

                var user = Patron.UpdatePasswordByToken(tokenObject.ToString(),
                                                        NPassword.Text);

                if (user == null)
                {
                    new SessionTools(Session).AlertPatron(GetResourceString("password-recovery-expired"),
                                                          PatronMessageLevels.Warning,
                                                          "exclamation-sign");
                    Response.Redirect("~/Recovery.aspx");
                    return;
                }

                // user requested a password for an email address that is not in the database
                // if account doesn't exist, send an email saying so
                var values = new {
                    SystemName    = SRPSettings.GetSettingValue("SysName"),
                    ContactName   = SRPSettings.GetSettingValue("ContactName"),
                    ContactEmail  = SRPSettings.GetSettingValue("ContactEmail"),
                    RemoteAddress = Request.UserHostAddress,
                    UserEmail     = user.EmailAddress,
                    Username      = user.Username,
                    LoginLink     = string.Format("{0}{1}",
                                                  WebTools.GetBaseUrl(Request),
                                                  "/Login.aspx"),
                    PasswordResetSuccessSubject = "Your password has been reset!"
                };

                this.Log().Info("Password reset process for {0} ({1}) complete from {2}",
                                values.Username,
                                values.UserEmail,
                                values.RemoteAddress);

                // TODO email - move this template out to the database
                StringBuilder body = new StringBuilder();
                body.Append("<p>The password change has been successful for the {SystemName} account: {Username}.</p>");
                body.Append("<p>You may now <a href=\"{LoginLink}\">log in</a> using your new password.</p>");
                body.Append("<p>If you have any comments or questions, please contact ");
                body.Append("{ContactName} at <a href=\"mailto:{ContactEmail}\">{ContactEmail}</a>.</p>");
                body.Append("<p style=\"font-size: smaller;\"><em>This password request was ");
                body.Append("completed from: {RemoteAddress}.</em></p>");

                new EmailService().SendEmail(user.EmailAddress,
                                             "{SystemName} - {PasswordResetSuccessSubject}".FormatWith(values),
                                             body.ToString().FormatWith(values));


                var st = new SessionTools(Session);
                st.EstablishPatron(user);
                st.AlertPatron(GetResourceString("Your password has been reset!"),
                               glyphicon: "ok");
                Response.Redirect("~");
            }
        }
Beispiel #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!String.IsNullOrEmpty(Request["PID"]))
            {
                Session["ProgramID"] = Request["PID"].ToString();
            }
            if (!IsPostBack)
            {
                if (Session["ProgramID"] == null)
                {
                    try
                    {
                        int PID = Programs.GetDefaultProgramID();
                        Session["ProgramID"] = PID.ToString();
                    }
                    catch
                    {
                        Response.Redirect("~/Badges/");
                    }
                }
            }
            TranslateStrings(this);

            badgeBackLink.NavigateUrl = "~/Badges/";

            TwitterShare.Visible  = false;
            FacebookShare.Visible = false;

            try
            {
                int    badgeId      = 0;
                string displayBadge = Request.QueryString["BadgeId"];
                if (!int.TryParse(displayBadge, out badgeId))
                {
                    throw new Exception("Invalid badge id provided.");
                }

                int patronId = 0;
                var patron   = Session[SessionKey.Patron] as DAL.Patron;
                if (patron != null)
                {
                    patronId = patron.PID;
                }

                var badgeDetailData = new Logic.Badge().GetForDisplay(Server, badgeId, patronId);


                if (badgeDetailData.Hidden == true && badgeDetailData.Earned == false)
                {
                    throw new Exception("Secret badge must be earned to be revealed.");
                }

                badgeTitle.Text      = badgeDetailData.DisplayName;
                this.Title           = string.Format("Badge: {0}", badgeTitle.Text);
                this.MetaDescription = string.Format("All about the {0} badge - {1}",
                                                     badgeTitle.Text,
                                                     GetResourceString("system-name"));
                badgeImage.ImageUrl      = badgeDetailData.ImageUrl;
                badgeImage.AlternateText = badgeDetailData.AlternateText;

                if (!string.IsNullOrEmpty(badgeDetailData.DateEarned))
                {
                    badgeEarnWhen.Text = string.Format("<p><strong>You earned this badge on {0}!</strong></p>",
                                                       badgeDetailData.DateEarned);
                    badgeEarnWhen.Visible = true;
                }
                else
                {
                    badgeEarnWhen.Visible = false;
                }

                badgeDetails.Visible = true;


                if (badgeDetailData.HowToEarn.Length > 0)
                {
                    badgeDesriptionLabel.Visible = true;
                    badgeDesriptionLabel.Text    = this.Server.HtmlDecode(badgeDetailData.Description);
                }
                else
                {
                    badgeDesriptionLabel.Visible = false;
                }

                if (!badgeDetailData.HideDefaultDescription)
                {
                    badgeEarnPanel.Visible = true;

                    StringBuilder sb = new StringBuilder();
                    foreach (var line in badgeDetailData.HowToEarn)
                    {
                        sb.AppendFormat("<li>{0}</li>", line);
                    }
                    badgeEarnLabel.Text = sb.ToString();
                }
                else
                {
                    badgeEarnPanel.Visible = false;
                }

                /* metadata */
                string systemName    = GetResourceString("system-name");
                var    fbDescription = StringResources.getStringOrNull("facebook-description");
                var    hashtags      = StringResources.getStringOrNull("socialmedia-hashtags");

                string title = string.Format("{0} badge: {1}",
                                             systemName,
                                             badgeDetailData.DisplayName);
                string description = null;
                string twitDescrip = null;

                if (badgeDetailData.Earned)
                {
                    description = string.Format("By participating in {0} I earned this badge: {1}!",
                                                systemName,
                                                badgeDetailData.DisplayName);
                    twitDescrip = string.Format("I earned this {0} badge: {1}!",
                                                systemName,
                                                badgeDetailData.DisplayName);
                    if (twitDescrip.Length > 118)
                    {
                        // if it's longer than this it won't fit with the url, shorten it
                        twitDescrip = string.Format("I earned this badge: {0}!",
                                                    badgeDetailData.DisplayName);
                    }
                }
                else
                {
                    description = string.Format("By participating in {0} you can earn this badge: {1}!",
                                                systemName,
                                                badgeDetailData.DisplayName);
                    twitDescrip = string.Format("Check out this {0} badge: {1}!",
                                                systemName,
                                                badgeDetailData.DisplayName);
                    if (twitDescrip.Length > 118)
                    {
                        // if it's longer than this it won't fit with the url, shorten it
                        twitDescrip = string.Format("Check out this badge: {0}!",
                                                    badgeDetailData.DisplayName);
                    }
                }

                var wt              = new WebTools();
                var baseUrl         = WebTools.GetBaseUrl(Request);
                var badgeDetailsUrl = string.Format("{0}/Badges/Details.aspx?BadgeId={1}",
                                                    baseUrl,
                                                    badgeDetailData.BadgeId);
                var badgeImagePath = string.Format("{0}{1}", baseUrl,
                                                   VirtualPathUtility.ToAbsolute(badgeDetailData.ImageUrl));

                wt.AddOgMetadata(Metadata,
                                 title,
                                 wt.BuildFacebookDescription(description, hashtags, fbDescription),
                                 badgeImagePath,
                                 badgeDetailsUrl,
                                 GetResourceString("facebook-appid"));

                wt.AddTwitterMetadata(Metadata,
                                      title,
                                      twitDescrip,
                                      badgeImagePath,
                                      twitterUsername: GetResourceString("twitter-username"));

                TwitterShare.NavigateUrl = wt.GetTwitterLink(twitDescrip,
                                                             Server.UrlEncode(badgeDetailsUrl),
                                                             hashtags);

                FacebookShare.NavigateUrl = wt.GetFacebookLink(Server.UrlEncode(badgeDetailsUrl));

                if (!badgeDetailData.Hidden)
                {
                    TwitterShare.Visible  = true;
                    FacebookShare.Visible = true;
                }
                // end social
                badgeDetails.Visible = true;
            }
            catch (Exception)
            {
                badgeDetails.Visible = false;
                var cph = Page.Master.FindControl("HeaderContent") as ContentPlaceHolder;
                if (cph != null)
                {
                    cph.Controls.Add(new HtmlMeta
                    {
                        Name    = "robots",
                        Content = "noindex"
                    });
                }
                new SessionTools(Session).AlertPatron("Could not find details on that badge.",
                                                      PatronMessageLevels.Warning,
                                                      "exclamation-sign");
            }
        }
Beispiel #4
0
        protected List <string> ConfigureTheGRA()
        {
            var           issues    = new List <string>();
            Configuration webConfig = null;

            try {
                webConfig = WebConfigurationManager.OpenWebConfiguration("~");
            } catch (Exception ex) {
                issues.Add(string.Format("Could not read the Web.config file on the disk (this is probably due to permissions): {0}", ex.Message));
                return(issues);
            }
            try {
                webConfig.Save(ConfigurationSaveMode.Minimal);
            } catch (Exception ex) {
                issues.Add(string.Format("Could not write to the Web.config file on the disk (this is probably due to permissions): {0}", ex.Message));
                return(issues);
            }

            var ownerBuilder = new SqlConnectionStringBuilder();

            ownerBuilder.DataSource     = DatabaseServer.Text;
            ownerBuilder.InitialCatalog = DatabaseCatalog.Text;
            if (!DatabaseServer.Text.Contains("(localdb)"))
            {
                ownerBuilder.UserID   = DatabaseOwnerUser.Text;
                ownerBuilder.Password = ViewState[DbOwnerKey].ToString();
            }

            using (var sqlConnection = new SqlConnection(ownerBuilder.ConnectionString)) {
                // do database script run
                var path = CreateSchemaPath;
                this.Log().Info("Creating database schema");
                var schemaIssues = ExecuteSqlFile(path, sqlConnection);

                if (schemaIssues.Count > 0)
                {
                    return(schemaIssues);
                }

                if (ReadingProgram.SelectedIndex == 0)
                {
                    // single program
                    path = Insert1ProgramPath;
                }
                else
                {
                    // multiple programs
                    path = Insert4ProgramsPath;
                }
                var insertIssues = ExecuteSqlFile(path, sqlConnection);

                if (insertIssues.Count > 0)
                {
                    return(insertIssues);
                }

                // update email address
                sqlConnection.Open();
                try {
                    // update the sysadmin user's email
                    SqlCommand updateEmail = new SqlCommand("UPDATE [SRPUser] SET [EmailAddress] = @emailAddress WHERE [Username] = 'sysadmin';",
                                                            sqlConnection);
                    updateEmail.Parameters.AddWithValue("@emailAddress", MailAddress.Text);
                    updateEmail.ExecuteNonQuery();
                } catch (Exception ex) {
                    string error = string.Format("Unable to update administrative email address: {0}",
                                                 ex);
                    this.Log().Error(error);
                }
                try {
                    // update the sysadmin contact email and mail from address
                    // TODO email - provide better setup for email
                    SqlCommand updateEmail = new SqlCommand("UPDATE [SRPSettings] SET [Value] = @emailAddress WHERE [Name] IN ('ContactEmail', 'FromEmailAddress');",
                                                            sqlConnection);
                    updateEmail.Parameters.AddWithValue("@emailAddress", MailAddress.Text);
                    updateEmail.ExecuteNonQuery();
                } catch (Exception ex) {
                    string error = string.Format("Unable to update administrative email address: {0}",
                                                 ex);
                    this.Log().Error(error);
                }
                sqlConnection.Close();
            }

            // data inserted, update Web.config
            try {
                var userBuilder = new SqlConnectionStringBuilder();
                userBuilder.DataSource     = DatabaseServer.Text;
                userBuilder.InitialCatalog = DatabaseCatalog.Text;
                if (!DatabaseServer.Text.Contains("(localdb)"))
                {
                    userBuilder.UserID   = DatabaseUserUser.Text;
                    userBuilder.Password = ViewState[DbUserKey].ToString();
                }

                var csSection = (ConnectionStringsSection)webConfig.GetSection("connectionStrings");
                csSection.ConnectionStrings[GlobalUtilities.SRPDBConnectionStringName].ConnectionString = userBuilder.ConnectionString;

                var mailSection = (MailSettingsSectionGroup)webConfig.GetSectionGroup("system.net/mailSettings");
                var network     = mailSection.Smtp.Network;

                if (!string.IsNullOrEmpty(MailServer.Text))
                {
                    network.Host = MailServer.Text;
                    mailSection.Smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
                }

                mailSection.Smtp.From = null;


                if (!string.IsNullOrEmpty(MailPort.Text))
                {
                    int port = 0;
                    if (int.TryParse(MailPort.Text, out port))
                    {
                        network.Port = port;
                    }
                }

                if (!string.IsNullOrEmpty(MailLogin.Text))
                {
                    network.UserName = MailLogin.Text;
                }

                if (ViewState[MailPwKey] != null && !string.IsNullOrEmpty(ViewState[MailPwKey].ToString()))
                {
                    network.Password = ViewState[MailPwKey].ToString();
                }

                webConfig.Save(ConfigurationSaveMode.Minimal);
            } catch (Exception ex) {
                string error = string.Format("Couldn't update Web.config with new connection string: {0}", ex.Message);
                this.Log().Error(error);
                issues.Add(error);
            }



            if (issues.Count == 0)
            {
                this.Log().Info(() => "Great Reading Adventure setup complete!");
                try {
                    // TODO email - move this template out to the database
                    var values = new {
                        SystemName      = "The Great Reading Adventure",
                        ControlRoomLink = string.Format("{0}{1}",
                                                        WebTools.GetBaseUrl(Request),
                                                        "/ControlRoom/"),
                    };

                    StringBuilder body = new StringBuilder();
                    body.Append("<p>Congratulations! You have successfully configured ");
                    body.Append("{SystemName}!</p><p>You may now ");
                    body.Append("<a href=\"{ControlRoomLink}\">log in</a> using the default ");
                    body.Append("system administrator credentials.</p><p>For more information on ");
                    body.Append("setting up and using the {SystemName} software, feel free to ");
                    body.Append("visit the <a href=\"http://manual.greatreadingadventure.com/\">manual</a>");
                    body.Append("and <a href=\"http://forum.greatreadingadventure.com/\">forum</a>.");
                    body.Append("</p>");

                    new EmailService().SendEmail(MailAddress.Text,
                                                 "{SystemName} - Setup complete!"
                                                 .FormatWith(values),
                                                 body.ToString().FormatWith(values));
                    this.Log().Info(() => "Welcome email sent.");
                } catch (Exception ex) {
                    this.Log().Error(() => "Welcome email sending failure: {Message}"
                                     .FormatWith(ex));
                }

                return(null);
            }
            else
            {
                return(issues);
            }
        }
        protected void LookupChallenge(int blid)
        {
            var bl = BookList.FetchObject(blid);

            if (bl == null)
            {
                challengeDetails.Visible = false;
                new SessionTools(Session).AlertPatron("Could not find details on that Challenge.",
                                                      PatronMessageLevels.Warning,
                                                      "exclamation-sign");
            }
            else
            {
                int patronId = -1;
                var p        = Session[SessionKey.Patron] as Patron;
                if (p != null)
                {
                    patronId = p.PID;
                }

                // see if this is bound to a specific program
                if (bl.ProgID != 0)
                {
                    // no user is logged in, don't show it
                    if (p == null)
                    {
                        var prog = DAL.Programs.FetchObject(bl.ProgID);
                        challengeDetails.Visible = false;
                        new SessionTools(Session).AlertPatron(
                            string.Format("You must be registered in the <strong>{0}</strong> program to view this Challenge.",
                                          prog.TabName),
                            PatronMessageLevels.Warning,
                            "exclamation-sign");
                    }

                    // user is registered under another program
                    if (p != null && bl.ProgID != p.ProgID)
                    {
                        var prog = DAL.Programs.FetchObject(bl.ProgID);
                        challengeDetails.Visible = false;
                        new SessionTools(Session).AlertPatron(
                            string.Format("That Challenge is only available to people in the <strong>{0}</strong> program.",
                                          prog.TabName),
                            PatronMessageLevels.Warning,
                            "exclamation-sign");
                    }
                }

                if (challengeDetails.Visible)
                {
                    Badge badge = null;

                    challengeTitle.Text = bl.ListName;
                    this.Title          = string.Format("Challenge: {0}", challengeTitle.Text);
                    lblDesc.Text        = string.Format("<p>{0}</p>", Server.HtmlDecode(bl.Description));

                    string award = null;

                    if (bl.AwardPoints > 0)
                    {
                        award = string.Format("Completing <strong>{0} task{1}</strong> will earn: <strong>{2} point{3}</strong>",
                                              bl.NumBooksToComplete,
                                              bl.NumBooksToComplete > 1 ? "s" : string.Empty,
                                              bl.AwardPoints,
                                              bl.AwardPoints > 1 ? "s" : string.Empty);
                    }

                    if (bl.AwardBadgeID > 0)
                    {
                        badge = DAL.Badge.FetchObject(bl.AwardBadgeID);
                        if (badge != null)
                        {
                            if (badge.HiddenFromPublic != true)
                            {
                                if (string.IsNullOrWhiteSpace(award))
                                {
                                    award = string.Format("Completing {0} task{1} will earn: <strong>a badge</strong>.",
                                                          bl.NumBooksToComplete,
                                                          bl.NumBooksToComplete > 1 ? "s" : string.Empty);
                                }
                                else
                                {
                                    award += " and <strong>a badge</strong>.";
                                }

                                BadgeImage.Text = string.Format("<img class=\"thumbnail disabled\" src=\"/images/badges/sm_{0}.png\" />", bl.AwardBadgeID);
                            }
                            else
                            {
                                badge = null;
                                if (string.IsNullOrWhiteSpace(award))
                                {
                                    award = string.Format("Completing {0} task{1} will earn: <strong>a secret badge</strong>.",
                                                          bl.NumBooksToComplete,
                                                          bl.NumBooksToComplete > 1 ? "s" : string.Empty);
                                }
                                else
                                {
                                    award += " and <strong>a secret badge</strong>.";
                                }
                                BadgeImage.Text = string.Empty;
                            }
                        }
                    }
                    else
                    {
                        BadgeImage.Text = string.Empty;
                        award          += ".";
                    }

                    BadgeImage.Visible = !string.IsNullOrEmpty(BadgeImage.Text);

                    if (!string.IsNullOrWhiteSpace(award))
                    {
                        lblPoints.Text    = award;
                        lblPoints.Visible = true;
                    }

                    var ds = BookListBooks.GetForDisplay(bl.BLID, patronId);

                    //Eval("NumBooksCompleted"), Eval("NumBooksToComplete")
                    if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                    {
                        int completed = 0;
                        foreach (DataRow row in ds.Tables[0].Rows)
                        {
                            if ((bool?)row["HasRead"] == true)
                            {
                                completed++;
                                if (completed >= bl.NumBooksToComplete)
                                {
                                    ChallengeCompleted = true;
                                    break;
                                }
                            }
                        }
                    }

                    rptr.DataSource = ds;
                    rptr.DataBind();

                    // begin social
                    var wt = new WebTools();

                    string systemName    = StringResources.getStringOrNull("system-name");
                    var    fbDescription = StringResources.getStringOrNull("facebook-description");
                    var    hashtags      = StringResources.getStringOrNull("socialmedia-hashtags");

                    string title = string.Format("{0} challenge: {1}",
                                                 systemName,
                                                 bl.ListName);

                    string description = string.Format("Check out this {0} challenge: {1}!",
                                                       systemName,
                                                       bl.ListName);

                    string twitDescrip = description;
                    if (twitDescrip.Length > 118)
                    {
                        // if it's longer than this it won't fit with the url, shorten it
                        twitDescrip = string.Format("Check this out: {0}!",
                                                    bl.ListName);
                    }

                    var baseUrl      = WebTools.GetBaseUrl(Request);
                    var challengeUrl = string.Format("{0}/Challenges/Details.aspx?ChallengeId={1}",
                                                     baseUrl,
                                                     bl.BLID);

                    string imagePath = null;
                    if (badge != null)
                    {
                        string potentialBadgePath = string.Format("~/Images/Badges/{0}.png",
                                                                  badge.BID);
                        if (System.IO.File.Exists(Server.MapPath(potentialBadgePath)))
                        {
                            imagePath = string.Format("{0}{1}",
                                                      baseUrl,
                                                      VirtualPathUtility.ToAbsolute(potentialBadgePath));
                        }
                    }

                    if (string.IsNullOrEmpty(imagePath))
                    {
                        imagePath = new GRA.Logic.Banner().FullMetadataBannerPath(baseUrl,
                                                                                  Session,
                                                                                  Server);
                    }

                    wt.AddOgMetadata(Metadata,
                                     title,
                                     wt.BuildFacebookDescription(description, hashtags, fbDescription),
                                     imagePath,
                                     challengeUrl,
                                     facebookApp: GetResourceString("facebook-appid"));

                    wt.AddTwitterMetadata(Metadata,
                                          title,
                                          description,
                                          imagePath,
                                          twitterUsername: GetResourceString("twitter-username"));

                    TwitterShare.NavigateUrl = wt.GetTwitterLink(description,
                                                                 Server.UrlEncode(challengeUrl),
                                                                 hashtags);
                    TwitterShare.Visible      = true;
                    FacebookShare.NavigateUrl = wt.GetFacebookLink(Server.UrlEncode(challengeUrl));
                    FacebookShare.Visible     = true;
                    // end social

                    this.ShowModal = true;
                }
            }
        }
Beispiel #6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            AvatarBackLink.NavigateUrl = "~/";

            SystemName.Text      = SystemNamePrint.Text = StringResources.getString("system-name");
            SystemSlogan.Text    = SystemSloganPrint.Text = StringResources.getString("slogan");
            SystemSlogan.Visible = SystemSloganPrint.Visible = SystemSlogan.Text != "slogan";
            string programId = null;

            AvatarBackLink.Text = StringResources.getString("avatar-return");
            if (AvatarBackLink.Text == "avatar-return")
            {
                AvatarBackLink.Text = "Back";
            }

            var patron = Session[SessionKey.Patron] as DAL.Patron;

            if (patron != null)
            {
                programId          = patron.ProgID.ToString();
                MyAvatarPrint.Text = Tools.DisplayHelper.FormatName(patron.FirstName,
                                                                    patron.LastName,
                                                                    patron.Username);
            }
            else
            {
                MyAvatarPrint.Text = "My Avatar";
            }

            if (string.IsNullOrEmpty(programId))
            {
                var sessionProgId = Session["ProgramId"];
                if (sessionProgId != null)
                {
                    programId = sessionProgId.ToString();
                }
            }

            if (string.IsNullOrEmpty(programId))
            {
                try
                {
                    programId = DAL.Programs.GetDefaultProgramID().ToString();
                }
                catch (Exception) { }
            }

            string bannerPath = new Logic.Banner().FullMetadataBannerPath(
                WebTools.GetBaseUrl(Request),
                programId,
                Server);

            if (!string.IsNullOrEmpty(bannerPath))
            {
                BannerImagePrint.ImageUrl = bannerPath;
            }
            else
            {
                BannerImagePrint.Visible = false;
            }

            string avatarPath   = null;
            string avatarMdPath = null;
            bool   validAvatar  = false;
            string avatarId     = Request.QueryString["AvatarId"];

            if (!string.IsNullOrEmpty(avatarId) && avatarId.Length <= 24)
            {
                char[] avatarIdArray = avatarId.ToCharArray();

                avatarIdArray = Array.FindAll <char>(avatarIdArray,
                                                     (c => (char.IsLetterOrDigit(c))));
                avatarId = new string(avatarIdArray);

                avatarPath   = string.Format("~/Images/AvatarCache/{0}.png", avatarId);
                avatarMdPath = string.Format("~/Images/AvatarCache/md_{0}.png", avatarId);

                if (File.Exists(Server.MapPath(avatarPath)))
                {
                    validAvatar          = true;
                    AvatarImage.ImageUrl = AvatarImagePrint.ImageUrl = avatarPath;
                    AvatarPanel.Visible  = true;
                }
            }

            if (!validAvatar)
            {
                AvatarPanel.Visible = false;
            }
            else
            {
                // begin social
                var wt = new WebTools();

                var fbDescription = StringResources.getStringOrNull("facebook-description");
                var hashtags      = StringResources.getStringOrNull("socialmedia-hashtags");

                var title       = string.Format("{0} avatar", SystemName.Text);
                var description = string.Format("Check out this awesome avatar in {0}!",
                                                SystemName.Text);

                var baseUrl          = WebTools.GetBaseUrl(Request);
                var avatarDetailPath = string.Format("{0}/Avatar/View.aspx?AvatarId={1}",
                                                     baseUrl,
                                                     avatarId);
                var fullAvatarPath = string.Format("{0}{1}",
                                                   baseUrl,
                                                   VirtualPathUtility.ToAbsolute(avatarPath));
                var fullAvatarMdPath = string.Format("{0}{1}",
                                                     baseUrl,
                                                     VirtualPathUtility.ToAbsolute(avatarMdPath));

                if (patron != null)
                {
                    title       = string.Format("My {0} avatar", SystemName.Text);
                    description = string.Format("Check out my awesome avatar in {0}!",
                                                SystemName.Text);
                }

                wt.AddOgMetadata(Metadata,
                                 title,
                                 wt.BuildFacebookDescription(description, hashtags, fbDescription),
                                 fullAvatarPath,
                                 avatarDetailPath,
                                 facebookApp: StringResources.getString("facebook-appid"));

                wt.AddTwitterMetadata(Metadata,
                                      title,
                                      description,
                                      fullAvatarMdPath,
                                      StringResources.getString("twitter-username"));

                TwitterShare.NavigateUrl = wt.GetTwitterLink(description,
                                                             Server.UrlEncode(avatarDetailPath),
                                                             hashtags);
                TwitterShare.Visible = true;

                FacebookShare.NavigateUrl = wt.GetFacebookLink(Server.UrlEncode(avatarDetailPath));
                FacebookShare.Visible     = true;
                // end social
            }

            AvatarPrintPanel.Visible = AvatarPanel.Visible;
            AvatarAlert.Visible      = !AvatarPanel.Visible;
        }
        protected void rptr_ItemDataBound(object source, RepeaterItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item ||
                e.Item.ItemType == ListItemType.AlternatingItem)
            {
                var eventRow        = e.Item.DataItem as System.Data.DataRowView;
                var branchName      = eventRow["Branch"].ToString();
                var branchAddress   = eventRow["BranchAddress"];
                var branchTelephone = eventRow["BranchTelephone"];
                var branchLink      = eventRow["BranchLink"];
                var label           = e.Item.FindControl("BranchName") as Literal;

                bool haveLink = branchLink != null &&
                                !string.IsNullOrWhiteSpace(branchLink.ToString());
                bool haveAddress = branchAddress != null &&
                                   !string.IsNullOrWhiteSpace(branchAddress.ToString());

                DateTime eventDate = DateTime.MinValue;
                if (eventRow["EventDate"] != null)
                {
                    eventDate = eventRow["EventDate"] as DateTime? ?? DateTime.MinValue;
                }

                if (haveLink)
                {
                    label.Text = string.Format(WebTools.BranchLinkStub,
                                               branchLink.ToString(),
                                               branchName);
                }

                if (haveAddress)
                {
                    label.Text += string.Format(WebTools.BranchMapStub,
                                                HttpUtility.UrlEncode(branchAddress.ToString()));
                }

                try
                {
                    if (haveLink && haveAddress && eventDate != DateTime.MinValue)
                    {
                        string detailsLink = string.Format("{0}{1}",
                                                           WebTools.GetBaseUrl(Request),
                                                           ResolveUrl(string.Format("~/Events/Details.aspx?EventId={0}", eventRow["EID"])));

                        SchemaOrgLibrary mdLib = new SchemaOrgLibrary
                        {
                            Name    = branchName,
                            Address = branchAddress.ToString(),
                            Url     = branchLink.ToString()
                        };

                        if (branchTelephone != null && !string.IsNullOrWhiteSpace(branchTelephone.ToString()))
                        {
                            mdLib.Telephone = branchTelephone.ToString();
                        }

                        SchemaOrgEvent mdEvt = new SchemaOrgEvent
                        {
                            Name      = eventRow["EventTitle"].ToString(),
                            Url       = detailsLink,
                            Location  = mdLib,
                            StartDate = eventDate
                        };

                        var md = e.Item.FindControl("Microdata") as Literal;

                        if (md != null)
                        {
                            md.Text = new WebTools().BuildEventJsonld(mdEvt);
                        }
                    }
                }
                catch (Exception ex)
                {
                    this.Log().Error("Problem creating microdata in event list for {0}: {1} - {2}",
                                     eventRow["EID"],
                                     ex.Message,
                                     ex.StackTrace);
                }
            }
        }
        protected void btnEmail_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(PUsername.Text.Trim()))
            {
                var patron = Patron.GetObjectByUsername(PUsername.Text.Trim());

                if (patron == null || string.IsNullOrEmpty(patron.EmailAddress))
                {
                    new SessionTools(Session).AlertPatron("Your account could not be located or is not associated with an email address. Please visit your local library branch to reset your password.", PatronMessageLevels.Warning, "exclamation-sign");
                    if (patron != null)
                    {
                        this.Log().Info("Unable to send password recovery email for patron id {0} becuase they don't have an email address configured", patron.PID);
                    }
                    return;
                }
                else
                {
                    try
                    {
                        string remoteAddress = new WebTools().RemoteUserAddress(Request);

                        string passwordResetToken = patron.GeneratePasswordResetToken();
                        if (string.IsNullOrEmpty(passwordResetToken))
                        {
                            new SessionTools(Session).AlertPatron("Unable to reset your password. Please visit your local library branch.", PatronMessageLevels.Warning, "exclamation-sign");
                            this.Log().Fatal("Unable to generate password reset token - critical error in password recovery");
                            return;
                        }

                        string systemName = SRPSettings.GetSettingValue("SysName");

                        var values = new
                        {
                            SystemName        = systemName,
                            PasswordResetLink = string.Format("{0}{1}?token={2}",
                                                              WebTools.GetBaseUrl(Request),
                                                              "/PasswordRecovery.aspx",
                                                              passwordResetToken),
                            ContactName          = SRPSettings.GetSettingValue("ContactName"),
                            ContactEmail         = SRPSettings.GetSettingValue("ContactEmail"),
                            RemoteAddress        = remoteAddress,
                            UserEmail            = patron.EmailAddress,
                            Username             = patron.Username,
                            PasswordResetSubject = string.Format("{0} password reset request", systemName)
                        };

                        StringBuilder body = new StringBuilder();
                        body.Append("<p>A password reset request was received by {SystemName} for ");
                        body.Append("your account: {Username}.</p><p>Please ");
                        body.Append("<a href=\"{PasswordResetLink}\">click here</a> ");
                        body.Append("to create a new password for your account.</p>");
                        body.Append("<p>If you did not initiate this request, take no action and your ");
                        body.Append("password will not be changed.</p>");
                        body.Append("<p>If you have any comments or questions, please contact ");
                        body.Append("{ContactName} at ");
                        body.Append("<a href=\"mailto:{ContactEmail}\">{ContactEmail}</a>.</p>");
                        body.Append("<p style=\"font-size: smaller;\"><em>This password request was ");
                        body.Append("submitted from: {RemoteAddress}.</em></p>");

                        new EmailService().SendEmail(patron.EmailAddress,
                                                     "{SystemName} - {PasswordResetSubject}".FormatWith(values),
                                                     body.ToString().FormatWith(values));
                        this.Log().Info("Sent password request email for patron id {0} to {1}",
                                        patron.PID, patron.EmailAddress);

                        new SessionTools(Session).AlertPatron("Processing your password reset request, you should receive an email soon.",
                                                              glyphicon: "ok");
                    }
                    catch (Exception ex)
                    {
                        this.Log().Fatal("Unable to send password recovery email for patron id {0} to {1}: {2} - {3}",
                                         patron.PID,
                                         patron.EmailAddress,
                                         ex.Message,
                                         ex.StackTrace);
                        new SessionTools(Session).AlertPatron("A problem occurred resetting your password. Please visit your local library branch to reset your password.",
                                                              PatronMessageLevels.Warning,
                                                              "exclamation-sign");
                    }
                }

                new SessionTools(Session).ClearPatron();
                Response.Redirect("~");
            }
        }
        protected void InstallBtn_Click(object sender, EventArgs e)
        {
            ////////////////////////////////////////
            ////////////////////////////////////////
            ////////////////////////////////////////
            string createSchemaFile = "~/ControlRoom/Modules/Install/CreateSchema.sql";
            string initialDataFile  = "~/ControlRoom/Modules/Install/InsertInitialData.sql";
            ////////////////////////////////////////
            ////////////////////////////////////////
            ////////////////////////////////////////

            string        conn        = null;
            string        rcon        = null;
            bool          localDbMode = DBServer.Text.ToUpper() == "(LOCALDB)";
            Configuration webConfig   = null;

            if (string.IsNullOrEmpty(Mailaddress.Text))
            {
                return;
            }

            this.Log().Info("GRA setup started, using LocalDb is: {0}", localDbMode);

            // test writing to Web.config before we go further
            if (!localDbMode)
            {
                if (!this.IsValid)
                {
                    return;
                }

                try {
                    webConfig = WebConfigurationManager.OpenWebConfiguration("~");
                } catch (Exception ex) {
                    this.Log().Error("There was an error reading the Web.config: {0}", ex.Message);
                    FailureText.Text = "There was an error when trying to read the Web.config file, see below:";
                    errorLabel.Text  = ex.Message;
                    return;
                }
                try {
                    webConfig.Save();
                } catch (Exception ex) {
                    this.Log().Error("There was an error writing the Web.config file: {0}",
                                     ex.Message);
                    FailureText.Text = "There was an error when trying to write to the Web.config file, see below:";
                    errorLabel.Text  = ex.Message;
                    return;
                }
            }

            if (localDbMode)
            {
                conn = GlobalUtilities.SRPDB;
                rcon = GlobalUtilities.SRPDB;

                // set reasonable defaults
                string dataSource = @"(localdb)\ProjectsV12";
                string dbName     = "SRP";

                // try to parse out data source and database name
                try {
                    var builder = new SqlConnectionStringBuilder(conn);
                    if (!string.IsNullOrEmpty(builder.DataSource))
                    {
                        dataSource = builder.DataSource;
                    }
                    if (!string.IsNullOrEmpty(builder.InitialCatalog))
                    {
                        dbName = builder.InitialCatalog;
                    }
                } catch (Exception) {
                    // if we can't parse the connection string, use defaults
                }

                string localDbCs = string.Format("server={0}", dataSource);

                string existsQuery = string.Format("SELECT [database_id] FROM [sys].[databases] "
                                                   + "WHERE [Name] = '{0}'",
                                                   dbName);
                object result = null;
                try {
                    result = SqlHelper.ExecuteScalar(localDbCs, CommandType.Text, existsQuery);
                } catch (Exception ex) {
                    this.Log().Error("There was an error when trying to connect to LocalDb: {0}",
                                     ex.Message);
                    FailureText.Text = "There was an error when trying to connect to LocalDb, see below:";
                    errorLabel.Text  = ex.Message;
                    return;
                }

                if (result == null)
                {
                    string createDb = string.Format("CREATE DATABASE [{0}]", dbName);
                    try {
                        SqlHelper.ExecuteNonQuery(localDbCs, CommandType.Text, createDb);
                    } catch (Exception ex) {
                        this.Log().Error("There was an error creating the database: {0}",
                                         ex.Message);
                        FailureText.Text = "There was an error creating the database, see below:";
                        errorLabel.Text  = ex.Message;
                    }
                }
            }
            else
            {
                if (!this.IsValid)
                {
                    return;
                }

                conn = string.Format("Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
                                     DBServer.Text,
                                     DBName.Text,
                                     UserName.Text,
                                     Password.Text);
                rcon = string.Format("Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
                                     DBServer.Text,
                                     DBName.Text,
                                     RunUser.Text,
                                     RuntimePassword.Text);
            }
            var mailHost = Mailserver.Text;


            try {
                SqlHelper.ExecuteNonQuery(conn, CommandType.Text, "SELECT 1");
            } catch (Exception ex) {
                this.Log().Error("There was an error when trying to connect with the SA account: {0}",
                                 ex.Message);
                FailureText.Text = "There was an error when trying to connect with the SA account, see below:";
                errorLabel.Text  = ex.Message;
                return;
            }

            try {
                SqlHelper.ExecuteNonQuery(rcon, CommandType.Text, "SELECT 1");
            } catch (Exception ex) {
                this.Log().Error("There was an error when trying to connect with the runtime account: {0}",
                                 ex.Message);
                FailureText.Text = "There was an error when trying to connect with the runtime account, see below:";
                errorLabel.Text  = ex.Message;
                return;
            }

            ////////////////////////////////////////
            ////////////////////////////////////////
            ////////////////////////////////////////
            List <string> issues = new List <string>();

            this.Log().Info("Executing the queries to create the database schema.");
            issues = ExecuteSqlFile(createSchemaFile, conn);

            if (issues.Count == 0)
            {
                this.Log().Info("Executing the queries to insert the initial data.");
                issues = ExecuteSqlFile(initialDataFile, conn);
                if (issues.Count != 0)
                {
                    issues.Add(LogAndReturnError("Could not insert initial data. GRA will not work until the data will insert properly. Please resolve the issue, recreate the database, and run this process again."));
                }
            }
            else
            {
                // schema create didn't work
                issues.Add(LogAndReturnError("Not inserting initial data due to schema issue. Please resolve the issue, recreate the database, and run this process again."));
            }

            if (issues.Count == 0)
            {
                // update email address with what the user entered
                this.Log().Info("Updating the administrative email addresses to: {0}",
                                Mailaddress);
                using (var connection = new SqlConnection(conn)) {
                    try {
                        connection.Open();
                        try {
                            // update the sysadmin user's email
                            SqlCommand updateEmail = new SqlCommand("UPDATE [SRPUser] SET [EmailAddress] = @emailAddress WHERE [Username] = 'sysadmin';",
                                                                    connection);
                            updateEmail.Parameters.AddWithValue("@emailAddress", Mailaddress.Text);
                            updateEmail.ExecuteNonQuery();
                        } catch (Exception ex) {
                            issues.Add(LogAndReturnError(string.Format("Unable to update sysadmin email: {0}",
                                                                       ex.Message)));
                        }
                        try {
                            // update the sysadmin contact email and mail from address
                            // TODO email - provide better setup for email
                            SqlCommand updateEmail = new SqlCommand("UPDATE [SRPSettings] SET [Value] = @emailAddress WHERE [Name] IN ('ContactEmail', 'FromEmailAddress');",
                                                                    connection);
                            updateEmail.Parameters.AddWithValue("@emailAddress", Mailaddress.Text);
                            updateEmail.ExecuteNonQuery();
                        } catch (Exception ex) {
                            issues.Add(LogAndReturnError(string.Format("Unable to update settings emails: {0}", ex.Message)));
                        }
                    } catch (Exception ex) {
                        issues.Add(LogAndReturnError(string.Format("Error connecting to update email address: {0}", ex.Message)));
                    } finally {
                        connection.Close();
                    }
                }
            }

            if (issues.Count == 0 && !localDbMode)
            {
                // modify the Web.config
                this.Log().Info(() => "Updating the Web.config file with the provided settings");

                webConfig = WebConfigurationManager.OpenWebConfiguration("~");

                var csSection = (ConnectionStringsSection)webConfig.GetSection("connectionStrings");
                csSection.ConnectionStrings[GlobalUtilities.SRPDBConnectionStringName].ConnectionString = rcon;

                if (mailHost != "(localhost)")
                {
                    var mailSection = (MailSettingsSectionGroup)webConfig.GetSectionGroup("system.net/mailSettings");
                    mailSection.Smtp.Network.Host = mailHost;
                }
                webConfig.Save();
            }

            if (issues.Count == 0)
            {
                // Delete the Install File
                //System.IO.File.Delete(Server.MapPath(InstallFile));
                this.Log().Info(() => "Great Reading Adventure setup complete!");
                try {
                    // TODO email - move this template out to the database
                    var values = new {
                        SystemName      = "The Great Reading Adventure",
                        ControlRoomLink = string.Format("{0}{1}",
                                                        WebTools.GetBaseUrl(Request),
                                                        "/ControlRoom/"),
                    };

                    StringBuilder body = new StringBuilder();
                    body.Append("<p>Congratulations! You have successfully configured ");
                    body.Append("{SystemName}!</p><p>You may now ");
                    body.Append("<a href=\"{ControlRoomLink}\">log in</a> using the default ");
                    body.Append("system administrator credentials.</p><p>For more information on ");
                    body.Append("setting up and using the {SystemName} software, feel free to ");
                    body.Append("visit the <a href=\"http://manual.greatreadingadventure.com/\">manual</a>");
                    body.Append("and <a href=\"http://forum.greatreadingadventure.com/\">forum</a>.");
                    body.Append("</p>");

                    new EmailService().SendEmail(Mailaddress.Text,
                                                 "{SystemName} - Setup complete!"
                                                 .FormatWith(values),
                                                 body.ToString().FormatWith(values));
                    this.Log().Info(() => "Welcome email sent.");
                } catch (Exception ex) {
                    this.Log().Error(() => "Welcome email sending failure: {Message}"
                                     .FormatWith(ex));
                }

                Response.Redirect("~/ControlRoom/");
            }
            else
            {
                FailureText.Text = "There have been errors, see details below.";
                StringBuilder errorText = new StringBuilder();
                foreach (var issue in issues)
                {
                    errorText.Append(issue);
                    errorText.AppendLine("<br>");
                }
                errorLabel.Text = errorText.ToString();
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!String.IsNullOrEmpty(Request["PID"]))
            {
                Session["ProgramID"] = Request["PID"].ToString();
            }
            if (!IsPostBack)
            {
                if (Session["ProgramID"] == null)
                {
                    try
                    {
                        int PID = Programs.GetDefaultProgramID();
                        Session["ProgramID"] = PID.ToString();
                    }
                    catch
                    {
                        Response.Redirect("~/Default.aspx");
                    }
                }
            }

            TranslateStrings(this);

            eventBackLink.NavigateUrl = "~/Events/";

            DAL.Event evnt         = null;
            int       eventId      = 0;
            string    displayEvent = Request.QueryString["EventId"];

            if (!string.IsNullOrEmpty(displayEvent) &&
                int.TryParse(displayEvent.ToString(), out eventId))
            {
                evnt = DAL.Event.GetEvent(eventId);
                if (evnt != null && evnt.HiddenFromPublic)
                {
                    evnt = null;
                }
                if (evnt != null)
                {
                    SchemaOrgLibrary mdLib = new SchemaOrgLibrary();
                    SchemaOrgEvent   mvEvt = new SchemaOrgEvent
                    {
                        Name      = evnt.EventTitle,
                        StartDate = evnt.EventDate
                    };

                    eventTitle.Text = evnt.EventTitle;
                    this.Title      = string.Format("Event Details: {0}", eventTitle.Text);

                    eventWhen.Text = DAL.Event.DisplayEventDateTime(evnt);

                    eventWhere.Visible     = false;
                    eventWhereLink.Visible = false;
                    atLabel.Visible        = false;

                    if (evnt.BranchID > 0)
                    {
                        var codeObject = DAL.Codes.FetchObject(evnt.BranchID);
                        if (codeObject != null)
                        {
                            eventWhere.Text
                                  = mdLib.Name
                                  = codeObject.Description;
                            eventWhereLink.Text = string.Format("{0} <span class=\"glyphicon glyphicon-new-window hidden-print\"></span>",
                                                                codeObject.Description);

                            eventWhere.Visible     = true;
                            atLabel.Visible        = true;
                            eventWhereLink.Visible = false;
                        }
                        var crosswalk = DAL.LibraryCrosswalk.FetchObjectByLibraryID(evnt.BranchID);
                        if (crosswalk != null)
                        {
                            if (!string.IsNullOrEmpty(eventWhere.Text) &&
                                !string.IsNullOrEmpty(crosswalk.BranchAddress))
                            {
                                eventWhereMapLink.Visible     = true;
                                eventWhereMapLink.NavigateUrl = string.Format(WebTools.BranchMapLinkStub,
                                                                              crosswalk.BranchAddress);
                            }

                            if (!string.IsNullOrEmpty(eventWhere.Text) &&
                                !string.IsNullOrEmpty(crosswalk.BranchLink))
                            {
                                eventWhereLink.NavigateUrl = crosswalk.BranchLink;
                                eventWhere.Visible         = false;
                                eventWhereLink.Visible     = true;
                                atLabel.Visible            = true;
                            }

                            mdLib.Address   = crosswalk.BranchAddress;
                            mdLib.Telephone = crosswalk.BranchTelephone;
                            mdLib.Url       = crosswalk.BranchLink;
                        }
                    }

                    if (string.IsNullOrEmpty(mdLib.Name))
                    {
                        this.MetaDescription = string.Format("Details about the event: {0} - {1}",
                                                             mdLib.Name,
                                                             GetResourceString("system-name"));
                    }
                    else
                    {
                        this.MetaDescription = string.Format("Details about the event: {0} at {1} - {2}",
                                                             eventTitle.Text,
                                                             eventWhere.Text,
                                                             GetResourceString("system-name"));
                    }

                    if (!string.IsNullOrWhiteSpace(evnt.ExternalLinkToEvent))
                    {
                        eventLinkPanel.Visible   = true;
                        ExternalLink.NavigateUrl = evnt.ExternalLinkToEvent;
                        ExternalLink.Text        = string.Format(eventTitle.Text);
                    }
                    else
                    {
                        eventLinkPanel.Visible = false;
                    }
                    eventDescription.Text = Server.HtmlDecode(evnt.HTML);
                    var cf = DAL.CustomEventFields.FetchObject();
                    if (!string.IsNullOrWhiteSpace(evnt.Custom1) &&
                        !string.IsNullOrWhiteSpace(cf.Label1))
                    {
                        eventCustom1Panel.Visible = true;
                        eventCustomLabel1.Text    = cf.Label1;
                        eventCustomValue1.Text    = evnt.Custom1;
                    }
                    else
                    {
                        eventCustom1Panel.Visible = false;
                    }
                    if (!string.IsNullOrWhiteSpace(evnt.Custom2) &&
                        !string.IsNullOrWhiteSpace(cf.Label2))
                    {
                        eventCustom2Panel.Visible = true;
                        eventCustomLabel2.Text    = cf.Label2;
                        eventCustomValue2.Text    = evnt.Custom2;
                    }
                    else
                    {
                        eventCustom2Panel.Visible = false;
                    }
                    if (!string.IsNullOrWhiteSpace(evnt.Custom3) &&
                        !string.IsNullOrWhiteSpace(cf.Label3))
                    {
                        eventCustom3Panel.Visible = true;
                        eventCustomLabel3.Text    = cf.Label3;
                        eventCustomValue3.Text    = evnt.Custom3;
                    }
                    else
                    {
                        eventCustom3Panel.Visible = false;
                    }
                    eventDetails.Visible = true;

                    mvEvt.Location = mdLib;
                    try
                    {
                        Microdata.Text = new WebTools().BuildEventJsonld(mvEvt);
                    }
                    catch (Exception ex)
                    {
                        this.Log().Error("Problem creating microdata in event detail for {0}: {1} - {2}",
                                         evnt.EID,
                                         ex.Message,
                                         ex.StackTrace);
                    }

                    // begin social
                    var wt = new WebTools();

                    var systemName    = StringResources.getStringOrNull("system-name");
                    var fbDescription = StringResources.getStringOrNull("facebook-description");
                    var hashtags      = StringResources.getStringOrNull("socialmedia-hashtags");

                    var title = string.Format("{0} event: {1}",
                                              systemName,
                                              evnt.EventTitle);
                    string description = string.Format("I'm thinking about attending this {0} event: {1}!",
                                                       systemName,
                                                       evnt.EventTitle);
                    string twitDescrip = string.Format("Check out this {0} event: {1}!",
                                                       systemName,
                                                       evnt.EventTitle);
                    if (twitDescrip.Length > 118)
                    {
                        // if it's longer than this it won't fit with the url, shorten it
                        twitDescrip = string.Format("Check this out: {0}!",
                                                    evnt.EventTitle);
                    }

                    var baseUrl         = WebTools.GetBaseUrl(Request);
                    var eventDetailsUrl = string.Format("{0}/Events/Details.aspx?EventId={1}",
                                                        baseUrl,
                                                        evnt.EID);
                    string bannerPath = new GRA.Logic.Banner().FullMetadataBannerPath(baseUrl,
                                                                                      Session,
                                                                                      Server);

                    wt.AddOgMetadata(Metadata,
                                     title,
                                     wt.BuildFacebookDescription(description, hashtags, fbDescription),
                                     bannerPath,
                                     eventDetailsUrl,
                                     facebookApp: GetResourceString("facebook-appid"));

                    wt.AddTwitterMetadata(Metadata,
                                          title,
                                          description,
                                          bannerPath,
                                          twitterUsername: GetResourceString("twitter-username"));

                    TwitterShare.NavigateUrl = wt.GetTwitterLink(twitDescrip,
                                                                 Server.UrlEncode(eventDetailsUrl),
                                                                 hashtags);
                    TwitterShare.Visible = true;
                    FacebookShare.NavigateUrl
                        = wt.GetFacebookLink(Server.UrlEncode(eventDetailsUrl));
                    FacebookShare.Visible = true;
                    //end social
                }
            }

            if (evnt == null)
            {
                eventDetails.Visible = false;
                var cph = Page.Master.FindControl("HeaderContent") as ContentPlaceHolder;
                if (cph != null)
                {
                    cph.Controls.Add(new HtmlMeta
                    {
                        Name    = "robots",
                        Content = "noindex"
                    });
                }
                Session[SessionKey.PatronMessage]          = "Could not find details on that event.";
                Session[SessionKey.PatronMessageLevel]     = PatronMessageLevels.Warning;
                Session[SessionKey.PatronMessageGlyphicon] = "exclamation-sign";
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (((BaseSRPPage)Page).IsLoggedIn)
            {
                Server.Transfer("~/Dashboard.aspx");
            }
            if (!String.IsNullOrEmpty(Request["PID"]))
            {
                Session["ProgramID"] = Request["PID"].ToString();
            }
            if (!IsPostBack)
            {
                if (Session["ProgramID"] == null)
                {
                    try
                    {
                        int PID = Programs.GetDefaultProgramID();
                        Session["ProgramID"] = PID.ToString();
                    }
                    catch
                    {
                        Response.Redirect("~/ControlRoom/Configure.aspx");
                    }
                    // pgmID.Text = Session["ProgramID"].ToString();
                }
                else
                {
                    //pgmID.Text = Session["ProgramID"].ToString();
                }

                var systemName  = GetResourceString("system-name");
                var description = GetResourceString("frontpage-description");
                var wt          = new WebTools();
                var baseUrl     = WebTools.GetBaseUrl(Request);
                var bannerPath  = new GRA.Logic.Banner().FullMetadataBannerPath(baseUrl,
                                                                                Session,
                                                                                Server);

                // open graph & facebook

                wt.AddOgMetadata(Metadata,
                                 systemName,
                                 description,
                                 bannerPath,
                                 baseUrl,
                                 facebookApp: GetResourceString("facebook-appid"));

                // dublin core
                Metadata.Controls.Add(new HtmlMeta {
                    Name = "DC.Title", Content = systemName
                });
                Metadata.Controls.Add(new HtmlMeta
                {
                    Name    = "DC.Description",
                    Content = description
                });
                Metadata.Controls.Add(new HtmlMeta {
                    Name = "DC.Source", Content = baseUrl
                });
                Metadata.Controls.Add(new HtmlMeta
                {
                    Name    = "DC.Type",
                    Content = "InteractiveResource"
                });

                //twitter
                wt.AddTwitterMetadata(Metadata,
                                      systemName,
                                      GetResourceString("twitter-description"),
                                      bannerPath,
                                      "summary_large_image",
                                      GetResourceString("twitter-username"));
            }
            TranslateStrings(this);
        }