public static List <Role> GetDenyRolesForUser(Guid userid) { List <Role> roles = new List <Role>(); xRPDataContext dataContext = new xRPDataContext(); var result = dataContext.Sp_Qlht_GetAllDenyRolesForUser(userid); foreach (Sp_Qlht_GetAllDenyRolesForUserResult r in result) { roles.Add(new Role { ID = r.RoleId, Name = r.RoleName, IsGrant = false }); } return(roles); }