public MessageQueueResponse Save(MessageQueueRequest request) { MessageQueueResponse response = new MessageQueueResponse(); using (var context = new hamptondwellEntities()) { var messageQueue = context.MessageQueues. Where(u => u.MessageQueueID == request.MessageQueueId).FirstOrDefault(); messageQueue = messageQueue ?? new MessageQueue(); messageQueue.ModifiedBy_UserID = request.ModifiedByUserId.Value; messageQueue.Active = request.Active ?? true; messageQueue.Status_MessageQueueStatusID = request.Status_MessageQueueStatusID; messageQueue.MessageResponse = request.MessageResponse; if (messageQueue.MessageQueueID == 0) { messageQueue.CreatedOn = DateTime.UtcNow; messageQueue.CreatedBy_UserID = request.CreatedByUserId ?? messageQueue.CreatedBy_UserID; messageQueue.OccurredOn = request.OccurredOn; messageQueue.Type_MessageQueueTypeID = request.Type_MessageQueueTypeID; messageQueue.MessageBody = request.MessageBody; } messageQueue.ModifiedOn = DateTime.UtcNow; if (messageQueue.MessageQueueID == 0) context.AddObject("MessageQueues", messageQueue); context.SaveChanges(); response.MessageQueue = new MessageQueueObject() { MessageQueueId = messageQueue.MessageQueueID, Active = messageQueue.Active, MessageResponse = messageQueue.MessageResponse, CreatedByUserId = messageQueue.CreatedBy_UserID, MessageBody = messageQueue.MessageBody, CreatedOn = messageQueue.CreatedOn, ModifiedByUserId = messageQueue.ModifiedBy_UserID, ModifiedOn = messageQueue.ModifiedOn, Status_MessageQueueStatusID = messageQueue.Status_MessageQueueStatusID, Type_MessageQueueTypeID = messageQueue.Type_MessageQueueTypeID } ; } return response; }
public MessageQueueResponse GetPendingMessageQueue(MessageQueueRequest request) { MessageQueueResponse response = new MessageQueueResponse(); using (var context = new hamptondwellEntities()) { List<MessageQueue> messageQueue = context.MessageQueues. Where(u => u.Status_MessageQueueStatusID == request.Status_MessageQueueStatusID && u.Type_MessageQueueTypeID == request.Type_MessageQueueTypeID && u.Active == true).ToList(); response.MessageQueueList = messageQueue.Select(a => new MessageQueueObject() { MessageQueueId = a.MessageQueueID, MessageBody = a.MessageBody, Type_MessageQueueTypeID = a.Type_MessageQueueTypeID, ModifiedByUserId = a.ModifiedBy_UserID, CreatedByUserId = a.CreatedBy_UserID, ModifiedOn = a.ModifiedOn, CreatedOn = a.CreatedOn }).ToList(); response.ResultSetCount = messageQueue.Count; } return response; }