public static db.user[] GetSubscribedUsers(EmailSubscriptionType subType)
{
var names = LibCommon.DBModel().userSettings
.Where(x => x.settingKey == EMAIL_SUB_SETTING_KEY_PREFIX + (int)subType && x.active_flag)
.Select(x => x.username)
.ToArray();
return(LibCommon.DBModel().users.Where(x => names.Contains(x.name) && x.email != null && x.IsActive).OrderBy(u => u.registration_dt).ToArray());
}
public abstract void SetSectionSubscriptionType(int SectionID, int UserID, EmailSubscriptionType subType);
private static int SendReminderEmails(HomeAppsLib.db.NFL_week weekAboutToExpire, EmailSubscriptionType emailSubscriptionType)
{
int count = 0;
foreach (var user in EmailSubscriptions.GetSubscribedUsers(emailSubscriptionType))
{
if (LibCommon.DBModel().NFL_userPicks.Count(x => x.week == weekAboutToExpire.week && x.username == user.name) == 0)
{
string to = LibCommon.IsDevelopmentEnvironment() ? "*****@*****.**" : user.email;
int daysLeft = (weekAboutToExpire.exp_dt.Date - DateTime.Now.Date).Days;
string subject = "Only " + daysLeft + " days left to make your picks!";
if (daysLeft == 1)
{
subject = subject.Replace("days", "day");
}
if (daysLeft == 0)
{
subject = "Picks expire today!";
}
//if (DateTime.Now < new DateTime(2016, 9, 10))
// subject = "FEATURING CORY QUICK PICKS!! " + subject;
string body = "Hi, " + user.name + "!<br><br>";
body += "Remember, picks for <b>" + weekAboutToExpire.text + "</b> will expire on " + weekAboutToExpire.exp_dt.ToLongDateTimeDisplay() + "!<br><br>";
body += "<span style='font-size:x-large;'>Be sure to make your picks before then!</span><br>";
body += "<br><a href='" + LibCommon.WebsiteUrlRoot() + "nflpicks.aspx?quickpicks=true&autoweek=" + weekAboutToExpire.week + "&sso=" + LibCommon.SSOUserKey(user) + "' style='font-size:xx-large;'>CLICK HERE FOR NEW CORY QUICK PICKS!</span><br><br>";
body += "<span style='font-size:large;'><a href='" + LibCommon.WebsiteUrlRoot() + "'>Click here to log in and make your picks now</a></span><br><br>";
body += "Thanks,<br>The Wright Picks";
body += "<br><br><br><span style='font-size:small;'>P.S. If you'd like to unsubscribe from this email, click <a href='" + EmailSubscriptions.LinkToUnsubscripe(user, (int)emailSubscriptionType) + "'>here.</a></span>";
LibCommon.SendEmail(to, subject, body, "The Wright Picks", waitAfter: TimeSpan.FromSeconds(15));
if (user.name.ToLower() == "cory")
{
HomeAppsLib.LibCommon.SendCoryText(weekAboutToExpire.week);
}
count++;
}
}
return(count);
}
