public BaseCollection <NewsletterSubscriber> GetNewsletterRecipients(Guid newsletterId, string[] NewsletterGroups, bool sendToNewSubscribers)
{
int AvailableMailings = -1;
if (SessionObject.CurrentLicense.MaxNumberOfNewsletterMailings != null)
{
AvailableMailings = (int)SessionObject.CurrentLicense.MaxNumberOfNewsletterMailings - BaseCollection <NewsletterMailing> .Get("FK_Site = '" + SessionObject.CurrentSite.ID.ToString() + "'").Count();
}
string groupIDs = "";
foreach (string groupID in NewsletterGroups)
{
groupIDs += "'" + groupID + "', ";
}
groupIDs = groupIDs.Substring(0, groupIDs.Length - 2);
string where = " EXISTS (SELECT * FROM NewsletterGroupSubscriber WHERE `UnsubscribeDate` IS NULL AND FK_NewsletterSubscriber = NewsletterSubscriber.ID AND FK_NewsletterGroup IN (" + groupIDs + ") AND Confirmed = 1)";
if (sendToNewSubscribers)
{
where = " EXISTS (SELECT * FROM NewsletterGroupSubscriber WHERE `UnsubscribeDate` IS NULL AND FK_NewsletterSubscriber = NewsletterSubscriber.ID AND FK_NewsletterGroup IN (" + groupIDs + ") AND Confirmed = 1 AND NOT EXISTS(SELECT * FROM newslettermailing WHERE FK_Newsletter = '" + newsletterId.ToString() + "' AND FK_NewsletterSubscriber = NewsletterSubscriber.ID))";
}
BaseCollection <NewsletterSubscriber> subscribers = BaseCollection <NewsletterSubscriber> .Get(where);
if (AvailableMailings != -1 && subscribers.Count() > AvailableMailings)
{
throw new Exception("Om de nieuwsbrief naar deze maillijst te versturen zijn: " + subscribers.Count().ToString() + " mailingen vereist. \r\n U heeft nog: " + AvailableMailings.ToString() + " mailingen beschikbaar.");
}
return(subscribers);
}
public void RemoveAt()
{
BaseCollection <int> collection = new BaseCollection <int>(new [] { 1, 2, 3 });
collection.RemoveAt(2);
collection.RemoveAt(1);
Assert.AreEqual(1, collection.Count());
Assert.AreEqual(1, collection[0]);
}
public void ProcessParametrizedConstructor()
{
BaseCollection <int> collection = new BaseCollection <int>(new [] { 1, 2, 3 });
Assert.AreEqual(3, collection.Count());
Assert.AreEqual(1, collection[0]);
Assert.AreEqual(2, collection[1]);
Assert.AreEqual(3, collection[2]);
}
public void Set()
{
BaseCollection <int> collection = new BaseCollection <int>( );
collection.Set(new [] { 1, 2, 3 });
Assert.AreEqual(3, collection.Count());
Assert.AreEqual(1, collection[0]);
Assert.AreEqual(2, collection[1]);
Assert.AreEqual(3, collection[2]);
}
public void BeEmptyOnDefaultCreation()
{
BaseCollection <int> collection = new BaseCollection <int>();
Assert.AreEqual(0, collection.Count());
}
public bool Exists(string id)
{
var mongoQuery = Query <T> .EQ(u => u.Id, id);
return(BaseCollection.Count(mongoQuery) > 0);
}
