public override string[] FindUsersInRole(string roleName, string usernameToMatch) { roleName = roleName.ToLower(); usernameToMatch = usernameToMatch.ToLower(); var userNames = new List <string>(); if (!string.IsNullOrEmpty(roleName)) { try { using (var context = new ExHolidayEntities()) { userNames = context.tblmembers .Where(a => a.Active && a.Roles.ToLower().Contains(roleName) && a.PICEmail.ToLower() == usernameToMatch) .Select(a => a.PICEmail).ToList(); } } catch (Exception ex) { ex.Log(); throw; } } return(userNames.ToArray()); }
public override string[] GetRolesForUser(string username) { var roles = new List <string>(); if (string.IsNullOrEmpty(username)) { return(roles.ToArray()); } try { username = username.ToLower(); using (var context = new ExHolidayEntities()) { var access = context.tblmembers.Where(a => a.Active && a.PICEmail.ToLower() == username).SingleOrDefault(); if (access == null) { return(roles.ToArray()); } roles = access.Roles.Split(',').ToList(); } } catch (Exception ex) { ex.Log(); throw; } return(roles.ToArray()); }
public static void SetSessionAccess(string loginID) { using (var context = new ExHolidayEntities()) { var access = context.tblmembers.Single(a => a.PICEmail.ToLower() == loginID.ToLower() && a.Active); Util.SessionAccess = access; } }
public override string[] GetAllRoles() { var roles = new List <string>(); try { using (var context = new ExHolidayEntities()) { roles = context.refroles.Select(a => a.Role).ToList(); } } catch (Exception ex) { ex.Log(); } return(roles.ToArray()); }
public override bool RoleExists(string roleName) { bool result = false; try { using (var context = new ExHolidayEntities()) { result = context.refroles.Any(a => a.Role == roleName); } } catch (Exception ex) { ex.Log(); return(result); } return(result); }