private void GetDatabaseUserRolesPermissions() { using (FreezeDownContext _data = new FreezeDownContext()) { User _user = _data.Users.Where(u => u.UserName == this.UserName).FirstOrDefault(); if (_user != null) { this.UserID = _user.UserID; foreach (Role _role in _user.Roles) { UserRole _userRole = new UserRole { RoleID = _role.RoleID, RoleName = _role.RoleName }; foreach (Permission _permission in _role.Permissions) { _userRole.Permissions.Add(new RolePermission { PermissionID = _permission.PermissionID, PermissionName = _permission.PermissionName }); } this.Roles.Add(_userRole); if (!this.IsSysAdmin) { this.IsSysAdmin = _role.IsSysAdmin; } } } } }