public static List<MenuType> getMenuType()
{
DataClasses1DataContext ctx = new DataClasses1DataContext();
var result = from r in ctx.MenuTypes select r;
return result.ToList();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (inputName.Enabled == false) return;
this.selectedNode = menuTree.SelectedNode;
DataClasses1DataContext ctx = new DataClasses1DataContext();
switch (activeMode)
{
case SaveMode.edit:
int nodeId = Convert.ToInt32(this.selectedNode.Name);
try
{
Menus menu2edit = (from m in ctx.Menus where m.idMenu == nodeId select m).First();
menu2edit.MenuName = inputName.Text;
menu2edit.Description = inputDescription.Text;
}
catch (Exception) { }
break;
case SaveMode.add:
Menus menu2add = new Menus();
try
{
if (menuTree.SelectedNode == null)
{// add root menu ...
menu2add.idParentMenu = null;
menu2add.MenuType = MENU_LEVEL0;
int? lastMenu = menusDB.FindAll(i => i.idParentMenu == null).Max(i => i.MenuOrder);
if (lastMenu == null)
menu2add.MenuOrder = 1;
else
menu2add.MenuOrder = lastMenu + 1;
}
else
{
Menus selectedNode = menusDB.Find(i => i.idMenu == Convert.ToInt32(menuTree.SelectedNode.Name));
if (selectedNode.idParentMenu == null)
{
menu2add.idParentMenu = selectedNode.idMenu;
menu2add.MenuType = MENU_LEVEL1;
}
else
{
menu2add.idParentMenu = selectedNode.idMenu;
menu2add.MenuType = MENU_LEVEL2;
}
}
menu2add.MenuName = inputName.Text;
menu2add.Description = inputDescription.Text;
ctx.Menus.InsertOnSubmit(menu2add);
}
catch (Exception) { }
break;
default:
break;
}
ctx.SubmitChanges();
loadTreeMenu();
this.enableInputs(false);
}
private void menuRemove_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show("Delete???","attention",MessageBoxButtons.YesNo);
if (DialogResult.Yes == dialog)
{
DataClasses1DataContext ctx = new DataClasses1DataContext();
int? id = Convert.ToInt32(menuTree.SelectedNode.Name);
Menus menu2delete = (from m in ctx.Menus where m.idMenu == id select m).First();
ctx.Menus.DeleteOnSubmit(menu2delete);
ctx.SubmitChanges();
loadTreeMenu();
}
}
private void switchNodes(object sender, DragEventArgs e)
{
TreeNode dragNode, destNode;
if (e.Data.GetDataPresent("System.Windows.Forms.TreeNode", false))
{
Point pt = ((TreeView)sender).PointToClient(new Point(e.X, e.Y));
dragNode = (TreeNode)e.Data.GetData("System.Windows.Forms.TreeNode");
Menus dragData = (Menus)dragNode.Tag;
int? dragNodeId = Convert.ToInt32(dragNode.Name);
int dragIndex = this.menusDB.FindIndex(i => i.idMenu == dragNodeId);
destNode = ((TreeView)sender).GetNodeAt(pt);
if (destNode == null) return; // dragged to an empty space ...
Menus destData = (Menus)destNode.Tag;
int? destNodeId = Convert.ToInt32(destNode.Name);
int destIndex = this.menusDB.FindIndex(i => i.idMenu == destNodeId);
// avoid these drags ...
if (dragData.idMenu == destData.idMenu) return;
if (dragData.idParentMenu == destData.idMenu) return;
DataClasses1DataContext ctx = new DataClasses1DataContext();
Menus dragMenu = (from m in ctx.Menus where m.idMenu == dragNodeId select m).First();
Menus destMenu = (from m in ctx.Menus where m.idMenu == destNodeId select m).First();
// node dragged into another of the same type
if (dragData.MenuType.Equals(destData.MenuType))
{
// swap order ...
int? tmpOrder = dragMenu.MenuOrder;
dragMenu.MenuOrder = destMenu.MenuOrder;
destMenu.MenuOrder = tmpOrder;
if (dragData.idParentMenu != destData.idParentMenu)
{
int? tmpIdParentMenu = dragMenu.idParentMenu;
dragMenu.idParentMenu = destMenu.idParentMenu;
destMenu.idParentMenu = tmpIdParentMenu;
}
ctx.SubmitChanges();
selectedNode = dragNode;
loadTreeMenu();
try
{
menuTree.SelectedNode = menuTree.Nodes.Find(Convert.ToString(destMenu.idParentMenu), true).First();
menuTree.SelectedNode.Expand();
menuTree.SelectedNode = menuTree.Nodes.Find(Convert.ToString(dragMenu.idParentMenu), true).First();
menuTree.SelectedNode.Expand();
}
catch (Exception) { }
return;
}
TreeNode parentDragNode;
Menus parentDragMenu;
try
{
parentDragNode = menuTree.Nodes.Find(Convert.ToString(dragMenu.idParentMenu), true).First();
parentDragMenu = parentDragNode.Tag as Menus;
}
catch (Exception) { return; }
// when a node is dragged to a node with the same level of the parentMenu ...
if (parentDragMenu.MenuType.Equals(destMenu.MenuType))
{
// get biggest menu order
int? biggest = menusDB.FindAll(i => i.idParentMenu == destMenu.idMenu).Max(m => m.MenuOrder);
int? dragMenuOriginalParentID = dragMenu.idParentMenu;
if (biggest != null)
{
dragMenu.MenuOrder = biggest + 1;
dragMenu.idParentMenu = destMenu.idMenu;
}
else
{
dragMenu.MenuOrder = 1;
dragMenu.idParentMenu = destMenu.idMenu;
}
ctx.SubmitChanges();
loadTreeMenu();
// expand both nodes
try
{
this.menuTree.SelectedNode = menuTree.Nodes.Find(Convert.ToString(destMenu.idMenu), true).First();
this.menuTree.SelectedNode.Expand();
this.menuTree.SelectedNode = menuTree.Nodes.Find(Convert.ToString(dragMenuOriginalParentID), true).First();
this.menuTree.SelectedNode.Expand();
}
catch (Exception) { }
return;
}
}
}
private void loadTreeMenu()
{
this.menuTree.Nodes.Clear();
// retrieve all menus from DB
DataClasses1DataContext ctx = new DataClasses1DataContext();
this.menusDB = (from m in ctx.Menus select m).ToList();
// root menus only ...
Menus[] rootMenus = menusDB.FindAll(i => i.idParentMenu == null).ToArray();
// sort them ...
Array.Sort(rootMenus, delegate(Menus mn1, Menus mn2)
{ return (int)(mn1.MenuOrder - mn2.MenuOrder); });
// add ROOT
foreach (var item in rootMenus)
{
TreeNode rootNode = new TreeNode();
rootNode.Name = item.idMenu.ToString();
rootNode.Text = item.MenuName;
rootNode.Tag = item;
menuTree.Nodes.Add(rootNode);
Menus[] subMenu = menusDB.FindAll(i => i.idParentMenu == item.idMenu).ToArray();
// check if there is a subMenu for this rootMenu ...
if (subMenu != null && subMenu.Length != 0)
{
Array.Sort(subMenu, delegate(Menus mn1, Menus mn2)
{ return (int)(mn1.MenuOrder - mn2.MenuOrder); });
// add SUB
fillNodes(subMenu,rootNode);
}
}
try
{
menuTree.SelectedNode = menuTree.Nodes.Find(selectedNode.Name, true).First();
menuTree.Select();
}
catch (Exception)
{
}
}