private void PopulateTaskFromReader(IRecordsReader dr) { _id = dr.GetInt("id"); Type = new TaskType((int)dr.GetByte("taskTypeId")); Node = new CMSNode(dr.GetInt("nodeId")); ParentUser = User.GetUser(dr.GetInt("parentUserId")); User = User.GetUser(dr.GetInt("userId")); Date = dr.GetDateTime("DateTime"); Comment = dr.GetString("comment"); Closed = dr.GetBoolean("closed"); }
private void setup() { using (IRecordsReader dr = SqlHelper.ExecuteReader("select macro, macroPropertyHidden, macroPropertyType, macroPropertySortOrder, macroPropertyAlias, macroPropertyName from cmsMacroProperty where id = @id", SqlHelper.CreateParameter("@id", _id))) { if (dr.Read()) { m_macro = new Macro(dr.GetInt("macro")); _public = dr.GetBoolean("macroPropertyHidden"); _sortOrder = (int)dr.GetByte("macroPropertySortOrder"); _alias = dr.GetString("macroPropertyAlias"); _name = dr.GetString("macroPropertyName"); _type = new MacroPropertyType(dr.GetShort("macroPropertyType")); } else { throw new ArgumentException("No macro property found for the id specified"); } } }
/// <summary> /// Read all ApplicationTree data and store it in cache. /// </summary> private static void Cache() { //don't query the database if the cache is not null if (HttpRuntime.Cache[CACHE_KEY] == null) { lock (m_Locker) { if (HttpRuntime.Cache[CACHE_KEY] == null) { List <ApplicationTree> list = new List <ApplicationTree>(); using (IRecordsReader dr = SqlHelper.ExecuteReader(@"Select treeSilent, treeInitialize, treeSortOrder, appAlias, treeAlias, treeTitle, treeIconClosed, treeIconOpen, treeHandlerAssembly, treeHandlerType, action from umbracoAppTree order by treeSortOrder")) { while (dr.Read()) { list.Add(new ApplicationTree( dr.GetBoolean("treeSilent"), dr.GetBoolean("treeInitialize"), dr.GetByte("treeSortOrder"), dr.GetString("appAlias"), dr.GetString("treeAlias"), dr.GetString("treeTitle"), dr.GetString("treeIconClosed"), dr.GetString("treeIconOpen"), dr.GetString("treeHandlerAssembly"), dr.GetString("treeHandlerType"), dr.GetString("action"))); } } AppTrees = list; } } } }