Okay I have a client running AspDotNetStoreFront multistore. They would like affiliates to be able to see a report of their sales. I assumed I could perhaps right an XML to do this but it isn't working out that easily. I was thinking if the Affiliate logs in the AffiliateID is stored. I was hoping to write a SQL calling on OrderNumber that matches the AffiliateID and then from Order_ShoppingCart show the Date, productID and OrderedProductPrice. I know this won't show commissions but I figured if I can show this much I'm headed in the right direction. I started writing the xml but it doesn't even like my sql which isn't complete.
The code below doesn't show anything at this point. But it throws an error when i try to view it in my browser. You help, suggestions, comments are greatly appreciated.
Thank you in advance.
<?xml version="1.0" standalone="yes" ?>
<query name="AffiliateReport" rowElementName="AffiliateOrders">
SELECT * FROM OrderNumber A with (NOLOCK)
WHERE A.AffiliateID = @affiliateID
sqlDataType="int" defvalue="0" validationpattern="" />
<xsl:output method="html" omit-xml-declaration="yes" />
<xsl:param name="AffiliateID" select="/root/Runtime/AffiliateID" />