public SendSettingsEntity GetSendSettings()
{
using (var context = new CorpSMSEntities())
{
context.CommandTimeout = 0;
var setting = context.SendSettings.Select(p => p).FirstOrDefault();
var entity = new SendSettingsEntity()
{
IsLive = setting.IsLive,
ReturnMessageSuccessCount = setting.ReturnMessageSuccessCount,
ReturnMessageFailedCount = setting.ReturnMessageFailedCount,
ReturnCredits = setting.ReturnCredits,
ReturnEntriesSuccessStatus = setting.ReturnEntriesSuccessStatus,
ReturnEntriesFailedStatus = setting.ReturnEntriesFailedStatus,
DefaultText1 = setting.DefaultText1,
DefaultText2 = setting.DefaultText2,
DefaultDate = DateTime.Now.ToString(setting.DefaultDateFormat),
DefaultTime = DateTime.Now.ToString(setting.DefaultTimeFormat),
DefaultSender = setting.DefaultSender,
Flash = setting.Flash,
Type = setting.Type,
CostCentre = setting.CostCentre
};
return entity;
}
}
public GeneralSettingsEntity GetSentSettings(int accountID)
{
using (var context = new CorpSMSEntities())
{
var setting = context.SentSettings.Where(p => p.AccountID == accountID && p.IsActive == true).FirstOrDefault();
var entity = new GeneralSettingsEntity()
{
LatestId = setting.LatestID,
RecordCount = setting.RecordCount,
ReturnColumns = setting.ReturnColumns,
DateFormat = setting.DateFormat
};
return entity;
}
}
public ShortCodeSettingsEntity GetShortCodeSettings(int accountID)
{
using (var context = new CorpSMSEntities())
{
ShortCodeSettingsEntity entity = null;
var setting = context.ShortCodeSettings.Where(p => p.AccountID == accountID && p.IsActive == true).FirstOrDefault();
if (setting != null)
{
entity = new ShortCodeSettingsEntity()
{
LatestId = setting.LatestID,
DateFormat = setting.DateFormat
};
}
return entity;
}
}
public ICollection<MessageQueueEntity> GetQueuedMessages(Guid batchId)
{
using (var context = new CorpSMSEntities())
{
var query = context.MessageQueues.Where(p => p.BatchId == batchId);
List<MessageQueueEntity> messageList = new List<MessageQueueEntity>();
foreach (var message in query)
{
messageList.Add(MessageQueueToEntity(message));
}
return messageList;
}
}
public void SetCredit(CreditEntity entity)
{
try
{
using (var context = new CorpSMSEntities())
{
var credit = Credit.CreateCredit(
0,
entity.AccountId,
entity.Amount,
DateTime.Now);
context.AddToCredits(credit);
context.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public ICollection<MessageEntity> GetShortCodeMessages(DateTime startTime, DateTime endTime)
{
using (var context = new CorpSMSEntities())
{
List<MessageEntity> messages = new List<MessageEntity>();
context.GetShortCodeMessage("AsymmetricKey1", "GWEST2003%", startTime, endTime).ForAll(message =>
{
messages.Add(ConvertToMessageEntity(message));
});
return messages;
}
}
public ICollection<MessageEntity> GetDeliveryReportByOriginId(int originId, int uniqueId)
{
using (var context = new CorpSMSEntities())
{
List<MessageEntity> messages = new List<MessageEntity>();
var query = context.Messages.Include("MessageDetails")
.Where(p => p.OriginId == originId && p.UniqueId == uniqueId);
query.ForAll(message =>
{
messages.Add(ConvertToMessageEntity(message));
});
return messages;
}
}
public ICollection<MessageEntity> GetDeliveryReports()
{
using (var context = new CorpSMSEntities())
{
List<MessageEntity> messages = new List<MessageEntity>();
var query = context.Messages.Include("MessageDetails");
query.ForAll(message =>
{
messages.Add(ConvertToMessageEntity(message));
});
return messages;
}
}
/// <summary>
/// Remove the Message from the Queue if it has been send successfully or failed more than 5 times
/// </summary>
/// <param name="uniqueID"></param>
public void RemoveSentMessages(int uniqueID)
{
using (var context = new CorpSMSEntities())
{
context.spRemoveSentMessages(uniqueID);
}
}
public void InsertMessageDetail(ShortCodeDataEntity entity)
{
try
{
using (var context = new CorpSMSEntities())
{
context.SetShortCodeMessage(
entity.ShortCode,
TypeSafety.GetValue<string>(entity.Number),
TypeSafety.GetValue<string>(entity.Text),
entity.ChangeId,
TypeSafety.GetValue<DateTime>(entity.DateReceived),
entity.BatchId,
"AsymmetricKey1");
}
}
catch (Exception)
{
throw;
}
}
public MessageReplyEntity InsertMessageReply(MessageReplyEntity entity)
{
using (var context = new CorpSMSEntities())
{
var reply = context.MessageReplies.Where(p => p.MessageReplyId == entity.MessageReplyId).FirstOrDefault();
if (reply != null)
{
// Detach the entity first
context.Detach(reply);
reply = EntityToMessageReply(entity, reply);
// Attach the entity again.
context.Attach(reply);
context.ObjectStateManager.ChangeObjectState(reply, System.Data.EntityState.Modified);
}
else
{
reply = EntityToMessageReply(entity, new MessageReply());
context.AddToMessageReplies(reply);
}
context.SaveChanges();
return MessageReplyToEntity(reply);
}
}
public DeliveryReportEntity InsertDeliveryReport(DeliveryReportEntity entity)
{
using (var context = new CorpSMSEntities())
{
var report = context.DeliveryReports.Where(p => p.DeliveryReportId == entity.DeliveryReportId).FirstOrDefault();
if (report != null)
{
// Detach the entity first
context.Detach(report);
report = EntityToDeliveryReport(entity, report);
// Attach the entity again.
context.Attach(report);
context.ObjectStateManager.ChangeObjectState(report, System.Data.EntityState.Modified);
}
else
{
report = EntityToDeliveryReport(entity, new DeliveryReport());
context.AddToDeliveryReports(report);
}
context.SaveChanges();
return DeliveryReportToEntity(report);
}
}
public MessageEntity GetMessageByRowGuid(Guid guid)
{
using (var context = new CorpSMSEntities())
{
var message = context.Messages.Where(p => p.RowGuid == guid).FirstOrDefault();
MessageEntity entity = null;
if (message != null)
{
entity = MessageToEntity(message);
}
return entity;
}
}
public MessageEntity SetMessageForced(MessageEntity entity)
{
using (var context = new CorpSMSEntities())
{
var message = context.Messages.Where(p => p.RowGuid == entity.RowGuid).FirstOrDefault();
if (message != null)
{
// Detach the entity first
context.Detach(message);
message = EntityToMessage(entity, message);
// Attach the entity again.
context.Attach(message);
context.ObjectStateManager.ChangeObjectState(message, System.Data.EntityState.Modified);
}
else
{
message = EntityToMessage(entity, new Message());
context.AddToMessages(message);
}
context.SaveChanges();
return MessageToEntity(message);
}
}
public void UpdateShortCodeSettingsLatestID(long latestID, int accountID)
{
using (var context = new CorpSMSEntities())
{
var setting = context.ShortCodeSettings.Where(p => p.AccountID == accountID).FirstOrDefault();
if (setting != null)
{
// Detach the entity first
context.Detach(setting);
setting.LatestID = latestID;
// Attach the entity again.
context.Attach(setting);
context.ObjectStateManager.ChangeObjectState(setting, System.Data.EntityState.Modified);
context.SaveChanges();
}
}
}
public ICollection<MessageQueueEntity> GetTopQueuedMessages()
{
using (var context = new CorpSMSEntities())
{
var query = ( from item in context.MessageQueues orderby item.Accessed ascending select item).Take(1000);
List<MessageQueueEntity> messageList = new List<MessageQueueEntity>();
foreach (var message in query)
{
messageList.Add(MessageQueueToEntity(message));
message.Accessed = DateTime.Now;
}
context.SaveChanges();
return messageList;
}
}
public ICollection<AccountEntity> GetAccounts()
{
using (var context = new CorpSMSEntities())
{
var query = context.Accounts;
List<AccountEntity> accountList = new List<AccountEntity>();
foreach (var account in query)
{
accountList.Add(new AccountEntity()
{
AccountId = account.AccountID,
Description = account.Description,
CountryCodePrefix = account.CountryCodePrefix,
Username = account.Username,
Password = account.Password
});
}
return accountList;
}
}
public AccountEntity GetDefaultAccount()
{
using (var context = new CorpSMSEntities())
{
var query = context.Accounts.Where(p => p.IsDefault).FirstOrDefault();
AccountEntity entity = null;
if (query != null)
{
entity = new AccountEntity()
{
AccountId = query.AccountID,
CountryCodePrefix = query.CountryCodePrefix,
Description = query.Description,
Username = query.Username,
Password = query.Password
};
}
return entity;
}
}
/// <summary>
/// Remove the Message from the Queue in the Barred List
/// </summary>
public void RemoveBarredMessages()
{
using (var context = new CorpSMSEntities())
{
context.spRemoveBarredMessages();
}
}
/// <summary>
/// RAdd numbers in the Barred List
/// </summary>
public void AddStopReplies()
{
using (var context = new CorpSMSEntities())
{
context.spAddStopReplies();
}
}