How Maps Works - Simple BizTalk Map XSLT (compiled)

HowMapsWorks.xls

<?xml version="1.0" encoding="UTF-16"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var" exclude-result-prefixes="msxsl var s0 userCSharp" version="1.0" xmlns:ns0="http://HowMapsWorks.PersonTarget2" xmlns:s0="http://HowMapsWorks.PersonOrigin" xmlns:userCSharp="http://schemas.microsoft.com/BizTalk/2003/userCSharp">
  <xsl:output omit-xml-declaration="yes" method="xml" version="1.0" />
  <xsl:template match="/">
    <xsl:apply-templates select="/s0:PersonOrigin" />
  </xsl:template>
  <xsl:template match="/s0:PersonOrigin">
    <xsl:variable name="var:v1" select="userCSharp:LogicalExistence(boolean(ZipCode))" />
    <xsl:variable name="var:v3" select="userCSharp:StringConcat(string(LastName/text()) , &quot;, &quot; , string(FirstName/text()))" />
    <ns0:PersonTarget2>
      <Address>
        <xsl:value-of select="Address/text()" />
      </Address>
      <xsl:if test="string($var:v1)='true'">
        <xsl:variable name="var:v2" select="ZipCode/text()" />
        <ZipCode>
          <xsl:value-of select="$var:v2" />
        </ZipCode>
      </xsl:if>
      <FullName>
        <xsl:value-of select="$var:v3" />
      </FullName>
      <xsl:variable name="var:v4" select="userCSharp:CalculateMyAge(string(DateOfBirth/text()))" />
      <Age>
        <xsl:value-of select="$var:v4" />
      </Age>
      <PhoneBilling>
        <xsl:variable name="var:v5" select="userCSharp:InitCumulativeSum(0)" />
        <xsl:for-each select="/s0:PersonOrigin/PhoneCalls">
          <xsl:variable name="var:v6" select="userCSharp:StringLeft(string(@PhoneNumber) , &quot;4&quot;)" />
          <xsl:variable name="var:v7" select="userCSharp:LogicalEq(string($var:v6) , &quot;+351&quot;)" />
          <xsl:variable name="var:v8" select="userCSharp:LogicalNot(string($var:v7))" />
          <xsl:if test="string($var:v8)='true'">
            <xsl:variable name="var:v9" select="@Cost" />
            <xsl:variable name="var:v10" select="userCSharp:AddToCumulativeSum(0,string($var:v9),&quot;1000&quot;)" />
          </xsl:if>
        </xsl:for-each>
        <xsl:variable name="var:v11" select="userCSharp:GetCumulativeSum(0)" />
        <TotalInternational>
          <xsl:value-of select="$var:v11" />
        </TotalInternational>
        <xsl:variable name="var:v12" select="userCSharp:InitCumulativeSum(1)" />
        <xsl:for-each select="/s0:PersonOrigin/PhoneCalls">
          <xsl:variable name="var:v13" select="string(@PhoneNumber)" />
          <xsl:variable name="var:v14" select="userCSharp:StringLeft($var:v13 , &quot;4&quot;)" />
          <xsl:variable name="var:v15" select="userCSharp:LogicalEq(string($var:v14) , &quot;+351&quot;)" />
          <xsl:if test="string($var:v15)='true'">
            <xsl:variable name="var:v16" select="@Cost" />
            <xsl:variable name="var:v17" select="userCSharp:AddToCumulativeSum(1,string($var:v16),&quot;1000&quot;)" />
          </xsl:if>
        </xsl:for-each>
        <xsl:variable name="var:v18" select="userCSharp:GetCumulativeSum(1)" />
        <TotalNational>
          <xsl:value-of select="$var:v18" />
        </TotalNational>
      </PhoneBilling>
    </ns0:PersonTarget2>
  </xsl:template>
  <msxsl:script language="C#" implements-prefix="userCSharp"><![CDATA[
public string StringConcat(string param0, string param1, string param2)
{
   return param0 + param1 + param2;
}


public int CalculateMyAge(string dateBirth)
{
   return (int)(DateTime.Now.Subtract(DateTime.Parse(dateBirth)).TotalDays / 365.25);          
}

public bool LogicalExistence(bool val)
{
	return val;
}


public string StringLeft(string str, string count)
{
	string retval = "";
	double d = 0;
	if (str != null && IsNumeric(count, ref d))
	{
		int i = (int) d;
		if (i > 0)
		{ 
			if (i <= str.Length)
			{
				retval = str.Substring(0, i);
			}
			else
			{
				retval = str;
			}
		}
	}
	return retval;
}


public bool LogicalEq(string val1, string val2)
{
	bool ret = false;
	double d1 = 0;
	double d2 = 0;
	if (IsNumeric(val1, ref d1) && IsNumeric(val2, ref d2))
	{
		ret = d1 == d2;
	}
	else
	{
		ret = String.Compare(val1, val2, StringComparison.Ordinal) == 0;
	}
	return ret;
}


public bool LogicalNot(string val)
{
	return !ValToBool(val);
}


public string InitCumulativeSum(int index)
{
	if (index >= 0)
	{
		if (index >= myCumulativeSumArray.Count)
		{
			int i = myCumulativeSumArray.Count;
			for (; i<=index; i++)
			{
				myCumulativeSumArray.Add("");
			}
		}
		else
		{
			myCumulativeSumArray[index] = "";
		}
	}
	return "";
}

public System.Collections.ArrayList myCumulativeSumArray = new System.Collections.ArrayList();

public string AddToCumulativeSum(int index, string val, string notused)
{
	if (index < 0 || index >= myCumulativeSumArray.Count)
	{
		return "";
    }
	double d = 0;
	if (IsNumeric(val, ref d))
	{
		if (myCumulativeSumArray[index] == "")
		{
			myCumulativeSumArray[index] = d;
		}
		else
		{
			myCumulativeSumArray[index] = (double)(myCumulativeSumArray[index]) + d;
		}
	}
	return (myCumulativeSumArray[index] is double) ? ((double)myCumulativeSumArray[index]).ToString(System.Globalization.CultureInfo.InvariantCulture) : "";
}

public string GetCumulativeSum(int index)
{
	if (index < 0 || index >= myCumulativeSumArray.Count)
	{
		return "";
	}
	return (myCumulativeSumArray[index] is double) ? ((double)myCumulativeSumArray[index]).ToString(System.Globalization.CultureInfo.InvariantCulture) : "";
}

public bool IsNumeric(string val)
{
	if (val == null)
	{
		return false;
	}
	double d = 0;
	return Double.TryParse(val, System.Globalization.NumberStyles.AllowThousands | System.Globalization.NumberStyles.Float, System.Globalization.CultureInfo.InvariantCulture, out d);
}

public bool IsNumeric(string val, ref double d)
{
	if (val == null)
	{
		return false;
	}
	return Double.TryParse(val, System.Globalization.NumberStyles.AllowThousands | System.Globalization.NumberStyles.Float, System.Globalization.CultureInfo.InvariantCulture, out d);
}

public bool ValToBool(string val)
{
	if (val != null)
	{
		if (string.Compare(val, bool.TrueString, StringComparison.OrdinalIgnoreCase) == 0)
		{
			return true;
		}
		if (string.Compare(val, bool.FalseString, StringComparison.OrdinalIgnoreCase) == 0)
		{
			return false;
		}
		val = val.Trim();
		if (string.Compare(val, bool.TrueString, StringComparison.OrdinalIgnoreCase) == 0)
		{
			return true;
		}
		if (string.Compare(val, bool.FalseString, StringComparison.OrdinalIgnoreCase) == 0)
		{
			return false;
		}
		double d = 0;
		if (IsNumeric(val, ref d))
		{
			return (d > 0);
		}
	}
	return false;
}


]]></msxsl:script>
</xsl:stylesheet>