internal void WriteOperationActionElement(string elementName, OperationAction operationAction)
{
DebugCheck.NotEmpty(elementName);
_xmlWriter.WriteStartElement(elementName);
_xmlWriter.WriteAttributeString(XmlConstants.Action, operationAction.ToString());
_xmlWriter.WriteEndElement();
}
public string ToXml()
{
StringBuilder XmlBuilder = new StringBuilder();
if (IsChild == false)
{
XmlBuilder.Append("<?xml version=\"1.0\" encoding=\"utf-8\"?><Input>");
}
else
{
XmlBuilder.Append("<Child>");
}
XmlBuilder.Append("<From>" + From + "</From>");
XmlBuilder.Append("<Entity name=\"" + Name + "\">");
XmlBuilder.Append("<Action>" + OperationAction.ToString() + "</Action>");
XmlBuilder.Append("<PKSourceField name=\"opportunityid\">" + this.PKSourceID + "</PKSourceField><PKDestinationField name=\"new_sfdcrenewalopportunityid\">" + this.PKDestinationID + "</PKDestinationField>");
XmlBuilder.Append("<Data>");
foreach (Field Childfield in Fields)
{
XmlBuilder.Append(Childfield.ToXml());
}
XmlBuilder.Append("</Data>");
XmlBuilder.Append("<Childs>");
foreach (SyncEntity Ch in ChildEntity)
{
XmlBuilder.Append(Ch.ToXml());
}
XmlBuilder.Append("</Childs>");
XmlBuilder.Append("</Entity>");
if (IsChild == false)
{
XmlBuilder.Append("</Input>");
}
else
{
XmlBuilder.Append("</Child>");
}
return(XmlBuilder.ToString());
}
private string GetAssociationCreateScript(AssociationType a)
{
StringBuilder sql = new StringBuilder();
StringBuilder keySql = new StringBuilder();
if (a.IsForeignKey)
{
EntityType childType = (EntityType)a.ReferentialConstraints[0].ToProperties[0].DeclaringType;
EntityType parentType = (EntityType)a.ReferentialConstraints[0].FromProperties[0].DeclaringType;
string fkName = a.Name;
if (fkName.Length > 64)
{
fkName = "FK_" + Guid.NewGuid().ToString().Replace("-", "");
}
sql.AppendLine(String.Format(
"ALTER TABLE `{0}` ADD CONSTRAINT {1}", _pluralizedNames[childType.Name], fkName));
sql.Append("\t FOREIGN KEY (");
string delimiter = "";
foreach (EdmProperty p in a.ReferentialConstraints[0].ToProperties)
{
EdmMember member;
if (!childType.KeyMembers.TryGetValue(p.Name, false, out member))
{
keySql.AppendLine(String.Format(
"ALTER TABLE `{0}` ADD KEY (`{1}`);", _pluralizedNames[childType.Name], p.Name));
}
sql.AppendFormat("{0}{1}", delimiter, p.Name);
delimiter = ", ";
}
sql.AppendLine(")");
delimiter = "";
sql.Append(String.Format("\tREFERENCES `{0}` (", _pluralizedNames[parentType.Name]));
foreach (EdmProperty p in a.ReferentialConstraints[0].FromProperties)
{
EdmMember member;
if (!parentType.KeyMembers.TryGetValue(p.Name, false, out member))
{
keySql.AppendLine(String.Format(
"ALTER TABLE `{0}` ADD KEY (`{1}`);", _pluralizedNames[parentType.Name], p.Name));
}
sql.AppendFormat("{0}{1}", delimiter, p.Name);
delimiter = ", ";
}
sql.AppendLine(")");
OperationAction oa = a.AssociationEndMembers[0].DeleteBehavior;
sql.AppendLine(String.Format(" ON DELETE {0} ON UPDATE {1};",
oa == OperationAction.None ? "NO ACTION" : oa.ToString(), "NO ACTION"));
sql.AppendLine();
}
keySql.Append(sql.ToString());
return(keySql.ToString());
}
internal void WriteOperationActionElement(string elementName, OperationAction operationAction)
{
this._xmlWriter.WriteStartElement(elementName);
this._xmlWriter.WriteAttributeString("Action", operationAction.ToString());
this._xmlWriter.WriteEndElement();
}
internal void WriteOperationActionElement(string elementName, OperationAction operationAction)
{
DebugCheck.NotEmpty(elementName);
_xmlWriter.WriteStartElement(elementName);
_xmlWriter.WriteAttributeString(XmlConstants.Action, operationAction.ToString());
_xmlWriter.WriteEndElement();
}
private void WriteOperationActionElement(string elementName, OperationAction operationAction)
{
_writer.WriteStartElement(elementName);
_writer.WriteAttributeString(XmlConstants.Action, operationAction.ToString());
_writer.WriteEndElement();
}
public string GetKey()
{
return(Name + OperationAction.ToString());
}
