protected override void setupNode() { base.setupNode(); using (IRecordsReader dr = SqlHelper.ExecuteReader("select dbType, controlId from cmsDataType where nodeId = '" + this.Id.ToString() + "'")) { if (dr.Read()) { _controlId = dr.GetGuid("controlId"); _dbType = dr.GetString("dbType"); } else { throw new ArgumentException("No dataType with id = " + this.Id.ToString() + " found"); } } }
public List <Field> GetAllFields(Form form) { List <Field> l = new List <Field>(); string sql = @"SELECT UFfields.*, UFpages.form AS form, UFfieldsets.sortorder as FieldsetIndex, UFpages.sortorder as PageIndex From UFfields INNER JOIN UFfieldsets ON UFfieldsets.id = fieldset INNER JOIN UFpages ON UFpages.id = UFfieldsets.page where UFpages.form = @form ORDER by UfPages.SortOrder ASC, UFFieldsets.sortorder ASC, UFfields.sortOrder ASC "; IRecordsReader rr = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@form", form.Id)); while (rr.Read()) { Field f = Field.CreateFromDataReader(rr); if (!rr.IsNull("prevalueProvider")) { f.PreValueSource = prevalueSourceStorage.GetPrevalueSource(rr.GetGuid("prevalueProvider")); } f.Settings = settings.GetSettingsAsList(f.Id); //if (f.FieldType.HasSettings()) // f.FieldType.LoadSettings(f.Settings); f.Condition = conditionStorage.GetFieldCondition(f); if (f.Condition == null) { f.Condition = new FieldCondition(); f.Condition.Enabled = false; f.Condition.ActionType = FieldConditionActionType.Show; f.Condition.LogicType = FieldConditionLogicType.All; } l.Add(f); } rr.Dispose(); return(l); }
/// <summary> /// Retrieve a list of the unique id's of all CMSNodes given the objecttype /// </summary> /// <param name="objectType">The objecttype identifier</param> /// <returns> /// A list of all unique identifiers which each are associated to a CMSNode /// </returns> public Guid[] GetAllUniquesFromObjectType(Guid objectType) { IRecordsReader dr = SqlHelper.ExecuteReader("Select uniqueID from umbracoNode where nodeObjectType = @type", SqlHelper.CreateParameter("@type", objectType)); var tmp = new System.Collections.ArrayList(); while (dr.Read()) { tmp.Add(dr.GetGuid("uniqueID")); } dr.Close(); Guid[] retval = new Guid[tmp.Count]; for (int i = 0; i < tmp.Count; i++) { retval[i] = (Guid)tmp[i]; } return(retval); }
/// <summary> /// Retrieves the top level nodes in the hierarchy /// </summary> /// <param name="ObjectType">The Guid identifier of the type of objects</param> /// <returns> /// A list of all top level nodes given the objecttype /// </returns> public static Guid[] TopMostNodeIds(Guid ObjectType) { IRecordsReader dr = SqlHelper.ExecuteReader("Select uniqueID from umbracoNode where nodeObjectType = @type And parentId = -1 order by sortOrder", SqlHelper.CreateParameter("@type", ObjectType)); System.Collections.ArrayList tmp = new System.Collections.ArrayList(); while (dr.Read()) { tmp.Add(dr.GetGuid("uniqueID")); } dr.Close(); Guid[] retval = new Guid[tmp.Count]; for (int i = 0; i < tmp.Count; i++) { retval[i] = (Guid)tmp[i]; } return(retval); }
protected void PopulateMediaFromReader(IRecordsReader dr) { var hc = dr.GetInt("children") > 0; SetupMediaForTree(dr.GetGuid("uniqueId") , dr.GetShort("level") , dr.GetInt("parentId") , dr.GetInt("nodeUser") , dr.GetString("path") , dr.GetString("text") , dr.GetDateTime("createDate") , dr.GetString("icon") , hc , dr.GetString("alias") , dr.GetString("thumbnail") , dr.GetString("description") , null , dr.GetInt("contentTypeId") , dr.GetBoolean("isContainer")); }
public virtual List <CMSPreviewNode> GetNodesForPreview(bool childrenOnly) { List <CMSPreviewNode> nodes = new List <CMSPreviewNode>(); string sql = @" select umbracoNode.id, umbracoNode.parentId, umbracoNode.level, umbracoNode.sortOrder, cmsPreviewXml.xml from umbracoNode inner join cmsPreviewXml on cmsPreviewXml.nodeId = umbracoNode.id where trashed = 0 and path like '{0}' order by level,sortOrder"; string pathExp = childrenOnly ? Path + ",%" : Path; IRecordsReader dr = SqlHelper.ExecuteReader(String.Format(sql, pathExp)); while (dr.Read()) { nodes.Add(new CMSPreviewNode(dr.GetInt("id"), dr.GetGuid("uniqueID"), dr.GetInt("parentId"), dr.GetShort("level"), dr.GetInt("sortOrder"), dr.GetString("xml"))); } dr.Close(); return(nodes); }
private void Initialize(int id) { IRecordsReader dr = SqlHelper.ExecuteReader( "select id, uninstalled, upgradeId, installDate, userId, package, versionMajor, versionMinor, versionPatch from umbracoInstalledPackages where id = @id", SqlHelper.CreateParameter("@id", id)); if (dr.Read()) { Id = id; Uninstalled = dr.GetBoolean("uninstalled"); UpgradeId = dr.GetInt("upgradeId"); InstallDate = dr.GetDateTime("installDate"); User = User.GetUser(dr.GetInt("userId")); PackageId = dr.GetGuid("package"); VersionMajor = dr.GetInt("versionMajor"); VersionMinor = dr.GetInt("versionMinor"); VersionPatch = dr.GetInt("versionPatch"); } dr.Close(); }
public List <Form> GetAllForms(bool archived) { //SQL string sql = "SELECT * FROM UFforms where archived = @archived order by name ASC;"; List <Form> l = new List <Form>(); IRecordsReader rr = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@archived", archived)); while (rr.Read()) { Guid id = rr.GetGuid("id"); Form f = Form.CreateFromDataReader(rr); f.Pages.AddRange(pageStorage.GetAllPages(f)); l.Add(f); } rr.Dispose(); return(l); }
/// <summary> /// Populates the global hash table with the data from the database. /// </summary> private static void EnsureCache() { if (!_isInitialize) { lock (Locker) { //double check if (!_isInitialize) { // load all data using (IRecordsReader dr = SqlHelper.ExecuteReader("Select LanguageId, UniqueId,[value] from cmsLanguageText order by UniqueId")) { while (dr.Read()) { var languageId = dr.GetInt("LanguageId"); var uniqueId = dr.GetGuid("UniqueId"); var text = dr.GetString("value"); Items.AddOrUpdate(uniqueId, guid => { var languagevalues = new Dictionary <int, string> { { languageId, text } }; return(languagevalues); }, (guid, dictionary) => { // add/update the text for the id dictionary[languageId] = text; return(dictionary); }); } } _isInitialize = true; } } } }
protected void PopulateMemberFromReader(IRecordsReader dr) { SetupNodeForTree(dr.GetGuid("uniqueId"), _objectType, dr.GetShort("level"), dr.GetInt("parentId"), dr.GetInt("nodeUser"), dr.GetString("path"), dr.GetString("text"), dr.GetDateTime("createDate"), false); if (!dr.IsNull("Email")) m_Email = dr.GetString("Email"); m_LoginName = dr.GetString("LoginName"); m_Password = dr.GetString("Password"); }
protected void PopulateDocumentFromReader(IRecordsReader dr) { var hc = dr.GetInt("children") > 0; SetupDocumentForTree(dr.GetGuid("uniqueId") , dr.GetShort("level") , dr.GetInt("parentId") , dr.GetInt("nodeUser") , dr.GetInt("documentUser") , !dr.GetBoolean("trashed") && (dr.GetInt("isPublished") == 1) //set published... double check trashed property , dr.GetString("path") , dr.GetString("text") , dr.GetDateTime("createDate") , dr.GetDateTime("updateDate") , dr.GetDateTime("versionDate") , dr.GetString("icon") , hc , dr.GetString("alias") , dr.GetString("thumbnail") , dr.GetString("description") , null , dr.GetInt("contentTypeId") , dr.GetInt("templateId") , dr.GetBoolean("isContainer")); if (!dr.IsNull("releaseDate")) _release = dr.GetDateTime("releaseDate"); if (!dr.IsNull("expireDate")) _expire = dr.GetDateTime("expireDate"); }
protected void PopulateDocumentFromReader(IRecordsReader dr) { bool _hc = false; if (dr.GetInt("children") > 0) _hc = true; int? masterContentType = null; if (!dr.IsNull("masterContentType")) masterContentType = dr.GetInt("masterContentType"); SetupDocumentForTree(dr.GetGuid("uniqueId") , dr.GetShort("level") , dr.GetInt("parentId") , dr.GetInt("nodeUser") , dr.GetInt("documentUser") , (dr.GetInt("isPublished") == 1) , dr.GetString("path") , dr.GetString("text") , dr.GetDateTime("createDate") , dr.GetDateTime("updateDate") , dr.GetDateTime("versionDate") , dr.GetString("icon") , _hc , dr.GetString("alias") , dr.GetString("thumbnail") , dr.GetString("description") , masterContentType , dr.GetInt("contentTypeId") , dr.GetInt("templateId")); }
internal DocTypeProperty BuildProperty(IRecordsReader reader) { var p = new DocTypeProperty { Alias = reader.GetAlias(), Description = reader.GetDescription(), Id = reader.GetId(), Mandatory = reader.GetBoolean("Mandatory"), Name = reader.GetName(), RegularExpression = reader.GetString("RegularExpression"), ControlId = reader.GetGuid("ControlId") }; switch (reader.GetDbType()) { case "Date": p.DatabaseType = typeof(DateTime); break; case "Integer": p.DatabaseType = typeof(int); break; case "Ntext": case "Nvarchar": p.DatabaseType = typeof(string); break; default: p.DatabaseType = typeof(object); break; } return p; }