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