public ActionResult <IEnumerable <MenuAccess> > GetMenuAcces()
{
foreach (var person in _context.MenuAccess)
{
var menuacces = new MenuAccess()
{
SubMenuId = person.SubMenuId
};
_context.MenuAccess.Add(menuacces);
}
return(StatusCode(500));
//MenuAccess menuaccess = new MenuAccess();
//using (ApplicationDbContext _context = new ApplicationDbContext())
//{
// menuaccess.SubMenuId = _context.Menu
//}
// List<MenuAccess> entities = new List<MenuAccess>();
//entities = (from e in _context.MenuAccess
// where e.RoleId == roleId
// select new MenuAccess
// {
// //Id = e.EmployeeID,
// SubMenuId = e.SubMenuId,
// //LastName = e.LastName,
// //City = e.City,
// //Country = e.Country
// }).ToList();
//return StatusCode(500);
}
public async Task <IActionResult> PutMenuAccess(string roleid, MenuAccess menuAccess)
{
if (roleid != menuAccess.RoleId)
{
return(BadRequest());
}
_context.Entry(menuAccess).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MenuAccessExists(roleid))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void InsertAssignsAndRemoveUnassigns(int menuId, List <int> all, IList <int> selecteds)
{
foreach (var userId in selecteds)
{
var MenuAccess = new MenuAccess
{
UserId = userId,
MenuId = menuId
};
var mAccess = SelectWhere <MenuAccess>(ma => ma.UserId == userId && ma.MenuId == menuId).FirstOrDefault();
if (mAccess == null)
{
Insert(MenuAccess);
}
all.Remove(userId);
}
foreach (var userId in all)
{
var mAccess = SelectWhere <MenuAccess>(ma => ma.UserId == userId && ma.MenuId == menuId).FirstOrDefault();
if (mAccess != null)
{
Delete(mAccess);
}
}
}
public int AddMenuAccess(MenuAccess menuaccess)
{
Utilities.Try(() =>
{
output = _menuAccessControl.CreateUserAccess(menuaccess);
}, "AddMenuAccess", log);
return(output);
}
public async Task <IActionResult> DeleteUserToGroup(MenuAccess access)
{
int Result = await menu.DeleteUserToGroup(access);
if (Result > 0)
{
return(Ok(Result));
}
return(BadRequest());
}
public IEnumerable <MenuAccess> GetAccessMenu(int currentUser)
{
using (MesaDineroContext context = new MesaDineroContext())
{
string raizRuta = ConfigurationManager.AppSettings["RutaMenu"];
var usuario = context.Tb_MD_Mae_Usuarios.First(x => x.iIdUsuario == currentUser);
IEnumerable <Tb_MD_Perfiles> perfiles;
perfiles = usuario.Tb_MD_PerfilUsuario.Select(x => x.Tb_MD_Perfiles).ToList();
var result = perfiles.SelectMany(x => x.Tb_MD_PefilPagina.Where(y => y.Tb_MD_Pagina.EsMenu == true).OrderBy(y => y.Tb_MD_Pagina.Orden).Select(y => new MenuAccess
{
Nombre = y.Tb_MD_Pagina.Nombre,
RouteUrl = y.Tb_MD_Pagina.Ruta,
Orden = y.Tb_MD_Pagina.Orden,
MenuId = y.Tb_MD_Pagina.iIdPagina,
ParentMenuId = y.Tb_MD_Pagina.ParentMenu,
Modulo = y.Tb_MD_Pagina.Modulo ?? "",
Icon = y.Tb_MD_Pagina.Icon ?? ""
}));
List <MenuAccess> menues = new List <MenuAccess>();
result.ToList().ForEach(x =>
{
if (menues.Where(y => y.Nombre == x.Nombre).ToList().Count() == 0)
{
MenuAccess men = new MenuAccess();
string ruta = "";
men.Nombre = x.Nombre;
if (x.RouteUrl == null)
{
ruta = "";
}
else
{
if (x.RouteUrl.Length > 0)
{
ruta = raizRuta + x.RouteUrl.Substring(1, x.RouteUrl.Length - 1).Trim();
}
}
men.RouteUrl = ruta;
men.Orden = x.Orden;
men.MenuId = x.MenuId;
men.ParentMenuId = x.ParentMenuId;
men.Modulo = x.Modulo ?? "";
men.Icon = x.Icon ?? "";
menues.Add(men);
}
});
//var lista2 = menues.ToList();
//var listas = result.Select(x => x.Nombre).Distinct();
//return result.ToList();
return(menues.ToList());
}
}
/// <summary>
/// 获取角色菜单分配页面数据
/// </summary>
/// <param name="RoleID"></param>
/// <param name="MenuName"></param>
/// <returns></returns>
public List <Menu_S> GetAllMenuWithRole(string RoleID, string MenuName)
{
using (MenuAccess access = new MenuAccess())
{
var RoleMenuIDs = access.GetRoleMenus(RoleID).Select(s => s.ID);
var spec = Specification <MenuEntity> .Create(c => c.Extend4 == "1" && c.RecordStatus != (int)RecordStatus.UnEnable);
if (!string.IsNullOrWhiteSpace(MenuName))
{
spec &= Specification <MenuEntity> .Create(c => c.MenuName.Contains(MenuName));
}
var AllMenus = access.GetAll <MenuEntity>(spec);
var list = AllMenus.Adapter <MenuEntity, Menu_S>(new List <Menu_S>());
list.ForEach(f => f.IsHas = RoleMenuIDs.Contains(f.ID));
list = list.OrderBy(o => !o.IsHas).ThenBy(t => t.MenuOrder).ToList();
return(list);
}
}
/// <summary>
/// 设定群组对应的用户
/// </summary>
/// <param name="menuID"></param>
/// <param name="groupIDList"></param>
public static void SetMenuGroups(string menuID, List <string> groupIDList)
{
MenuAccess.SetMenuGroups(menuID, groupIDList);
}
public static SysMenu GetMenu(string menu_id)
{
return(MenuAccess.GetMenu(menu_id));
}
public ActionResult MainMenu()
{
var model = new MenuAccess().ReadMenusByMenuTypeId(1);
return(PartialView(model));
}
public async Task <ActionResult <MenuAccess> > PostMenuAccess(string RoleId, MenuAccess menuAccess)
{
if (!_context.MenuAccess.Any(e => e.RoleId == menuAccess.RoleId))
{
_context.MenuAccess.Add(menuAccess);
}
else
{
var pos = await _context.MenuAccess.FirstOrDefaultAsync(e => e.RoleId == menuAccess.RoleId);
if (pos != null)
{
pos.RoleId = menuAccess.RoleId;
pos.SubMenuId = menuAccess.SubMenuId;
}
//return Ok(menuAccess);
}
await _context.SaveChangesAsync();
return(Ok(menuAccess));
//if (!ModelState.IsValid)
//{
// return Page();
//}
//_context.Attach(Movie).State = EntityState.Modified;
//try
//{
// await _context.SaveChangesAsync();
//}
//catch (DbUpdateConcurrencyException)
//{
// if (!MovieExists(Movie.ID))
// {
// return NotFound();
// }
// else
// {
// throw;
// }
//}
//return CreatedAtAction("PostMenuAccess", new { id = menuAccess.RoleId }, menuAccess);
//try
//{
// var newMonthlyAssessment = new MenuAccess
// {
// RoleId = menuAccess.RoleId,
// SubMenuId = menuAccess.SubMenuId,
// };
// _context.MenuAccess.Add(newMonthlyAssessment);
// await _context.SaveChangesAsync();
// return CreatedAtAction("PostMenuAccess", new { id = newMonthlyAssessment.Id }, newMonthlyAssessment);
//}
//catch (DbUpdateException)
//{
//}
//return StatusCode(500);
}
/// <summary>
/// 获取所有的菜单
/// </summary>
/// <returns></returns>
public static List <SysMenu> GetAllMenus()
{
return(MenuAccess.GetAllMenus());
}
public static List <SysGroup> GetMenuGroupList(string menuID)
{
return(MenuAccess.GetMenuGroupList(menuID));
}
/// <summary>
/// when file moveup or movedown, change it's order_index
/// </summary>
/// <param name="fileID">當前移動文件的menu_id</param>
/// <param name="anotherFileID">被交換文件的menu_id</param>
/// <param name="order">當前文件的display_order</param>
/// <param name="anotherOrder">被交換文件的display_order</param>
public static void UpdateOrderIndexOfMenu(string menuID, string anotherMenuID, int order, int anotherOrder)
{
MenuAccess.UpdateOrderIndexOfMenu(menuID, anotherMenuID, order, anotherOrder);
}
/// <summary>
/// 获取Parent下的所有SysMenu
/// </summary>
/// <returns></returns>
public static List <SysMenu> GetChildMenuList(string parentID)
{
return(MenuAccess.GetChildMenuList(parentID));
}
public async Task <int> DeleteUserToGroup(MenuAccess menuAccess)
{
string query = @"DELETE FROM MenuAccess WHERE MenuAccessId = @MenuAccessId";
return(await db.SaveData(query, new { menuAccess.MenuAccessId }));
}
/// <summary>
/// 新增SysMenu
/// </summary>
/// <param name="menu"></param>
public static void InsertMenu(SysMenu menu)
{
MenuAccess.InsertMenu(menu);
}
/// <summary>
/// 删除SysMenu
/// </summary>
/// <param name="menuID"></param>
public static void DeleteMenu(string menuID)
{
MenuAccess.DeleteMenu(menuID);
}
/// <summary>
/// 修改SysMenu
/// </summary>
/// <param name="menu"></param>
public static void UpdateMenu(SysMenu menu)
{
MenuAccess.UpdateMenu(menu);
}
public static SysMenu GetMenuById(string menuID)
{
return(MenuAccess.GetMenuById(menuID));
}
public async Task <int> InsertUserToGroup(MenuAccess menuAccess)
{
string query = @"INSERT INTO MenuAccess OUTPUT inserted.MenuAccessId VALUES (@GroupId,@UserId)";
return(await db.SaveDataReturnId(query, new { menuAccess.GroupId, menuAccess.UserId }));
}
