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