Exemple #1
0
        public object Delete(string id)
        {
            ////_logger.LogInformation(LoggingEvents.LogDb, "Delete group user");
            //_actionLog.InsertActionLog("VIB_GROUP_USER", "Delete group user", null, null,false);
            try
            {
                AdPermission  permission  = _context.AdPermissions.SingleOrDefault(x => x.GroupUserCode == id);
                AdUserInGroup userInGroup = _context.AdUserInGroups.SingleOrDefault(x => x.GroupUserCode == id);
                if (permission != null || userInGroup != null)
                {
                    //_logger.LogError(LoggingEvents.LogDb, "Delete group user fail");
                    //_actionLog.InsertActionLog("VIB_GROUP_USER", "Delete department/PC fail", null, null, "Delete");
                    return(Json(new JMessage()
                    {
                        Error = true, Title = String.Format(CommonUtil.ResourceValue("COM_ERR_OBJ_REF"), CommonUtil.ResourceValue("ADM_DEPARTMENT_LBL_DEPT").ToLower())
                    }));
                }
                else
                {
                    var objChild = _context.AdGroupUsers.SingleOrDefault(x => x.ParentCode == id);
                    if (objChild == null)
                    {
                        //AdGroupUser obj = new AdGroupUser();
                        //obj.GroupUserCode = id;
                        //_context.AdGroupUsers.Attach(obj);
                        var obj = _context.AdGroupUsers.FirstOrDefault(x => x.GroupUserId == Int32.Parse(id));
                        _context.AdGroupUsers.Remove(obj);
                        _context.SaveChanges();
                        ////_logger.LogInformation(LoggingEvents.LogDb, "Delete group user successfully");
                        //_actionLog.InsertActionLog("VIB_GROUP_USER", "Delete department/PC successfully", obj, null, "Delete");
                        return(Json(new JMessage()
                        {
                            Error = false, Title = CommonUtil.ResourceValue("ADM_DEPARTMENT_MSG_DELETE_SUCCESS")
                        }));
                    }
                    else
                    {
                        //_logger.LogError(LoggingEvents.LogDb, "Delete group user fail");
                        //_actionLog.InsertActionLog("VIB_GROUP_USER", "Delete department/PC fail", null, null, "Error");

                        return(Json(new JMessage()
                        {
                            Error = true, Title = String.Format(CommonUtil.ResourceValue("COM_MSG_DELETE_CHILD"), CommonUtil.ResourceValue("ADM_DEPARTMENT_LBL_DEPT"))
                        }));
                    }
                }
            }
            catch (Exception ex)
            {
                //_logger.LogError(LoggingEvents.LogDb, "Delete group user fail");
                //_actionLog.InsertActionLog("VIB_GROUP_USER", "Delete department/PC failed: " + ex.Message, null, null, "Error");

                return(Json(new JMessage()
                {
                    Error = true, Title = String.Format(CommonUtil.ResourceValue("COM_MSG_DELETE_FAIL"), CommonUtil.ResourceValue("ADM_DEPARTMENT_LBL_DEPT").ToLower())
                }));
            }
        }
Exemple #2
0
        protected bool UpdatePermissionUserByGroup(EIMDBContext context, string groupCode, string userId, string roleId, string appCode, string newRoleId = null, string newGroupCode = null, string newAppCode = null)
        {
            IQueryable <AdPermission> listPermissionDefault;

            if (newAppCode == null)
            {
                if (newRoleId == null)
                {
                    if (newGroupCode == null || newGroupCode == groupCode)
                    {
                        listPermissionDefault = context.AdPermissions.Where(x => x.GroupUserCode == groupCode && x.UserId == null && x.RoleId == roleId && x.ApplicationCode == appCode);
                    }
                    else
                    {
                        // Remove old permission
                        var listPermissionUser = context.AdPermissions.Where(x => x.GroupUserCode == groupCode && x.UserId != null && x.UserId == userId && x.RoleId == roleId && x.ApplicationCode == appCode);
                        if (listPermissionUser.Any())
                        {
                            context.RemoveRange(listPermissionUser);
                        }

                        // Get new default permission
                        listPermissionDefault = context.AdPermissions.Where(x => x.GroupUserCode == newGroupCode && x.UserId == null && x.RoleId == roleId && x.ApplicationCode == appCode);
                    }
                }
                else
                {
                    // Remove old permission
                    var listPermissionUser = context.AdPermissions.Where(x => x.GroupUserCode == groupCode && x.UserId != null && x.UserId == userId && x.RoleId == roleId && x.ApplicationCode == appCode);
                    if (listPermissionUser.Any())
                    {
                        context.RemoveRange(listPermissionUser);
                    }

                    if (newGroupCode == null || newGroupCode == groupCode)
                    {
                        // Get new default permission
                        listPermissionDefault = context.AdPermissions.Where(x => x.GroupUserCode == groupCode && x.UserId == null && x.RoleId == newRoleId && x.ApplicationCode == appCode);
                    }
                    else
                    {
                        // Get new default permission
                        listPermissionDefault = context.AdPermissions.Where(x => x.GroupUserCode == newGroupCode && x.UserId == null && x.RoleId == newRoleId && x.ApplicationCode == appCode);
                    }
                }
            }
            else
            {
                if (newRoleId == null)
                {
                    if (newGroupCode == null || newGroupCode == groupCode)
                    {
                        listPermissionDefault = context.AdPermissions.Where(x => x.GroupUserCode == groupCode && x.UserId == null && x.RoleId == roleId && x.ApplicationCode == newAppCode);
                    }
                    else
                    {
                        // Remove old permission
                        var listPermissionUser = context.AdPermissions.Where(x => x.GroupUserCode == groupCode && x.UserId != null && x.UserId == userId && x.RoleId == roleId && x.ApplicationCode == appCode);
                        if (listPermissionUser.Any())
                        {
                            context.RemoveRange(listPermissionUser);
                        }

                        // Get new default permission
                        listPermissionDefault = context.AdPermissions.Where(x => x.GroupUserCode == newGroupCode && x.UserId == null && x.RoleId == roleId && x.ApplicationCode == newAppCode);
                    }
                }
                else
                {
                    // Remove old permission
                    var listPermissionUser = context.AdPermissions.Where(x => x.GroupUserCode == groupCode && x.UserId != null && x.UserId == userId && x.RoleId == roleId && x.ApplicationCode == appCode);
                    if (listPermissionUser.Any())
                    {
                        context.RemoveRange(listPermissionUser);
                    }

                    if (newGroupCode == null || newGroupCode == groupCode)
                    {
                        // Get new default permission
                        listPermissionDefault = context.AdPermissions.Where(x => x.GroupUserCode == groupCode && x.UserId == null && x.RoleId == newRoleId && x.ApplicationCode == newAppCode);
                    }
                    else
                    {
                        // Get new default permission
                        listPermissionDefault = context.AdPermissions.Where(x => x.GroupUserCode == newGroupCode && x.UserId == null && x.RoleId == newRoleId && x.ApplicationCode == newAppCode);
                    }
                }
            }

            // Insert new permission of user
            if (listPermissionDefault.Any())
            {
                foreach (var per in listPermissionDefault)
                {
                    // Add new permission
                    var permission = new AdPermission();
                    permission.ApplicationCode = per.ApplicationCode;
                    permission.FunctionCode    = per.FunctionCode;
                    permission.ResourceCode    = per.ResourceCode;
                    permission.GroupUserCode   = per.GroupUserCode;
                    permission.RoleId          = per.RoleId;
                    permission.UserId          = userId;
                    context.AdPermissions.Add(permission);
                }
            }

            return(true);
        }
