Esempio n. 1
0
        /// <summary>
        /// Evaluates a collection of entities, and takes care of the whole CRUD operation.
        /// Meaning, it checks existance in database, and if not found, its created in database.
        /// If it exists in database with different info, it updates the database.
        /// In other words, "syncs" the received collection of entities to the database.
        /// /// </summary>
        /// <param name="Entities">A list of Entities to be added / updated to the database ///</param>
        public void PushToDbset(List <InstanceContent> Entities)
        {
            //Extract Contained Classes, and push them to the database
            List <Attribute> Attributes_ToPush = Entities.Select(c => c.Attribute).ToList();
            List <Instance>  Instances_ToPush  = Entities.Select(c => c.Instance).ToList();
            List <IOTag>     IOTags_ToPush     = Entities.Select(c => c.IOTag).ToList();

            List <PLCTag> PLCTags_ToPush = Entities.Select(c => c.PLCTag).ToList();

            Attributes.PushToDbset(Attributes_ToPush);
            Instances.PushToDbset(Instances_ToPush);
            IOTags.PushToDbset(IOTags_ToPush);
            PLCTags.PushToDbset(PLCTags_ToPush);
            context.SaveChanges();

            //Update the contained classes in the entities, so that they are not null or incomplete
            List <InstanceContent> EntsToPush = GetListSyncFromDB(Entities);

            //Find contents that as NOT in the database, and insert them
            List <InstanceContent> Entities_NOTinDb = NOTInDatabase(EntsToPush);

            if (Entities_NOTinDb.Count
                > 0)
            {
                InsertList(Entities_NOTinDb);
            }

            //Find contents that are in the database, and update them
            List <InstanceContent> Entities_inDb = InDatabase(EntsToPush);

            if (Entities_inDb.Count > 0)
            {
                UpdateList(Entities_inDb);
            }
        }
Esempio n. 2
0
        public List <InstanceContent> GetListSyncFromDB(List <InstanceContent> _Entities)
        {
            List <InstanceContent> UpdatedList = (from Cont in _Entities
                                                  select new InstanceContent()
            {
                InstanceContentID = GetID(Cont.Instance.Name, Cont.Attribute.Name),
                Instance = Instances.GetSyncFromDB(Cont.Instance),
                InstanceID = Instances.GetID(Cont.Instance.Name),
                Attribute = Attributes.GetSyncFromDB(Cont.Attribute),
                AttributeID = Attributes.GetID(Cont.Attribute.Name),
                PLCTag = Cont.PLCTag != null ? PLCTags.GetSyncFromDB(Cont.PLCTag) : null,
                PLCTagID = Cont.PLCTag != null ? PLCTags.GetID(Cont.PLCTag.Name) : Cont.PLCTagID,
                IOTag = IOTags.GetSyncFromDB(Cont.IOTag),
                IOTagID = IOTags.GetID(Cont.IOTag.Name),
                AssetName = Cont.AssetName
            }).ToList();

            return(UpdatedList);
        }