/// <inheritdoc />
public int AddSubscriber(string authKey, DataTransferObject.SubscriberDto s)
{
if (!IsAuthenticatedKey(authKey)) {
return 0;
}
using (var context = new NewsletterEntities()) {
var subscriber = new Subscriber();
var sessions = new SessionManager(context);
subscriber.name = s.Name;
subscriber.contact = s.Contact;
subscriber.newsletter = sessions.GetSession(authKey).NewsletterId;
context.Subscribers.AddObject(subscriber);
context.SaveChanges();
return subscriber.id;
}
}
/// <inheritdoc />
public void DeleteSubscriber(string authKey, int id)
{
if (!IsAuthenticatedKey(authKey)) {
return;
}
// Create a message entity and store it
using (var context = new NewsletterEntities()) {
var sessions = new SessionManager(context);
var newsletterId = sessions.GetSession(authKey).NewsletterId;
var subscriberQuery = from s in context.Subscribers
where s.newsletter == newsletterId && s.id == id
select s;
foreach (var row in subscriberQuery) {
context.Subscribers.DeleteObject(row);
}
// Persist changes
context.SaveChanges();
}
}
/// <inheritdoc />
public void UpdateSubscriber(string authKey, DataTransferObject.SubscriberDto sub)
{
if (!IsAuthenticatedKey(authKey)) {
return;
}
using (var context = new NewsletterEntities()) {
var sessions = new SessionManager(context);
var newsletterId = sessions.GetSession(authKey).NewsletterId;
var subscriberQuery = from s in context.Subscribers
where s.newsletter == newsletterId && s.id == sub.Id
select s;
foreach (var row in subscriberQuery) {
row.name = sub.Name;
row.contact = sub.Contact;
}
context.SaveChanges();
}
}
/// <inheritdoc />
public bool QueueMessage(string subject, string body, string clean_body, string authKey)
{
if (!IsAuthenticatedKey(authKey)) {
return false;
}
// Create a message entity and store it
using (var context = new NewsletterEntities()) {
var sessions = new SessionManager(context);
var message = new Message();
message.status = 3; // TODO DeliveryServer.TransferAgent.Message.StatusWaiting;
message.text = body;
message.clean_text = clean_body;
message.subject = subject;
message.newsletter = sessions.GetSession(authKey).NewsletterId;
message.date = DateTime.Now;
context.Messages.AddObject(message);
// Persist changes
context.SaveChanges();
}
return true;
}
