/// <summary> /// Ov /// </summary> /// <param name="d"></param> /// <returns></returns> public override System.Xml.XmlNode ToXMl(System.Xml.XmlDocument d) { // Get the value from string v = ""; try { IRecordsReader dr = SqlHelper.ExecuteReader("Select [value] from cmsDataTypeprevalues where id in (" + SqlHelper.EscapeString(Value.ToString()) + ")"); while (dr.Read()) { if (v.Length == 0) { v += dr.GetString("value"); } else { v += "," + dr.GetString("value"); } } dr.Close(); } catch {} return(d.CreateCDataSection(v)); }
public PropertyType(int id) { using (IRecordsReader dr = SqlHelper.ExecuteReader( "Select mandatory, DataTypeId, tabId, ContentTypeId, sortOrder, alias, name, validationRegExp, description from cmsPropertyType where id=@id", SqlHelper.CreateParameter("@id", id))) { if (!dr.Read()) { throw new ArgumentException("Propertytype with id: " + id + " doesnt exist!"); } _mandatory = dr.GetBoolean("mandatory"); _id = id; if (!dr.IsNull("tabId")) { _tabId = dr.GetInt("tabId"); } _sortOrder = dr.GetInt("sortOrder"); _alias = dr.GetString("alias"); _name = dr.GetString("Name"); _validationRegExp = dr.GetString("validationRegExp"); _DataTypeId = dr.GetInt("DataTypeId"); _contenttypeid = dr.GetInt("contentTypeId"); _description = dr.GetString("description"); } }
private void setupStyleSheet(bool loadFileData, bool updateStyleProperties) { // Get stylesheet data using (IRecordsReader dr = SqlHelper.ExecuteReader("select filename, content from cmsStylesheet where nodeid = " + Id)) { if (dr.Read()) { if (!dr.IsNull("filename")) { _filename = dr.GetString("filename"); } // Get Content from db or file if (!loadFileData) { if (!dr.IsNull("content")) { _content = dr.GetString("content"); } } else if (File.Exists(IOHelper.MapPath(String.Format("{0}/{1}.css", SystemDirectories.Css, this.Text)))) { string propertiesContent = String.Empty; using (StreamReader re = File.OpenText(IOHelper.MapPath(String.Format("{0}/{1}.css", SystemDirectories.Css, this.Text)))) { string input = null; _content = string.Empty; // NH: Updates the reader to support properties bool readingProperties = false; while ((input = re.ReadLine()) != null && true) { if (input.Contains("EDITOR PROPERTIES")) { readingProperties = true; } else if (readingProperties) { propertiesContent += input.Replace("\n", "") + "\n"; } else { _content += input.Replace("\n", "") + "\n"; } } } // update properties if (updateStyleProperties) { if (propertiesContent != String.Empty) { parseProperties(propertiesContent); } } } } } }
/// <summary> /// Read all Application data and store it in cache. /// </summary> private static void Cache() { //don't query the database is the cache is not null if (HttpRuntime.Cache[CACHE_KEY] != null) { return; } try { List <Application> tmp = new List <Application>(); using (IRecordsReader dr = SqlHelper.ExecuteReader("Select appAlias, appIcon, appName from umbracoApp")) { while (dr.Read()) { tmp.Add(new Application(dr.GetString("appName"), dr.GetString("appAlias"), dr.GetString("appIcon"))); } } Apps = tmp; } catch { //this is a bit of a hack that just ensures the application doesn't crash when the //installer is run and there is no database or connection string defined. //the reason this method may get called during the installation is that the //SqlHelper of this class is shared amongst everything "Application" wide. } }
private void setupUser(int ID) { _id = ID; using (IRecordsReader dr = SqlHelper.ExecuteReader( "Select userNoConsole, userDisabled, userType,startStructureID, startMediaId, userName,userLogin,userEmail,userDefaultPermissions, userLanguage, defaultToLiveEditing from umbracoUser where id = @id", SqlHelper.CreateParameter("@id", ID))) { if (dr.Read()) { _userNoConsole = dr.GetBoolean("usernoconsole"); _userDisabled = dr.GetBoolean("userDisabled"); _name = dr.GetString("userName"); _loginname = dr.GetString("userLogin"); _email = dr.GetString("userEmail"); _language = dr.GetString("userLanguage"); _startnodeid = dr.GetInt("startStructureID"); if (!dr.IsNull("startMediaId")) { _startmediaid = dr.GetInt("startMediaID"); } _usertype = UserType.GetUserType(dr.GetShort("UserType")); _defaultToLiveEditing = dr.GetBoolean("defaultToLiveEditing"); } else { throw new ArgumentException("No User exists with ID " + ID.ToString()); } } _isInitialized = true; }
protected override void setupNode() { base.setupNode(); IRecordsReader dr = SqlHelper.ExecuteReader("Select alias,design,master from cmsTemplate where nodeId = " + this.Id); bool hasRows = dr.Read(); if (hasRows) { _alias = dr.GetString("alias"); _design = dr.GetString("design"); //set the master template to zero if it's null _mastertemplate = dr.IsNull("master") ? 0 : dr.GetInt("master"); } dr.Close(); if (Umbraco.Core.Configuration.UmbracoSettings.DefaultRenderingEngine == RenderingEngine.Mvc && ViewHelper.ViewExists(this)) { _design = ViewHelper.GetFileContents(this); } else { _design = MasterPageHelper.GetFileContents(this); } }
/// <summary> /// Read all UserType data and store it in cache. /// </summary> private static void Cache() { //don't query the database is the cache is not null if (HttpRuntime.Cache[CACHE_KEY] != null) { return; } List <UserType> tmp = new List <UserType>(); using (IRecordsReader dr = SqlHelper.ExecuteReader("select id, userTypeName, userTypeAlias, userTypeDefaultPermissions from umbracoUserType")) { while (dr.Read()) { tmp.Add(new UserType( dr.GetShort("id"), dr.GetString("userTypeName"), dr.GetString("userTypeDefaultPermissions"), dr.GetString("userTypeAlias"))); } } UserTypes = tmp; }
private static Company FromReader(Company c, IRecordsReader rr) { c.Id = rr.GetInt("id"); c.Category = rr.GetString("category"); c.Name = rr.GetString("name"); c.Symbol = rr.GetString("symbol"); return(c); }
private void PopulateFromReader(IRecordsReader dr) { this._id = dr.GetInt("id"); this._dual = dr.GetBoolean("dual"); //this._parentObjectType = dr.GetGuid("parentObjectType"); //this._childObjectType = dr.GetGuid("childObjectType"); this._name = dr.GetString("name"); this._alias = dr.GetString("alias"); }
//public CmsNode GetNodeById(Guid uniqueId) //{ // CmsNode cmsNode; // var id = SqlHelper.ExecuteScalar<int>("SELECT id FROM umbracoNode WHERE uniqueID = @uniqueId", SqlHelper.CreateParameter("@uniqueId", uniqueId)); // using (IRecordsReader dr = SqlHelper.ExecuteReader(m_SQLSingle, // SqlHelper.CreateParameter("@id", id))) // { // if (dr.Read() || dr.IsNull("uniqueID")) // { // cmsNode = new CmsNode // { // UniqueId = dr.GetGuid("uniqueID"), // NodeObjectType = dr.GetGuid("nodeObjectType"), // ContentTypeId = dr.GetInt("contentTypeId"), // Level = dr.GetShort("level"), // Path = dr.GetString("path"), // ParentId = dr.GetInt("parentId"), // Text = dr.GetString("text"), // SortOrder = dr.GetInt("sortOrder"), // UserId = dr.GetInt("nodeUser"), // CreateDate = dr.GetDateTime("createDate"), // IsTrashed = dr.GetBoolean("trashed") // }; // } // else // { // throw new ArgumentException(string.Format("No node exists with id '{0}' ({1})", id, uniqueId)); // } // } // return cmsNode; //} public IEnumerable <T> GetNodesByIds <T>(Guid[] uniqueIds) where T : CmsNode, new() { var cmsNodes = new List <T>(); // TODO: parameterize this the "right" way to prevent future sql injection var strUIds = string.Format("'{0}'", string.Join("','", uniqueIds)); var ids = new List <int>(); using (IRecordsReader reader = SqlHelper.ExecuteReader(string.Format("SELECT id FROM umbracoNode WHERE uniqueID in ({0})", strUIds))) { while (reader.Read()) { ids.Add(reader.GetInt("id")); } } var strIds = string.Join(",", ids); using (IRecordsReader dr = SqlHelper.ExecuteReader(string.Format(m_SQMultiple, strIds))) { while (dr.Read()) { cmsNodes.Add(new T { UniqueId = dr.GetGuid("uniqueID"), NodeObjectType = dr.GetGuid("nodeObjectType"), ContentTypeId = dr.GetInt("contentTypeId"), Level = dr.GetShort("level"), Path = dr.GetString("path"), ParentId = dr.GetInt("parentId"), Text = dr.GetString("text"), SortOrder = dr.GetInt("sortOrder"), UserId = dr.GetInt("nodeUser"), CreateDate = dr.GetDateTime("createDate"), IsTrashed = dr.GetBoolean("trashed") }); } } if (typeof(T) == typeof(DocType)) { // Fill out property data foreach (var node in cmsNodes) { var docType = node as DocType; if (docType != null) { docType.Properties = GetPropertyTypes(node).ToList(); } } } return(cmsNodes); }
private void initProperty() { IRecordsReader dr = SqlHelper.ExecuteReader("Select stylesheetPropertyAlias,stylesheetPropertyValue from cmsStylesheetProperty where nodeId = " + this.Id.ToString()); if (dr.Read()) { _alias = dr.GetString("stylesheetPropertyAlias"); _value = dr.GetString("stylesheetPropertyValue"); } else { throw new ArgumentException("NO DATA EXSISTS"); } dr.Close(); }
public static Record CreateFromDataReader(IRecordsReader reader) { Record record = Create(); record.Id = reader.GetGuid("Id"); record.Form = reader.GetGuid("Form"); record.Created = reader.GetDateTime("Created"); record.Updated = reader.GetDateTime("Updated"); record.State = reader.GetInt("State"); record.currentPage = reader.GetGuid("currentPage"); record.umbracoPageId = reader.GetInt("umbracoPageId"); record.IP = reader.GetString("IP"); record.MemberKey = reader.GetString("MemberKey"); return(record); }
protected void PopulateFromReader(IRecordsReader dr) { _id = Convert.ToInt32(dr.GetShort("id")); _cultureAlias = dr.GetString("languageISOCode"); UpdateNames(); }
public Dictionary <string, string> GetSettings(Guid id) { string sql = "SELECT * from UFSettings where id = @id"; IRecordsReader settingsReader = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@id", id)); Dictionary <string, string> settings = new Dictionary <string, string>(); while (settingsReader.Read()) { settings.Add(settingsReader.GetString("key"), settingsReader.GetString("value")); } settingsReader.Dispose(); return(settings); }
/// <summary> /// Populates the global hash table with the data from the database. /// </summary> private static void ensureData() { if (!m_IsInitialize) { lock (m_Locker) { //double check if (!m_IsInitialize) { // load all data using (IRecordsReader dr = SqlHelper.ExecuteReader("Select LanguageId, UniqueId,[value] from cmsLanguageText order by UniqueId")) { while (dr.Read()) { int LanguageId = dr.GetInt("LanguageId"); Guid UniqueId = dr.GetGuid("UniqueId"); string text = dr.GetString("value"); updateCache(LanguageId, UniqueId, text); } } m_IsInitialize = true; } } } }
public List <object> GetRecordFieldValues(RecordField rf) { string sql = string.Format("SELECT * FROM UFRecordData{0} where [Key] = @key ORDER BY Id ASC", rf.DataTypeAlias); List <object> l = new List <object>(); IRecordsReader rr = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@key", rf.Key)); while (rr.Read()) { switch (rf.DataType) { case FieldDataType.String: case FieldDataType.LongString: l.Add(rr.GetString("Value")); break; case FieldDataType.Integer: l.Add(rr.GetInt("Value")); break; case FieldDataType.DateTime: l.Add(rr.GetDateTime("Value")); break; case FieldDataType.Bit: l.Add(rr.GetBoolean("Value")); break; } } rr.Dispose(); return(l); }
/// <summary> /// This function shows all version history for each current node /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gvCurVer_RowDataBound(object sender, GridViewRowEventArgs e) { // Set Text for no versions to show if (e.Row.RowType.Equals(DataControlRowType.EmptyDataRow)) { Label lblNoVersionsToShow = (Label)e.Row.FindControl("lblNoVersionsToShow"); lblNoVersionsToShow.Text = getDictionaryItem("versions_Label_NoLogsToShow") + " '" + dtpckrDateFrom.DateTime.ToShortDateString() + "'"; } if (e.Row.RowType == DataControlRowType.DataRow) { Label lblNodeId = (Label)e.Row.FindControl("lblNodeId"); Literal ltrlHistVer = (Literal)e.Row.FindControl("ltrlHistVer"); using (IRecordsReader dr = SqlHelper.ExecuteReader(GetSQLHistoryVersions(), SqlHelper.CreateParameter("@nodeId", int.Parse(lblNodeId.Text)))) { while (dr.Read()) { ltrlHistVer.Text += dr.GetString("text") + " <small>(Created: " + dr.GetDateTime("updateDate").ToShortDateString() + " " + dr.GetDateTime("updateDate").ToShortTimeString() + ") "; if (dr.GetBoolean("published")) { ltrlHistVer.Text += "(<span style='color: green;'>published</span>)"; } if (dr.GetBoolean("newest")) { ltrlHistVer.Text += "(<span style='color: navy;'>newest</span>)"; } ltrlHistVer.Text += "</small><br />"; } } } }
/// <summary> /// Gets the .Net type corresponding to the specified database data type. /// </summary> /// <param name="dataTypeReader">The data type reader.</param> /// <returns>The .Net type</returns> protected virtual Type GetType(IRecordsReader dataTypeReader) { string typeName = dataTypeReader.GetString("DataType"); switch (typeName) { case "bit": return(typeof(bool)); case "tinyint": return(typeof(byte)); case "datetime": return(typeof(DateTime)); // TODO: return different decimal type according to field precision case "decimal": return(typeof(decimal)); case "uniqueidentifier": return(typeof(Guid)); case "smallint": return(typeof(Int16)); case "int": return(typeof(Int32)); case "bigint": return(typeof(Int64)); case "nvarchar": return(typeof(string)); default: throw new ArgumentException(String.Format("Cannot convert database type '{0}' to a .Net type.", typeName)); } }
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); }
public static List <LogItem> ConvertIRecordsReader(IRecordsReader reader) { var items = new List <LogItem>(); while (reader.Read()) { items.Add(new LogItem( reader.GetInt("userId"), reader.GetInt("nodeId"), reader.GetDateTime("DateStamp"), ConvertLogHeader(reader.GetString("logHeader")), reader.GetString("logComment"))); } return(items); }
internal static List <Domain> GetDomains() { return(Cache.GetCacheItem <List <Domain> >("UmbracoDomainList", getDomainsSyncLock, TimeSpan.FromMinutes(30), delegate { List <Domain> result = new List <Domain>(); using (IRecordsReader dr = SqlHelper.ExecuteReader( "select id, domainName from umbracoDomains")) { while (dr.Read()) { string domainName = dr.GetString("domainName"); int domainId = dr.GetInt("id"); if (result.Find(delegate(Domain d) { return d.Name == domainName; }) == null) { result.Add(new Domain(domainId)); } else { Log.Add(LogTypes.Error, User.GetUser(0), -1, string.Format("Domain already exists in list ({0})", domainName)); } } } return result; })); }
/// <summary> /// Initializes the user node permissions /// </summary> public void initCruds() { if (!_isInitialized) { setupUser(_id); } // clear cruds System.Web.HttpContext.Current.Application.Lock(); _cruds.Clear(); System.Web.HttpContext.Current.Application.UnLock(); using (IRecordsReader dr = SqlHelper.ExecuteReader("select * from umbracoUser2NodePermission where userId = @userId order by nodeId", SqlHelper.CreateParameter("@userId", this.Id))) { // int currentId = -1; while (dr.Read()) { if (!_cruds.ContainsKey(dr.GetInt("nodeId"))) { _cruds.Add(dr.GetInt("nodeId"), String.Empty); } _cruds[dr.GetInt("nodeId")] += dr.GetString("permission"); } } _crudsInitialized = true; }
/// <summary> /// Reads all items from the database and stores in local cache /// </summary> private static void EnsureCache() { if (!_cacheIsEnsured) { lock (Locker) { if (!_cacheIsEnsured) { using (IRecordsReader dr = SqlHelper.ExecuteReader("Select pk, id, [key], parent from cmsDictionary")) { while (dr.Read()) { //create new dictionaryitem object and put in cache var item = new DictionaryItem(dr.GetInt("pk"), dr.GetString("key"), dr.GetGuid("id"), dr.GetGuid("parent")); DictionaryItems.TryAdd(item.key, item); } } _cacheIsEnsured = true; } } } }
public static Workflow CreateFromDataReader(IRecordsReader reader) { Workflow wf = new Workflow(); wf.Id = reader.GetGuid("id"); wf.Name = reader.GetString("name"); wf.Form = reader.GetGuid("form"); wf.SortOrder = reader.GetInt("sortorder"); wf.Active = reader.GetBoolean("active"); if (!reader.IsNull("executesOn")) { wf.ExecutesOn = (FormState)System.Enum.ToObject(typeof(FormState), reader.GetInt("executesOn")); } //if the type is null or does not exist in the collection, we should not initialize the workflow if (!reader.IsNull("type") && Umbraco.Forms.Core.Providers.WorkflowTypeProviderCollection.Instance.ContainsProvider(reader.GetGuid("type"))) { wf.Type = Umbraco.Forms.Core.Providers.WorkflowTypeProviderCollection.Instance.GetProviderInstance(reader.GetGuid("type")); } else { wf.Active = false; } wf.Settings = new Dictionary <string, string>(); return(wf); }
/// <summary> /// Gets the table with the specified name. /// </summary> /// <param name="name">The name.</param> /// <returns>The table, or <c>null</c> if no table with that name exists.</returns> public override ITable GetTable(string name) { if (name == null) { throw new ArgumentNullException("name"); } ITable table = null; // get name in correct casing name = SqlHelper.ExecuteScalar <string>("SELECT name FROM sys.tables WHERE name=@name", SqlHelper.CreateParameter("name", name)); if (name != null) { table = new DefaultTable(name); using (IRecordsReader reader = SqlHelper.ExecuteReader( @"SELECT c.name AS Name, st.name AS DataType, c.max_length, c.is_nullable, c.is_identity FROM sys.tables AS t JOIN sys.columns AS c ON t.object_id = c.object_id JOIN sys.schemas AS s ON s.schema_id = t.schema_id JOIN sys.types AS ty ON ty.user_type_id = c.user_type_id JOIN sys.types st ON ty.system_type_id = st.user_type_id WHERE t.name = @name ORDER BY c.column_id", SqlHelper.CreateParameter("name", name))) { while (reader.Read()) { table.AddField(table.CreateField(reader.GetString("Name"), GetType(reader))); } } } return(table); }
public static Form CreateFromDataReader(IRecordsReader reader) { Form form = Create(); form.Id = reader.GetGuid("id"); form.Pages = new List <Page>(); form.Name = reader.GetString("name"); form.Created = reader.GetDateTime("created"); form.MessageOnSubmit = reader.GetString("MessageOnSubmit"); form.GoToPageOnSubmit = reader.GetInt("GotoPageOnSubmit"); form.ShowValidationSummary = reader.GetBoolean("ShowValidationSummary"); form.HideFieldValidation = reader.GetBoolean("HideFieldValidation"); form.RequiredErrorMessage = reader.GetString("RequiredErrorMessage"); form.InvalidErrorMessage = reader.GetString("InvalidErrorMessage"); form.ManualApproval = reader.GetBoolean("ManualApproval"); form.Archived = reader.GetBoolean("Archived"); form.StoreRecordsLocally = reader.GetBoolean("StoreRecordsLocally"); if (!reader.IsNull("DataSource")) { form.DataSource = reader.GetGuid("DataSource"); } if (!reader.IsNull("FieldIndicationType")) { form.FieldIndicationType = (FormFieldIndication)System.Enum.Parse(typeof(FormFieldIndication), reader.GetInt("FieldIndicationType").ToString()); form.Indicator = reader.GetString("Indicator"); } if (!reader.IsNull("DisableDefaultStylesheet")) { form.DisableDefaultStylesheet = reader.GetBoolean("DisableDefaultStylesheet"); } //check for xpath setting //Umbraco.Forms.Migration.Data.Storage.SettingsStorage ss = new Umbraco.Forms.Migration.Data.Storage.SettingsStorage(); //string set = ss.GetSetting(form.Id, "XPathOnSubmit"); //if (!string.IsNullOrEmpty(set)) // form.XPathOnSubmit = set; //ss.Dispose(); return(form); }
private void setup() { using (IRecordsReader dr = SqlHelper.ExecuteReader("select macroPropertyTypeAlias, macroPropertyTypeRenderAssembly, macroPropertyTypeRenderType, macroPropertyTypeBaseType from cmsMacroPropertyType where id = @id", SqlHelper.CreateParameter("@id", _id))) { if (dr.Read()) { _alias = dr.GetString("macroPropertyTypeAlias"); _assembly = dr.GetString("macroPropertyTypeRenderAssembly"); _type = dr.GetString("macroPropertyTypeRenderType"); _baseType = dr.GetString("macroPropertyTypeBaseType"); } else { throw new ArgumentException("No macro property type found with the id specified"); } } }
public template(int templateID) { if (templateCache["template" + templateID.ToString()] != null) { template t = (template)templateCache["template" + templateID]; this._masterTemplate = t._masterTemplate; this._templateAlias = t._templateAlias; this._templateDesign = t._templateDesign; this._masterTemplate = t._masterTemplate; this._templateName = t._templateName; } else { using (IRecordsReader templateData = SqlHelper.ExecuteReader("select nodeId, alias, master, text, design from cmsTemplate inner join umbracoNode node on node.id = cmsTemplate.nodeId where nodeId = @templateID", SqlHelper.CreateParameter("@templateID", templateID))) { if (templateData.Read()) { // Get template master and replace content where the template if (!templateData.IsNull("master")) { _masterTemplate = templateData.GetInt("master"); } if (!templateData.IsNull("alias")) { _templateAlias = templateData.GetString("alias"); } if (!templateData.IsNull("text")) { _templateName = templateData.GetString("text"); } if (!templateData.IsNull("design")) { _templateDesign = templateData.GetString("design"); } templateData.Close(); templateCache.Insert("template" + templateID.ToString(), this); } } } // Only check for master on legacy templates - can show error when using master pages. if (!UmbracoSettings.UseAspNetMasterPages) { checkForMaster(templateID); } }
private static IEnumerable <Tag> ConvertSqlToTags(string sql, params IParameter[] param) { List <Tag> tags = new List <Tag>(); using (IRecordsReader rr = SqlHelper.ExecuteReader(sql, param)) { while (rr.Read()) { tags.Add(new Tag( rr.GetInt("id"), rr.GetString("tag"), rr.GetString("group"), rr.GetInt("nodeCount"))); } } return(tags); }
public List <Setting <string, string> > GetSettings(int dataTypeNodeID) { string sql = "select * from cmsDataTypePreValues where datatypenodeid = @datatypenodeid"; IRecordsReader settingsReader = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@datatypenodeid", dataTypeNodeID)); List <Setting <string, string> > settings = new List <Setting <string, string> >(); while (settingsReader.Read()) { Setting <string, string> setting = new Setting <string, string>(); setting.Key = settingsReader.GetString("alias"); setting.Value = settingsReader.GetString("value"); settings.Add(setting); } settingsReader.Dispose(); return(settings); }
public static bool TryGetColumnString(IRecordsReader reader, string columnName, out string value) { if (reader.ContainsField(columnName) && !reader.IsNull(columnName)) { value = reader.GetString(columnName); return true; } value = string.Empty; return false; }
protected void PopulateFromReader(IRecordsReader dr) { _id = Convert.ToInt32(dr.GetShort("id")); _cultureAlias = dr.GetString("languageISOCode"); updateNames(); }
private static XPathNodeIterator CommentsToXml(IRecordsReader rr) { XmlDocument xd = new XmlDocument(); XmlNode x = umbraco.xmlHelper.addTextNode(xd, "comments", ""); while (rr.Read()) { XmlNode c = xd.CreateElement("comment"); c.Attributes.Append(umbraco.xmlHelper.addAttribute(xd, "id", rr.GetInt("id").ToString())); c.Attributes.Append(umbraco.xmlHelper.addAttribute(xd, "nodeid", rr.GetInt("nodeid").ToString())); c.Attributes.Append(umbraco.xmlHelper.addAttribute(xd, "created", rr.GetDateTime("created").ToString())); c.AppendChild(umbraco.xmlHelper.addCDataNode(xd, "name", rr.GetString("name"))); c.AppendChild(umbraco.xmlHelper.addCDataNode(xd, "email", rr.GetString("email"))); c.AppendChild(umbraco.xmlHelper.addCDataNode(xd, "website", rr.GetString("website"))); c.AppendChild(umbraco.xmlHelper.addCDataNode(xd, "message", rr.GetString("comment"))); x.AppendChild(c); } xd.AppendChild(x); rr.Close(); return xd.CreateNavigator().Select("."); }
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")); }
public static List<LogItem> ConvertIRecordsReader(IRecordsReader reader) { var items = new List<LogItem>(); while (reader.Read()) { items.Add(new LogItem( reader.GetInt("userId"), reader.GetInt("nodeId"), reader.GetDateTime("DateStamp"), ConvertLogHeader(reader.GetString("logHeader")), reader.GetString("logComment"))); } return items; }
protected void PopulateContentTypeNodeFromReader(IRecordsReader dr) { _alias = dr.GetString("Alias"); _iconurl = dr.GetString("icon"); _isContainerContentType = dr.GetBoolean("isContainer"); _allowAtRoot = dr.GetBoolean("allowAtRoot"); if (!dr.IsNull("thumbnail")) _thumbnail = dr.GetString("thumbnail"); if (!dr.IsNull("description")) _description = dr.GetString("description"); }
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"); }
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"); }
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; }
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 PopulateContentTypeNodeFromReader(IRecordsReader dr) { _alias = dr.GetString("Alias"); _iconurl = dr.GetString("icon"); if (!dr.IsNull("masterContentType")) m_masterContentType = dr.GetInt("masterContentType"); if (!dr.IsNull("thumbnail")) _thumbnail = dr.GetString("thumbnail"); if (!dr.IsNull("description")) _description = dr.GetString("description"); }
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")); }
private void PopulateMacroInfo(IRecordsReader dr) { _useInEditor = dr.GetBoolean("macroUseInEditor"); _refreshRate = dr.GetInt("macroRefreshRate"); _alias = dr.GetString("macroAlias"); _id = dr.GetInt("id"); _name = dr.GetString("macroName"); _assembly = dr.GetString("macroScriptAssembly"); _type = dr.GetString("macroScriptType"); _xslt = dr.GetString("macroXSLT"); _scriptingFile = dr.GetString("macroPython"); _cacheByPage = dr.GetBoolean("macroCacheByPage"); _cachePersonalized = dr.GetBoolean("macroCachePersonalized"); _renderContent = !dr.GetBoolean("macroDontRender"); }
private static Company FromReader(Company c, IRecordsReader rr) { c.Id = rr.GetInt("id"); c.Category = rr.GetString("category"); c.Name = rr.GetString("name"); c.Symbol = rr.GetString("symbol"); return c; }