Pramod Raising: Create Global Variable in xsl and value assign by c sharp function in xsl all those thing in one xsl

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:tns="urn:thisnamespace:tns" exclude-result-prefixes="tns msxsl"
>
<xsl:output method="xml" indent="yes" encoding="utf-8" omit-xml-declaration="yes"/>
<xsl:param name="currentPage"/>
<xsl:param name="PageUrl" />
<xsl:param name="url"/>
<xsl:param name="hanmant"/>
<xsl:param name="date" />

<msxsl:script language="C#" implements-prefix="tns">
<msxsl:assembly name="System" />
<msxsl:using namespace="System" />
<msxsl:assembly name="System.Web" />
<msxsl:using namespace="System.Web" />
<msxsl:assembly name="System.Configuration"/>
<msxsl:using namespace="System.Configuration"/>
<msxsl:using namespace="System.Xml"/>
<msxsl:using namespace="System.Xml.XPath"/>
<msxsl:assembly name="System.Data"/>
<msxsl:using namespace="System.Data"/>
<msxsl:using namespace="System.Data.SqlClient"/>
<![CDATA[

public string databaseaccess()
{
String query, kk= "<table border='1px'><tr><td>Sr no.</td><td>Name</td><td>File Path</td></tr>";
try
{
SqlConnection con = new SqlConnection("Data Source=INMUBLBW0709\\SQLEXPRESS2008;Initial Catalog=idfcmf;Persist Security Info=True;User ID=sa;Password=admin123");
con.Open();
int i=0;
query = "select * from DownloadCenter";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader dr;
//cmd.Parameters.Add("@id", SqlDbType.Int).Value = name.Value;
//cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = address.Value;
dr = cmd.ExecuteReader();
dr.Read();
while (dr.Read())
{
i=i+1;
kk = kk+"<tr><td> "+i+" </td><td>"+ dr["Title"].ToString()+"</td><td>"+ dr["uploadfile"].ToString()+"</td></tr>";
//Text3.Value = dr(1)
}
kk = kk + "</table>";
}
catch (Exception ex)
{
return ex.ToString();
}
return kk;

}

public string readxml()
{
string xmlstring = "<table border='1px'><tr><td>Sr no.</td><td>Name</td></tr>";
int i=0;
string link1 = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["NavXML"]);
try
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(link1);

XmlNode titleNode = xmlDoc.SelectSingleNode("site//global");

foreach (XmlNode xn in titleNode)
{
i=i+1;
try
{
xmlstring = xmlstring +"<tr><td> "+i+" </td><td>"+ xn.Attributes["caption"].Value +"</td></tr>";//innertext
}
catch
{
}

}
xmlstring = xmlstring + "</table>";

}
catch (Exception ex)
{
return ex.ToString();
}

return xmlstring;
}

public string LinkFile()
{
string link = System.Configuration.ConfigurationManager.AppSettings["SiteURL"];
return link;
}

public double calculation(double radius){
double pi = 3.14;
double circ = pi*radius*2;
return circ;
}

public string circumference()
{
DateTime date = DateTime.Now;
string vv =date.ToString()+HttpContext.Current.Request.Url.AbsoluteUri.ToString().ToLower().Replace("http://"+HttpContext.Current.Request.Url.Authority.ToString(),"");// date.ToString();
return vv;
}
public string mydate()
{
DateTime date = DateTime.Now;
string vv = date.ToString();
return vv;
}
]]>

</msxsl:script>

<xsl:variable name="cdtitle">
<xsl:value-of select="tns:readxml()"/>
</xsl:variable>
<xsl:param name="date1" >
<xsl:value-of select="tns:mydate()"/>
</xsl:param>
<xsl:variable name="smallcase" select="'abcdefghijklmnopqrstuvwxyz'" />
<xsl:variable name="uppercase" select="'ABCDEFGHIJKLMNOPQRSTUVWXYZ'" />

<xsl:template match="/">
<xsl:text disable-output-escaping="yes">
<![CDATA[
<script type="text/javascript">

function callme() {
alert('pramod');
}
</script>
]]>
</xsl:text>
<br/><xsl:value-of select="$cdtitle"/><br/>
<div onclick="callme();">
<xsl:value-of select="tns:circumference()"/></div>

after load Request.Url.ToString():= <input type="button" value="Stampa" onclick="callme();"></input>

<xsl:value-of select="$hanmant"/> <xsl:value-of select="$currentPage"/>
<xsl:value-of select="$date1"/>new
<xsl:apply-templates select="." mode="GetData" />
</xsl:template>
<xsl:template match="site" mode="GetData">

<xsl:for-each select="main/page">
11<xsl:value-of select="current()"/>22
<ul class="col{position()}">
<li>
<span>

pramod:--
<xsl:value-of select="$date"/>
--tests
<xsl:value-of select="@caption"/>
</span>
<span>

<xsl:value-of select="@caption"/>
</span>
<xsl:call-template name="drawChildNodes">
<xsl:with-param name="parentnode" select="."/>
</xsl:call-template>
</li>
</ul>
</xsl:for-each>
</xsl:template>

<xsl:template name="drawChildNodes">
<xsl:param name="parentnode"></xsl:param>

<xsl:if test="count($parentnode/page) > 0">
<ul>
<xsl:for-each select="$parentnode/page">


<li >

<xsl:if test="$currentPage=translate(@link, $uppercase , $smallcase)">
<xsl:attribute name="style">color:Red</xsl:attribute>
</xsl:if>
<xsl:choose>
<xsl:when test="@label=1">

<span>

<xsl:value-of select="@caption"/>

</span>
</xsl:when>
<xsl:otherwise>
<a href="#" rel="{@rel}">


<xsl:if test="@class!=''">
<xsl:attribute name="class">
<xsl:value-of select="@class"/>
</xsl:attribute>
</xsl:if>


<xsl:if test="@link!=''">
<xsl:attribute name="href">
<xsl:value-of select="@link"/>
</xsl:attribute>
</xsl:if>
<xsl:if test="@target!=''">
<xsl:attribute name="target">
<xsl:value-of select="@target"/>
</xsl:attribute>
</xsl:if>
<xsl:value-of select="@caption"/>
</a>
</xsl:otherwise>
</xsl:choose>
<xsl:if test="number(@level) <= 2">
<xsl:call-template name="drawChildNodes">
<xsl:with-param name="parentnode" select="."/>
</xsl:call-template>
</xsl:if>
</li>
</xsl:for-each>
</ul>

</xsl:if>
</xsl:template>
</xsl:stylesheet>

Pramod Raising

Monday, 9 June 2014

Create Global Variable in xsl and value assign by c sharp function in xsl all those thing in one xsl

No comments:

Post a Comment