/// <summary>
/// Retieve all MacroProperties of a macro
/// </summary>
/// <param Name="MacroId">Macro identifier</param>
/// <returns>All MacroProperties of a macro</returns>
public static MacroProperty[] GetProperties(int MacroId)
{
int totalProperties = int.Parse(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(GlobalSettings.DbDSN, CommandType.Text, "select count(*) from cmsMacroProperty where macro = @macroID", new SqlParameter("@macroID", MacroId)).ToString());
int count = 0;
using (SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(GlobalSettings.DbDSN, CommandType.Text, "select id from cmsMacroProperty where macro = @macroId order by macroPropertySortOrder", new SqlParameter("@macroId", MacroId)))
{
MacroProperty[] retval = new MacroProperty[totalProperties];
while (dr.Read())
{
retval[count] = new MacroProperty(int.Parse(dr["id"].ToString()));
count++;
}
return(retval);
}
}
private void setup()
{
using (SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(GlobalSettings.DbDSN, CommandType.Text, "select macroUseInEditor, macroRefreshRate, macroAlias, macroName, macroScriptType, macroScriptAssembly, macroXSLT from cmsMacro where id = @id", new SqlParameter("@id", _id)))
{
if (dr.Read())
{
_useInEditor = bool.Parse(dr["macroUseInEditor"].ToString());
_refreshRate = int.Parse(dr["macroRefreshRate"].ToString());
_alias = dr["macroAlias"].ToString();
_name = dr["macroName"].ToString();
_assembly = dr["macroScriptAssembly"].ToString();
_type = dr["macroScriptType"].ToString();
_xslt = dr["macroXSLT"].ToString();
_properties = MacroProperty.GetProperties(_id);
}
}
}
/// <summary>
/// Retieve all MacroProperties of a macro
/// </summary>
/// <param Name="MacroId">Macro identifier</param>
/// <returns>All MacroProperties of a macro</returns>
public static MacroProperty[] GetProperties(int MacroId)
{
int totalProperties = int.Parse(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(GlobalSettings.DbDSN, CommandType.Text, "select count(*) from cmsMacroProperty where macro = @macroID", new SqlParameter("@macroID", MacroId)).ToString());
int count = 0;
using (SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(GlobalSettings.DbDSN, CommandType.Text, "select id from cmsMacroProperty where macro = @macroId order by macroPropertySortOrder", new SqlParameter("@macroId", MacroId)))
{
MacroProperty[] retval = new MacroProperty[totalProperties];
while(dr.Read())
{
retval[count] = new MacroProperty(int.Parse(dr["id"].ToString()));
count++;
}
return retval;
}
}
