public static DeliveryReport MessageEntityToDeliveryReport(MessageEntity entity)
{
if (entity == null) throw new ArgumentNullException("entity");
DeliveryReport report = new DeliveryReport()
{
//Number = entity.Number,
//Text = entity.Text,
//OriginID = entity.OriginId,
//UniqueID = entity.UniqueId
};
//if (entity.MessageDetail != null)
//{
// entity.MessageDetail.ForAll(detail =>
// {
// report.MessageStatus.Add(new MessageStatus()
// {
// Status = detail.StatusDescription,
// StatusDate = detail.StatusDate,
// Reason = detail.Reason
// });
// });
//}
return report;
}
public static MessageEntity MessageContractToMessageEntity(Message contract)
{
MessageEntity entity = new MessageEntity()
{
MessageId = contract.MessageId,
NumberTo = contract.Number,
Text = contract.Text,
OriginId = contract.OriginID,
UniqueId = contract.UniqueID,
DateCreated = contract.DateCreated
};
return entity;
}
public static Message MessageEntityToSendMessageContract(MessageEntity entity)
{
Message contract = new Message()
{
MessageId = entity.MessageId,
Number = entity.NumberTo,
Text = entity.Text,
EncryptedText = entity.EncryptedText,
OriginID = entity.OriginId,
UniqueID = entity.UniqueId,
DateCreated = entity.DateCreated
};
return contract;
}
public static void RefreshReplies()
{
using (var dataBinding = new MessageDataAccessor())
using (var service = new MyMobileAPIService.APISoapClient())
{
foreach (var account in dataBinding.GetAccounts())
{
bool recordsProcessed;
do
{
recordsProcessed = false;
ReplyServiceCallEntity data = new ReplyServiceCallEntity()
{
Settings = dataBinding.GetReplySettings(account.AccountId)
};
DataSet dataSet = new DataSet("reply");
DataTable settingsTable = new DataTable("settings");
settingsTable.Columns.Add("id");
settingsTable.Columns.Add("max_recs");
settingsTable.Columns.Add("cols_returned");
settingsTable.Columns.Add("date_format");
DataRow mainRow = settingsTable.NewRow();
mainRow["id"] = data.Settings.LatestId;
mainRow["max_recs"] = data.Settings.RecordCount;
mainRow["cols_returned"] = data.Settings.ReturnColumns;
mainRow["date_format"] = data.Settings.DateFormat;
settingsTable.Rows.Add(mainRow);
dataSet.Tables.Add(settingsTable);
DataSet results = service.Reply_DS_DS(account.Username, account.Password, dataSet);
if (results != null && results.Tables.Contains("data"))
{
results.Tables["data"].AsEnumerable().ForAll(r =>
{
Guid tempGuid;
MessageEntity message;
if (Guid.TryParse(TypeSafety.GetValue<string>(r["sentcustomerid"]), out tempGuid))
{
message = dataBinding.GetMessageByRowGuid(tempGuid);
if (message != null)
{
message.Text = TypeSafety.GetValue<string>(r["sentdata"]);
message.EventId = TypeSafety.GetValue<int>(r["eventid"]);
message.Status = "REPLY";
}
else
{
message = new MessageEntity()
{
NumberTo = string.Empty,
Sender = TypeSafety.GetValue<string>(r["numfrom"]),
Text = TypeSafety.GetValue<string>(r["sentdata"]),
DateCreated = TypeSafety.GetValue<DateTime>(r["sentdatetime"], DateTime.Now),
OriginId = 5, // Legacy
UniqueId = TypeSafety.GetValue<int>(r["eventid"]),
EventId = TypeSafety.GetValue<int>(r["eventid"]),
RowGuid = Guid.NewGuid(),
Status = "UNKNOWN WITH REPLY"
};
}
message = dataBinding.SetMessageForced(message);
}
else
{
message = new MessageEntity()
{
NumberTo = string.Empty,
Sender = TypeSafety.GetValue<string>(r["numfrom"]),
Text = TypeSafety.GetValue<string>(r["sentdata"]),
DateCreated = TypeSafety.GetValue<DateTime>(r["sentdatetime"], DateTime.Now),
OriginId = 5, // Legacy
UniqueId = TypeSafety.GetValue<int>(r["sentcustomerid"],0),
EventId = TypeSafety.GetValue<int>(r["eventid"]),
RowGuid = Guid.NewGuid(),
Status = "UNKNOWN WITH REPLY"
};
message = dataBinding.SetMessageForced(message);
}
if (message != null)
{
MessageReplyEntity reply = new MessageReplyEntity()
{
ReplyId = TypeSafety.GetValue<int>(r["replyid"]),
MessageId = message.MessageId,
Text = TypeSafety.GetValue<string>(r["receiveddata"]),
DateReceived = TypeSafety.GetValue<DateTime>(r["received"], DateTime.Now)
};
dataBinding.InsertMessageReply(reply);
}
});
recordsProcessed = results.Tables["data"].Rows.Count > 0;
if (recordsProcessed)
{
int latestID = results.Tables["data"].AsEnumerable().Max(s => TypeSafety.GetValue<int>(s["replyid"]));
dataBinding.UpdateReplySettingsLatestID(latestID, account.AccountId);
dataBinding.AddStopReplies();
}
}
} while (recordsProcessed);
}
}
}
public static void RefreshDeliveryReport()
{
using (var dataBinding = new MessageDataAccessor())
using (var service = new MyMobileAPIService.APISoapClient())
{
DataSet dataSet = null;
DataTable settingsTable = null;
foreach (var account in dataBinding.GetAccounts())
{
bool recordsProcessed;
do
{
recordsProcessed = false;
SentServiceCallEntity data = new SentServiceCallEntity()
{
Settings = dataBinding.GetSentSettings(account.AccountId)
};
dataSet = new DataSet("sent");
settingsTable = new DataTable("settings");
settingsTable.Columns.Add("id");
settingsTable.Columns.Add("max_recs");
settingsTable.Columns.Add("cols_returned");
settingsTable.Columns.Add("date_format");
DataRow mainRow = settingsTable.NewRow();
mainRow["id"] = data.Settings.LatestId;
mainRow["max_recs"] = data.Settings.RecordCount;
mainRow["cols_returned"] = data.Settings.ReturnColumns;
mainRow["date_format"] = data.Settings.DateFormat;
settingsTable.Rows.Add(mainRow);
dataSet.Tables.Add(settingsTable);
DataSet results = service.Sent_DS_DS(account.Username, account.Password, dataSet);
SaveXmlStringToFile(results.GetXml(),"DELIVERIES");
if (results != null && results.Tables.Contains("data"))
{
results.Tables["data"].AsEnumerable().ForAll(r =>
{
//var r = results.Tables["data"].Rows[0];
Guid tempGuid;
MessageEntity message;
try
{
if (Guid.TryParse(TypeSafety.GetValue<string>(r["customerid"]), out tempGuid))
{
message = dataBinding.GetMessageByRowGuid(tempGuid);
// we only update the values of an existing message
if (message != null)
{
message.NumberTo = TypeSafety.GetValue<string>(r["numto"]);
message.NumberTo = (message.NumberTo.Length > 15) ? message.NumberTo.Substring(0, 15) : message.NumberTo;
message.Text = TypeSafety.GetValue<string>(r["data"]);
message.EventId = TypeSafety.GetValue<int>(r["eventid"]);
message.Status = TypeSafety.GetValue<string>(r["status"]);
}
else
{
message = new MessageEntity()
{
// we create a new message as it does not exist
NumberTo = TypeSafety.GetValue<string>(r["numto"]),
Sender = string.Empty,
Text = TypeSafety.GetValue<string>(r["data"]),
DateCreated = DateTime.Now,
OriginId = 5, // Legacy System
UniqueId = TypeSafety.GetValue<int>(r["customerid"], 0),
EventId = TypeSafety.GetValue<int>(r["eventid"]),
RowGuid = Guid.NewGuid(),
Status = "UNKOWN " + TypeSafety.GetValue<string>(r["status"])
};
}
message = dataBinding.SetMessageForced(message);
}
else
{
message = new MessageEntity()
{
// we create a new message as it does not exist
NumberTo = TypeSafety.GetValue<string>(r["numto"]),
Sender = string.Empty,
Text = TypeSafety.GetValue<string>(r["data"]),
DateCreated = DateTime.Now,
OriginId = 5, // Legacy System
UniqueId = TypeSafety.GetValue<int>(r["customerid"], 0),
EventId = TypeSafety.GetValue<int>(r["eventid"]),
RowGuid = Guid.NewGuid(),
Status = "UNKOWN " + TypeSafety.GetValue<string>(r["status"])
};
message = dataBinding.SetMessageForced(message);
}
if (message != null)
{
DeliveryReportEntity report = new DeliveryReportEntity();
report.ChangeId = TypeSafety.GetValue<long>(r["changeid"]);
report.MessageId = message.MessageId;
report.SentId = TypeSafety.GetValue<long>(r["sentid"].ToString());
report.Status = TypeSafety.GetValue<string>(r["status"]);
report.StatusDate = TypeSafety.GetValue<DateTime>(r["statusdate"], DateTime.Now);
dataBinding.InsertDeliveryReport(report);
}
}
catch (Exception ex)
{
System.Threading.Thread.Sleep(1);
}
} );
recordsProcessed = results.Tables["data"].Rows.Count > 0;
if (recordsProcessed)
{
long latestID = results.Tables["data"].AsEnumerable().Max(s => TypeSafety.GetValue<long>(s["changeid"]));
dataBinding.UpdateSentSettingsLatestID(latestID, account.AccountId);
}
}
} while (recordsProcessed);
}
}
}
private static void ProcessMessagesToServiceCall(List<SendServiceCallEntity> dataList, AccountEntity account, ref SendServiceCallEntity data, ref int counter, ref List<MessageEntity> entries, MessageEntity message)
{
message.HasPrefix = true;
entries.Add(message);
if (++counter == 1000)
{
AddMessagesToServiceCallList(dataList, data, entries);
entries = new List<MessageEntity>();
counter = 0;
data = GetSendBatch(account);
}
}
private static void SaveMessage(MessageEntity message, DeliveryReportEntity deliveryReport)
{
using (var dataBinding = new MessageDataAccessor())
{
message = dataBinding.SetMessage(message);
if (deliveryReport != null && message != null)
{
deliveryReport.MessageId = message.MessageId;
dataBinding.InsertDeliveryReport(deliveryReport);
}
}
}
private static void SaveMessage(MessageEntity message)
{
SaveMessage(message, null);
}
private static DataRow GetEntryDataRow(DataRow entryRow, MessageEntity entry)
{
entry.RowGuid = Guid.NewGuid();
entryRow["numto"] = entry.NumberTo;
entryRow["customerid"] = entry.RowGuid;
entryRow["data1"] = entry.Text;
return entryRow;
}
private static MessageEntity ConvertToMessageEntity(Message message)
{
MessageEntity entity = new MessageEntity()
{
MessageId = message.MessageId,
NumberTo = message.Number,
Sender = message.Sender,
Text = message.Text,
EncryptedText = message.EncryptedText,
OriginId = message.OriginId,
UniqueId = message.UniqueId,
DateCreated = message.Created,
Status = message.Status
};
return entity;
}
private static Message EntityToMessage(MessageEntity entity, Message message)
{
message.Number = entity.NumberTo;
message.Sender = entity.Sender;
message.Text = entity.Text;
message.Created = entity.DateCreated;
message.OriginId = entity.OriginId;
message.UniqueId = entity.UniqueId;
message.EventId = entity.EventId;
message.RowGuid = entity.RowGuid;
message.Status = entity.Status;
return message;
}
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);
}
}
