private PropertiesInfo FillObject(IDataRecord dr)
{
PropertiesInfo pi = null;
if (dr != null)
{
pi = new PropertiesInfo();
pi.PropertyId = Convert.ToInt32(dr["PropertyId"].ToString());
pi.PortalId = Convert.ToInt32(dr["PortalId"].ToString());
pi.ObjectType = Convert.ToInt32(dr["ObjectType"].ToString());
pi.ObjectOwnerId = Convert.ToInt32(dr["ObjectOwnerId"].ToString());
pi.Name = dr["Name"].ToString();
pi.DataType = dr["DataType"].ToString();
pi.DefaultAccessControl = Convert.ToInt32(dr["DefaultAccessControl"].ToString());
pi.IsHidden = bool.Parse(dr["IsHidden"].ToString());
pi.IsReadOnly = bool.Parse(dr["IsReadOnly"].ToString());
pi.IsRequired = bool.Parse(dr["IsRequired"].ToString());
pi.ValidationExpression = dr["ValidationExpression"].ToString();
pi.ViewTemplate = dr["ViewTemplate"].ToString();
pi.EditTemplate = dr["EditTemplate"].ToString();
pi.SortOrder = int.Parse(dr["SortOrder"].ToString());
pi.DefaultValue = dr["DefaultValue"].ToString();
}
return(pi);
}
internal PropertiesInfo GetProperty(int PropertyId, int PortalId)
{
Data.PropertiesDB db = new Data.PropertiesDB();
PropertiesInfo pi = null;
using (IDataReader dr = db.GetProperties(PropertyId, PortalId))
{
while (dr.Read())
{
pi = FillObject(dr);
}
dr.Close();
}
return(pi);
}
internal List <PropertiesInfo> ListProperties(int PortalId, int ObjectType, int ObjectOwnerId)
{
List <PropertiesInfo> list = new List <PropertiesInfo>();
Data.PropertiesDB db = new Data.PropertiesDB();
using (IDataReader dr = db.ListProperties(PortalId, ObjectType, ObjectOwnerId))
{
while (dr.Read())
{
PropertiesInfo p = FillObject(dr);
if (p != null)
{
list.Add(p);
}
}
dr.Close();
}
return(list);
}
internal PropertiesInfo SaveProperty(PropertiesInfo pi)
{
Data.PropertiesDB db = new Data.PropertiesDB();
pi.PropertyId = db.SaveProperty(pi.PropertyId, pi.PortalId, pi.ObjectType, pi.ObjectOwnerId, pi.Name, pi.DataType, pi.DefaultAccessControl, pi.IsHidden, pi.IsRequired, pi.IsReadOnly, pi.ValidationExpression, pi.EditTemplate, pi.ViewTemplate, pi.SortOrder, pi.DefaultValue);
return(GetProperty(pi.PropertyId, pi.PortalId));
}
private void LoadTopic()
{
ctlForm.EditorMode = Modules.ActiveForums.Controls.SubmitForm.EditorModes.EditTopic;
var tc = new TopicsController();
var ti = tc.Topics_Get(PortalId, ForumModuleId, TopicId, ForumId, UserId, true);
if (ti == null)
{
Response.Redirect(NavigateUrl(ForumTabId));
}
else if ((ti.Content.AuthorId != UserId && _canModEdit == false) | (ti.Content.AuthorId == UserId && _canEdit == false) | (_canEdit == false && _canModEdit))
{
Response.Redirect(NavigateUrl(ForumTabId));
}
else if (!_canModEdit && (ti.Content.AuthorId == UserId && _canEdit && MainSettings.EditInterval > 0 & SimulateDateDiff.DateDiff(SimulateDateDiff.DateInterval.Minute, ti.Content.DateCreated, DateTime.Now) > MainSettings.EditInterval))
{
var im = new InfoMessage
{
Message = "<div class=\"afmessage\">" + string.Format(GetSharedResource("[RESX:Message:EditIntervalReached]"), MainSettings.EditInterval) + "</div>"
};
plhMessage.Controls.Add(im);
plhContent.Controls.Clear();
}
else
{
//User has acccess
var sBody = ti.Content.Body;
var sSubject = ti.Content.Subject;
sBody = Utilities.PrepareForEdit(PortalId, ForumModuleId, ImagePath, sBody, _allowHTML, _editorType);
sSubject = Utilities.PrepareForEdit(PortalId, ForumModuleId, ImagePath, sSubject, false, EditorTypes.TEXTBOX);
ctlForm.Subject = sSubject;
ctlForm.Summary = ti.Content.Summary;
ctlForm.Body = sBody;
ctlForm.AnnounceEnd = ti.AnnounceEnd;
ctlForm.AnnounceStart = ti.AnnounceStart;
ctlForm.Locked = ti.IsLocked;
ctlForm.Pinned = ti.IsPinned;
ctlForm.TopicIcon = ti.TopicIcon;
ctlForm.Tags = ti.Tags;
ctlForm.Categories = ti.Categories;
ctlForm.IsApproved = ti.IsApproved;
ctlForm.StatusId = ti.StatusId;
ctlForm.TopicPriority = ti.Priority;
if (ti.Author.AuthorId > 0)
ctlForm.Subscribe = Subscriptions.IsSubscribed(PortalId, ForumModuleId, ForumId, TopicId, SubscriptionTypes.Instant, ti.Author.AuthorId);
_contentId = ti.ContentId;
_authorId = ti.Author.AuthorId;
if (!(string.IsNullOrEmpty(ti.TopicData)))
{
var pl = new List<PropertiesInfo>();
var xDoc = new XmlDocument();
xDoc.LoadXml(ti.TopicData);
XmlNode xRoot = xDoc.DocumentElement;
if (xRoot != null)
{
var xNodeList = xRoot.SelectNodes("//properties/property");
if (xNodeList != null && xNodeList.Count > 0)
{
for (var i = 0; i < xNodeList.Count; i++)
{
var pName = Utilities.HTMLDecode(xNodeList[i].ChildNodes[0].InnerText);
var pValue = Utilities.HTMLDecode(xNodeList[i].ChildNodes[1].InnerText);
var xmlAttributeCollection = xNodeList[i].Attributes;
if (xmlAttributeCollection == null)
continue;
var pId = Convert.ToInt32(xmlAttributeCollection["id"].Value);
var p = new PropertiesInfo {Name = pName, DefaultValue = pValue, PropertyId = pId};
pl.Add(p);
}
}
}
ctlForm.TopicProperties = pl;
}
if (ti.TopicType == TopicTypes.Poll)
{
//Get Poll
var ds = DataProvider.Instance().Poll_Get(ti.TopicId);
if (ds.Tables.Count > 0)
{
var pollRow = ds.Tables[0].Rows[0];
ctlForm.PollQuestion = pollRow["Question"].ToString();
ctlForm.PollType = pollRow["PollType"].ToString();
foreach (DataRow dr in ds.Tables[1].Rows)
ctlForm.PollOptions += dr["OptionName"] + System.Environment.NewLine;
}
}
if (ti.Content.AuthorId != UserId && _canModApprove)
ctlForm.ShowModOptions = true;
}
}
internal PropertiesInfo SaveProperty(PropertiesInfo pi)
{
Data.PropertiesDB db = new Data.PropertiesDB();
pi.PropertyId = db.SaveProperty(pi.PropertyId, pi.PortalId, pi.ObjectType, pi.ObjectOwnerId, pi.Name, pi.DataType, pi.DefaultAccessControl, pi.IsHidden, pi.IsRequired, pi.IsReadOnly, pi.ValidationExpression, pi.EditTemplate, pi.ViewTemplate, pi.SortOrder, pi.DefaultValue);
return GetProperty(pi.PropertyId, pi.PortalId);
}
private PropertiesInfo FillObject(IDataRecord dr)
{
PropertiesInfo pi = null;
if (dr != null)
{
pi = new PropertiesInfo();
pi.PropertyId = Convert.ToInt32(dr["PropertyId"].ToString());
pi.PortalId = Convert.ToInt32(dr["PortalId"].ToString());
pi.ObjectType = Convert.ToInt32(dr["ObjectType"].ToString());
pi.ObjectOwnerId = Convert.ToInt32(dr["ObjectOwnerId"].ToString());
pi.Name = dr["Name"].ToString();
pi.DataType = dr["DataType"].ToString();
pi.DefaultAccessControl = Convert.ToInt32(dr["DefaultAccessControl"].ToString());
pi.IsHidden = bool.Parse(dr["IsHidden"].ToString());
pi.IsReadOnly = bool.Parse(dr["IsReadOnly"].ToString());
pi.IsRequired = bool.Parse(dr["IsRequired"].ToString());
pi.ValidationExpression = dr["ValidationExpression"].ToString();
pi.ViewTemplate = dr["ViewTemplate"].ToString();
pi.EditTemplate = dr["EditTemplate"].ToString();
pi.SortOrder = int.Parse(dr["SortOrder"].ToString());
pi.DefaultValue = dr["DefaultValue"].ToString();
}
return pi;
}
