private List <LetterSubscriber> LoadFromReader(IDataReader reader)
{
List <LetterSubscriber> letterSubscriberList
= new List <LetterSubscriber>();
try
{
while (reader.Read())
{
LetterSubscriber letterSubscriber = new LetterSubscriber();
letterSubscriber.SubscribeGuid = new Guid(reader["Guid"].ToString());
letterSubscriber.SiteGuid = new Guid(reader["SiteGuid"].ToString());
letterSubscriber.LetterInfoGuid = new Guid(reader["LetterInfoGuid"].ToString());
letterSubscriber.VerifyGuid = new Guid(reader["VerifyGuid"].ToString());
letterSubscriber.UserGuid = new Guid(reader["UserGuid"].ToString());
letterSubscriber.UseHtml = Convert.ToBoolean(reader["UseHtml"]);
letterSubscriber.BeginUtc = Convert.ToDateTime(reader["BeginUtc"]);
letterSubscriber.EmailAddress = reader["Email"].ToString();
letterSubscriber.Name = reader["Name"].ToString();
letterSubscriber.IsVerified = Convert.ToBoolean(reader["IsVerified"]);
letterSubscriber.IpAddress = reader["IpAddress"].ToString();
letterSubscriberList.Add(letterSubscriber);
}
}
finally
{
reader.Close();
}
return(letterSubscriberList);
}
public bool Delete(LetterSubscriber subscription, bool createHistory)
{
if (subscription == null)
{
return(false);
}
if (createHistory)
{
DBLetterSubscription.CreateHistory(
Guid.NewGuid(),
subscription.SiteGuid,
subscription.SubscribeGuid,
subscription.LetterInfoGuid,
subscription.UserGuid,
subscription.EmailAddress,
subscription.IsVerified,
subscription.UseHtml,
subscription.BeginUtc,
DateTime.UtcNow,
subscription.IpAddress);
}
return(DBLetterSubscription.Delete(subscription.SubscribeGuid));
}
public void Save(LetterSubscriber subsciption)
{
if (subsciption == null)
{
return;
}
if (subsciption.SubscribeGuid == Guid.Empty)
{
subsciption.SubscribeGuid = Guid.NewGuid();
DBLetterSubscription.Create(
subsciption.SubscribeGuid,
subsciption.SiteGuid,
subsciption.LetterInfoGuid,
subsciption.UserGuid,
subsciption.EmailAddress.ToLower(),
subsciption.IsVerified,
subsciption.VerifyGuid,
DateTime.UtcNow,
subsciption.UseHtml,
subsciption.IpAddress);
}
else
{
DBLetterSubscription.Update(
subsciption.SubscribeGuid,
subsciption.UserGuid,
subsciption.UseHtml);
}
}
public LetterSubscriber Fetch(Guid siteGuid, Guid letterInfoGuid, string email)
{
using (IDataReader reader = DBLetterSubscription.GetByEmail(siteGuid, letterInfoGuid, email.ToLower()))
{
if (reader.Read())
{
LetterSubscriber letterSubscriber = new LetterSubscriber();
letterSubscriber.SubscribeGuid = new Guid(reader["Guid"].ToString());
letterSubscriber.SiteGuid = new Guid(reader["SiteGuid"].ToString());
letterSubscriber.LetterInfoGuid = new Guid(reader["LetterInfoGuid"].ToString());
letterSubscriber.VerifyGuid = new Guid(reader["VerifyGuid"].ToString());
letterSubscriber.UserGuid = new Guid(reader["UserGuid"].ToString());
letterSubscriber.UseHtml = Convert.ToBoolean(reader["UseHtml"]);
letterSubscriber.BeginUtc = Convert.ToDateTime(reader["BeginUtc"]);
letterSubscriber.EmailAddress = reader["Email"].ToString();
letterSubscriber.Name = reader["Name"].ToString();
letterSubscriber.IsVerified = Convert.ToBoolean(reader["IsVerified"]);
letterSubscriber.IpAddress = reader["IpAddress"].ToString();
return(letterSubscriber);
}
}
return(null);
}
public bool Delete(LetterSubscriber subscription)
{
return(Delete(subscription, true));
}