public string BuildEditorNavigation()
{
//SqlConnection conn = new SqlConnection(Helpers.ConnectionString);
//SqlCommand cmd = new SqlCommand(@"SELECT category_title, category_id FROM categories ORDER BY category_title ASC", conn);
//conn.Open();
//string MenuItems = "";
//SqlDataReader reader = cmd.ExecuteReader();
//while (reader.Read())
//{
// string active = (Request.RawUrl.Contains("News.aspx") && category_id == reader["category_id"].ToString() ? " class='active'" : "");
// MenuItems += String.Format("<li{2}><a href='{0}'>{1}</a></li>", "News.aspx?category_id=" + reader["category_id"], reader["category_title"], active);
//}
//conn.Close();
//return MenuItems;
DataLinqDB db = new DataLinqDB();
string category_id = "0";
if (Request.QueryString["category_id"] != null)
{
category_id = Request.QueryString["category_id"].ToString();
}
string MenuItems = "";
List<category> kategori_title = new List<category>();
if(Convert.ToInt32(Session["role_access"]) >= 100)
{
kategori_title = db.categories.OrderBy(i => i.category_id).ToList();
}
else
{
kategori_title = db.category_editors.Where(i => i.fk_users_id == Convert.ToInt32(Session["user_id"])).Select(ce => ce.category)
.OrderBy(i => i.category_id).ToList();
}
foreach (var item in kategori_title)
{
string active = (Request.RawUrl.Contains("News.aspx") && category_id == item.category_id.ToString() ? " class='active'" : "");
MenuItems += String.Format("<li{2}><a href='{0}'>{1}</a></li>", "News.aspx?category_id=" + item.category_id, item.category_title, active);
}
return MenuItems;
}
public static void RSSOpretKategori(int idvalue = 0)
{
DataLinqDB db = new DataLinqDB();
string k = "kategori";
XmlDocument dom = new XmlDocument();
XmlProcessingInstruction xpi = dom.CreateProcessingInstruction(
"xml", "version=\"1.0\" encoding=\"utf‐8\"");
dom.AppendChild(xpi);
XmlElement rod = dom.CreateElement("rod");
rod.SetAttribute("attribut", k);
List<category> ListCategory;
if (idvalue > 0)
{
ListCategory = db.categories.Where(i => i.category_id == idvalue).ToList();
}
else
{
ListCategory = db.categories.ToList();
}
foreach (var item in ListCategory)
{
XmlElement addRes = dom.CreateElement("channel");
XmlElement navn = dom.CreateElement("title");
navn.AppendChild(dom.CreateTextNode(item.category_title));
addRes.AppendChild(navn);
XmlElement status = dom.CreateElement("description");
status.AppendChild(dom.CreateTextNode(item.category_description));
addRes.AppendChild(status);
XmlElement links = dom.CreateElement("link");
links.AppendChild(dom.CreateTextNode(Url + "Categories.aspx?category_id='" + item.category_id));
addRes.AppendChild(links);
if (idvalue > 0)
{
ListCategory = db.news.Where(i => i.fk_categories_id == idvalue).ToList();
}
else
{
ListCategory = db.news.ToList();
}
foreach (var item1 in collection)
{
}
rod.AppendChild(addRes);
dom.AppendChild(rod);
dom.Save(HttpContext.Current.Server.MapPath("~/feeds/") + k + ".xml");
}
}
