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;
}
