/// <summary> /// Gets the values of from cmsDataTypePreValues table by id and puts them into a CDATA section /// </summary> /// <param name="xmlDocument"></param> /// <returns></returns> public override System.Xml.XmlNode ToXMl(System.Xml.XmlDocument xmlDocument) { var value = string.Empty; try { // Don't query if there's nothing to query for.. if (string.IsNullOrWhiteSpace(Value.ToString()) == false) { var dr = SqlHelper.ExecuteReader(string.Format("Select [value] from cmsDataTypeprevalues where id in ({0})", SqlHelper.EscapeString(Value.ToString()))); while (dr.Read()) { value += value.Length == 0 ? dr.GetString("value") : string.Format(",{0}", dr.GetString("value")); } dr.Close(); } } catch (Exception ex) { LogHelper.Error<DefaultDataKeyValue>("An exception occurred converting the property data to XML", ex); } return xmlDocument.CreateCDataSection(value); }
/// <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); }
/// <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 { SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader( umbraco.GlobalSettings.DbDSN, CommandType.Text, "Select [value] from cmsDataTypeprevalues where id in (" + Value.ToString() +")"); while (dr.Read()) { if (v.Length == 0) v += dr["value"].ToString(); else v += "," + dr["value"].ToString(); } dr.Close(); } catch {} return d.CreateCDataSection(v); }
public virtual System.Xml.XmlNode ToXMl(System.Xml.XmlDocument d) { if (this._dataType.DBType == DBTypes.Ntext) return d.CreateCDataSection(this.Value.ToString()); return d.CreateTextNode(Value.ToString()); }
public System.Xml.XmlElement CreateXmlElement(System.Xml.XmlDocument document) { System.Xml.XmlElement templateElement = document.CreateElement("EmailTemplate"); System.Xml.XmlElement smtpElement = document.CreateElement("Smtp"); smtpElement.SetAttribute("host", this.Smtp.Host); smtpElement.SetAttribute("port", this.Smtp.Port.ToString()); smtpElement.SetAttribute("enableSSL", this.Smtp.EnableSsl.ToString()); smtpElement.SetAttribute("deliveryMethod", this.Smtp.DeliveryMethod.ToString()); smtpElement.SetAttribute("username", ((System.Net.NetworkCredential)this.Smtp.Credentials).UserName); smtpElement.SetAttribute("password", ((System.Net.NetworkCredential)this.Smtp.Credentials).Password); templateElement.AppendChild(smtpElement); System.Xml.XmlElement subjectElement = document.CreateElement("Subject"); subjectElement.AppendChild(document.CreateCDataSection(this.Subject)); templateElement.AppendChild(subjectElement); System.Xml.XmlElement bodyElement = document.CreateElement("Body"); bodyElement.AppendChild(document.CreateCDataSection(this.Body)); bodyElement.SetAttribute("isHtml", this.BodyIsHtml.ToString()); templateElement.AppendChild(bodyElement); if (this.Sender != null) { System.Xml.XmlElement senderElement = document.CreateElement("Sender"); senderElement.SetAttribute("address", this.Sender.Address); senderElement.SetAttribute("displayName", this.Sender.DisplayName); templateElement.AppendChild(senderElement); } if (this.From != null) { System.Xml.XmlElement fromElement = document.CreateElement("From"); fromElement.SetAttribute("address", this.From.Address); fromElement.SetAttribute("displayName", this.From.DisplayName); templateElement.AppendChild(fromElement); } if (this.ReplyTo != null) { System.Xml.XmlElement replyToElement = document.CreateElement("ReplyTo"); replyToElement.SetAttribute("address", this.ReplyTo.Address); replyToElement.SetAttribute("displayName", this.ReplyTo.DisplayName); templateElement.AppendChild(replyToElement); } return templateElement; }