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