public WikiFile(int id)
{
umbraco.DataLayer.IRecordsReader dr = Data.SqlHelper.ExecuteReader("SELECT * FROM wikiFiles WHERE id = " + id.ToString());
if (dr.Read())
{
Id = dr.GetInt("id");
Path = dr.GetString("path");
Name = dr.GetString("name");
FileType = dr.GetString("type");
RemovedBy = dr.GetInt("removedBy");
CreatedBy = dr.GetInt("createdBy");
NodeVersion = dr.GetGuid("version");
NodeId = dr.GetInt("nodeId");
CreateDate = dr.GetDateTime("createDate");
Current = dr.GetBoolean("current");
Downloads = dr.GetInt("downloads");
Archived = dr.GetBoolean("archived");
Verified = dr.GetBoolean("verified");
Versions = GetVersionsFromString(dr.GetString("umbracoVersion"));
Version = Versions.Any() ? GetVersionsFromString(dr.GetString("umbracoVersion"))[0] : UmbracoVersion.DefaultVersion();
}
else
{
throw new ArgumentException(string.Format("No node exists with id '{0}'", Id));
}
dr.Close();
}
public static Topic GetFromReader(umbraco.DataLayer.IRecordsReader reader)
{
var topic = new Topic
{
Id = reader.GetInt("id"),
ParentId = reader.GetInt("parentId"),
MemberId = reader.GetInt("memberId"),
Replies = reader.GetInt("replies"),
Title = CleanInvalidXmlChars(reader.GetString("title")),
Body = CleanInvalidXmlChars(reader.GetString("body")),
LatestReplyAuthor = reader.GetInt("latestReplyAuthor"),
Created = reader.GetDateTime("created"),
Updated = reader.GetDateTime("updated"),
UrlName = reader.GetString("urlName"),
Locked = reader.GetBoolean("locked")
};
return(topic);
}