private void BindUserAccounts(bool refreshTotal) { var sSearch = txtSearch.Text.Trim().ToLower(); Session["SearchUseKeyWork"] = sSearch; PollinatorEntities mydb = new PollinatorEntities(); var users = (from ud in mydb.UserDetails from pi in mydb.PolinatorInformations where ud.UserId == pi.UserId && (!this.OnlyShowBFF || (this.OnlyShowBFF && ud.MembershipLevel >= 1)) && ((this.UsernameToMatch == string.Empty) || ud.FirstName.StartsWith(this.UsernameToMatch)) && (sSearch == string.Empty || ud.FirstName.ToLower().IndexOf(sSearch) >= 0 || ud.LastName.ToLower().IndexOf(sSearch) >= 0 || pi.OrganizationName.ToLower().IndexOf(sSearch) >= 0 || pi.LandscapeStreet.ToLower().IndexOf(sSearch) >= 0 || pi.LandscapeCity.ToLower().IndexOf(sSearch) >= 0 || pi.LandscapeState.ToLower().IndexOf(sSearch) >= 0 ) orderby pi.IsApproved, pi.LastUpdated descending select new { ud.UserId, ud.FirstName, ud.LastName, ud.MembershipLevel, pi.PhotoUrl, pi.OrganizationName, pi.LandscapeStreet, pi.LandscapeCity, pi.LandscapeState, pi.IsApproved, pi.IsNew, pi.LastUpdated }).ToList(); UserAccounts.DataSource = users; UserAccounts.DataBind(); if (refreshTotal) { var totalUser = users.Count; var totalPremium = users.Where(u => u.MembershipLevel > 0).Count(); lblSummary.Text = String.Format("Total: {0} users ({1} ", totalUser, totalPremium); // lblSummary.Text = String.Format("Total: {0} users ({1} <font color='violet'>BFF </font> users)", totalUser, totalPremium); } }
private void BindUserAccounts() { int totalRecords; UserAccounts.DataSource = Membership.FindUsersByName(this.UsernameToMatch + "%", this.PageIndex, this.PageSize, out totalRecords); UserAccounts.DataBind(); bool visitingFirstPage = (this.PageIndex == 0); lnkFirst.Enabled = !visitingFirstPage; lnkPrev.Enabled = !visitingFirstPage; int lastPageIndex = (totalRecords - 1) / this.PageSize; bool visitingLastPage = (this.PageIndex >= lastPageIndex); lnkNext.Enabled = !visitingLastPage; lnkLast.Enabled = !visitingLastPage; }
private void BindUserAccounts() { int totalRecords; UserAccounts.DataSource = Membership.FindUsersByName(UsernameToMatch + "%", PageIndex, PageSize, out totalRecords); UserAccounts.DataBind(); // Enable/disable the paging interface var visitingFirstPage = PageIndex == 0; lnkFirst.Enabled = !visitingFirstPage; lnkPrev.Enabled = !visitingFirstPage; var lastPageIndex = (totalRecords - 1) / PageSize; var visitingLastPage = PageIndex >= lastPageIndex; lnkNext.Enabled = !visitingLastPage; lnkLast.Enabled = !visitingLastPage; }