private static List <WebMenu> SetWebMenuList(DataTable WebModuleTable) { try { List <WebMenu> WebMenuList = new List <WebMenu>(); foreach (DataRow dr in WebModuleTable.Rows) { WebMenu theWebMenu = new WebMenu(); theWebMenu.WebMenuID = int.Parse(dr["WebMenuID"].ToString()); theWebMenu.MenuDisplayText = dr["MenuDisplayText"].ToString(); theWebMenu.MenuToolTip = dr["MenuToolTip"].ToString(); theWebMenu.MenuValueText = dr["MenuValueText"].ToString(); theWebMenu.NavigationURL = dr["NavigationURL"].ToString(); theWebMenu.ParentWebMenuID = (dr["ParentWebMenuID"].ToString() == string.Empty)? -1 : int.Parse(dr["ParentWebMenuID"].ToString()); theWebMenu.ImageURL = dr["ImageURL"].ToString(); theWebMenu.DisplayOrder = (dr["DisplayOrder"].ToString() == string.Empty) ? -1 : int.Parse(dr["DisplayOrder"].ToString()); theWebMenu.CanRedirectAfterUserLogin = (dr["CH_FIELD1"].ToString() == "Y" ? "YES" : "NO"); WebMenuList.Add(theWebMenu); } return(WebMenuList); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
private static List <WebMenu> SetWebMenuPermissonList(DataTable WebModuleTable) { try { List <WebMenu> RoleWebMenuList = new List <WebMenu>(); foreach (DataRow dr in WebModuleTable.Rows) { WebMenu objWebMenu = new WebMenu(); objWebMenu.WebRolePermissionID = int.Parse(dr["RolePermissionID"].ToString()); objWebMenu.FormOrMenuID = int.Parse(dr["FormOrMenuID"].ToString()); objWebMenu.WebMenuID = int.Parse(dr["FormOrMenuID"].ToString()); objWebMenu.MenuDisplayText = dr["MenuDisplayText"].ToString(); objWebMenu.PermissionID = int.Parse(dr["PermissionID"].ToString()); objWebMenu.RoleID = int.Parse(dr["RoleID"].ToString()); objWebMenu.RoleDescription = dr["RoleDescription"].ToString(); objWebMenu.PermissionDescription = dr["PermissionDescription"].ToString(); objWebMenu.FormOrMenu = dr["FormOrMenu"].ToString(); RoleWebMenuList.Add(objWebMenu); } return(RoleWebMenuList); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public ActionResult AddOrEditWebMenu(int menuID) { List <WebMenu> menuList = webMenuService.GetWebMenuList(); WebMenu rootMenu = new WebMenu() { EnglishName = "All", IsDisplay = false, ParentID = 0, ParentName = "一级栏目", WebMenuName = "一级栏目", AddOn = DateTime.Now, FlagDelete = 0 }; menuList.Add(rootMenu); IEnumerable <SelectListItem> parentMenus = menuList.Select(m => new SelectListItem { Value = m.WebMenuID.ToString(), Text = m.WebMenuName }); ViewBag.ParentMenus = parentMenus; WebMenu menu = webMenuService.GetMenuByID(menuID); if (menu == null) { menu = new WebMenu(); } return(View(menu)); }
private int Save_MenuItems() { int ProcReturnValue = 0; WebMenu TheWebMenu = new WebMenu(); TheWebMenu.MenuDisplayText = txt_MenuDisplayText.Text; TheWebMenu.NavigationURL = txt_NavigationUrl.Text; TheWebMenu.MenuToolTip = txt_MenuToolTip.Text; if (!string.IsNullOrEmpty(txt_DisplayOrder.Text)) { TheWebMenu.DisplayOrder = int.Parse(txt_DisplayOrder.Text.ToString()); } if (!ddl_SubMenu.SelectedValue.Equals(MicroConstants.DROPDOWNLIST_DEFAULT_ITEMTEXT)) { TheWebMenu.ParentWebMenuID = int.Parse(ddl_SubMenu.SelectedValue); } else { TheWebMenu.ParentWebMenuID = int.Parse(ddl_MenuHead.SelectedValue); } ProcReturnValue = WebMenuManagement.GetInstance.InsertMenuItems(TheWebMenu); return(ProcReturnValue); }
public int UpdateWebMenu(WebMenu webMenu) { using (AIYunNetContext context = new AIYunNetContext()) { if (webMenu != null) { WebMenu originalMenu = context.WebMenu.Find(webMenu.WebMenuID); if (originalMenu != null) { originalMenu.EditOn = DateTime.Now; originalMenu.EnglishName = webMenu.EnglishName; originalMenu.ImageUrl = webMenu.ImageUrl; originalMenu.IsDisplay = webMenu.IsDisplay; originalMenu.ParentID = webMenu.ParentID; originalMenu.ParentName = webMenu.ParentName; originalMenu.ShowOrder = webMenu.ShowOrder; originalMenu.ShowUrl = webMenu.ShowUrl; originalMenu.Style = webMenu.Style; originalMenu.WebMenuName = webMenu.WebMenuName; context.SaveChanges(); return(1); } else { return(0); } } else { return(0); } } }
private static List <WebMenu> GetDepartmentsList(int parentID) { List <WebMenu> ChildSubMenuItems = new List <WebMenu>(); List <Department> deptList = new List <Department>(); deptList = Micro.BusinessLayer.ICAS.STAFFS.DepartmentManagement.GetInstance.GetDepartmentsList(); int ctr = 80000; foreach (Department d in deptList) { //if (d.DepartmentDescription.ToString().ToUpper().Equals("MANAGEMENT")) //{ // continue; //} WebMenu m = new WebMenu(); m.WebMenuID = ctr; ctr++; m.ParentWebMenuID = parentID; m.MenuDisplayText = d.DepartmentDescription; m.NavigationURL = string.Format("about-department-{0}", d.DepartmentDescription.ToString().ToLower()); m.MenuToolTip = string.Format("Click here to learn about the {0} department.", d.DepartmentDescription); ChildSubMenuItems.Add(m); } return(ChildSubMenuItems); }
public static WebMenu GetWebMenuByWebMenuID(int WebMenuID) { DataRow TheWebMenuRow = WebMenuDataAccess.GetInstance.GetWebMenuByWebMenuID(WebMenuID); WebMenu TheWebMenu = DataRowToObject(TheWebMenuRow); return(TheWebMenu); }
private int DeleteRecord() { WebMenu objWebMenu = new WebMenu(); objWebMenu.WebMenuID = int.Parse(PageVariables.SubWebMenuID); int ProcReturnValue = WebMenuManagement.GetInstance.DeleteMenuItems(objWebMenu); return(ProcReturnValue); }
public ActionResult SaveContent(WebMenu input) { var temp = _context.FindDetail <WebMenu>(input.Id); temp.Content = input.Content; temp.UpdatedDate = DateTime.Now; _context.SaveChange(); return(RedirectToAction <WebMenuController>(d => d.Index(temp.LanguageId))); }
public int PutWebGroup(WebGroupDTO obj) { int result = 0; SessionManager.DoWork(session => { WebGroup webGroup = new WebGroup(); webGroup.Id = obj.Id; webGroup.Name = obj.Name; webGroup.WebMenus = new List <WebMenu>(); List <Guid> temp = new List <Guid>(); //Check menu con lấy menu cha foreach (Guid t in obj.WebMenuIds) { WebMenu menu = session.Query <WebMenu>().Where(p => p.Id == t).SingleOrDefault(); temp.Add(menu.Id); if (menu.ParentMenu != null) { temp.Add(menu.ParentMenu.Id); } } obj.WebMenuIds = temp.Distinct().ToList(); foreach (Guid w in obj.WebMenuIds) { //Add menu con của hồ sơ, quá trình, đoàn thể if ((w.ToString() == "00000000-0000-0000-0000-000000000017") || (w.ToString() == "00000000-0000-0000-0000-000000000018") || (w.ToString() == "00000000-0000-0000-0000-000000000020")) { WebMenu web = new WebMenu() { Id = w }; webGroup.WebMenus.Add(web); List <Guid> childList = ChildrenMenuIds(w); foreach (Guid c in childList) { WebMenu cw = new WebMenu() { Id = c }; webGroup.WebMenus.Add(cw); } } else { WebMenu web = new WebMenu() { Id = w }; webGroup.WebMenus.Add(web); } } session.Update(webGroup); result = 1; }); return(result); }
public async Task <WebMenuDTO> GetWebMenuInfoAsync([Required(ErrorMessage = "唯一标识不能为空")] Guid id) { WebMenu webMenuFromDB = await _webMenuRepository.FirstOrDefaultAsync(id); if (webMenuFromDB == null) { throw new InvalidOperationException("网页菜单权限不存在"); } return(_mapper.Map <WebMenuDTO>(webMenuFromDB)); }
public CPApiController(ILogs logs, IConfiguration configuration) { _configuration = configuration; _logs = logs; _menu = new WebMenu(); _templateDetailsService = new SysTemplateDetailsService(); _templateService = new SysTemplateService(); _menuService = new CPMenuService(); _propertyService = new SysPropertyService(); currentLang = StartUp.CurrentLang; }
public int UpdateWebRolePermission(WebMenu objWebMenu) { try { return(WebMenuIntegration.UpdateWebRolePermission(objWebMenu)); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public static int DeleteWebRolePermission(WebMenu objWebMenu) { try { return(WebMenuDataAccess.GetInstance.DeleteWebRolePermission(objWebMenu)); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public int Delete(WebMenu m) { string sql = "delete from WebMenu where Id=@Id"; SqlParameter[] param = { new SqlParameter("@Id", m.Id) }; return(SqlHelper.ExecuteNonQuery(sql, param)); }
private void PopulatePageFields(int theWebMenuId) { WebMenu TheWebMenu = WebMenuManagement.GetInstance.GetWebMenuByWebMenuID(theWebMenuId); txt_MenuDisplayText.Text = TheWebMenu.MenuDisplayText; txt_MenuToolTip.Text = TheWebMenu.MenuToolTip; txt_NavigationUrl.Text = TheWebMenu.NavigationURL; txt_DisplayOrder.Text = TheWebMenu.DisplayOrder.ToString(); ChangeBackColor(view_MenuItemEntry); }
public int Add(WebMenu m) { string sql = "insert into WebMenu(Title,Link,ParentId) values(@Title,@Link,@ParentId)"; SqlParameter[] param = { new SqlParameter("@Title", m.Title), new SqlParameter("@Link", m.Link), new SqlParameter("@ParentId", m.ParentId) }; return(SqlHelper.ExecuteNonQuery(sql, param)); }
public async Task EditWebMenuAsync(EditWebMenuModel model) { WebMenu webMenuFromDB = await _webMenuRepository.FirstOrDefaultAsync(model.ID); if (webMenuFromDB == null) { throw new InvalidOperationException("网页菜单权限不存在"); } model.CopyProperties(webMenuFromDB); webMenuFromDB.UpdateTime = DateTime.Now; _authorityUnitOfWork.RegisterEdit(webMenuFromDB); await _authorityUnitOfWork.CommitAsync(); }
private void PopulateSubMenu(int theWebMenuId) { WebMenu TheWebMenu = WebMenuManagement.GetInstance.GetWebMenuByWebMenuID(theWebMenuId); ddl_SubMenuHead.SelectedIndex = GetSelecteIndex(ddl_SubMenuHead, TheWebMenu.WebMenuID); txt_SubMenuDisplayText.Text = TheWebMenu.MenuDisplayText; txt_SubMenuToolTip.Text = TheWebMenu.MenuToolTip; txt_SubMenuNavigationURL.Text = TheWebMenu.NavigationURL; txt_SubMenuDisplayOrder.Text = TheWebMenu.DisplayOrder.ToString(); ChangeBackColor(view_InputControlChildMenu); }
public WebMenuDTO GetObject(Guid id) { WebMenuDTO result = new WebMenuDTO(); SessionManager.DoWork(session => { WebMenu webmenu = session.Query <WebMenu>().Where(w => w.Id == id).SingleOrDefault(); result.Id = webmenu.Id; result.Name = webmenu.Name; result.Index = webmenu.Index; result.ParentId = webmenu.ParentMenu != null ? webmenu.ParentMenu.Id : Guid.Empty; }); return(result); }
public int Edit(WebMenu m) { string sql = "update WebMenu set Title=@Title,Link=@Link,ParentId=@ParentId where Id=@Id"; SqlParameter[] param = { new SqlParameter("@Title", m.Title), new SqlParameter("@Link", m.Link), new SqlParameter("@ParentId", m.ParentId), new SqlParameter("@Id", m.Id) }; return(SqlHelper.ExecuteNonQuery(sql, param)); }
public DataTable GetWebMenuByRoleID(int RoleID) { try { WebMenu TheWebMenu = new WebMenu(); SqlCommand SqlCmd = new SqlCommand(); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.Add(GetParameter("RoleID", SqlDbType.Int, (RoleID == -1 ? Micro.Commons.Connection.LoggedOnUser.RoleId : RoleID))); SqlCmd.CommandText = "pADM_MenuItemsPermission_SelectByRoleID"; return(ExecuteGetDataTable(SqlCmd)); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public JsonResult AddOrEditWebMenu(WebMenu menu) { int result = 0; WebMenu parentMenu = webMenuService.GetMenuByID(menu.ParentID); menu.ParentName = parentMenu != null ? parentMenu.WebMenuName : string.Empty; if (menu.WebMenuID > 0) { result = webMenuService.UpdateWebMenu(menu); } else { result = webMenuService.AddWebMenu(menu); } return(Json(new { RetCode = 1 })); }
public int AddWebMenu(WebMenu webMenu) { using (AIYunNetContext context = new AIYunNetContext()) { if (webMenu != null) { context.WebMenu.Add(webMenu); context.SaveChanges(); return(1); } else { return(0); } } }
public JsonResult AddOrEditWebNews1(WebNews news) { IWebNews newsService = new WebNewsService(); int result = 0; WebMenu parentMenu = webMenuService.GetMenuByID(news.ClassID); news.ClassName = parentMenu != null ? parentMenu.WebMenuName : string.Empty; if (news.ContentID > 0) { result = newsService.updateWebNews(news); } else { result = newsService.AddWebNews(news); } return(Json(new { RetCode = result })); }
private int UpdateSubMenuRecord() { WebMenu theMenu = new WebMenu(); theMenu.MenuDisplayText = txt_SubMenuDisplayText.Text; theMenu.MenuToolTip = txt_SubMenuToolTip.Text; theMenu.NavigationURL = txt_SubMenuNavigationURL.Text; if (!string.IsNullOrEmpty(txt_SubMenuDisplayOrder.Text)) { theMenu.DisplayOrder = int.Parse(txt_SubMenuDisplayOrder.Text); } theMenu.WebMenuID = int.Parse(PageVariables.SubWebMenuID); theMenu.ParentWebMenuID = int.Parse(ddl_SubMenuHead.SelectedValue); int ProcReturnValue = WebMenuManagement.GetInstance.UpdateMenuItems(theMenu); return(ProcReturnValue); }
public int DeleteMenuItem(WebMenu theWebMenu) { int ReturnValue = 0; using (SqlCommand DeleteCommand = new SqlCommand()) { DeleteCommand.CommandType = CommandType.StoredProcedure; DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; DeleteCommand.Parameters.Add(GetParameter("@WebMenuID", SqlDbType.Int, theWebMenu.WebMenuID)); DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, theWebMenu.ModifiedBy)); DeleteCommand.CommandText = "pADM_WebMenuItems_Delete"; ExecuteStoredProcedure(DeleteCommand); ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public int DeleteWebMenu(int menuID) { using (AIYunNetContext context = new AIYunNetContext()) { WebMenu webMenu = context.WebMenu.Find(menuID); if (webMenu != null) { webMenu.FlagDelete = 1; webMenu.DeleteOn = DateTime.Now; context.SaveChanges(); return(1); } else { return(0); } } }
public JsonResult AddOrEditWebFile(WebFile file) { int result = 0; IWebFile webFileService = new WebFileService(); WebMenu parentMenu = webMenuService.GetMenuByID(file.ClassID); file.ClassName = parentMenu != null ? parentMenu.WebMenuName : string.Empty; file.Tags = FileHelper.GetFileTag(file.FileName); if (file.FileID > 0) { result = webFileService.UpdateWebFile(file); } else { result = webFileService.AddWebFile(file); } return(Json(new { RetCode = result })); }
public WebMenu GetWebMenuById(int id) { string sql = "select * from WebMenu where Id = @Id"; SqlParameter[] param = { new SqlParameter("@Id", id) }; var dt = SqlHelper.Query(sql, param); WebMenu menu = null; foreach (DataRow dr in dt.Rows) { menu = FileData(dr); } return(menu); }
public void AddMenu(WebMenu menu) { try { using (var context = new AEPEntities()) { context.WebMenu.AddObject(menu); context.SaveChanges(); } } catch (Exception ex) { if (ex.InnerException.Message.Contains("23505")) throw new Exception("Error: no puede asignar dos menus con el mismo nombre."); else throw new Exception(ex.Message); } }
public void UpdateMenu(WebMenu menu) { using (var context = new AEPEntities()) { //WebMenu menu2 = context.WebMenu.First(i => i.WebMenuId == menu.WebMenuId); //menu2.Descripcion = menu.Descripcion; //menu2.Orden = menu.Orden; //menu2.Url = menu.Url; //menu2.Estado = menu.Estado; context.WebMenu.Attach(context.WebMenu.Single(i => i.WebMenuId == menu.WebMenuId)); context.WebMenu.ApplyCurrentValues(menu); int inte = context.SaveChanges(SaveOptions.DetectChangesBeforeSave); context.SaveChanges(); } }