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