CREATE TABLE [dbo].[Menu](
[Id_Menu] [int] IDENTITY(1,1) NOT NULL,
[Parent_Id] [int] NULL,
[MenuName] [nvarchar](max) NOT NULL,
[Order] [int] NOT NULL CONSTRAINT [DF_Category_Order] DEFAULT ((0)),
[SeoUrl] [nvarchar](max) NOT NULL,
[PageTitle] [nvarchar](200) NOT NULL,
[Description] [nvarchar](200) NULL,
[SearchWord] [nvarchar](max) NULL,
[LinkURL] [nvarchar](max) NULL,
[ItemPerPage] [int] NOT NULL CONSTRAINT [DF_Menu_ItemPerPage] DEFAULT ((10)),
[IsActive] [bit] NOT NULL CONSTRAINT [DF_Menu_IsActive] DEFAULT ((1)),
[Position] [nvarchar](50) NOT NULL,
[IsVideo] [bit] NOT NULL CONSTRAINT [DF_Menu_IsVideo] DEFAULT ((0)),
[IsMusic] [bit] NOT NULL CONSTRAINT [DF_Menu_IsMusic] DEFAULT ((0)),
[file_stream_id] [uniqueidentifier] NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_Category_CreateDate] DEFAULT (getdate()),
[ModifyDate] [datetime] NOT NULL CONSTRAINT [DF_Category_ModifyDate] DEFAULT (getdate()),
CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED
(
[Id_Menu] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CarFileGroup]
) ON [CarFileGroup] TEXTIMAGE_ON [CarFileGroup]
GO
ALTER TABLE [dbo].[Menu] WITH CHECK ADD CONSTRAINT [FK_Menu_GalleryFile] FOREIGN KEY([file_stream_id])
REFERENCES [dbo].[GalleryFile] ([stream_id])
GO
ALTER TABLE [dbo].[Menu] CHECK CONSTRAINT [FK_Menu_GalleryFile]
GO
ALTER TABLE [dbo].[Menu] WITH CHECK ADD CONSTRAINT [FK_Menu_Menu] FOREIGN KEY([Parent_Id])
REFERENCES [dbo].[Menu] ([Id_Menu])
GO
ALTER TABLE [dbo].[Menu] CHECK CONSTRAINT [FK_Menu_Menu]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'''TDLR'': T=Top,D=Down,L=Left,R=Right' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Menu', @level2type=N'COLUMN',@level2name=N'Position'
GO
public ActionResult TopMenu()
{
return PartialView(viewName: "_PartialTopMenu", model: db.MenuView.Where(p => p.Position == "T").OrderBy(o => o.Order).ToList());
}
menu View :
SELECT TOP (100) PERCENT dbo.Menu.Id_Menu, dbo.Menu.Parent_Id, dbo.Menu.MenuName, dbo.Menu.[Order], dbo.Menu.SeoUrl, dbo.Menu.PageTitle, dbo.Menu.Description, dbo.Menu.SearchWord,
dbo.Menu.ItemPerPage, dbo.Menu.IsActive, dbo.Menu.Position, dbo.Menu.IsVideo, dbo.Menu.IsMusic, dbo.Menu.file_stream_id, dbo.Menu.CreateDate, dbo.Menu.ModifyDate,
Menu_1.MenuName AS Parent_MenuName, dbo.Menu.LinkURL
FROM dbo.Menu LEFT OUTER JOIN
dbo.Menu AS Menu_1 ON dbo.Menu.Parent_Id = Menu_1.Id_Menu
ORDER BY dbo.Menu.[Order], dbo.Menu.CreateDate
Partial VIew :
@using Car.Classes
@model IEnumerable<Car.Models.MenuView>
<div class="navbar navbar-default fontyekan navbar-static-top " style="background-color: #5F944C; color: #fff; ">
<div class="container-fluid">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button data-target="#bs-example-navbar-collapse-1" data-toggle="collapse" class="navbar-toggle" type="button">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div id="bs-example-navbar-collapse-1" class="collapse navbar-collapse">
<div class="col-md-12">
<ul class="nav navbar-nav navbar-right">
@{
List<int> idmenu = new List<int>();
}
@foreach (var item in Model)
{
<li>
@foreach (var item2 in Model)
{
if (item.Id_Menu == item2.Parent_Id)
{
if (idmenu.ToList().Where(p => p == item.Id_Menu).Count() == 0)
{
<div class="dropdown" style="margin: 15px; ">
<div class=" dropdown-toggle" type="button" id="menu1" data-toggle="dropdown">
<a style="color:#fff; " tabindex="-1" href="@item.LinkURL">
@item.MenuName
@{
idmenu.Add(item.Id_Menu);
}
</a>
<span class="caret"></span>
</div>
<ul class="dropdown-menu" role="menu" aria-labelledby="menu1">
@foreach (var item3 in Model.Where(p => p.Parent_Id == item.Id_Menu))
{
<li role="presentation">
<a role="menuitem" style="color:#fff; " tabindex="-1" href="@item3.LinkURL">
@item3.MenuName
@{
idmenu.Add(item3.Id_Menu);
}
</a>
</li>
}
</ul>
</div>
}
}
else
{
// break;
}
}
@foreach (var item2 in Model)
{
if (item.Parent_Id == null)
{
if (idmenu.ToList().Where(p => p == item.Id_Menu).Count() == 0)
{
<li role="presentation">
<a role="menuitem" style="color: #fff; margin: 2px; " tabindex="-1" href="@item.LinkURL">
@item.MenuName
@{
idmenu.Add(item.Id_Menu);
}
</a>
</li>
}
}
break;
}
</li>
}
</ul>
</div><!-- /.navbar-collapse -->
</div><!-- /.container-fluid -->
</div>
</div>