using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DomainModel;
using IdeaBlade.Core;
using IdeaBlade.EntityModel;

namespace DevForceInterceptorTest
{
    class InterceptorTest
    {
        private DomainModelEntityManager customerManager;

        private static DomainModelEntityManager referenceManager;
        private static IEnumerable<Type> referenceTypes = new Type[] { typeof(CustomerStatus) };

        static InterceptorTest()
        {
            PropertyInterceptorManager.CurrentInstance.DiscoverInterceptorsFromAttributes(typeof(InterceptorTest));
            referenceManager = new DomainModelEntityManager();
            referenceManager.CustomerStatuses.ToList();
        }

        public void Start()
        {
            customerManager = new DomainModelEntityManager();
            customerManager.DefaultQueryStrategy = QueryStrategy.CacheOnly;

            foreach (Customer customer in customerManager.Customers.With(QueryStrategy.DataSourceOnly).ToList())
            {
                Console.WriteLine("Customer {0} Status {1}", customer.Name, customer.CustomerStatus.Name);
            }

            Console.ReadKey();
        }

        [AfterGet(TargetType = typeof(TravelEntity))]
        public static void ReferenceEntityGetInterceptor(IEntityPropertyInterceptorArgs args)
        {
            if (!referenceTypes.Contains(args.EntityProperty.DataType))
                return;

            NavigationEntityProperty navigationProperty = (NavigationEntityProperty)args.EntityProperty;
            TravelEntity entity = (TravelEntity)args.Instance;
            string fkName = navigationProperty.RelationLink.EntityRelation.Role1.Properties[0].Name;
            object id = entity.EntityAspect[fkName];

            if (args.EntityProperty.DataType == typeof(CustomerStatus))
            {
                args.Value = referenceManager.CustomerStatuses.Where(cs => cs.Id == (Guid)id).FirstOrNullEntity();
            }

        }
    }
}

Now, this does work, but I have bolded the section that needs some improvement. I'll have a think about making this more generic.

Thanks for drawing a clear picture of your app and workflow ... it's one we can all recognize too.

A proper discussion of how best to refresh the reference data from the database is out-of-scope; "best" is a function of too many factors to cover here. For now we'll assume you poll every ... I don't know ... couple of minutes. The point is that the polling frequency is too long to keep up with changes made by the local user. The local user will expect to see her changes propagated immediately.

Don't dismiss the messaging approach (whether you use an EA or a specialized service). You will have created a mechanism whereby any module can learn about entity saves coming from anywhere. You'll have something more general than just a way to alert the Ref Repo to such changes.

• Admin Module adds a new Airline
• Admin Module changes the name of an existing Airline
• Customer Edit session 'A' has Airline with the old name and doesn't know about the new Airline
• Customer Edit session 'B' is in the same boat.

What do you do? You can't just fold the Admin Module into the Customer Edit Module ... because you won't have dealt with the real problem ... that other modules (session 'B' in this example) have stale Reference Entity state.