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 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 UserRoleType GetRole(long roleId) { return(UserRoleTypes.Find(roleId)); }