public void UpdateMenuCategory(MenuCategory MenuCategory)
{
try
{
var MenuCategoryUpdate = _dBContext.MenuCategories.FirstOrDefault(aMenuCategory => aMenuCategory.MenuCategoryId == aMenuCategory.MenuCategoryId);
MenuCategoryUpdate.CategoryName = MenuCategory.CategoryName;
//MenuCategoryUpdate.Orders = MenuCategory.Orders;
//MenuCategoryUpdate.MenuCategories = MenuCategory.MenuCategories;
_dBContext.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <MenuItem> GetMenuItemsByCategory(MenuCategory category)
{
return(_menu.Where(mi => mi.Category == category));
}
public void InsertMenuCategory(MenuCategory MenuCategory)
{
try
{
_dBContext.MenuCategories.Add(MenuCategory);
_dBContext.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateMenuCate(MenuCategory mnc)
{
string query = string.Format(" UPDATE MenuCategory SET Name = N'{1}' WHERE Id = '{0}'", mnc.Id, mnc.Name);
connect.ExecuteNonQuery(query);
}
private static ToolStripMenuItem CreateTopLevelMenuItem(MenuCategory category, IList <IGuiAction> items)
{
var menuItems = items.Select(a => a.ToMenuItem()).ToArray();
return(new ToolStripMenuItem(GetCategoryDescription(category), null, menuItems));
}
public ViewResult Edit(int menuCategoryId)
{
MenuCategory menuCategory = menuRepository.MenuCategories.FirstOrDefault(p => p.MenuCategoryId == menuCategoryId);
return(View(menuCategory));
}
public override void BindingProperty()
{
var MenuCategory = new MenuCategory();
AddToControlList(() => MenuCategory.MenuCategoryName, TbName);
}
public void RegisterMenuCategory(MenuCategory menuCategory)
{
Menu.Add(menuCategory);
}
public void Update(MenuCategory menuCategory)
{
db.Entry(menuCategory).State = EntityState.Modified;
db.SaveChanges();
}
public void Add(MenuCategory menuCategory)
{
db.MenuCategories.Add(menuCategory);
db.SaveChanges();
}
public static MenuItemViewModel GetMenuItemsByMenuCategory(MenuCategory topMenucategory, MenuCategory leftMenuCategory, bool isAdvancedGrid)
{
ICachingService cachingService = IoC.Container.GetInstance <ICachingService>();
var result = new List <MenuItem>();
var usersPermissions = cachingService.GetUserPermissions(Thread.CurrentPrincipal.Identity.ToAccountID());
var accountPermissions = cachingService.GetAccountPermissions(Thread.CurrentPrincipal.Identity.ToAccountID());
var userModules = usersPermissions.Where(s => s.RoleId == (short)Thread.CurrentPrincipal.Identity.ToRoleID() && accountPermissions.Contains(s.ModuleId)).Select(r => r.ModuleId).ToList();
MenuItemViewModel viewModel = new MenuItemViewModel();
if (leftMenuCategory == MenuCategory.LeftMenuAccountSettings)
{
viewModel.IsAccountSettings = true;
}
var menus = new MenuService().GetMenu(topMenucategory.ToString(), leftMenuCategory.ToString(), userModules);
if (isAdvancedGrid)
{
menus = menus.Where(w => w.MenuID != 1 && w.MenuID != 2).ToList();
}
foreach (var parentItem in menus.Where(mi => mi.ParentMenuID.Equals(null)))
{
result.Add(parentItem);
var currentItem = (MenuItem)parentItem;
foreach (var childItem in menus.Where(ci => ci.ParentMenuID == parentItem.MenuID).OrderBy(c => c.SortingID))
{
result.Find(r => r.MenuId == currentItem.MenuId).Children.Add(childItem);
}
}
result.OrderBy(o => o.SortingId).ToList();
viewModel.TopMenuItems = result.GroupBy(s => s.Category).Where(s => s.Key == topMenucategory).SelectMany(group => group).OrderBy(group => group.SortingId).ToList();
viewModel.LeftMenuItems = result.GroupBy(s => s.Category).Where(s => s.Key == leftMenuCategory).SelectMany(group => group).OrderBy(group => group.SortingId).ToList();
return(viewModel);
}
public ActionResult Index()
{
String file = "1";
if (Request.QueryString.Count > 0 && Request.QueryString[0] != String.Empty)
{
file = Request.QueryString[0].ToString();
}
String fileName = System.IO.Path.Combine(Request.PhysicalApplicationPath, String.Format("App_Data/{0}.xml", file));
if (!System.IO.File.Exists(fileName))
{
Response.Write("xml does not exist.");
Response.End();
}
XmlDocument doc = new XmlDocument();
doc.Load(fileName);
Menu model = new Menu();
Settings Settings = new Settings();
foreach (XmlNode setting in doc.SelectNodes("/Menu/Settings"))
{
Settings.ResolutionWidth = setting.Attributes["ResolutionWidth"] == null && setting.Attributes["ResolutionWidth"].Value != String.Empty ? 0 : Int32.Parse(setting.Attributes["ResolutionWidth"].Value);
Settings.ResolutionHeight = setting.Attributes["ResolutionHeight"] == null && setting.Attributes["ResolutionHeight"].Value != String.Empty ? 0 : Int32.Parse(setting.Attributes["ResolutionHeight"].Value);
Settings.OffsetLeft = setting.Attributes["OffsetLeft"] == null && setting.Attributes["OffsetLeft"].Value != String.Empty ? 0 : Int32.Parse(setting.Attributes["OffsetLeft"].Value);
Settings.OffsetTop = setting.Attributes["OffsetTop"] == null && setting.Attributes["OffsetTop"].Value != String.Empty ? 0 : Int32.Parse(setting.Attributes["OffsetTop"].Value);
}
model.Settings = Settings;
model.MenuCategories = new List <MenuCategory>();
XmlNodeList menuCategories = doc.SelectNodes("/Menu/Categories/Category");
// Category In Categories
foreach (XmlNode menuCategory in menuCategories)
{
MenuCategory category = new MenuCategory();
category.Id = menuCategory.Attributes["Id"].Value;
category.Name = menuCategory.Attributes["Name"].Value;
if (menuCategory.Attributes["Description"] != null)
{
category.Description = menuCategory.Attributes["Description"].Value;
}
category.ImageUrl = menuCategory.Attributes["ImageUrl"].Value;
category.ImageOnly = (menuCategory.Attributes["ImageOnly"] != null);
category.Side = menuCategory.Attributes["Side"].Value;
// Items
foreach (XmlNode menuCategoryItems in menuCategory.ChildNodes)
{
category.MenuItems = new List <MenuItem>();
// Item in Items
foreach (XmlNode menuCategoryItem in menuCategoryItems.ChildNodes)
{
MenuItem item = new MenuItem();
item.Id = menuCategoryItem["Id"].InnerText;
item.Name = menuCategoryItem["Name"].InnerText;
item.Description = menuCategoryItem["Description"].InnerText;
item.Price = menuCategoryItem["Price"].InnerText;
item.ImageUrl = menuCategoryItem["ImageUrl"].InnerText;
item.Name = menuCategoryItem["Name"].InnerText;
category.MenuItems.Add(item);
}
}
model.MenuCategories.Add(category);
}
return(View(model));
}
