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