private void AddTemplateBindings(IEnumerable <int> newsletterIds)
{
foreach (var newsletterId in newsletterIds)
{
EmailTemplateNewsletterInfoProvider.AddNewsletterToTemplate(emailTemplateInfo.TemplateID, newsletterId);
}
}
private void RemoveTemplateBindings(IEnumerable <int> newsletterIds)
{
foreach (var newsletterId in newsletterIds)
{
EmailTemplateNewsletterInfoProvider.RemoveNewsletterFromTemplate(emailTemplateInfo.TemplateID, newsletterId);
}
}
private static bool IsSafeToRemove(int newsletterId)
{
var assignedTemplatesCount = EmailTemplateNewsletterInfoProvider.GetEmailTemplateNewsletters()
.WhereEquals("NewsletterID", newsletterId)
.GetCount();
return(assignedTemplatesCount > 1);
}
private static WhereCondition GetAssignedTemplatesWhere()
{
var newsletterId = QueryHelper.GetInteger("parentobjectid", 0);
var newsletterTemplates = EmailTemplateNewsletterInfoProvider.GetEmailTemplateNewsletters()
.Columns("TemplateID")
.WhereEquals("NewsletterID", newsletterId);
return(new WhereCondition().WhereIn("TemplateID", newsletterTemplates));
}
/// <summary>
/// Loads current newsletters from DB.
/// </summary>
private void GetCurrentNewsletters()
{
var templateNewsletters = EmailTemplateNewsletterInfoProvider
.GetEmailTemplateNewsletters()
.WhereEquals("TemplateID", emailTemplateInfo.TemplateID)
.Column("NewsletterID")
.GetListResult <int>();
currentValues = TextHelper.Join(";", templateNewsletters);
}
/// <summary>
/// Loads current templates from DB.
/// </summary>
private void GetCurrentTemplates()
{
var templateNewsletters = EmailTemplateNewsletterInfoProvider
.GetEmailTemplateNewsletters()
.WhereEquals("NewsletterID", EditedNewsletter.NewsletterID)
.Column("TemplateID")
.Select(template => template.TemplateID);
mCurrentTemplates = TextHelper.Join(";", templateNewsletters);
}
/// <summary>
/// Add templates to newsletter.
/// </summary>
private void AddNewRecords(string newValues, string currentRecords)
{
string items = DataHelper.GetNewItemsInList(currentRecords, newValues);
if (!String.IsNullOrEmpty(items))
{
var modifiedItems = items.Split(new[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string item in modifiedItems)
{
EmailTemplateNewsletterInfoProvider.AddNewsletterToTemplate(ValidationHelper.GetInteger(item, 0), mNewsletter.NewsletterID);
}
}
}
/// <summary>
/// Remove newsletters from template.
/// </summary>
private void RemoveOldRecords(string newValues, string currentNewsletters)
{
string items = DataHelper.GetNewItemsInList(newValues, currentNewsletters);
if (!String.IsNullOrEmpty(items))
{
var modifiedItems = items.Split(new[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string item in modifiedItems)
{
EmailTemplateNewsletterInfoProvider.RemoveNewsletterFromTemplate(emailTemplateInfo.TemplateID, ValidationHelper.GetInteger(item, 0));
}
}
}
/// <summary>
/// Loads current templates from DB.
/// </summary>
private void GetCurrentNewsletters()
{
string where = string.Format("NewsletterID = {0}", newsletterInfo.NewsletterID);
templateNewsletters = EmailTemplateNewsletterInfoProvider.GetEmailTemplatesNewsletters(where, "TemplateID");
if (!DataHelper.DataSourceIsEmpty(templateNewsletters))
{
currentValues = TextHelper.Join(";", SystemDataHelper.GetStringValues(templateNewsletters.Tables[0], "TemplateID"));
}
else
{
currentValues = String.Empty;
}
}
private void AddTemplatesToNewsletter(string templateIDsString)
{
if (String.IsNullOrEmpty(templateIDsString))
{
return;
}
var templateIDs = templateIDsString.Split(new[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var templateID in templateIDs)
{
EmailTemplateNewsletterInfoProvider.AddNewsletterToTemplate(ValidationHelper.GetInteger(templateID, 0), TypedEditedObject.NewsletterID);
}
}
/// <summary>
/// Loads current templates from DB.
/// </summary>
private void GetCurrentNewsletters()
{
mTemplateNewsletters = EmailTemplateNewsletterInfoProvider
.GetEmailTemplateNewsletters()
.WhereEquals("NewsletterID", mNewsletter.NewsletterID)
.Column("TemplateID");
if (!DataHelper.DataSourceIsEmpty(mTemplateNewsletters))
{
mCurrentValues = TextHelper.Join(";", DataHelper.GetStringValues(mTemplateNewsletters.Tables[0], "TemplateID"));
}
else
{
mCurrentValues = String.Empty;
}
}
/// <summary>
/// Remove templates from newsletter.
/// </summary>
private void RemoveOldTemplates(string newValues, string currentRecords)
{
var items = DataHelper.GetNewItemsInList(newValues, currentRecords);
if (String.IsNullOrEmpty(items))
{
return;
}
var modifiedItems = items.Split(new[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var item in modifiedItems)
{
EmailTemplateNewsletterInfoProvider.RemoveNewsletterFromTemplate(ValidationHelper.GetInteger(item, 0), EditedNewsletter.NewsletterID);
}
}
private WhereCondition GetAssignedTemplatesWhere(IssueInfo issue)
{
var templatesCondition = EmailTemplateNewsletterInfoProvider.GetEmailTemplateNewsletters()
.Column("TemplateID")
.WhereEquals("NewsletterID", NewsletterID);
var assignedTemplatesWhere = new WhereCondition().WhereIn("TemplateID", templatesCondition);
//Add template assigned to issue
if (issue != null)
{
assignedTemplatesWhere = AddIssueAssignedTemplate(assignedTemplatesWhere, issue.IssueID);
}
return(assignedTemplatesWhere);
}
