public override System.Web.Profile.ProfileInfoCollection GetAllProfiles(System.Web.Profile.ProfileAuthenticationOption authenticationOption, int pageIndex, int pageSize, out int totalRecords) { System.Web.Profile.ProfileInfoCollection piCol = new System.Web.Profile.ProfileInfoCollection(); using (DataSet ds = this.OpenXml()) { DataTable dt = ds.Tables["Profile"]; totalRecords = dt.Rows.Count; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; DataRow[] drProfData = ds.Tables["ProfileData"].Select(string.Format("ProfileId = '{0}'", dr["ProfileId"])); int profSz = 0; for (int j = 0; j < drProfData.Length; j++) { profSz += drProfData[j]["PropertyValue"].ToString().Length; } System.Web.Profile.ProfileInfo pi = new System.Web.Profile.ProfileInfo((string)dr["UserName"], (bool)dr["IsAnonymous"], (DateTime)dr["LastActivityDate"], (DateTime)dr["LastUpdatedDate"], profSz); piCol.Add(pi); } } return(piCol); }
public override System.Web.Profile.ProfileInfoCollection FindProfilesByUserName(System.Web.Profile.ProfileAuthenticationOption authenticationOption, string usernameToMatch, int pageIndex, int pageSize, out int totalRecords) { using (var Entities = Repository) { pageIndex = pageIndex < 1 ? 1 : pageIndex; Guid applicationInstance = Guid.Parse(ApplicationName); System.Web.Profile.ProfileInfoCollection profiles = new System.Web.Profile.ProfileInfoCollection(); var members = Entities. ApplicationInstance_v1_0 .Single(i => i.instanceUID == applicationInstance) .Membership_v1_0.Where(m => m.Users_v1_0.email == usernameToMatch && m.Users_v1_0.isAnonymous == (authenticationOption == System.Web.Profile.ProfileAuthenticationOption.Anonymous || authenticationOption == System.Web.Profile.ProfileAuthenticationOption.All)); totalRecords = members.Count(); members.Skip((pageIndex - 1) * pageSize) .ToList().ForEach(m => { profiles.Add(new System.Web.Profile.ProfileInfo(m.Users_v1_0.email, m.Users_v1_0.isAnonymous, m.Users_v1_0.lastActivityDate.Value, m.Profile_v1_0.Max(p => p.LastUpdatedDate), m.Profile_v1_0.Count())); }); return profiles; } }
public override System.Web.Profile.ProfileInfoCollection GetAllProfiles(System.Web.Profile.ProfileAuthenticationOption authenticationOption, int pageIndex, int pageSize, out int totalRecords) { using (var Entities = Repository) { pageIndex = pageIndex < 1 ? 1 : pageIndex; Guid applicationInstance = Guid.Parse(ApplicationName); System.Web.Profile.ProfileInfoCollection profiles = new System.Web.Profile.ProfileInfoCollection(); var members = Entities. ApplicationInstance_v1_0 .Single(i => i.instanceUID == applicationInstance) .Membership_v1_0; totalRecords = members.Count(); members.Skip((pageIndex - 1) * pageSize) .ToList().ForEach(m => { profiles.Add(new System.Web.Profile.ProfileInfo(m.Users_v1_0.email, m.Users_v1_0.isAnonymous, m.Users_v1_0.lastActivityDate.Value, m.Profile_v1_0.Max(p => p.LastUpdatedDate), m.Profile_v1_0.Count())); }); return(profiles); } }
public override System.Web.Profile.ProfileInfoCollection GetAllProfiles(System.Web.Profile.ProfileAuthenticationOption authenticationOption, int pageIndex, int pageSize, out int totalRecords) { System.Web.Profile.ProfileInfoCollection retval = new System.Web.Profile.ProfileInfoCollection(); try { IList<Profile> list = Profile.Search<Profile>(QrySearchProfiles.Query(authenticationOption, Application.ID, pageIndex, pageSize)); totalRecords = (int)QrySearchProfiles.QueryCount(authenticationOption, Application.ID).UniqueResult<int>(); foreach (Profile p in list) { retval.Add(p.User.ToProfileInfo()); } } catch (Exception ex) { throw new ProviderException("Unable to find inactive profiles", ex); } return retval; }
public override System.Web.Profile.ProfileInfoCollection FindProfilesByUserName(System.Web.Profile.ProfileAuthenticationOption authenticationOption, string usernameToMatch, int pageIndex, int pageSize, out int totalRecords) { if (string.IsNullOrEmpty(usernameToMatch)) throw new ArgumentException("Username to match by cannot be empty", "usernameToMatch"); System.Web.Profile.ProfileInfoCollection retval = new System.Web.Profile.ProfileInfoCollection(); try { string matchOn = usernameToMatch.Replace("?", "_").Replace("*", "%"); IList<Profile> list = Profile.Search<Profile>(QrySearchProfiles.Query(authenticationOption, matchOn, Application.ID, pageIndex, pageSize)); totalRecords = (int)QrySearchProfiles.QueryCount(authenticationOption, matchOn, Application.ID).UniqueResult<int>(); foreach (Profile p in list) { retval.Add(p.User.ToProfileInfo()); } } catch (Exception ex) { throw new ProviderException("Unable to find inactive profiles", ex); } return retval; }
public override System.Web.Profile.ProfileInfoCollection GetAllProfiles(System.Web.Profile.ProfileAuthenticationOption authenticationOption, int pageIndex, int pageSize, out int totalRecords) { System.Web.Profile.ProfileInfoCollection piCol = new System.Web.Profile.ProfileInfoCollection(); using (DataSet ds = this.OpenXml()) { DataTable dt = ds.Tables["Profile"]; totalRecords = dt.Rows.Count; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; DataRow[] drProfData = ds.Tables["ProfileData"].Select(string.Format("ProfileId = '{0}'", dr["ProfileId"])); int profSz = 0; for (int j = 0; j < drProfData.Length; j++) profSz += drProfData[j]["PropertyValue"].ToString().Length; System.Web.Profile.ProfileInfo pi = new System.Web.Profile.ProfileInfo((string)dr["UserName"], (bool)dr["IsAnonymous"], (DateTime)dr["LastActivityDate"], (DateTime)dr["LastUpdatedDate"], profSz); piCol.Add(pi); } } return piCol; }