protected void Page_Load(object sender, EventArgs e)
{
header1.Visible = false;
Response.ContentType = "text/xml; charset=utf-8";
using (dboManager dboManager = new dboManager())
{
SqlDataReader reader = dboManager.ExecuteQuery("SELECT * FROM [examples] WHERE [status] = 'Active' ORDER BY [lastUpdate] DESC");
XmlDocument xmlDoc = new XmlDocument();
XmlNode declaration = xmlDoc.CreateNode(XmlNodeType.XmlDeclaration, null, null);
xmlDoc.AppendChild(declaration);
XmlNode urlset = xmlDoc.CreateNode(XmlNodeType.Element, "urlset", "http://www.sitemaps.org/schemas/sitemap/0.9");
while (reader.Read())
{
XmlNode url = xmlDoc.CreateNode(XmlNodeType.Element, "url", null);
XmlNode loc = xmlDoc.CreateNode(XmlNodeType.Element, "loc", null);
loc.InnerXml = "http://www.sbirkaprikladu.eu/p/" + reader["id"].ToString();
XmlNode lastmod = xmlDoc.CreateNode(XmlNodeType.Element, "lastmod", null);
DateTime lastUpdate = Convert.ToDateTime(reader["lastUpdate"].ToString());
lastmod.InnerXml = lastUpdate.ToString("yyyy-MM-dd");
url.AppendChild(loc);
url.AppendChild(lastmod);
urlset.AppendChild(url);
}
xmlDoc.AppendChild(urlset);
Response.Write(xmlDoc.OuterXml.Replace(" xmlns=\"\"", ""));
}
}
public void fillTreeView(string dboTableName, TreeView treeViewToFillId)
{
List <oneNodeObject> list = new List <oneNodeObject>();
using (dboManager dboManager = new dboManager())
{
SqlDataReader reader = dboManager.ExecuteQuery("SELECT * FROM [" + dboTableName + "] ORDER BY [position],[name]");
while (reader.Read())
{
bool pomHasCheckBox = false;
bool pomChecked = false;
try { if (reader["checked"] != null)
{
pomHasCheckBox = true; pomChecked = Convert.ToBoolean(reader["checked"].ToString());
}
}
catch { }
oneNodeObject pomNode = new oneNodeObject()
{
Id = Convert.ToInt64(reader["id"].ToString()), Name = reader["name"].ToString(), ParentId = Convert.ToInt64(reader["parentId"].ToString()), hasCheckBox = pomHasCheckBox
};
list.Add(pomNode);
}
}
treeViewToFillId.Nodes.Clear();
tvRecursive(list, null, treeViewToFillId);
}