Exemple #1
0
        public async Task <DataSourceDTO> Register(DataSourceTransferDTO dto)
        {
            NetworkEntity datamartEntity = DataContext.NetworkEntities.Add(new NetworkEntity {
                NetworkID = dto.NetworkID.Value, NetworkEntityID = dto.ID, EntityType = EntityType.DataSource
            });

            Data.DataSource datamart = DataContext.DataSources.Add(new Data.DataSource()
            {
                ID                 = datamartEntity.ID,
                Name               = dto.Name,
                Acronym            = dto.Acronym,
                OrganizationID     = dto.OrganizationID,
                AdapterSupportedID = dto.AdapterSupportedID
            });

            await DataContext.SaveChangesAsync();

            if (dto.Metadata != null && dto.Metadata.Count() > 0)
            {
                IList <Data.DataSourceDomainData> metadata = new List <Data.DataSourceDomainData>();
                foreach (var meta in dto.Metadata)
                {
                    var orgMeta = new DataSourceDomainData()
                    {
                        DataSourceID   = datamart.ID,
                        DomainUseID    = meta.DomainUseID,
                        Value          = meta.Value,
                        SequenceNumber = meta.SequenceNumber,
                    };
                    if (meta.DomainReferenceID.HasValue)
                    {
                        orgMeta.DomainReferenceID = meta.DomainReferenceID.Value;
                    }
                    metadata.Add(orgMeta);
                }
                if (metadata.Count > 0)
                {
                    DataContext.DomainDatas.AddRange(metadata);
                }
                await DataContext.SaveChangesAsync();
            }

            await DataContext.Entry(datamart).Reference(dm => dm.AdapterSupported).LoadAsync();

            return(datamart.Map <DataSource, DataSourceDTO>());
        }
Exemple #2
0
        public async Task <DataSourceDTO> Update(DataSourceTransferDTO dto)
        {
            var datamart = await DataContext.DataSources.FindAsync(dto.ID);

            if (datamart.Deleted)
            {
                throw new Exception("The Specified DataSource was not found");
            }

            datamart.Name               = dto.Name;
            datamart.Acronym            = dto.Acronym;
            datamart.OrganizationID     = dto.OrganizationID;
            datamart.AdapterSupportedID = dto.AdapterSupportedID;

            await DataContext.SaveChangesAsync();


            var dataMartMetaData = await DataContext.DomainDatas.OfType <DataSourceDomainData>().Where(x => x.DataSourceID == dto.ID).ToArrayAsync();

            if (dto.Metadata != null && dto.Metadata.Count() > 0)
            {
                IList <DataSourceDomainData> metaDataToAdd = new List <DataSourceDomainData>();
                foreach (var meta in dto.Metadata.Where(m => !m.ID.HasValue))
                {
                    var dsMeta = new DataSourceDomainData()
                    {
                        DataSourceID   = dto.ID,
                        DomainUseID    = meta.DomainUseID,
                        Value          = meta.Value,
                        SequenceNumber = meta.SequenceNumber,
                    };
                    if (meta.DomainReferenceID.HasValue)
                    {
                        dsMeta.DomainReferenceID = meta.DomainReferenceID.Value;
                    }
                    metaDataToAdd.Add(dsMeta);
                }
                if (metaDataToAdd.Count > 0)
                {
                    DataContext.DomainDatas.AddRange(metaDataToAdd);
                }

                foreach (var meta in dataMartMetaData.Where(org => dto.Metadata.Any(m => m.ID == org.ID && (org.Value != m.Value || org.SequenceNumber != m.SequenceNumber || org.DomainReferenceID != m.DomainReferenceID))))
                {
                    var diff = dto.Metadata.Where(m => m.ID == meta.ID).FirstOrDefault();
                    DataContext.DomainDatas.Attach(meta);
                    if (meta.Value != diff.Value)
                    {
                        meta.Value = diff.Value;
                    }
                    if (meta.SequenceNumber != diff.SequenceNumber)
                    {
                        meta.SequenceNumber = diff.SequenceNumber;
                    }
                    if (meta.DomainReferenceID != diff.DomainReferenceID)
                    {
                        meta.DomainReferenceID = diff.DomainReferenceID;
                    }
                }
                await DataContext.SaveChangesAsync();
            }

            var metadataIDs = dto.Metadata.Where(x => x.ID.HasValue).Select(x => x.ID.Value);
            var remove      = (from d in dataMartMetaData
                               where !metadataIDs.Contains(d.ID) && d.DataSourceID == dto.ID
                               select d.ID).ToArray();


            if (remove.Count() > 0)
            {
                //Have to do this cause of trigger
                var removeIDs = String.Join(",", remove.Select(x => String.Format("'{0}'", x)));
                await DataContext.Database.ExecuteSqlCommandAsync(string.Format("delete from DataSourceDomainData where ID IN ({0})", removeIDs));
            }

            await DataContext.Entry(datamart).Reference(dm => dm.AdapterSupported).LoadAsync();

            return(datamart.Map <DataSource, DataSourceDTO>());
        }