protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["c"] != null && Request.QueryString["s"] != null)
{
var strContactId = Request.QueryString["c"];
var strSiteId = Request.QueryString["s"];
Guid contactId, siteId;
if (Guid.TryParse(strContactId, out contactId) && Guid.TryParse(strSiteId, out siteId))
{
var dm = new DataManager();
var contact = dm.Contact.SelectById(siteId, contactId);
if (contact != null)
{
contact.EmailStatusID = (int)EmailStatus.Banned;
dm.Contact.Update(contact);
var emailStats = dm.EmailStats.SelectByEmail(contact.Email);
if (emailStats != null)
{
if (emailStats.tbl_EmailStatsUnsubscribe.SingleOrDefault(o => o.SiteID == siteId) == null)
{
emailStats.tbl_EmailStatsUnsubscribe.Add(new tbl_EmailStatsUnsubscribe()
{
SiteID = siteId, CreatedAt = DateTime.Now
});
}
}
else
{
emailStats = new tbl_EmailStats {
Email = contact.Email
};
dm.EmailStats.Add(emailStats);
emailStats.tbl_EmailStatsUnsubscribe.Add(new tbl_EmailStatsUnsubscribe()
{
SiteID = siteId, CreatedAt = DateTime.Now
});
dm.EmailStats.Update(emailStats);
}
}
}
}
}
/// <summary>
/// Adds the specified email stats.
/// </summary>
/// <param name="emailStats">The email stats.</param>
public void Add(tbl_EmailStats emailStats)
{
emailStats.ID = Guid.NewGuid();
_dataContext.tbl_EmailStats.AddObject(emailStats);
_dataContext.SaveChanges();
}
/// <summary>
/// Updates the specified email stats.
/// </summary>
/// <param name="emailStats">The email stats.</param>
public void Update(tbl_EmailStats emailStats)
{
_dataContext.SaveChanges();
}
