using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Text;
using System.Data;
using CMS.Helpers;
using CMS.Taxonomy;

public class CategoriesFunctions
{
    public static string GetCategories(string docID, string path = "~/blog")
    {
        bool firstItem = true;
        StringBuilder result = new StringBuilder();
        System.Data.DataSet ds = CategoryInfoProvider.GetCategories("CategoryID IN (SELECT CategoryID FROM CMS_DocumentCategory WHERE DocumentID = " + docID + ")", null);
        for (int i = 0; i < ds.Tables.Count; i++)
        {
            foreach (DataRow dtRow in ds.Tables[i].Rows)
            {
                if (!firstItem) result.Append(", ");
                result.Append("<a href='" + URLHelper.AddParameterToUrl(URLHelper.GetAbsoluteUrl(URLHelper.ResolveUrl(path)), "categoryid", dtRow["CategoryID"].ToString()) + "'>");
                result.Append(ResHelper.LocalizeString(dtRow["CategoryDisplayName"].ToString()));
                result.Append("</a>");
                firstItem = false;
            }
        }
        return result.ToString();
    }
}