public string GetCurrentUserGPN() { using(var context = new QUERYEntities()) { return context.Users.Single(u => u.UserID == GetCurrentUserId()).GPN; } }
public IList<string> GetAllLocations() { using(var context = new QUERYEntities()) { return context.Locals.Select(l => l.Name).ToList(); } }
public bool UserHasPermission(int headerId, string locationId, string userId) { using (var context = new QUERYEntities()) { var requiredPermissionId = context.Headers.Single(h => h.HeaderID == headerId).PermissionID; return context.UserPermissions.Any(up => up.LocalID == locationId && up.UserID == userId && up.PermissionID == requiredPermissionId); } }
public IList<PermissionDTO> GetAllPermissions() { using (var context = new QUERYEntities()) { return context.Permissions.Select(p => new PermissionDTO() { Description = p.Description, PermissionId = p.PermissionID }).ToList(); } }
public IEnumerable<PermissionLocationDTO> GetPermissionDTOsByUserID(string userID) { using (var context = new QUERYEntities()) { return (from userPermission in context.UserPermissions where userPermission.UserID == userID select new PermissionLocationDTO() { LocationId = userPermission.LocalID, PermissionId = userPermission.PermissionID }).ToList(); } }
public UserDetailsDTO GetUserById(string userId) { using (var context = new QUERYEntities()) { return (from user in context.Users where user.UserID == userId select new UserDetailsDTO() { UserId = user.UserID, UserName = user.Name, BU = user.BU, GPN = user.GPN, Mail = user.Mail, LocationId = user.LocationID, SMU = user.SMU, Permission = user.UserPermissions.Select(up => new PermissionLocationDTO() { LocationId = up.LocalID, PermissionId = up.PermissionID }) }).First(); } }
public IList<UserDetailsDTO> GetUsersByName(string userName, int pageIndex, int pageSize) { using(var context = new QUERYEntities()) { return (from user in context.Users where user.Name.Contains(userName) select new UserDetailsDTO() { UserId = user.UserID, UserName = user.Name, BU = user.BU, GPN = user.GPN, Mail = user.Mail, LocationId = user.LocationID, SMU = user.SMU, Permission = user.UserPermissions.Select(up => new PermissionLocationDTO() { LocationId = up.LocalID, PermissionId = up.PermissionID }) }).ToList(); } }