private static object GetSyncRecordId(object id, EntityMetadata metadata, Dictionary <string, object> syncParams)
{
if (!metadata.Attributes.Any(c => syncParams.ContainsKey(c.PropertyName)))
{
return(id);
}
var oldItem = DynamicRepository.Get(metadata, FilterCriteriaSet.And.Equal(id, metadata.PrimaryKeyPropertyName), ExternalMethodsCallMode.None).FirstOrDefault();
foreach (var p in syncParams)
{
if (metadata.Attributes.Any(c => c.PropertyName == p.Key))
{
if ((oldItem as DynamicEntity)[p.Key].Equals(p.Value))
{
return(id);
}
}
}
FilterCriteriaSet compareFilter = FilterCriteriaSet.And;
foreach (var p in syncParams)
{
if (metadata.Attributes.Any(c => c.PropertyName == p.Key))
{
compareFilter.Merge(FilterCriteriaSet.And.Equal(p.Value, p.Key));
}
}
foreach (var attributeToCompare in metadata.Attributes.Where(a => a.ForCompare))
{
compareFilter.Merge(FilterCriteriaSet.And.Equal((oldItem as DynamicEntity)[attributeToCompare.PropertyName], attributeToCompare.PropertyName));
}
var item = DynamicRepository.Get(metadata, compareFilter, ExternalMethodsCallMode.None).FirstOrDefault();
return(item != null ? (item as DynamicEntity).GetId() : id);
}
public static List <Tuple <Guid, string, List <Tuple <Guid, string> > > > GetDependingEntityAccess(string metaviewName, Guid[] ids, int deep = 1)
{
DynamicEntityRepository repo = new DynamicEntityRepository();
EntityMetadata metadata = repo.GetEntityMetadataByEntityName(metaviewName);
List <Guid> dependingEntityMetadataIds = MetadataRepositoty.GetDependingEntityIds(new TableDescription(metadata.SchemaName, metadata.TableName));
Dictionary <Guid, EntityMetadata> dependingMetadata = dependingEntityMetadataIds.Select(id => new KeyValuePair <Guid, EntityMetadata>(id, repo.GetEntityMetadataByEntityId(id)))
.ToDictionary(kvp => kvp.Key, kvp => kvp.Value);
var dependingEntities = new List <Tuple <Guid, string, List <Tuple <Guid, string> > > >();
foreach (var entityMetadata in dependingMetadata)
{
FilterCriteriaSet filters = FilterCriteriaSet.Empty;
AttributeDescription entityCaptionAttribute = OptimaJet.BJet.CommonMethods.GetEntityCaptionAttribute(entityMetadata.Value);
List <FilterCriteriaSet> filterSets = entityMetadata.Value.PlainAttributes.Where(a => a.IsReference && a.ReferencedSchemaName == metadata.SchemaName && a.ReferencedTableName == metadata.TableName)
.Select(a => FilterCriteriaSet.And.In(ids.ToList(), entityMetadata.Value.GetColumn(a))).ToList();
filterSets.ForEach(f => filters = filters != FilterCriteriaSet.Empty ? filters.Merge(f) : f);
var entities = repo.GetEntitiesByMetadata(entityMetadata.Value, filters).Entities;
if (entities == null || entities.Count() == 0)
{
continue;
}
var dependingEntity = new Tuple <Guid, string, List <Tuple <Guid, string> > >(
entityMetadata.Key,
entityMetadata.Value.TableName,
new List <Tuple <Guid, string> >(entities.Select(e =>
new Tuple <Guid, string>((Guid)e.Id, e.GetProperty(entityCaptionAttribute.PropertyName).ToString())
).ToList()));
dependingEntities.Add(dependingEntity);
if (deep > 0)
{
dependingEntities.AddRange(GetDependingEntityAccess(dependingEntity.Item2, dependingEntity.Item3.Select(t => t.Item1).ToArray(), deep - 1));
}
}
return(dependingEntities);
}