%@ WebService Language="C#" Class="Utilities" %>
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;
[WebService(Namespace="http://selfservice.local/ESD/WS")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Utilities : System.Web.Services.WebService {
///
/// Convert any escaped characters in the input string.
///
///
///
[WebMethod(Description = "Get Custom Variables for a given catalog item.")]
public DataTable GetCatalogVariables(int catalogID)
{
String connString = AppPortal.Business.ESDConfig.getConnString();
DataTable dtSaaSVariables = new DataTable("variables");
string sqlQuery = @"SELECT [ID], [Key], [Value],[ORDER],[CatalogID],[Description] FROM [WD_CatalogVariable] WHERE [CatalogID] = " + catalogID + " ORDER BY [Order] ASC";
SqlDataAdapter da = new SqlDataAdapter(sqlQuery, connString);
da.Fill(dtSaaSVariables);
return dtSaaSVariables;
}
}