/// <summary> /// Handles the OnClick event of the btnAddMenuTab control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnAddMenuTab_OnClick(object sender, EventArgs e) { if (!string.IsNullOrEmpty(hdnMenuID.Value)) { var menuUpdate = dataManager.Menu.SelectByID(Guid.Parse(hdnMenuID.Value)); menuUpdate.Title = txtMenuTabTitle.Text; menuUpdate.TabName = txtMenuName.Text; dataManager.Menu.Update(menuUpdate); } else { var order = 0; var menus = dataManager.Menu.SelectByAccessProfileID(AccessProfileID); if (menus != null && menus.Count > 0) { order = menus.OrderByDescending(a => a.Order).First().Order + 1; } var menuId = Guid.NewGuid(); var menuAdd = new tbl_Menu(); menuAdd.ID = menuId; menuAdd.AccessProfileID = AccessProfileID; menuAdd.Title = txtMenuTabTitle.Text; menuAdd.TabName = txtMenuName.Text; menuAdd.Order = order; dataManager.Menu.Add(menuAdd); } BindTreeMenu(); }
/// <summary> /// Handles the OnNodeDrop event of the rtvTreeModules control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="Telerik.Web.UI.RadTreeNodeDragDropEventArgs"/> instance containing the event data.</param> protected void rtvTreeModules_OnNodeDrop(object sender, RadTreeNodeDragDropEventArgs e) { // Only tabs if (e.DestDragNode.Level == 1) { e.DestDragNode.Nodes.Add(e.DraggedNodes[0]); e.DraggedNodes[0].Selected = true; var order = 0; var menus = dataManager.Menu.SelectByAccessProfileID(AccessProfileID).Where(a => a.ParentID == Guid.Parse(e.DestDragNode.Attributes["NodeID"])).ToList(); if (menus.Count > 0) { order = menus.OrderByDescending(a => a.Order).First().Order + 1; } var menuId = Guid.NewGuid(); var menuAdd = new tbl_Menu(); menuAdd.ID = menuId; menuAdd.ParentID = Guid.Parse(e.DestDragNode.Attributes["NodeID"]); menuAdd.AccessProfileID = AccessProfileID; menuAdd.ModuleID = Guid.Parse(e.DraggedNodes[0].Value); menuAdd.Order = order; dataManager.Menu.Add(menuAdd); BindTreeModules(); BindTreeMenu(); } }
/// <summary> /// Adds the specified menu. /// </summary> /// <param name="menu">The menu.</param> /// <returns></returns> public tbl_Menu Add(tbl_Menu menu) { if (menu.ID == Guid.Empty) { menu.ID = Guid.NewGuid(); } _dataContext.tbl_Menu.AddObject(menu); _dataContext.SaveChanges(); return(menu); }
public bool Update(tbl_Menu menu) { try { var entity = db.tbl_Menu.Find(menu.ID); entity.Text = menu.Text; entity.Status = menu.Status; entity.Text = menu.Text; entity.tbl_TypeMenu.ID = menu.tbl_TypeMenu.ID; db.SaveChanges(); return(true); } catch (Exception) { return(false); throw; } }
public JsonResult AddNewFoodItem(MenuItems menu) { int currentUserTypeLoggedin = Convert.ToInt32(Request.Cookies["UserType"].Value); tbl_Menu item = new tbl_Menu(); item.Food_Item_Name = menu.Food_Item_Name; item.Details = menu.Details; item.Price = menu.Price; item.FoodType = menu.FoodType; item.AddedBy = Request.Cookies["AddedBy"].Value; item.InventoryID = menu.InventoryID; if (currentUserTypeLoggedin == 2) { item.NewItemApprvFrmSuperAdm = false; } else { item.NewItemApprvFrmSuperAdm = true; } item.DelItemApprvFromSuperAdm = false; context.tbl_Menu.Add(item); context.SaveChanges(); return(Json(currentUserTypeLoggedin)); }
public static void Seed(this ModelBuilder modelBuilder) { //if (!System.Diagnostics.Debugger.IsAttached) // System.Diagnostics.Debugger.Launch(); //context.Privilliges.RemoveRange(context.Privilliges.ToList()); //context.Menus.RemoveRange(context.Menus.ToList()); //context.SaveChanges(); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Privillige] ON"); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Menu] ON"); //context.Database.ExecuteSqlCommand("TRUNCATE TABLE [tbl_Privillige]"); //context.Database.ExecuteSqlCommand("TRUNCATE TABLE [tbl_Menu]"); //DBCC CHECKIDENT('tbl_Privillige',RESEED, 0) #region Seed #region UserTypes tbl_UserType ut1 = new tbl_UserType() { NameAr = "مريض", NameEn = "Patient" }; tbl_UserType ut2 = new tbl_UserType() { NameAr = "طبيب", NameEn = "Doctor" }; tbl_UserType ut3 = new tbl_UserType() { NameAr = "ادارة النظام", NameEn = "Administrator" }; fillbase(ut1); fillbase(ut2); fillbase(ut3); modelBuilder.Entity <tbl_UserType>().HasData(ut1, ut2, ut3); #endregion #region Privilliges tbl_Privillige Page_administration = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_administration.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_administration.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_administration.ToString() }; tbl_Privillige Page_Groups = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_Groups.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_Groups.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_Groups.ToString() }; tbl_Privillige Page_Groups_Add = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_Groups_Add.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_Groups_Add.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_Groups_Add.ToString() }; tbl_Privillige Page_Users = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_Users.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_Users.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_Users.ToString() }; tbl_Privillige Page_Users_Add = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_Users_Add.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_Users_Add.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_Users_Add.ToString() }; fillbase(Page_Groups); fillbase(Page_Groups_Add); fillbase(Page_Users); fillbase(Page_Users_Add); fillbase(Page_administration); modelBuilder.Entity <tbl_Privillige>().HasData(Page_Groups, Page_Groups_Add, Page_Users, Page_Users_Add, Page_administration); #endregion #region Privilliges_Groups tbl_Group AdminGroup = new tbl_Group() { NameAr = common.Enums.Enum_PrivilligesGroup.AdminGroup.ToString(), NameEn = common.Enums.Enum_PrivilligesGroup.AdminGroup.ToString() }; tbl_Group DoctorGroup = new tbl_Group() { NameAr = common.Enums.Enum_PrivilligesGroup.DoctorGroup.ToString(), NameEn = common.Enums.Enum_PrivilligesGroup.DoctorGroup.ToString() }; tbl_Group PatientGroup = new tbl_Group() { NameAr = common.Enums.Enum_PrivilligesGroup.PatientGroup.ToString(), NameEn = common.Enums.Enum_PrivilligesGroup.PatientGroup.ToString() }; fillbase(AdminGroup); fillbase(DoctorGroup); fillbase(PatientGroup); modelBuilder.Entity <tbl_Group>().HasData(AdminGroup, DoctorGroup, PatientGroup); #endregion #region Menu List <tbl_Menu> Menus = new List <tbl_Menu>(); #region Security //tbl_Menu Menu_Security_Privilliges = new tbl_Menu() //{ // NameAr = "Privilliges", // icon = "ion-card", // NameEn = "Privilliges", // link = "/pages/Security/privilliges/Index", //}; tbl_Menu Menu_Security = new tbl_Menu() { ParentID = null, NameAr = " الادارة", NameEn = "administration", icon = "ion-settings", link = "", PrivilligeID = Page_administration.ID, //Children = new List<tbl_Menu>() //{ // Menu_Security_Users, // Menu_Security_Groups, //} }; fillbase(Menu_Security); tbl_Menu Menu_Security_Groups = new tbl_Menu() { ID = Guid.NewGuid(), ParentID = Menu_Security.ID, NameAr = "المجموعات", icon = "fa fa-object-group", NameEn = "groups", link = "/pages/administration/groups", }; fillbase(Menu_Security_Groups); tbl_Menu Menu_Security_Users = new tbl_Menu() { ID = Guid.NewGuid(), ParentID = Menu_Security.ID, NameAr = "المستخدمون", NameEn = "Users", icon = "ion-person-stalker", link = "/pages/administration/users", }; fillbase(Menu_Security_Users); Menus.Add(Menu_Security); Menus.Add(Menu_Security_Groups); Menus.Add(Menu_Security_Users); foreach (var m in Menus) { fillbase(m); foreach (var m_child in m.Children) { fillbase(m_child); } } modelBuilder.Entity <tbl_Menu>().HasData(Menu_Security, Menu_Security_Users, Menu_Security_Groups); #endregion #endregion #region Settings tbl_Setting sett1 = new tbl_Setting() { Conf_Key = "Active_Directory_Domain", Conf_Value = "GETGROUP.com" }; fillbase(sett1); modelBuilder.Entity <tbl_Setting>().HasData(sett1); #endregion #region Users tbl_User ahmedadmin = new tbl_User() { Email = "*****@*****.**", NameAr = "احمد حسن", NameEn = "ahmed hassan", Password = "******", isActivated = true, Mobile = "01111376958", Name = "*****@*****.**", ActivationStartDate = DateTime.Now.AddDays(-1), ActivationEndDate = null, UserTypeID = ut3.ID }; tbl_User user1 = new tbl_User() { Email = "*****@*****.**", NameAr = "admin1", NameEn = "admin1", Password = "******", isActivated = true, ActivationStartDate = DateTime.Now.AddDays(-1), ActivationEndDate = DateTime.MaxValue }; tbl_User user2 = new tbl_User() { Email = "*****@*****.**", NameAr = "admin2", NameEn = "admin2", Password = "******", isActivated = true, ActivationStartDate = DateTime.Now.AddDays(-1), ActivationEndDate = DateTime.MaxValue, }; fillbase(ahmedadmin); fillbase(user1); fillbase(user2); modelBuilder.Entity <tbl_User>().HasData(ahmedadmin); List <tbl_Privilligetbl_User> usersInPriv = new List <tbl_Privilligetbl_User>() { new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_Groups.ID, //Privillige = Page_Groups }, new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_Groups_Add.ID, //Privillige = Page_Groups_Add }, new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_Users.ID, //Privillige = Page_Users }, new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_Users_Add.ID, //Privillige = Page_Users_Add }, new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_administration.ID, //Privillige = Page_Users_Add } }; //var ahmedadminPriv0 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_administration //}; //var ahmedadminPriv1 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_Groups //}; //var ahmedadminPriv2 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_Users //}; //var ahmedadminPriv3 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_Groups_Add //}; //var ahmedadminPriv4 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_Users_Add //}; modelBuilder.Entity <tbl_Privilligetbl_User>().HasData(usersInPriv[0], usersInPriv[1], usersInPriv[2], usersInPriv[3], usersInPriv[4]); #endregion #endregion // context.Database.ExecuteSqlCommand(@"CREATE SEQUENCE [dbo].[ReferenceNmberSequence] // AS[bigint] // START WITH 40425942 // INCREMENT BY 1 // MINVALUE - 9223372036854775808 // MAXVALUE 99999999 // CACHE //GO"); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Privillige] OFF"); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Menu] OFF"); }
/// <summary> /// Updates the specified menu. /// </summary> /// <param name="menu">The menu.</param> public void Update(tbl_Menu menu) { _dataContext.SaveChanges(); }
/// <summary> /// Menus the actions. /// </summary> /// <param name="selectedNode">The selected node.</param> /// <param name="commandName">Name of the command.</param> /// <param name="commandArgument">The command argument.</param> protected void MenuActions(RadTreeNode selectedNode, string commandName, string commandArgument) { switch (commandName) { case "AddTab": hdnMenuID.Value = ""; txtMenuTabTitle.Text = ""; txtMenuName.Text = ""; rttAddTab.Show(); break; case "Rename": if (rtvTreeMenu.SelectedNode.Level == 1) { var menu = dataManager.Menu.SelectByID(Guid.Parse(rtvTreeMenu.SelectedNode.Attributes["NodeID"])); if (menu != null) { hdnMenuID.Value = menu.ID.ToString(); txtMenuTabTitle.Text = menu.Title; txtMenuName.Text = menu.TabName; rttAddTab.Show(); } } if (IsSiteProfiles && rtvTreeMenu.SelectedNode.Level == 2) { var menu = dataManager.Menu.SelectByID(Guid.Parse(rtvTreeMenu.SelectedNode.Attributes["NodeID"])); if (menu != null) { txtMenuItemTitle.Text = string.IsNullOrEmpty(menu.Title) ? menu.tbl_Module.Title : menu.Title; var accessProfileModule = menu.tbl_AccessProfile.tbl_AccessProfileModule.SingleOrDefault(o => o.ModuleID == menu.ModuleID); ddlModuleEditionAction.Items.Clear(); if (accessProfileModule != null && accessProfileModule.ModuleEditionID.HasValue) { var moduleEditionActions = dataManager.ModuleEditionAction.SelectByModuleEditionId(accessProfileModule.ModuleEditionID.Value); ddlModuleEditionAction.DataSource = moduleEditionActions; ddlModuleEditionAction.DataTextField = "Title"; ddlModuleEditionAction.DataValueField = "ID"; ddlModuleEditionAction.DataBind(); ddlModuleEditionAction.Items.Insert(0, new ListItem("Выберите значение", "")); } if (menu.ModuleEditionActionID.HasValue) { ddlModuleEditionAction.SelectedIndex = ddlModuleEditionAction.FindItemIndexByValue(menu.ModuleEditionActionID.Value.ToString()); } lbtnEditMenu.CommandArgument = menu.ID.ToString(); rttEditMenu.Show(); } } break; case "Delete": if (selectedNode.Level == 1 || selectedNode.Level == 2) { dataManager.Menu.DeleteByMenuID(Guid.Parse(selectedNode.Attributes["NodeID"])); } BindTreeMenu(); break; case "ResetMenu": dataManager.Menu.DeleteAllByAccessProfileID(AccessProfileID); BindTreeMenu(); break; case "CopyMenu": using (var scope = new TransactionScope()) { dataManager.Menu.DeleteAllByAccessProfileID(AccessProfileID); var copyMenu = dataManager.Menu.SelectByAccessProfileID(Guid.Parse(commandArgument)); var copyMenuTabs = copyMenu.Where(a => a.ModuleID.Equals(null)); if (copyMenu != null) { foreach (var copyMenuTab in copyMenuTabs) { var menuTab = new tbl_Menu { AccessProfileID = AccessProfileID, Title = copyMenuTab.Title, TabName = copyMenuTab.TabName, Order = copyMenuTab.Order }; menuTab = dataManager.Menu.Add(menuTab); var copyMenuModules = copyMenu.Where(a => a.ParentID == copyMenuTab.ID); foreach (var copyMenuModule in copyMenuModules) { var menuModule = new tbl_Menu { ParentID = menuTab.ID, AccessProfileID = AccessProfileID, ModuleID = copyMenuModule.ModuleID, ModuleEditionActionID = copyMenuModule.ModuleEditionActionID, Title = copyMenuModule.Title, Order = copyMenuModule.Order }; dataManager.Menu.Add(menuModule); } } } scope.Complete(); } BindTreeMenu(); break; } }
public long Insert(tbl_Menu menu) { db.tbl_Menu.Add(menu); db.SaveChanges(); return(menu.ID); }
public ActionResult Manage(MenuInfo info) { var service = Container.GetService <IMenuService>(); var result = new Manage.Common.AjaxResult() { }; try { if (info.Key == 0) { if (!(info.Name.Length > 0)) { result.State = false; result.Message = "菜单名不能为空"; } else { if (!CanCreated) { ViewBag.Message = CannotAddText; return(View("Error")); } var menu = new tbl_Menu(); menu.C_Name = info.Name; menu.C_Description = info.Description; menu.C_ParentMenu = info.ParentKey; menu.C_Controller = info.Controller; menu.C_Action = info.Action; menu.C_CreatedDate = DateTime.Now; result.State = service.Add(menu); if (result.State) { result.Message = "添加成功"; } else { result.Message = "添加失败"; } } } else { if (!CanUpdated) { ViewBag.Message = CannotUpateText; return(View("Error")); } var menu = service.GetModels(m => m.keyid == info.Key).FirstOrDefault(); menu.C_Name = info.Name; menu.C_Description = info.Description; menu.C_ParentMenu = info.ParentKey; menu.C_Controller = info.Controller; menu.C_Action = info.Action; menu.C_UpdatedDate = DateTime.Now; if (menu != null) { result.State = service.Update(menu); if (result.State) { result.Message = "修改成功"; } else { result.Message = "修改失败"; } } else { result.Message = "错误,不存在此菜单,修改失败"; } } } catch (Exception ex) { result.Message = ex.Message; } return(Json(result)); }