public async Task <List <EmailListResponseModel> > GetFilteredEmailLists(string emailListName, string param)
{
return(await Task.Run(() =>
{
List <EmailListResponseModel> result = new List <EmailListResponseModel>();
string resultQuery = "SELECT * FROM EmailLists";
if (!string.IsNullOrEmpty(emailListName))
{
resultQuery += $" WHERE EmailListName LIKE '%{emailListName}%'";
}
if (param != null && param.Length != 0)
{
resultQuery += " ORDER BY ";
resultQuery += $"{param.Replace('_', ' ')},";
resultQuery = resultQuery.TrimEnd(',');
}
List <EmailList> EmailLists;
try
{
EmailLists = db.Database.SqlQuery <EmailList>(resultQuery).ToList();
}
catch
{
return null;
}
return EmailLists.Select(emailList => factory.CreateEmailResponseModel(emailList)).ToList();
}));
}
private void IntializeEmailLists()
{
if (!Page.IsPostBack)
{
if (!AbleContext.Current.User.IsAnonymous || CreateNewAccountPanel.Visible)
{
EmailLists.DataSource = GetPublicEmailLists();
EmailLists.DataBind();
}
else
{
EmailLists.Visible = false;
}
}
}
private void IntializeEmailLists()
{
IList <EmailList> lists = GetPublicEmailLists();
if ((lists.Count > 0) && (!AbleContext.Current.User.IsAnonymous || AbleContext.Current.User.PrimaryAddress.IsValid))
{
EmailLists.DataSource = lists;
EmailLists.DataBind();
EmailListsPanel.Visible = true;
}
else
{
EmailListsPanel.Visible = false;
}
}
public EmailListsBL CreateEmailList(EmailListsBL emailListModel)
{
var emailList = new EmailLists
{
EmailListName = emailListModel.MailListName
};
UnitOfWork.EmailListRepository.Add(emailList);
UnitOfWork.SaveChanges();
return(new EmailListsBL
{
Id = emailList.Id,
MailListName = emailList.EmailListName
});
}
public ConfigurationEmail(Boolean active_, Alert_Mail.Classes.Configuration.Connexion connexion_, EmailLists emailLists_, EmailError emailError_, EmailSummary emailSummary_, EmailPendingFiles emailPendingFiles_)
{
this.active = active_;
this.connexion = connexion_;
this.emailLists = emailLists_;
this.emailError = emailError_;
this.emailSummary = emailSummary_;
this.emailPendingFiles = emailPendingFiles_;
}
