gistfile1.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Intranet.minicms
{
    public class MenuCMS : IMenu
    {
        SmgIntranetContainer mycontainer;

        public int Id { get; private set; }
        public string BezeichnungDE { get; private set; }
        public string BezeichnungIT { get; private set; }
        public int Order { get; private set; }
        public int Level { get; private set; }
        public int Parent { get; private set; }
        public int Node { get; private set; }

        public int SuccessorNodeID { get; private set; }
        public int PrecedessorNodeID { get; private set; }
        

        MenuCms menu;

        public MenuCMS(MenuCms mymenu)
        {
            mycontainer = GlobalContainer.Instance;

            menu = mymenu;
            Id = menu.Id;
            BezeichnungDE = menu.NameDE;
            BezeichnungIT = menu.NameIT;
            Order = menu.Order;
            Level = menu.Level;
            Parent = menu.ParentId;
            Node = menu.NodeId;

            var SuccessorNode = (from xy in mycontainer.MenuCmsSet where xy.Level == Level orderby xy.Order select xy).AsEnumerable().SkipWhile(n => n.Order <= Order).Take(1);
            SuccessorNodeID = SuccessorNode.FirstOrDefault().Id;
            var PrecedessorNode = (from xy in mycontainer.MenuCmsSet where xy.Level == Level orderby xy.Order select xy).AsEnumerable().SkipWhile(n => n.Order >= Order).Take(1);
            PrecedessorNodeID = PrecedessorNode.FirstOrDefault().Id;
        }        

    }
}