public Entities.EMailConfiguration GetEmailConfiguration(int applicationid)
{
using (MessagingEntities db = new MessagingEntities())
{
var emailConfiguration = db.EMailConfigurations.Where(a => a.ApplicationID == applicationid && a.IsDeleted == false).FirstOrDefault();
if (emailConfiguration != null)
{
var messagingemailConfiguration = new Entities.EMailConfiguration
{
Id = emailConfiguration.Id,
ApplicationID = emailConfiguration.ApplicationID,
MaxNumberOfRetry = emailConfiguration.MaxNumberOfRetry,
SMTPClientHostName = emailConfiguration.SMTPClientHostName,
SMTPClientPassword = emailConfiguration.SMTPClientPassword,
SmtpClientPortNumber = emailConfiguration.SmtpClientPortNumber,
SMTPClientUserName = emailConfiguration.SMTPClientUserName,
IsDeleted = emailConfiguration.IsDeleted,
IsSSLEnabled = emailConfiguration.IsSSLEnabled
};
return(messagingemailConfiguration);
}
}
return(null);
}
public Entities.SMSQueueItem GetSMSFromQueue(int queueid)
{
using (MessagingEntities db = new MessagingEntities())
{
var smsqueue = db.SMSQueues.Where(a => a.Id == queueid).FirstOrDefault();
if (smsqueue != null)
{
var messagingsmslqueue = new Entities.SMSQueueItem
{
Id = smsqueue.Id,
ApplicationID = smsqueue.ApplicationID,
CreatedDate = smsqueue.CreatedDate,
SMSObject = smsqueue.SMSObject,
DeliveryDate = smsqueue.DeliveryDate,
DeliveryResponse = smsqueue.DeliveryResponse,
NumberOfAttempts = smsqueue.NumberOfAttempts,
StatusID = smsqueue.StatusID
};
return(messagingsmslqueue);
}
}
return(null);
}
public Entities.EMailQueueItem GetEmailFromQueue(int queueid)
{
using (MessagingEntities db = new MessagingEntities())
{
var emailqueue = db.EMailQueues.Where(a => a.Id == queueid).FirstOrDefault();
if (emailqueue != null)
{
var messagingemailqueue = new Entities.EMailQueueItem
{
Id = emailqueue.Id,
ApplicationID = emailqueue.ApplicationID,
CreatedDate = emailqueue.CreatedDate,
EmailObject = emailqueue.EmailObject,
DeliveryDate = emailqueue.DeliveryDate,
DeliveryResponse = emailqueue.DeliveryResponse,
NumberOfAttempts = emailqueue.NumberOfAttempts,
StatusID = emailqueue.StatusID
};
return(messagingemailqueue);
}
}
return(null);
}
public IEnumerable <Entities.SMSQueueItem> GetPendingSMSFromQueue()
{
using (MessagingEntities db = new MessagingEntities())
{
return(db.SMSQueues.Where(a => a.StatusID == (int)MessageDeliveryStatus.Scheduled).Select(e => new Entities.SMSQueueItem
{
Id = e.Id,
ApplicationID = e.ApplicationID,
CreatedDate = e.CreatedDate,
SMSObject = e.SMSObject,
DeliveryDate = e.DeliveryDate,
DeliveryResponse = e.DeliveryResponse,
NumberOfAttempts = e.NumberOfAttempts,
StatusID = e.StatusID
}).ToList());
}
}
public IEnumerable <Entities.EMailQueueItem> GetEmailFromQueueByApplicationID(int applicationid)
{
using (MessagingEntities db = new MessagingEntities())
{
return(db.EMailQueues.Where(a => a.Id == applicationid).Select(e => new Entities.EMailQueueItem
{
Id = e.Id,
ApplicationID = e.ApplicationID,
CreatedDate = e.CreatedDate,
EmailObject = e.EmailObject,
DeliveryDate = e.DeliveryDate,
DeliveryResponse = e.DeliveryResponse,
NumberOfAttempts = e.NumberOfAttempts,
StatusID = e.StatusID
}).ToList());
}
}
public void AddSMSToQueue(Entities.SMSQueueItem queue)
{
using (MessagingEntities db = new MessagingEntities())
{
SMSQueue smsqueue = new SMSQueue
{
ApplicationID = queue.ApplicationID,
StatusID = queue.StatusID,
SMSObject = queue.SMSObject,
CreatedDate = queue.CreatedDate,
DeliveryDate = queue.DeliveryDate,
NumberOfAttempts = queue.NumberOfAttempts,
DeliveryResponse = queue.DeliveryResponse
};
db.SMSQueues.Add(smsqueue);
db.SaveChanges();
}
}
public void AddEmailToQueue(Entities.EMailQueueItem queue)
{
using (MessagingEntities db = new MessagingEntities())
{
EMailQueue mailqueue = new EMailQueue
{
ApplicationID = queue.ApplicationID,
StatusID = queue.StatusID,
EmailObject = queue.EmailObject,
CreatedDate = queue.CreatedDate,
DeliveryDate = queue.DeliveryDate,
NumberOfAttempts = queue.NumberOfAttempts,
DeliveryResponse = queue.DeliveryResponse
};
db.EMailQueues.Add(mailqueue);
db.SaveChanges();
}
}
public Entities.QueueType GetQueueType(int id)
{
using (MessagingEntities db = new MessagingEntities())
{
var queuetype = db.QueueTypes.Where(a => a.Id == id).FirstOrDefault();
if (queuetype != null)
{
var messagingqueuetype = new Entities.QueueType
{
Id = queuetype.Id,
QueueTypeName = queuetype.QueueTypeName
};
return(messagingqueuetype);
}
}
return(null);
}
public Entities.Application GetApplication(string applicationname)
{
using (MessagingEntities db = new MessagingEntities())
{
var application = db.Applications.Where(a => a.Name == applicationname).FirstOrDefault();
if (application != null)
{
var messagingApplication = new Entities.Application
{
Id = application.Id,
Name = application.Name,
QueueTypeID = application.QueueTypeId
};
return(messagingApplication);
}
}
return(null);
}
public Entities.SMSConfiguration GetSMSConfiguration(int applicationid)
{
using (MessagingEntities db = new MessagingEntities())
{
var smsConfiguration = db.SMSConfigurations.Where(a => a.ApplicationID == applicationid).FirstOrDefault();
if (smsConfiguration != null)
{
var messagingsmsConfiguration = new Entities.SMSConfiguration
{
Id = smsConfiguration.Id,
ApplicationID = smsConfiguration.ApplicationID,
MaxNumberOfRetry = smsConfiguration.MaxNumberOfRetry,
AccountSid = smsConfiguration.AccountSid,
AuthToken = smsConfiguration.AuthToken
};
return(messagingsmsConfiguration);
}
}
return(null);
}
public DataOperationStatus UpdateSMSToQueue(Entities.SMSQueueItem queue)
{
using (MessagingEntities db = new MessagingEntities())
{
var smsqueue = db.SMSQueues.Where(q => q.Id == queue.Id).FirstOrDefault();
if (smsqueue != null)
{
smsqueue.ApplicationID = queue.ApplicationID;
smsqueue.StatusID = queue.StatusID;
smsqueue.SMSObject = queue.SMSObject;
smsqueue.CreatedDate = queue.CreatedDate;
smsqueue.DeliveryDate = queue.DeliveryDate;
smsqueue.NumberOfAttempts = queue.NumberOfAttempts;
smsqueue.DeliveryResponse = queue.DeliveryResponse;
db.SaveChanges();
return(DataOperationStatus.SavedSuccessfully);
}
else
{
return(DataOperationStatus.RecordNotExist);
}
}
}
