<%@ Page Language="C#" %>

<%@ import Namespace="System" %>
<%@ import Namespace="System.Web" %>
<%@ import Namespace="System.Xml" %>
<%@ import Namespace="System.Text" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>

<script runat="server">

	private const int MAXENTRIES = 100;

	private void Page_Load(object sender, System.EventArgs e)
	{
		Response.ContentEncoding = Encoding.UTF8;
		Response.ContentType = "text/xml";

		// we will create this method later to render the XML 
		// feed to the Response stream sent back to the client
		renderFeed(this.userid, this.maxentries);
	}

	private string userid
	{
		get
		{
			object param = Request.QueryString["userid"];
			return param == null ? string.Empty : (string)param;
		}
	}

	private int maxentries
	{
		get
		{
			object param = Request.QueryString["maxentries"];
			return param == null ? MAXENTRIES : int.Parse((string)param);
		}
	}

</script>

private void renderFeed(string userid, int maxentries)
{
	// create an XML writer and supply the Response stream to output to
	XmlTextWriter w = new XmlTextWriter(Response.OutputStream, null);

	// start the RSS XML
	w.WriteStartElement("rss"); // rss
	w.WriteAttributeString("version", "2.0");
	w.WriteAttributeString("xmlns", "dc", null, "http://purl.org/dc/elements/1.1/");

	// add a channel with the channel information
	w.WriteStartElement("channel"); // channel
	w.WriteElementString("title","SalesLogix Latest Opportunities");
	w.WriteElementString("link","http://www.slxdeveloper.com/scripts/slxweb.dll/home");
	w.WriteElementString("description","This feed returns the latest opportunities in SalesLogix");

	// create a connection to the SalesLogix database. We'll use the SqlClient, instead of the SalesLogix
	// provider since we will be reading data only
	SqlConnection conn = new SqlConnection(@"server=morpheus\sql2000;database=saleslogix61_eval;uid=sysdba;pwd=masterkey");
	try
	{
		conn.Open();

		// execute a DataReader to read the opportunity data
		SqlCommand cmd = new SqlCommand(getOpportunitySql(userid, maxentries), conn);
		SqlDataReader r = cmd.ExecuteReader(CommandBehavior.CloseConnection);
		string tmp = string.Empty;

		while (r.Read())
		{
			// start creating the individual items for the feed
			w.WriteStartElement("item"); // item
			w.WriteElementString("title", r["description"].ToString());

			w.WriteStartElement("guid"); // guid
			w.WriteAttributeString("isPermaLink","false");
			w.WriteString("OpportunityID:" + r["opportunityid"].ToString());
			w.WriteEndElement(); // guid

			// this StringBuilder will hold the main content for each entry in the feed
			StringBuilder sb = new StringBuilder();
			sb.Append("The following opportunity has been created in SalesLogix:");
			sb.Append("<br><hr>");

			sb.Append("Opportunity: ");
			sb.Append(r["description"]);
			sb.Append("<br>");

			sb.Append("Account manager: ");
			sb.Append(r["username"]);
			sb.Append("<br><br>");

			sb.Append("Opportunity type: ");
			sb.Append(r["type"]);
			sb.Append("<br>");

			tmp = r["salespotential"].ToString();
			if (!tmp.Equals(string.Empty)) tmp = string.Format("{0:c}", r["salespotential"]);
			sb.Append("Sales potential: ");
			sb.Append(tmp);
			sb.Append("<br>");

			sb.Append("Account: ");
			sb.Append(r["account"]);
			sb.Append("<br><br>");

			sb.Append("Created on: ");
			sb.Append(DateTime.Parse(r["createdate"].ToString()).ToLongDateString());
			sb.Append("<br><br>");

			w.WriteElementString("description", sb.ToString());
			tmp = DateTime.Parse(r["createdate"].ToString()).ToUniversalTime().ToString("r");
			w.WriteElementString("pubDate", tmp);
			w.WriteElementString("category", "Latest Opportunities");
			w.WriteElementString("creator", "http://purl.org/dc/elements/1.1/", r["username"].ToString());
			w.WriteEndElement(); // item
		}
		r.Close();
	}
	finally
	{
		conn.Dispose();
	}

	w.WriteEndElement(); // channel
	w.WriteEndElement(); // rss

	// now flush the XML writer so it is written out to the Response stream and sent to the client
	w.Flush();
}

private string getOpportunitySql(string userid, int maxentries)
{
	// create the SQL statement used to gather the opportunity data
	StringBuilder sb = new StringBuilder();

	sb.Append("select top ");
	sb.Append(maxentries);
	sb.Append(" o1.opportunityid, o1.accountid, a1.account, o1.description, ");
	sb.Append("o1.type, o1.salespotential, u1.username, o1.createdate ");
	sb.Append("from opportunity o1 ");
	sb.Append("inner join account a1 on o1.accountid = a1.accountid ");
	sb.Append("inner join userinfo u1 on o1.accountmanagerid = u1.userid ");

	if (!userid.Equals(string.Empty))
	{
		sb.Append("where o1.accountmanagerid = '");
		sb.Append(userid);
		sb.Append("'");
	}
	sb.Append(" order by o1.createdate desc");

	return sb.ToString();
}

• Feed Demon
• SharpReader
• NewsGator
  (NewsGator is awesome, it is an addon to Outlook so your subscribed feeds are delivered right to Outlook folders)

• http://localhost/SalesLogixRSS/Rss.aspx
• http://localhost/SalesLogixRSS/Rss.aspx?maxentries=20
• http://localhost/SalesLogixRSS/Rss.aspx?userid=UAX040000001
• http://localhost/SalesLogixRSS/Rss.aspx?userid=UAX040000001&maxentries=15

   
Click to enlarge view

• 4/12/2004 - Updated code sample - forgot to close DataReader and convert pubdate in XML to universal time format. Related code download also updated.