/// <summary> /// Adds to queue site action. /// </summary> /// <param name="massMailId">The mass mail id.</param> public void AddToQueueSiteAction(Guid massMailId) { var massMail = _dataContext.tbl_MassMail.SingleOrDefault(a => a.ID == massMailId); List <Guid> contactIds; if (massMail != null) { var dc = new WebCounterEntities(); var siteActionTemplate = dc.tbl_SiteActionTemplate.SingleOrDefault(a => a.ID == massMail.SiteActionTemplateID); massMail.MassMailStatusID = (int)MassMailStatus.Done; if (massMail.SiteTagID.HasValue) { contactIds = _dataContext.tbl_SiteTagObjects.Where(a => a.SiteTagID == massMail.SiteTagID).Select(a => a.ObjectID).ToList(); Save(massMail.SiteID, contactIds, massMailId); } else { contactIds = _dataContext.tbl_MassMailContact.Where(a => a.MassMailID == massMailId).Select(a => a.ContactID).ToList(); } foreach (var contactId in contactIds) { var siteActionId = Guid.NewGuid(); var siteAction = new tbl_SiteAction { ID = siteActionId, SiteID = massMail.SiteID, SiteActionTemplateID = massMail.SiteActionTemplateID, ContactID = contactId, ObjectID = massMail.ID, MessageTypeID = (int)MessageType.MassMail, ActionStatusID = (int)ActionStatus.Scheduled, ActionDate = (DateTime)massMail.MailDate, OwnerID = massMail.OwnerID, MessageTitle = siteActionTemplate.MessageCaption, MessageText = siteActionTemplate.MessageBody }; _dataContext.tbl_SiteAction.AddObject(siteAction); var updateMassMailContact = _dataContext.tbl_MassMailContact.SingleOrDefault(a => a.MassMailID == massMailId && a.ContactID == contactId); updateMassMailContact.SiteActionID = siteActionId; } } _dataContext.SaveChanges(); }
/// <summary> /// Initializes a new instance of the <see cref="TaskHistoryRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public TaskHistoryRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="ModuleEditionRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public ModuleEditionRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="BrandRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public PortalSettingsRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="ProductComplectationRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public ProductComplectationRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="ImportColumnRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public ImportColumnRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="EmailStatsRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public EmailStatsRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="WorkflowRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public WorkflowRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="ContactRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public ContactJobLevelRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="ContactRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public DistrictRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="BrandRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public BrandRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="SiteActionAttachmentRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public OrderTypeRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="SiteActionAttachmentRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public EmailToAnalysisRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="LinksRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public LinksRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="ContactRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public ContactCommunicationRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="SiteTagObjectsRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public SiteTagObjectsRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="PriceListStatusRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public PriceListStatusRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="RequestSourceTypeRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public RequestSourceTypeRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="WorkflowTemplateConditionEventRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public WorkflowTemplateConditionEventRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="MenuRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public MenuRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="SiteEventActionTemplateRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public SiteEventActionTemplateRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="WebSiteRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public WebSiteRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="RequirementTransitionRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public RequirementTransitionRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="SiteActionTagValueRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public SiteActionTagValueRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="PublicationRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public PublicationRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="RequirementStatusRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public RequirementStatusRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="ActionTypesRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public ActionTypesRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="StartAfterTypesRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public StartAfterTypesRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="ContactActivityRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public ContactActivityRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }
/// <summary> /// Initializes a new instance of the <see cref="RequirementStatusRepository"/> class. /// </summary> /// <param name="dataContext">The data context.</param> public PaymentPassCategoryRepository(WebCounterEntities dataContext) { _dataContext = dataContext; }