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();
}
}