Exemple #3
0
        public async Task <IActionResult> UpdatePermission([FromBody] PermissionModel model)
        {
            JMessage msg = new JMessage {
                Error = true, Title = string.Format(CommonUtil.ResourceValue("MSG_UPDATE_FAIL"), CommonUtil.ResourceValue("PERMISSION").ToLower())
            };

            try
            {
                if (model.UserInGroups.Count > 0 && model.Resources.Count > 0)
                {
                    foreach (var user in model.UserInGroups)
                    {
                        foreach (var resource in model.Resources)
                        {
                            var permission = await _context.AdPermissions.FirstOrDefaultAsync(x => x.ApplicationCode == model.ApplicationCode && x.FunctionCode == resource.FunctionCode && x.ResourceCode == resource.Code && x.GroupUserCode == user.GroupUserCode && x.UserId == user.UserId);

                            if (permission == null)
                            {
                                if (resource.HasPermission)
                                {
                                    // Add new permission
                                    permission = new AdPermission();
                                    permission.ApplicationCode = model.ApplicationCode;
                                    permission.FunctionCode    = resource.FunctionCode;
                                    permission.ResourceCode    = resource.Code;
                                    permission.GroupUserCode   = user.GroupUserCode;
                                    permission.UserId          = user.UserId;
                                    permission.RoleId          = user.RoleId;
                                    _context.AdPermissions.Add(permission);
                                    _actionLog.InsertActionLog("VIB_PERMISSION", "Add permission successfully", null, permission, "Insert");
                                }
                            }
                            else
                            {
                                if (resource.HasPermission)
                                {
                                    // Update permission
                                    permission.RoleId = user.RoleId;
                                    _context.AdPermissions.Update(permission);
                                    _actionLog.InsertActionLog("VIB_PERMISSION", "Update permission successfully", null, permission, "Insert");
                                }
                                else
                                {
                                    _context.AdPermissions.Remove(permission);
                                    await _context.SaveChangesAsync();
                                }
                            }
                        }
                        // Update role of user in group
                        var userInGroup = await _context.AdUserInGroups.FirstOrDefaultAsync(x => x.GroupUserCode == user.GroupUserCode && x.UserId == user.UserId);

                        if (userInGroup != null)
                        {
                            userInGroup.RoleId = user.RoleId;
                            _context.AdUserInGroups.Update(userInGroup);
                        }
                    }

                    var result = await _context.SaveChangesAsync();

                    //if (result > 0)
                    //{
                    //_logger.LogInformation(LoggingEvents.LogDb, "Update permission success");
                    //_actionLog.InsertActionLog("VIBGroupUser", "Update permission success", objOld, model, "Update");

                    //}
                }

                msg.Error = false;
                msg.Title = string.Format(CommonUtil.ResourceValue("MSG_UPDATE_SUCCESS"), CommonUtil.ResourceValue("PERMISSION").ToLower());
                //_actionLog.InsertActionLog("VIBPermissionResoure", "MSG_UPDATE_SUCCESS", null, model, "Insert");
            }
            catch (Exception ex)
            {
                //_logger.LogError(LoggingEvents.LogDb, "Update permission failed");
                _actionLog.InsertActionLog("VIB_PERMISSION", "Update permission failed", null, null, "Error");

                msg.Object = ex;
            }

            return(Json(msg));
        }