/// <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; } }