public bool IsUserRoleForCHGSite(long userId, long CHGSiteId, long roleId)
{
var roleEntity = UserRoleTypes.Find(roleId);
//Check for CRO
if (roleEntity.Name == "CRO")
{
return(true);
}
//Check for CAC
if (roleEntity.Name == "CAC")
{
return(true);
}
//Check for CEO and DBD
if (roleEntity.Name == "CEO" || roleEntity.Name == "DBD")
{
return(UserCHGSites.Where(p => p.UserId == UserId && p.Deleted == false && p.CHGSiteId == CHGSiteId).Count() > 0);
}
var items = (
from os in OrganizationServiceTypes
join rs in RegionServiceTypes on os.ServiceTypeId equals rs.ServiceTypeId
join s in CHGSites on rs.RegionTypeId equals s.RegionTypeId
where
os.Deleted == false &&
rs.Deleted == false &&
s.Deleted == false
select new
{
OrganizationId = os.OrganizationId,
ServiceTypeId = os.ServiceTypeId,
RegionTypeId = rs.RegionTypeId,
CHGSiteId = s.CHGSiteId
}).ToList();
//Check for AVP
if (roleEntity.Name == "AVP")
{
return((from c in UserRegions.Where(p => p.Deleted == false).ToList() join ur in UserRoles on c.UserId equals ur.UserId join i in items on c.RegionTypeId equals i.RegionTypeId where c.Deleted == false && c.UserId == userId && i.CHGSiteId == CHGSiteId && ur.User.Deleted == false && ur.User.Enabled == true && ur.UserRoleTypeId == roleId select c).Count() > 0);
}
//Add more permission checks here.
return(false);
}
public FoldingRegion GetUserRegion(int line, int column)
{
// search all regions -> then search the last containing region since regions can be nested
// this algorithm doesn't require the folding regions to be sorted.
FoldingRegion result = null;
foreach (var region in UserRegions.Where(r => r.Region.Contains(line, column)))
{
if (result == null || region.Region.Start > result.Region.Start)
{
result = region;
}
}
return(result);
}
public List <User> GetRoleUsersForCHGSite(long CHGSiteId, long roleId)
{
var roleEntity = UserRoleTypes.Find(roleId);
//Check for CRO
if (roleEntity.Name == "CRO")
{
return(UserRoles.Include("UserRoleType").Include("User").Where(p => p.Deleted == false && p.UserRoleType.Name == "CRO" && p.User.Deleted == false && p.User.Enabled == true).Select(p => p.User).ToList());
}
if (roleEntity.Name == "CAC")
{
return(UserRoles.Include("UserRoleType").Include("User").Where(p => p.Deleted == false && p.UserRoleType.Name == "CAC" && p.User.Deleted == false && p.User.Enabled == true).Select(p => p.User).ToList());
}
if (roleEntity.Name == "CEO" || roleEntity.Name == "DBD")
{
return((from ur in UserRoles join us in UserCHGSites on ur.UserId equals us.UserId where us.Deleted == false && ur.Deleted == false && ur.UserRoleTypeId == roleId && us.CHGSiteId == CHGSiteId && us.User.Deleted == false && us.User.Enabled == true select us.User).Distinct().ToList());
}
var items = (
from os in OrganizationServiceTypes
join rs in RegionServiceTypes on os.ServiceTypeId equals rs.ServiceTypeId
join s in CHGSites on rs.RegionTypeId equals s.RegionTypeId
where
os.Deleted == false &&
rs.Deleted == false &&
s.Deleted == false
select new
{
OrganizationId = os.OrganizationId,
ServiceTypeId = os.ServiceTypeId,
RegionTypeId = rs.RegionTypeId,
CHGSiteId = s.CHGSiteId
}).ToList();
if (roleEntity.Name == "AVP")
{
return((from u in UserRegions.Where(p => p.Deleted == false).ToList() join ur in UserRoles on u.UserId equals ur.UserId join i in items on u.RegionTypeId equals i.RegionTypeId where u.Deleted == false && i.CHGSiteId == CHGSiteId && ur.Deleted == false && ur.User.Deleted == false && ur.User.Enabled == true && ur.UserRoleTypeId == roleId select u.User).Distinct().ToList());
}
return(null);
}
public List <CHGSite> GetUserSites(long userId)
{
List <CHGSite> sites = new List <CHGSite>();
foreach (var role in GetUserRoles(userId))
{
switch (role.Name)
{
case "CRO":
sites.AddRange(CHGSites.Where(p => p.Deleted == false).ToList());
break;
case "CAC":
sites.AddRange(CHGSites.Where(p => p.Deleted == false).ToList());
break;
case "SLH":
sites.AddRange((from c in UserServices.Where(p => p.Deleted == false && p.UserId == userId) join d in CHGSites.Where(p => p.Deleted == false) on c.ServiceTypeId equals d.ServiceTypeId select d).ToList());
break;
case "AVP":
sites.AddRange((from c in UserRegions.Where(p => p.Deleted == false && p.UserId == userId) join d in CHGSites.Where(p => p.Deleted == false) on c.RegionTypeId equals d.RegionTypeId select d).ToList());
break;
case "CEO":
sites.AddRange((from c in UserCHGSites.Where(p => p.Deleted == false && p.UserId == userId) join d in CHGSites.Where(p => p.Deleted == false) on c.CHGSiteId equals d.CHGSiteId select d).ToList());
break;
case "DBD":
sites.AddRange((from c in UserCHGSites.Where(p => p.Deleted == false && p.UserId == userId) join d in CHGSites.Where(p => p.Deleted == false) on c.CHGSiteId equals d.CHGSiteId select d).ToList());
break;
case "CL":
sites.AddRange((from c in UserCHGSites.Where(p => p.Deleted == false && p.UserId == userId) join d in CHGSites.Where(p => p.Deleted == false) on c.CHGSiteId equals d.CHGSiteId select d).ToList());
break;
}
}
return(sites.Distinct().ToList());
}
