private void getItemsForPublish()
{
if (nodeInfo.Count == 0)
{
return;
}
DataTable dt = new DataTable();
dt.Columns.Add("type", typeof(string));
dt.Columns.Add("nodeID", typeof(int));
dt.Columns.Add("filename", typeof(string));
dt.Columns.Add("title", typeof(string));
dt.Columns.Add("modifiedBy", typeof(string));
dt.Columns.Add("dateModified", typeof(DateTime));
foreach (DictionaryEntry de in nodeInfo)
{
publishNodeInfo pni = (publishNodeInfo)de.Value;
DataSet ds = SFGlobal.DAL.execDataSet(pni.SelectSP, null);
foreach (DataRow dr in ds.Tables[0].Rows)
{
dt.Rows.Add(new object[] { pni.Name, (int)dr["nodeID"], dr["filename"].ToString(), dr["title"].ToString(), dr["username"].ToString(), (DateTime)dr["dateModified"] });
}
}
dt.DefaultView.Sort = "dateModified DESC";
itemsGrid.DataSource = dt.DefaultView;
itemsGrid.DataBind();
if (dt.Rows.Count == 0)
{
itemsGrid.Visible = false;
}
}
private HybridDictionary getNodeInfo(string xmlFile)
{
HybridDictionary hd = new HybridDictionary();
XmlDocument xd = new XmlDocument();
try
{
xd.Load(xmlFile);
foreach (XmlNode xn in xd["nodeTypes"])
{
if (xn.Attributes["publishSP"] != null && xn.Attributes["selectSP"] != null)
{
publishNodeInfo pni = new publishNodeInfo();
pni.Name = xn.Attributes["name"].Value;
pni.PublishSP = xn.Attributes["publishSP"].Value;
pni.SelectSP = xn.Attributes["selectSP"].Value;
hd.Add(pni.Name, pni);
}
}
}
catch (Exception e)
{
throw new DuryTools.ErrorHandler("can't read xml..." + xmlFile, e);
}
return(hd);
}
private void publishItems()
{
string s = "";
// first publish the nodes
SFGlobal.DAL.execNonQuery("publishNodes", null);
s += "published nodes<br>";
// now publish what we want...
foreach (ListItem li in nodesToPublish.Items)
{
if (li.Selected)
{
publishNodeInfo pni = (publishNodeInfo)nodeInfo[li.Value];
SFGlobal.DAL.execNonQuery(pni.PublishSP, null);
s += "published " + pni.Name + "<BR>";
}
}
SFGlobal.UpdateNodes();
getItemsForPublish();
results.Text = s;
}
