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