mds – Averbouch.biz : le blog

Master Data Services : Business Rules Copy / Import / Export (Cross Model)

By Xavier | September 21, 2011 - 12:20 | Master Data Services

updated article (Oct 2011)

(code refactored)

Hi All,

One other missing feature of MDS is Import / Export / Copy Business rules from a model to another (or copy business rules to the same model)

my code is still in beta, but it is already (partially) working.

you can find it on my “MDS Manager” tool on codeplex:

http://mdsmanager.codeplex.com

Get business rules from modelId, quite easy with service client method “business rules get”, returns a business rule set

 public BusinessRules GetBusinessRules(string fileName)
        {
            BusinessRules brs = null;
            Stream str = null;
            try
            {

                if (File.Exists(fileName))
                {
                    str = new FileStream(@fileName, FileMode.Open, FileAccess.Read, FileShare.Read);

                    if (str == null)
                    {
                        throw new BusinessRulesException("error while opening file!");
                    }

                    XmlSerializer xs = new XmlSerializer(typeof(BusinessRules));
                    // Load the object saved above by using the Deserialize function
                     brs = (BusinessRules)xs.Deserialize(str);

                }
                else
                {
                    throw new BusinessRulesException("Cannot find specified file!");
                }

                return brs;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {

                // Cleanup                 if (str != null)
                    str.Close();

            }

        }

public BusinessRules GetBusinessRules(string fileName)

{

BusinessRules brs = null;

Stream str = null;

try

{

if (File.Exists(fileName))

{

str = new FileStream(@fileName, FileMode.Open, FileAccess.Read, FileShare.Read);

if (str == null)

{

throw new BusinessRulesException("error while opening file!");

}

XmlSerializer xs = new XmlSerializer(typeof(BusinessRules));

// Load the object saved above by using the Deserialize function

brs = (BusinessRules)xs.Deserialize(str);

}

else

{

throw new BusinessRulesException("Cannot find specified file!");

}

return brs;

}

catch (Exception ex)

{

throw ex;

}

finally

{

// Cleanup if (str != null)

str.Close();

}

then we export business rules to a XML file

1	then we export business rules to a XML file

note:

note:

//this is needed to avoid a serialization error (more info on <a title="http://www.johnsoer.com/blog/?p=125" href="http://www.johnsoer.com/blog/?p=125" target="_blank">http://www.johnsoer.com/blog/?p=125</a> ) :

1	//this is needed to avoid a serialization error (more info on <a title="http://www.johnsoer.com/blog/?p=125" href="http://www.johnsoer.com/blog/?p=125" target="_blank">http://www.johnsoer.com/blog/?p=125</a> ) :

 //XmlSerializer xs = new XmlSerializer(typeof(BusinessRules), new Type[] { typeof(BRAttributeValueArgument),typeof(BRBlankArgument)
   //                                                                                     ,typeof(BRDomainBasedAttributeArgument)});

1 2	//XmlSerializer xs = new XmlSerializer(typeof(BusinessRules), new Type[] { typeof(BRAttributeValueArgument),typeof(BRBlankArgument) // ,typeof(BRDomainBasedAttributeArgument)});

here is the export method :

1	here is the export method :

 public void ExportBusinessRules(string exportFileName, BusinessRules brs)
        {
            TextWriter WriteFileStream = null;
            try
            {

public void ExportBusinessRules(string exportFileName, BusinessRules brs)

{

TextWriter WriteFileStream = null;

try

{

//new type needed to avoir error because serialization of an inherited class XmlSerializer xs = new XmlSerializer(typeof(BusinessRules), new Type[] { typeof(Common.ServiceReference1.BRAttributeValueArgument) });
//update oct 2011!
//new type needed to avoir error because serialization of an inherited class

               XmlSerializer xs = new XmlSerializer(typeof(BusinessRules), new Type[] { typeof(BRAttributeValueArgument),typeof(BRBlankArgument)
                                                                                        ,typeof(BRDomainBasedAttributeArgument)});

1 2	XmlSerializer xs = new XmlSerializer(typeof(BusinessRules), new Type[] { typeof(BRAttributeValueArgument),typeof(BRBlankArgument) ,typeof(BRDomainBasedAttributeArgument)});

              // Create a new file stream to write the serialized object to a file                 WriteFileStream = new StreamWriter(@exportFileName);
                xs.Serialize(WriteFileStream, brs);

               //custom exception class , but not required              throw new BusinessRulesException("Business Rules successfully exported to file " + exportFileName);

            }
            catch (Exception exc)
            {
                throw exc;
            }
            finally
            {
               // Cleanup                 if (WriteFileStream != null)
                    WriteFileStream.Close();
            }
        }

// Create a new file stream to write the serialized object to a file WriteFileStream = new StreamWriter(@exportFileName);

xs.Serialize(WriteFileStream, brs);

//custom exception class , but not required throw new BusinessRulesException("Business Rules successfully exported to file " + exportFileName);

}

catch (Exception exc)

{

throw exc;

}

finally

{

// Cleanup if (WriteFileStream != null)

WriteFileStream.Close();

}

then we would like to import this XML file to another model:

1	then we would like to import this XML file to another model:

here is the method to get business rules set from a previously exported XML file :

1	here is the method to get business rules set from a previously exported XML file :

  public BusinessRules GetBusinessRules(string fileName)
        {
            BusinessRules brs = null;
            Stream str = null;
            try
            {

                if (File.Exists(fileName))
                {
                    str = new FileStream(@fileName, FileMode.Open, FileAccess.Read, FileShare.Read);

                    if (str == null)
                    {
                        throw new BusinessRulesException("error while opening file!");
                    }

                    XmlSerializer xs = new XmlSerializer(typeof(BusinessRules));
                   // Load the object saved above by using the Deserialize function                    brs = (BusinessRules)xs.Deserialize(str);

                }
                else
                {
                    throw new BusinessRulesException("Cannot find specified file!");
                }

                return brs;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {

              // Cleanup 
          if (str != null)
                    str.Close();

            }

        }

public BusinessRules GetBusinessRules(string fileName)

{

BusinessRules brs = null;

Stream str = null;

try

{

if (File.Exists(fileName))

{

str = new FileStream(@fileName, FileMode.Open, FileAccess.Read, FileShare.Read);

if (str == null)

{

throw new BusinessRulesException("error while opening file!");

}

XmlSerializer xs = new XmlSerializer(typeof(BusinessRules));

// Load the object saved above by using the Deserialize function brs = (BusinessRules)xs.Deserialize(str);

}

else

{

throw new BusinessRulesException("Cannot find specified file!");

}

return brs;

}

catch (Exception ex)

{

throw ex;

}

finally

{

// Cleanup

if (str != null)

str.Close();

}

<span style="color: #339966;">//then we can get the source modelID</span>

1	<span style="color: #339966;">//then we can get the source modelID</span>

 sourceModelId =brs.BusinessRulesMember.First().Identifier.ModelId as Identifier;

1	sourceModelId =brs.BusinessRulesMember.First().Identifier.ModelId as Identifier;

<span style="color: #339966;">// and then clone business rule set with updated modelId:</span>

1	<span style="color: #339966;">// and then clone business rule set with updated modelId:</span>

<span style="color: #339966;">//brs is the business rule set</span>

1	<span style="color: #339966;">//brs is the business rule set</span>

<span style="color: #339966;">//sourceModelId is the source Model Identifier (taken above from the Rules set from the XML file)</span>

1	<span style="color: #339966;">//sourceModelId is the source Model Identifier (taken above from the Rules set from the XML file)</span>

<span style="color: #339966;">//target ModelId is the model Identifier for the model we want to import back the B. rules to</span>

1	<span style="color: #339966;">//target ModelId is the model Identifier for the model we want to import back the B. rules to</span>

CloneBusinessRules(brs,sourceModelId, targetModelId));

1	CloneBusinessRules(brs,sourceModelId, targetModelId));

Here is the CloneBusinessRules Method:

1	Here is the CloneBusinessRules Method:

public string CloneBusinessRules(BusinessRules brs, Identifier SourceModelId, Identifier targetModelId)
        {

            OperationResult or = null;
            //instanciate new BR members
            try
            {
                int cptMissingEntity = 0;
                StringBuilder sb = new StringBuilder("these business rule related entities does not exists in target model:");
                sb.AppendLine();
                BusinessRules newBRS = new BusinessRules();
                foreach (BusinessRule br in brs.BusinessRulesMember)
                {
                    Identifier EntityId = null;
                    //this is used to get the target entity Id with matching its name 
                    using (ServiceClient c = new ServiceClientWrapper().CreateServiceClient())
                    {
                        EntityId = GetEntityIdFromName(c, c.Endpoint.Address.Uri.OriginalString, targetModelId, br.Identifier.EntityId.Name);

                    }
                    if (EntityId != null)
                    {
                        newBRS.BusinessRulesMember = new Collection&lt;BusinessRule&gt;();

                        //create a new business rule based on the source one, and applying on it the target identifiers and names 
                        BusinessRule newBR = BusinessRuleInstanciate(Guid.NewGuid(), br.Identifier.Name, targetModelId.Name, br.Identifier.EntityId.Name,
                            br.Identifier.MemberType, br.Priority, br.BRActions, br.Identifier.InternalId, br.RuleActionText, br.RuleConditionText);
                        //some required parameters to instanciate below:

                        //instanciate BRActions
                        newBRS.BRActions = BRActionsInstanciate(brs.BRActions, newBR.Identifier);
                        //instanciate BRConditions
                        newBRS.BRConditions = BRConditionsInstanciate(brs.BRConditions, newBR.Identifier);
                        //instanciate BRConditionTreeNodes
                        newBRS.BRConditionTreeNodes = BRConditionTreeNodesInstanciate(brs.BRConditionTreeNodes, newBR.Identifier);
                        newBRS.BusinessRulesMember.Add(newBR);
                    }
                    else
                    {
                        sb.AppendLine(br.Identifier.EntityId.Name);
                        cptMissingEntity++;
                        //these business rule related entities do not exist in target model
                    }
                    //then we clone modified BRSet
                    using (ServiceClient c = new ServiceClientWrapper().CreateServiceClient())
                    {

                        or = c.BusinessRulesClone(new International(), newBRS);
                        string err = Tools.HandleErrors(or);
                        if (!string.IsNullOrEmpty(err))
                        {
                            throw new Exception(err);
                        }
                    }
                    if (cptMissingEntity == 0)
                    {
                        sb = new StringBuilder();
                    }
                }

                return sb.ToString();
            }
            catch (Exception exc)
            {
                throw exc;
            }
        }

public string CloneBusinessRules(BusinessRules brs, Identifier SourceModelId, Identifier targetModelId)

{

OperationResult or = null;

//instanciate new BR members

try

{

int cptMissingEntity = 0;

StringBuilder sb = new StringBuilder("these business rule related entities does not exists in target model:");

sb.AppendLine();

BusinessRules newBRS = new BusinessRules();

foreach (BusinessRule br in brs.BusinessRulesMember)

{

Identifier EntityId = null;

//this is used to get the target entity Id with matching its name

using (ServiceClient c = new ServiceClientWrapper().CreateServiceClient())

{

EntityId = GetEntityIdFromName(c, c.Endpoint.Address.Uri.OriginalString, targetModelId, br.Identifier.EntityId.Name);

}

if (EntityId != null)

{

newBRS.BusinessRulesMember = new Collection<BusinessRule>();

//create a new business rule based on the source one, and applying on it the target identifiers and names

BusinessRule newBR = BusinessRuleInstanciate(Guid.NewGuid(), br.Identifier.Name, targetModelId.Name, br.Identifier.EntityId.Name,

br.Identifier.MemberType, br.Priority, br.BRActions, br.Identifier.InternalId, br.RuleActionText, br.RuleConditionText);

//some required parameters to instanciate below:

//instanciate BRActions

newBRS.BRActions = BRActionsInstanciate(brs.BRActions, newBR.Identifier);

//instanciate BRConditions

newBRS.BRConditions = BRConditionsInstanciate(brs.BRConditions, newBR.Identifier);

//instanciate BRConditionTreeNodes

newBRS.BRConditionTreeNodes = BRConditionTreeNodesInstanciate(brs.BRConditionTreeNodes, newBR.Identifier);

newBRS.BusinessRulesMember.Add(newBR);

}

else

{

sb.AppendLine(br.Identifier.EntityId.Name);

cptMissingEntity++;

//these business rule related entities do not exist in target model

}

//then we clone modified BRSet

using (ServiceClient c = new ServiceClientWrapper().CreateServiceClient())

{

or = c.BusinessRulesClone(new International(), newBRS);

string err = Tools.HandleErrors(or);

if (!string.IsNullOrEmpty(err))

{

throw new Exception(err);

}

if (cptMissingEntity == 0)

{

sb = new StringBuilder();

}

return sb.ToString();

}

catch (Exception exc)

{

throw exc;

}

update oct 2011 code for BRActionsInstanciate, BRConditionsInstanciate,BRConditionTreeNodesInstanciate

 private Collection&lt;BRConditionTreeNode&gt; BRConditionTreeNodesInstanciate(Collection&lt;BRConditionTreeNode&gt; BRConditionTreeNodes, MemberTypeContextIdentifier BRId)
        {

            try
            {
                //Add BRConditionTreeNode to BRConditionTreeNode Collection

                Collection&lt;BRConditionTreeNode&gt; newBRConditionTreeNodes = new Collection&lt;BRConditionTreeNode&gt;();

                foreach (BRConditionTreeNode brctn in BRConditionTreeNodes)
                {
                    BRConditionTreeNode BRConditionTreeNodeItem = new BRConditionTreeNode();
                    //Add Attribute and Action type to the collection
                    BRConditionTreeNodeItem.BRConditions = BRConditionsInstanciate(brctn.BRConditions, BRId);
                    BRConditionTreeNodeItem.BusinessRuleId = BRId;
                    BRConditionTreeNodeItem.ConditionTreeChildNodes = brctn.ConditionTreeChildNodes;
                    BRConditionTreeNodeItem.ConditionTreeParentNode = brctn.ConditionTreeParentNode;
                    BRConditionTreeNodeItem.LogicalOperator = brctn.LogicalOperator;
                    BRConditionTreeNodeItem.Identifier = new Identifier() { Name = brctn.Identifier.Name, Id = Guid.NewGuid() };

                    //All Action and Condition Items must have a sequence greater that zero
                    BRConditionTreeNodeItem.Sequence = brctn.Sequence;
                    newBRConditionTreeNodes.Add(BRConditionTreeNodeItem);
                }
                return newBRConditionTreeNodes;
            }
            catch (Exception exc)
            {
                throw exc;
            }
        }

        private Collection&lt;BRAction&gt; BRActionsInstanciate(Collection&lt;BRAction&gt; BRActions, MemberTypeContextIdentifier BRId)
        {

            try
            {
                //Add Action to Action Collection

                Collection&lt;BRAction&gt; newBRActions = new Collection&lt;BRAction&gt;();

                foreach (BRAction bra in BRActions)
                {
                    BRAction BRActionItem = new BRAction() { Identifier = new Identifier() { Id = Guid.NewGuid(), Name = bra.Identifier.Name }, BusinessRuleId = BRId };
                    //Add Attribute and Action type to the collection
                    BRActionItem.PrefixArgument = new BRAttributeArgument();
                    BRActionItem.PrefixArgument.PropertyName = bra.PrefixArgument.PropertyName;
                    BRActionItem.PrefixArgument.AttributeId = new Identifier();
                    BRActionItem.PrefixArgument.AttributeId.Id = Guid.NewGuid();
                    BRActionItem.PrefixArgument.AttributeId.Name = bra.PrefixArgument.AttributeId.Name;
                    BRActionItem.Operator = bra.Operator;
                    var colBRffa = new Collection&lt;object&gt;();
                    foreach (var brffa in bra.PostfixArguments)
                    {
                        BRBlankArgument BRba = brffa as BRBlankArgument;
                        BRFreeformArgument BRffa = brffa as BRFreeformArgument;
                        if (BRba != null)
                        {
                            colBRffa.Add(new BRBlankArgument() { Identifier = new Identifier() { Id = Guid.NewGuid(), Name = BRba.Identifier.Name }, PropertyName = BRba.PropertyName });

                        }
                        else
                        {
                            if (BRffa != null)
                            {
                                colBRffa.Add(new BRFreeformArgument() { Identifier = new Identifier() { Id = Guid.NewGuid(), Name = BRffa.Identifier.Name }, Value = BRffa.Value, PropertyName = BRffa.PropertyName });

                            }
                        }
                    }
                    BRActionItem.PostfixArguments = colBRffa;
                    BRActionItem.Text = bra.Text;

                    //All Action and Condition Items must have a sequence greater that zero
                    BRActionItem.Sequence = bra.Sequence;
                    newBRActions.Add(BRActionItem);
                }
                return newBRActions;
            }
            catch (Exception exc)
            {
                throw exc;
            }
        }
        public Collection&lt;BRCondition&gt; BRConditionsInstanciate(Collection&lt;BRCondition&gt; BRconditions, MemberTypeContextIdentifier BRId)
        {

            try
            {
                //Add Action to Action Collection

                Collection&lt;BRCondition&gt; newBRconditions = new Collection&lt;BRCondition&gt;();
                BRCondition BRConditionItem = new BRCondition();

                foreach (BRCondition brc in BRconditions)
                {
                    //Add Attribute and Action type to the collection
                    BRConditionItem.BusinessRuleId = BRId;

                    BRConditionItem.ConditionTreeNodeId = new Identifier() { Name = brc.ConditionTreeNodeId.Name };
                    BRConditionItem.Identifier = new Identifier() { Id = Guid.NewGuid(), Name = brc.Identifier.Name };
                    BRConditionItem.Operator = brc.Operator;
                    BRConditionItem.PrefixArgument = brc.PrefixArgument;
                    BRConditionItem.PostfixArguments = brc.PostfixArguments;
                    //All Action and Condition Items must have a sequence greater that zero
                    BRConditionItem.Sequence = brc.Sequence;
                    BRConditionItem.Text = brc.Text;
                    newBRconditions.Add(BRConditionItem);
                }
                return newBRconditions;
            }
            catch (Exception exc)
            {
                throw exc;
            }
        }

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

private Collection<BRConditionTreeNode> BRConditionTreeNodesInstanciate(Collection<BRConditionTreeNode> BRConditionTreeNodes, MemberTypeContextIdentifier BRId)

{

try

{

//Add BRConditionTreeNode to BRConditionTreeNode Collection

Collection<BRConditionTreeNode> newBRConditionTreeNodes = new Collection<BRConditionTreeNode>();

foreach (BRConditionTreeNode brctn in BRConditionTreeNodes)

{

BRConditionTreeNode BRConditionTreeNodeItem = new BRConditionTreeNode();

//Add Attribute and Action type to the collection

BRConditionTreeNodeItem.BRConditions = BRConditionsInstanciate(brctn.BRConditions, BRId);

BRConditionTreeNodeItem.BusinessRuleId = BRId;

BRConditionTreeNodeItem.ConditionTreeChildNodes = brctn.ConditionTreeChildNodes;

BRConditionTreeNodeItem.ConditionTreeParentNode = brctn.ConditionTreeParentNode;

BRConditionTreeNodeItem.LogicalOperator = brctn.LogicalOperator;

BRConditionTreeNodeItem.Identifier = new Identifier() { Name = brctn.Identifier.Name, Id = Guid.NewGuid() };

//All Action and Condition Items must have a sequence greater that zero

BRConditionTreeNodeItem.Sequence = brctn.Sequence;

newBRConditionTreeNodes.Add(BRConditionTreeNodeItem);

}

return newBRConditionTreeNodes;

}

catch (Exception exc)

{

throw exc;

}

private Collection<BRAction> BRActionsInstanciate(Collection<BRAction> BRActions, MemberTypeContextIdentifier BRId)

{

try

{

//Add Action to Action Collection

Collection<BRAction> newBRActions = new Collection<BRAction>();

foreach (BRAction bra in BRActions)

{

BRAction BRActionItem = new BRAction() { Identifier = new Identifier() { Id = Guid.NewGuid(), Name = bra.Identifier.Name }, BusinessRuleId = BRId };

//Add Attribute and Action type to the collection

BRActionItem.PrefixArgument = new BRAttributeArgument();

BRActionItem.PrefixArgument.PropertyName = bra.PrefixArgument.PropertyName;

BRActionItem.PrefixArgument.AttributeId = new Identifier();

BRActionItem.PrefixArgument.AttributeId.Id = Guid.NewGuid();

BRActionItem.PrefixArgument.AttributeId.Name = bra.PrefixArgument.AttributeId.Name;

BRActionItem.Operator = bra.Operator;

var colBRffa = new Collection<object>();

foreach (var brffa in bra.PostfixArguments)

{

BRBlankArgument BRba = brffa as BRBlankArgument;

BRFreeformArgument BRffa = brffa as BRFreeformArgument;

if (BRba != null)

{

colBRffa.Add(new BRBlankArgument() { Identifier = new Identifier() { Id = Guid.NewGuid(), Name = BRba.Identifier.Name }, PropertyName = BRba.PropertyName });

}

else

{

if (BRffa != null)

{

colBRffa.Add(new BRFreeformArgument() { Identifier = new Identifier() { Id = Guid.NewGuid(), Name = BRffa.Identifier.Name }, Value = BRffa.Value, PropertyName = BRffa.PropertyName });

}

BRActionItem.PostfixArguments = colBRffa;

BRActionItem.Text = bra.Text;

//All Action and Condition Items must have a sequence greater that zero

BRActionItem.Sequence = bra.Sequence;

newBRActions.Add(BRActionItem);

}

return newBRActions;

}

catch (Exception exc)

{

throw exc;

}

public Collection<BRCondition> BRConditionsInstanciate(Collection<BRCondition> BRconditions, MemberTypeContextIdentifier BRId)

{

try

{

//Add Action to Action Collection

Collection<BRCondition> newBRconditions = new Collection<BRCondition>();

BRCondition BRConditionItem = new BRCondition();

foreach (BRCondition brc in BRconditions)

{

//Add Attribute and Action type to the collection

BRConditionItem.BusinessRuleId = BRId;

BRConditionItem.ConditionTreeNodeId = new Identifier() { Name = brc.ConditionTreeNodeId.Name };

BRConditionItem.Identifier = new Identifier() { Id = Guid.NewGuid(), Name = brc.Identifier.Name };

BRConditionItem.Operator = brc.Operator;

BRConditionItem.PrefixArgument = brc.PrefixArgument;

BRConditionItem.PostfixArguments = brc.PostfixArguments;

//All Action and Condition Items must have a sequence greater that zero

BRConditionItem.Sequence = brc.Sequence;

BRConditionItem.Text = brc.Text;

newBRconditions.Add(BRConditionItem);

}

return newBRconditions;

}

catch (Exception exc)

{

throw exc;

}

Master Data Services : Cross Model entity Copy

By Xavier | September 19, 2011 - 21:36 | Master Data Services

Leave a comment

Hi all,

One of the missing things in MDS is the cross-model entity copy

here is a API usage example for copying an entity from a model /version to another (or even copy an entity into a new model with a new entity name).

you can download the complete source code of my codeplex tool including this sample on : http://mdsmanager.codeplex.com

note: if source entity contains domain based attributes, and if the target model does not contain the domain based attribute parent entity, the attribute type will automatically converted to “Freeform” instead of “Domain based attribute”.

 private void CopyEntity(Identifier newModelId, Identifier versionId, Entity EntityToCopy)
        {
            OperationResult or = new OperationResult();

            try
            {
                Cursor.Current = Cursors.WaitCursor;

                Common.MDS_WS mds = new MDS_WS();
                //create a new guid for the new entity (target entity must NOT have the same ID than the source entity)             
    Guid newEntityId = Guid.NewGuid();

                //create a new metadata instance      
           Metadata md = new Metadata();
                md.Entities = new Collection();

                //add a new entity in this new metadata, with values and fields from source entity
                md.Entities.Add(new Entity()
                {
                    Identifier = new ModelContextIdentifier() { ModelId = newModelId, Name = !string.IsNullOrEmpty(txtNewEntityName.Text) ? txtNewEntityName.Text : EntityToCopy.Identifier.Name, Id = newEntityId },
                    AuditInfo = EntityToCopy.AuditInfo,
                    ExtensionData = EntityToCopy.ExtensionData,
                    ExplicitHierarchies = EntityToCopy.ExplicitHierarchies,
                    IsBase = EntityToCopy.IsBase,
                    IsFlat = EntityToCopy.IsFlat,
                    IsSystem = EntityToCopy.IsSystem
                });

                //publish this new entity
                using (ServiceClient c = MDS_WSConnect.CreateMdsProxy())
                {
                    Metadata retMd = c.MetadataCreate(new International(), md, true, out or);

                    //get source entity attributes
                    md = mds.GetMetaData(new International(), ref or, (Identifier)cbModel.SelectedItem, ((CustomVersion)cbVersion.SelectedItem).Identifier, EntityToCopy.Identifier, MDS_WS.MDAction.AttributesDetails);

                    //create a new metadata instance for attributes to copy
                    Metadata newMD = new Metadata();
                    newMD.Attributes = new Collection();

                    //for each source entity attribute, create a new attribute containing values and fields from this source entity
                    foreach (MetadataAttribute oldMA in md.Attributes)
                    {
                        MetadataAttribute ma = new MetadataAttribute()
                        {
                            AttributeType = oldMA.AttributeType,
                            Identifier = new MemberTypeContextIdentifier()
                            {
                                //entityId is coming from the target entity                               
  EntityId = retMd.Entities.First().Identifier,
                                //Id  is coming from the target entity
                                Id = retMd.Entities.First().Identifier.Id,
                                //internal Id  is coming from the target entity                             
    InternalId = retMd.Entities.First().Identifier.InternalId,
                                ModelId = newModelId,
                                MemberType = oldMA.Identifier.MemberType,
                                Name = oldMA.Identifier.Name
                            },
                            DataType = oldMA.DataType,
                            DataTypeInformation = oldMA.DataTypeInformation,
                            AuditInfo = oldMA.AuditInfo,
                            ChangeTrackingGroup = oldMA.ChangeTrackingGroup,
                            DisplayWidth = oldMA.DisplayWidth,
                            ExtensionData = oldMA.ExtensionData,

                            InputMaskId = oldMA.InputMaskId,
                            IsCode = oldMA.IsCode,
                            IsName = oldMA.IsName,
                            IsReadOnly = oldMA.IsReadOnly,
                            IsSystem = oldMA.IsSystem,
                            Permission = oldMA.Permission,
                            SortOrder = oldMA.SortOrder

                        };

                        //add all destination attributes to the metadata
                        newMD.Attributes.Add(ma);
                    }
                    //create the attributes metadata
                    c.MetadataCreate(new International(), newMD, true, out or);

                }
                //if operation is done and no error, displays message             
    if (or != null &amp;&amp; or.Errors.Count == 0)
                    MessageBox.Show("DONE!");
            }
            catch (Exception ex)
            {
                //to displays errors if any             
    StringBuilder sb = new StringBuilder();
                if (or != null &amp;&amp; or.Errors.Count &gt; 0)
                {

                    foreach (Error err in or.Errors)
                    {
                        sb.AppendFormat("{0}" + Environment.NewLine, err.Code + " - " + err.Description);
                    }
                }

                if (sb.Length &gt; 0)
                {
                    throw new Exception(sb.ToString());
                }
                else
                {
                    throw ex;
                }

            }
            finally
            {
                Cursor.Current = Cursors.Default;
            }
        }

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

private void CopyEntity(Identifier newModelId, Identifier versionId, Entity EntityToCopy)

{

OperationResult or = new OperationResult();

try

{

Cursor.Current = Cursors.WaitCursor;

Common.MDS_WS mds = new MDS_WS();

//create a new guid for the new entity (target entity must NOT have the same ID than the source entity)

Guid newEntityId = Guid.NewGuid();

//create a new metadata instance

Metadata md = new Metadata();

md.Entities = new Collection();

//add a new entity in this new metadata, with values and fields from source entity

md.Entities.Add(new Entity()

{

Identifier = new ModelContextIdentifier() { ModelId = newModelId, Name = !string.IsNullOrEmpty(txtNewEntityName.Text) ? txtNewEntityName.Text : EntityToCopy.Identifier.Name, Id = newEntityId },

AuditInfo = EntityToCopy.AuditInfo,

ExtensionData = EntityToCopy.ExtensionData,

ExplicitHierarchies = EntityToCopy.ExplicitHierarchies,

IsBase = EntityToCopy.IsBase,

IsFlat = EntityToCopy.IsFlat,

IsSystem = EntityToCopy.IsSystem

});

//publish this new entity

using (ServiceClient c = MDS_WSConnect.CreateMdsProxy())

{

Metadata retMd = c.MetadataCreate(new International(), md, true, out or);

//get source entity attributes

md = mds.GetMetaData(new International(), ref or, (Identifier)cbModel.SelectedItem, ((CustomVersion)cbVersion.SelectedItem).Identifier, EntityToCopy.Identifier, MDS_WS.MDAction.AttributesDetails);

//create a new metadata instance for attributes to copy

Metadata newMD = new Metadata();

newMD.Attributes = new Collection();

//for each source entity attribute, create a new attribute containing values and fields from this source entity

foreach (MetadataAttribute oldMA in md.Attributes)

{

MetadataAttribute ma = new MetadataAttribute()

{

AttributeType = oldMA.AttributeType,

Identifier = new MemberTypeContextIdentifier()

{

//entityId is coming from the target entity

EntityId = retMd.Entities.First().Identifier,

//Id is coming from the target entity

Id = retMd.Entities.First().Identifier.Id,

//internal Id is coming from the target entity

InternalId = retMd.Entities.First().Identifier.InternalId,

ModelId = newModelId,

MemberType = oldMA.Identifier.MemberType,

Name = oldMA.Identifier.Name

DataType = oldMA.DataType,

DataTypeInformation = oldMA.DataTypeInformation,

AuditInfo = oldMA.AuditInfo,

ChangeTrackingGroup = oldMA.ChangeTrackingGroup,

DisplayWidth = oldMA.DisplayWidth,

ExtensionData = oldMA.ExtensionData,

InputMaskId = oldMA.InputMaskId,

IsCode = oldMA.IsCode,

IsName = oldMA.IsName,

IsReadOnly = oldMA.IsReadOnly,

IsSystem = oldMA.IsSystem,

Permission = oldMA.Permission,

SortOrder = oldMA.SortOrder

};

//add all destination attributes to the metadata

newMD.Attributes.Add(ma);

}

//create the attributes metadata

c.MetadataCreate(new International(), newMD, true, out or);

}

//if operation is done and no error, displays message

if (or != null && or.Errors.Count == 0)

MessageBox.Show("DONE!");

}

catch (Exception ex)

{

//to displays errors if any

StringBuilder sb = new StringBuilder();

if (or != null && or.Errors.Count > 0)

{

foreach (Error err in or.Errors)

{

sb.AppendFormat("{0}" + Environment.NewLine, err.Code + " - " + err.Description);

}

if (sb.Length > 0)

{

throw new Exception(sb.ToString());

}

else

{

throw ex;

}

finally

{

Cursor.Current = Cursors.Default;

}

Tag Archives: mds

Master Data Services : Business Rules Copy / Import / Export (Cross Model)

Master Data Services : Cross Model entity Copy

Liens