internal static void UnsubscribeNewsletterItem(Newsletter_Send_Item newsletterSendItem) { try { using (Vicdude_NewsletterEntities db = new Vicdude_NewsletterEntities()) { var item = db.Newsletter_Send_Item.FirstOrDefault(n => n.NewsletterSendItemGUID == newsletterSendItem.NewsletterSendItemGUID); if (item != null) { item.HasUnsubscribed = true; db.SaveChanges(); } } } catch (Exception ex) { LogHelper.LogError(string.Format("Error updating newsletter send item to unsubscribed..."), ex, 0); } }
internal static void CreateNewsletterSendItems(int newsletterSendId, List <int> userIds, List <int> contactIds = null, int formFieldId = -1) { using (Vicdude_NewsletterEntities db = new Vicdude_NewsletterEntities()) { foreach (int userId in userIds) { Newsletter_Send_Item item = new Newsletter_Send_Item() { IsRead = false, IsSent = false, Email = SW.Core.BLL.AccountBLL.GetUserEmail(userId), NewsletterSendId = newsletterSendId, NewsletterSendItemGUID = Guid.NewGuid().ToString(), SendDate = DateTime.Now, SendToUserId = userId, ReadDate = DateTime.Now.AddYears(-10), HasUnsubscribed = false, SendType = "USER" }; db.Newsletter_Send_Item.Add(item); } if (contactIds != null && contactIds.Count > 0) { foreach (int contactId in contactIds) { Newsletter_Send_Item item = new Newsletter_Send_Item() { IsRead = false, IsSent = false, Email = SW.Core.BLL.ContactBLL.GetContact(contactId).Email, NewsletterSendId = newsletterSendId, NewsletterSendItemGUID = Guid.NewGuid().ToString(), SendDate = DateTime.Now, SendToContactId = contactId, ReadDate = DateTime.Now.AddYears(-10), HasUnsubscribed = false, SendType = "CONTACT" }; db.Newsletter_Send_Item.Add(item); } } if (formFieldId > 0) { List <string> emails = FormsAdminBLL.GetExternalSubmitValues(formFieldId); foreach (var email in emails) { Newsletter_Send_Item item = new Newsletter_Send_Item() { IsRead = false, IsSent = false, Email = email, NewsletterSendId = newsletterSendId, NewsletterSendItemGUID = Guid.NewGuid().ToString(), SendDate = DateTime.Now, ReadDate = DateTime.Now.AddYears(-10), HasUnsubscribed = false, SendType = "FORM" }; db.Newsletter_Send_Item.Add(item); } } db.SaveChanges(); } }