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