public static bool ManageSubscription(Subscriber entity)
{
DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString, "dbo.mon_elrn_INSERT_SUBSCRIBERINFO");
cmd.AddInputParam("@Email", DbType.AnsiString, entity.Email);
cmd.AddInputParam("@FirstName", DbType.AnsiString, entity.FirstName);
cmd.AddInputParam("@LastName", DbType.AnsiString, entity.LastName);
cmd.AddInputParam("@CreatedDate", DbType.DateTime, System.DateTime.Now);
cmd.AddInputParam("@OptOutDate", DbType.DateTime, GetOptOutDate(entity.SubscribedStatus));
cmd.AddInputParam("@TotalEmailsSent", DbType.Int64, entity.TotalEmailsSent);
cmd.AddInputParam("@ApplicationName", DbType.String, System.Web.Security.Membership.Provider.ApplicationName);
if (Convert.ToInt32(SqlHelpers.ExecuteScalar(cmd)) <= 0)
return false;
return true;
}
/// <summary>
/// Replaces the input text's personalization placeholders
/// </summary>
private static string ReplacePersonalizationPlaceholders(string text, Subscriber subscriber, bool isHtml)
{
if (isHtml)
{
text = Regex.Replace(text, @"<%\s*email\s*%>",
subscriber.Email, RegexOptions.IgnoreCase | RegexOptions.Compiled);
text = Regex.Replace(text, @"<%\s*firstname\s*%>",
(subscriber.FirstName.Length > 0 ? subscriber.FirstName : "reader"),
RegexOptions.IgnoreCase | RegexOptions.Compiled);
text = Regex.Replace(text, @"<%\s*lastname\s*%>",
subscriber.LastName, RegexOptions.IgnoreCase | RegexOptions.Compiled);
}
else
{
text = Regex.Replace(text, @"<%\s*email\s*%>",
subscriber.Email, RegexOptions.IgnoreCase | RegexOptions.Compiled);
text = Regex.Replace(text, @"<%\s*firstname\s*%>",
(subscriber.FirstName.Length > 0 ? subscriber.FirstName : "reader"),
RegexOptions.IgnoreCase | RegexOptions.Compiled);
text = Regex.Replace(text, @"<%\s*lastname\s*%>",
subscriber.LastName, RegexOptions.IgnoreCase | RegexOptions.Compiled);
}
return text;
}
public static bool ResetSubscription(Subscriber entity)
{
DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString, "dbo.mon_elrn_UPDATE_RESETSUBSCRIPTION");
cmd.AddInputParam("@Email", DbType.AnsiString, entity.Email);
cmd.AddInputParam("@OptOutDate", DbType.DateTime, GetOptOutDate(entity.SubscribedStatus));
return Convert.ToBoolean(SqlHelpers.ExecuteNonQuery(cmd));
}
