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(); }